Skip main navigation
For sale
  • $675,000

    40458 Road 406, Madera, CA 93636

    4beds
    2baths
    1,903sqft
    : 
    $4,412/mo
    Get pre-qualified
    Residential, Single Family Residence
    Built in 1993
    19.2 Acres Lot
    $663,400 Zestimate®
    $355/sqft
    $-- HOA

    What's special

    Move-in-ready homeNew water heaterHorse arenaNew flooringBrand-new roofUsable acreageGarden areas
    Welcome to your own 20-acre farm and ranch retreat! This fully fenced and cross-fenced property offers the space, infrastructure, and versatility to bring your rural-living dreams to life.The nearly 2,000-square-foot home is fully updated and move-in ready, featuring 4 bedrooms and 2 bathrooms, with an open floor plan, complete with a living and family room. Enjoy views of your pastures for as far as the eye can see from both the kitchen and living rooms. Recent improvements include a brand-new roof, new water heater, new flooring, an updated kitchen, remodeled bathrooms, and a new booster pump for the well.Formerly operated as a fully functioning farm, the property includes multiple pastures for large and small animals, garden areas, a horse arena, and a 6-stall mare motel with tack room. There is plenty of room for horses, livestock, gardening, and outdoor projects.A fully covered motorhome pad provides added potential with its own septic, water, and power hookups, as well as a separate APNperfect for an RV setup, guest accommodations, second home, or potential Airbnb. With usable acreage, established farm improvements, and a move-in-ready home, this property offers a rare opportunity to enjoy space, privacy, and a true country lifestyle.
    5 days
    1,288
    75

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Sarah Gillespie DRE #01843339 559-375-6841,

    Executive Realty Associates

    Source: Fresno MLS,MLS#: 654381Originating MLS: Fresno MLS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 2
      Primary bedroom
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 1
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 2
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 3
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 4
      • Area: 0
      • Dimensions: 0 x 0
      Bathroom
      • Features: Tub/Shower, Shower
      Dining room
      • Area: 0
      • Dimensions: 0 x 0
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Features: Eat-in Kitchen, Pantry
      • Area: 0
      • Dimensions: 0 x 0
      Living room
      • Area: 0
      • Dimensions: 0 x 0
      Basement
      • Area: 0
      Heating
      • Has Heating (Unspecified Type)
      Cooling
      • Central Air
      Appliances
      • Included: F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator
      • Laundry: Inside, Utility Room
      Features
      • Isolated Bedroom
      • Number of fireplaces: 1
      • Fireplace features: Free Standing
      Interior area
      • Total structure area: 1,903
      • Total interior livable area: 1,903 sqft

      Property

      Parking
      • Parking features: RV Access/Parking, Carport, Work/Shop Area
      • Has carport: Yes
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Concrete
      • Fencing: Cross Fenced,Fenced
      Lot
      • Size: 19.2 Acres
      • Features: Foothill, Pasture, Horses Allowed, Mature Landscape, Drip System
      Details
      • Additional structures: Barn(s), Shed(s), Other
      • Parcel number: 050280047000
      • Horses can be raised: Yes
      • Horse amenities: Horse Setup

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Residential, Single Family Residence
      Materials
      • Wood Siding
      • Foundation: Concrete
      • Roof: Composition
      Condition
      • Year built: 1993

      Utilities & green energy

      • Electric: On
      • Sewer: Septic Tank
      • Water: Private
      • Utilities for property: Public Utilities, Propane

      Community & HOA

      Community
      • Security: Security Gate
      Location
      • Region: Madera

      Financial & listing details

      • Price per square foot: $355/sqft
      • Tax assessed value: $512,018
      • Date on market: 8/27/2026
      • Listing agreement: Exclusive Right To Sell

        Estimated market value

        $663,400

        $630,000 - $697,000

        $2,798/mo

        Price history

        DateEventPrice
        8/27/2026Listed for sale$675,000+50%$355/sqft
        Source: Fresno MLS #654381 Report a problem
        7/29/2019Sold$450,000+9%$236/sqft
        Source: Public Record Report a problem
        6/30/2017Sold$413,000-11.9%$217/sqft
        Source: Public Record Report a problem
        9/7/2007Sold$469,000$246/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026-- $512,018 +2%
        2025$5,354 +1.7%$501,979 +2%
        2024$5,267 +2.2%$492,137 +2%
        2023$5,153 +1%$482,488 +2%
        2022$5,100 +3.1%$473,028 +2%
        2021$4,948 +3.2%$463,754 +1%
        2020$4,795 +5.7%$459,000 +6.8%
        2019$4,538 +4.1%$429,685 +2%
        2018$4,360 +28.9%$421,260 +32.5%
        2017$3,382 $317,927 +3%
        2016$3,382 +16.6%$308,667 +2%
        2015$2,900 $302,615
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 93636

        Getting around

        0 / 100
        Car-Dependent
        0 / 100
        No Nearby Transit
        6 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Spring Valley
        • Middle: Spring Valley
        • High: Minarets

        Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts
            • Local buyer's agents are ready to help