x
Showing 1 of 0
X
Save

40458 Road 406
Madera CA 93636 US

$675,000

Active Listing ID 654381
bed icon
4 bed
rule icon
1,903 square feet
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 19.20 Acres
home icon
Single Family Residence

$675,000

Active Listing ID 654381
Save

40458 Road 406 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 19.20 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • Exterior Finish: Wood
  • Roof Type: Composition
  • Additional Features
  • Fireplace

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 675000
  • unparsedaddress: 40458 Road 406
  • postalcity: Madera
  • stateorprovince: CA
  • country: US
  • postalcode: 93636
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 19.2
  • lotsizeunits: Acres
  • lotsizearea: 19.2
  • livingarea: 1903
  • livingareaunits: Square Feet
  • latitude: 37.079103
  • longitude: -119.811985
  • listagentfullname: Sarah Gillespie
  • listagentemail: derek@sti.net
  • listagentkey: 3yd-FARCA-15303
  • listagentmlsid: 15303
  • listagentpreferredphone: (559) 676-6333
  • listofficekey: 3yd-FARCA-1320
  • listofficemlsid: 1320
  • disclaimer: Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: FARCA
  • yearbuilt: 1993
  • listingcontractdate: 2026-08-27
  • listagenturl: http://www.executiverealty.org
  • countyorparish: Madera
  • parcelnumber: 050280047000
  • highschooldistrict: Chawanakee
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: RV, Carport
  • roof: Composition
  • waterfrontyn: False
  • franchiseaffiliation: None
  • exteriorfeatures: Wood
  • architecturalstyle: Ranch
  • rooms: Bedroom 1, Bedroom 3, Bedroom 4, Bathroom 2, Bedroom 2, Bathroom 1
  • utilities: Propane
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -119.81198, 37.0791
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Executive Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"derek@sti.net", "ListBrokerageCity":"Coarsegold", "ListBrokerageCountry":"US", "ListBrokerageEmail":"derek@sti.net", "ListBrokerageLogoUrl":"http://lh.rdcpix.com/ab7f6b0194da11df98e400219b9aa4d8k-c1787199775r.jpg", "ListBrokerageName":"Executive Realty", "ListBrokeragePhone":"(559) 676-6333", "ListBrokeragePostalCode":"93614", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"28474 Yosemite Springs Parkway", "ListBrokerageWebsiteUrl":"http://www.executiverealty.org", "ListOfficeAddress1":"28474 Yosemite Springs Pkwy#1 ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"1320", "ListOfficeCity":"Coarsegold", "ListOfficeCountry":"US", "ListOfficeEmail":"derek@sti.net", "ListOfficePostalCode":"93614", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Residential, Madera, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/40458-Road-406_Madera_CA_93636_M23419-62828?f=listhub&s=FARCA&m=654381&c=rexren", "MLSModificationTimestamp":"2026-08-27 13:10:34", "Neighborhoods":[{"Description":null, "Name":"636"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 9/3/2026 7:24:41 PM GMT
Source Updated Date: 9/5/2026 12:48:18 AM GMT

Courtesy of: Sarah Gillespie, Executive Realty Associates, derek@sti.net

Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.