Welcome to your own private retreat overlooking the scenic beauty of Millerton Lake and the rolling foothills beyond. This well-cared-for 3-bedroom, 2-bathroom residence features 1,734 sq. ft. of comfortable living space filled with natural light and captivating views from nearly every angle. Step outside onto the spacious wraparound patio and enjoy unforgettable sunsets, peaceful evenings beneath the stars, and the calming presence of nature right outside your door. From deer grazing nearby to eagles gliding across the lake, the setting offers a truly remarkable connection to the outdoors.The home also features a brand-new HVAC furnace system, providing improved efficiency, reliability, and year-round indoor comfort. Tucked away in a quiet community, this property offers a relaxing atmosphere while remaining conveniently close to Eagle Springs Golf Course, Table Mountain Casino, and just a short drive to North Fresno. Enjoy the feeling of everyday vacation living without sacrificing access to shopping, dining, and entertainment.Make your appointment today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1986
Region
Foothill
# of Stories
Two
Price Per Square Foot
$228
Price Per Acre
$1,890,378
Days On London
2
Cumulative Days On London
77
County
Fresno
REO / Bank Owned
No
Cross Street Address
Millerton RD/ Sky Harbour Rd
Directions
From Millerton Rd, turn left onto Sky Harbour Rd. Follow Sky Harbour Rd for about 5 miles. Property will be on your left.
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Both
Kitchen
F/S Range/Oven, Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414645 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` = 1716289 OR `props-main`.`id` = 1716240 OR `props-main`.`id` = 1708078 OR `props-main`.`id` = 1713868 OR `props-main`.`id` = 1704932 OR `props-main`.`id` = 1713870 OR `props-main`.`id` = 1721433 OR `props-main`.`id` = 1727572 OR `props-main`.`id` = 1722174 OR `props-main`.`id` = 1727179 OR `props-main`.`id` = 1717902 OR `props-main`.`id` = 1717935 OR `props-main`.`id` = 1727250 OR `props-main`.`id` = 1711322 OR `props-main`.`id` = 1697189 OR `props-main`.`id` = 1718010 OR `props-main`.`id` = 1701766 OR `props-main`.`id` = 1688127 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1727902 OR `props-main`.`id` = 1694390 OR `props-main`.`id` = 1694391 OR `props-main`.`id` = 1720003 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1725630 OR `props-main`.`id` = 1695901 OR `props-main`.`id` = 1698887 OR `props-main`.`id` = 1716252 OR `props-main`.`id` = 1712450 OR `props-main`.`id` = 1673250)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648961' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-20' 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 Haydee Moerman, Western Pioneer Properties - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 20 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.
