Welcome to your own private foothill retreat overlooking the scenic beauty of Millerton Lake and the rolling hills beyond. This well-maintained 3-bedroom, 2-bathroom home offers 1,734 sq. ft. of comfortable living space filled with natural light and stunning lake views from every room in the home. Whether you're relaxing indoors or enjoying the scenery outside, the ever-changing landscape of water, wildlife, and foothills creates a peaceful setting that feels miles away from the everyday. Step onto the expansive wraparound patio and enjoy morning coffee overlooking the lake, spectacular sunsets across the foothills, and quiet evenings beneath a sky full of stars. Nature is on full display here, with deer often grazing nearby and eagles swooping down to catch their dinner from the lake. For those who enjoy exploring the outdoors, a path from the backyard leads directly down to the lake's edge, offering access to the shoreline and an even closer connection to the natural beauty that surrounds the property. The home also features a brand-new HVAC system, providing enhanced efficiency, reliability, and year-round comfort. Tucked away in a quiet community, this property offers the perfect balance of privacy and convenience. Enjoy nearby recreation at Millerton Lake, a round of golf at Eagle Springs Golf Course, and the excitement of Chukchansi Gold Resort & Casino just 10 minutes away. North Fresno is also within a comfortable drive, giving you access to shopping, dining, and everyday amenities while still enjoying the tranquility of foothill living. If you've been searching for a home where breathtaking lake views, abundant wildlife, and a relaxed lifestyle come together, this is an opportunity you won't want to miss.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1986
Region
Foothill
Unique Conditions
1031 Exchange
# of Stories
Two
Price Per Square Foot
$231
Price Per Acre
$1,914,313
Days On London
0
Cumulative Days On London
99
County
Fresno
Leased Equipment
Propane
REO / Bank Owned
No
Cross Street Address
Sky Harbour Rd & Millerton Rd
Directions
From Fresno, take CA-41 North to CA-145 North. Continue to Millerton Rd, then turn onto Sky Harbour Rd. Follow Sky Harbour Rd to 27817 Sky Harbour Rd, Friant. Property will be on left; you'll need to make a you turn to access property.
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` = 1730706 OR `props-main`.`id` = 1728561 OR `props-main`.`id` = 1737845 OR `props-main`.`id` = 1708078 OR `props-main`.`id` = 1713868 OR `props-main`.`id` = 1704932 OR `props-main`.`id` = 1728145 OR `props-main`.`id` = 1713870 OR `props-main`.`id` = 1721433 OR `props-main`.`id` = 1741902 OR `props-main`.`id` = 1722174 OR `props-main`.`id` = 1731583 OR `props-main`.`id` = 1727179 OR `props-main`.`id` = 1717902 OR `props-main`.`id` = 1717935 OR `props-main`.`id` = 1733270 OR `props-main`.`id` = 1727250 OR `props-main`.`id` = 1739537 OR `props-main`.`id` = 1732373 OR `props-main`.`id` = 1718010 OR `props-main`.`id` = 1701766 OR `props-main`.`id` = 1688127 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1728315 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1725630 OR `props-main`.`id` = 1729236 OR `props-main`.`id` = 1729237 OR `props-main`.`id` = 1734749 OR `props-main`.`id` = 1716252 OR `props-main`.`id` = 1712450 OR `props-main`.`id` = 1673250)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650970' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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
Last modified 2 hours ago Fresno MLS last checked for updates 2 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.
