Courtesy of Sarah Gillespie, Executive Realty Associates - [email protected]
Exceptional 20-acre ranch property offering rare multi-home flexibility and turnkey agricultural amenities ideal for multigenerational living, hobby farming, or a full-scale cattle operation. The main residence is a beautifully designed 4-bedroom, 3-bath home featuring a light-filled open floorplan, vaulted ceilings, dramatic floor-to-ceiling windows, and a versatile loft. Thoughtful interior details include a spacious walk-in pantry, convenient inside laundry, and expansive living spaces that flow effortlessly from room to room. Enjoy panoramic sunset views over the foothills from the main house perfect for evening gatherings and peaceful country living.A separate, well-maintained 3-bedroom, 2-bath mobile home sits privately on the lot, making it ideal for extended family, guests, or rental income. The mobile home boasts an owned solar system to reduce PG&E expenses, a large front deck for outdoor entertaining, a fenced yard, and pristine sunrise views overlooking neighboring cattle ranches creating a serene morning retreat.The property's agricultural infrastructure is robust: multiple pastures and pens configured for both large and small animals, a substantial barn, dedicated garden area, and well-maintained internal roads providing easy access across the entire parcel. The perimeter is fully fenced and configured to support cattle, making this an excellent turnkey option for an active cattle ranch or mixed-use farm. Dual circle driveways add convenience and curb appeal.Location and lifestyle combine here secluded, functional, and picture-perfect with sweeping rural vistas in every direction. Whether you need separate living quarters for family, space for animals and equipment, or a productive ranching setup, this 20-acre property delivers flexibility, privacy, and breathtaking views. Schedule a showing today to experience the full potential of this exceptional ranch estate.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1988
Region
Rural
# of Stories
Single Story, Two
Price Per Square Foot
$199
Price Per Acre
$34,794
Days On London
42
Cumulative Days On London
42
County
Madera
Special Features
Isolated Bedroom, Isolated Bathroom
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
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '7' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3650 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` = 1724200 OR `props-main`.`id` = 1666422)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647902' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 3 weeks ago Fresno MLS last checked for updates 19 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.