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.
For sale
$675,000
40458 Road 406, Madera, CA 93636
4beds
2baths
1,903sqft
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
- 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
| Date | Event | Price |
|---|---|---|
| 8/27/2026 | Listed for sale | $675,000+50%$355/sqft |
Source: Fresno MLS #654381 Report a problem | ||
| 7/29/2019 | Sold | $450,000+9%$236/sqft |
Source: Public Record Report a problem | ||
| 6/30/2017 | Sold | $413,000-11.9%$217/sqft |
Source: Public Record Report a problem | ||
| 9/7/2007 | Sold | $469,000$246/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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.Climate risks
Neighborhood: 93636
Nearby schools
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.
Local buyer's agents are ready to help




