Courtesy of David Cameron, Realty Concepts, Ltd. - Fresno - [email protected]
Experience effortless hillside living in this move in ready, 3 bedroom 3 bath custom home featuring panoramic elevated views of Lake Millerton. This 1696 sq. ft. light filled layout inculeds high ceilings, skylight and floor to ceiling vistas designed for seamless indoor outdoor entertaining. The upper level primary bedroom serves as a private retreat with it's own water view balcony with a nice en suite bath and soaking tub. Complete with multiple view decks, a large patio and generous garage storage, this serene lake view home sits just minutes from hiking trails, boating and dining.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1998
Region
Foothill
# of Stories
Two
Price Per Square Foot
$277
Price Per Acre
$3,243,430
Days On London
0
Cumulative Days On London
0
County
Fresno
Leased Equipment
Satellite Dish
Special Features
Isolated Bedroom, Skylight, Satellite Dish
REO / Bank Owned
No
Cross Street Address
Millerton Rd.
Directions
North on Auberry Rd. to Millerton Rd. turn north onto Sky Harbour just past Table Mountain Casino.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 445550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 492450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1446 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1946 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` = 1728561 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` = 1773702 OR `props-main`.`id` = 1727179 OR `props-main`.`id` = 1761892 OR `props-main`.`id` = 1757661 OR `props-main`.`id` = 1753067 OR `props-main`.`id` = 1733270 OR `props-main`.`id` = 1727250 OR `props-main`.`id` = 1753041 OR `props-main`.`id` = 1743884 OR `props-main`.`id` = 1732373 OR `props-main`.`id` = 1718010 OR `props-main`.`id` = 1781429 OR `props-main`.`id` = 1753308 OR `props-main`.`id` = 1768436 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1725630 OR `props-main`.`id` = 1777513 OR `props-main`.`id` = 1729237 OR `props-main`.`id` = 1734749 OR `props-main`.`id` = 1716252)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655689' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-25' 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 1 hour ago Fresno MLS last checked for updates 10 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.
