Welcome to your dream four-season retreat! This stunning 3-story, 4-bedroom home sits on nearly 40 acres, offering breathtaking sunset views and abundant natural light through large windows that connect you to nature. The unique gambrel roof creates extra interior space, featuring a versatile loft that can serve as bedrooms, an office, or a playroom, all enhanced by high ceilings for an airy feel.
Step outside to the expansive wrap-around deckperfect for relaxing or entertaining while soaking in the scenic beauty. The property includes two fenced pastures ideal for livestock or pets, along with fields of wild blackberries for summer enjoyment. A seasonal pond attracts wildlife, adding to the natural charm.
For practicality, a spacious shed and sea train provide ample storage for tools and equipment, while a generous 500-square-foot supply room on the first floor is perfect for hobbies or a workshop. Two wells ensure a reliable water source for all your household and agricultural needs.
Experience tranquility and versatility in this beautiful retreat, where every feature enhances your connection to the serene surroundings.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Region
Mountain
# of Stories
Two
Price Per Square Foot
$176
Price Per Acre
$15,296
Days On Market
346
Cumulative Days On Market
716
County
Fresno
REO / Bank Owned
No
Cross Street Address
Millwood Rd
Directions
CA-180 E to Dunlap Rd in Dunlap Rd, Dunlap Rd to Millwood Rd, Millwood Rd to Todd Eymann R
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' 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` = 1687627 OR `props-main`.`id` = 1656865 OR `props-main`.`id` = 1666087 OR `props-main`.`id` = 1609184 OR `props-main`.`id` = 1696517 OR `props-main`.`id` = 1609180 OR `props-main`.`id` = 1609321)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno620122' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-07' 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
Courtesy of Mark Campbell, Modern Broker - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 33 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.
