Experience the perfect blend of tranquility and recreation in this pristine 3-bedroom, 2-bathroom home. Spanning 1,734 square feet of bright, clean living space, this residence is designed to frame the stunning, unobstructed views of Millerton Lake and the rolling California foothills. Enjoy watching deer grazing nearby and birds diving into the lake for their next meal!
Located in a quiet, peaceful community, you'll feel worlds away from the hustle while staying remarkably connected. Whether you're hitting the greens at Eagle Springs Golf Course or enjoying world-class entertainment at Table Mountain Casino, you are only minutes from the action. Plus, with North Fresno just a 20-minute drive away, you get the best of both worlds: a vacation-style sanctuary with city amenities within easy reach.
This home is move-in ready and waiting for its next chapter. Come for the views, stay for the peace.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 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) >= 1484 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1984 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` = 1666362 OR `props-main`.`id` = 1708078 OR `props-main`.`id` = 1704932 OR `props-main`.`id` = 1705058 OR `props-main`.`id` = 1711322 OR `props-main`.`id` = 1697189 OR `props-main`.`id` = 1701766 OR `props-main`.`id` = 1685314 OR `props-main`.`id` = 1688127 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1694390 OR `props-main`.`id` = 1694391 OR `props-main`.`id` = 1694393 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1695901 OR `props-main`.`id` = 1708359 OR `props-main`.`id` = 1698887 OR `props-main`.`id` = 1673250 OR `props-main`.`id` = 1670883)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643039' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 John Porter, CMT Properties, Inc. - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 13 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.
