Courtesy of Sarah Gillespie, Executive Realty Associates - [email protected]
Exclusive 20‑acre Madera ranch a rare blend of refined comfort and true rural freedom. This 2,000 sq ft, 3‑bed/2‑bath home frames panoramic country and mountain side views from every corner and opens to a private sunset deck perfect for evening cocktails and long, golden horizons. Home offers vaulted ceilings, granite counters, gas appliances, and the opportunity to add a huge butlers pantry. Built for purposeful living and weekend escapes alike. The property is fully fenced and cross‑fenced, with a fenced backyard as well, chicken coop, dog run, sheds, horse corral. lean to's, and more, ideal for hobby farming, animals, or secure family living. Turnkey infrastructure includes a spacious shop, onsite fuel tank for heavy equipment, a backup generator, and owned solar waiting to be connected, for energy independence. Inside, enjoy an indoor laundry room with room to add a mudroom and a large walk‑in butler's pantry awaiting completion, customize to your taste. Meticulously maintained land offers privacy, development potential, and scenic vistas, sophisticated country living with modern conveniences. Schedule your private showing and imagine life where sunsets are your daily luxury. If you've been waiting for a property that could be a forever home, this is it! Schedule a showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2011
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$373
Price Per Acre
$36,667
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Millstream/ Road 406
Directions
From Hwy 41, head north on Rd 209, towards 209 Travel Center, follow road, to the left at Road 406, home is on the right. 6.7 miles from the new truck stop
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
In Garage, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop, Barn, Kennel, Shed, Green House
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Breakfast Bar
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Tile
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
Above Ground
Patio Features
Uncovered
Yard
Sprinklers Front, Sprinklers Back, Fenced
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank
Solar
Yes
Solar Type
Owned
Parking Features
Existing RV Parking, Carport, Work/Shop Area
Are there garage spaces?
No
Carport Spaces
2
APN
050 280 025 000
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Spring Valley
School Type 3
Grade School
School Name 3
Spring Valley
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 679250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 750750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1669 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2169 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1745238)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651382' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-02' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Last modified 2 hours ago Fresno MLS last checked for updates 26 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
