Custom modern architecture overlooking Millerton Lake! Completely serene with views from every window and from outside at the pool and the spa. This remarkable home has an oversized main bedroom with a fireplace and outside access to the deck and pool. There's a 3- car garage and extensive landscaping all situated on a 2.47 acre lot in the gated community of Lakeview Estates. Lakeview Estates is comprised of 10 lakeview lots & 9 completed custom homes. This home features custom windows and doors that bring in the amazing surrounding views. (all movable windows manufactured by Pella). There is incredible storage throughout entire home, stunning shiplap ceilings, with an open kitchen featuring a spacious walk-in pantry. This home is built for entertaining indoors & outdoors. The great-room has a wet bar, fireplace, lakeview and view of the Sierra's. Incredible formal living & dining rooms, which features stunning windows and magnificent views. Outside approximately 2000 sq ft of outdoor decking that overlook the beautiful rose garden, 1/2 acre landscaped yard, Pebble Tec pool & above ground hot tub. Rare and wonderful Heartwood redwood paneling. We believe you will feel like you are on vacation everyday! This home has owned solar & truly exudes high quality construction in the mid-century style. Schedule your appointment today to view this amazing property. Vacant lot listing #638763 next door is also for sale. Buyers must be prequalified with Sheri Collins at Assured Mortgage. Please call Sheri for details. Escrow to be with Chicago Title, Pam Sebastian.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Foothill
# of Stories
Two, Multi/Split
Price Per Square Foot
$312
Price Per Acre
$516,194
Days On London
29
Cumulative Days On London
29
County
Fresno
Reports Available
Pest, Well, CC&Rs, NHD, Prelim Title Report
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Skylight, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
Friant
Directions
Take Friant Road north to Millerton Road. Lakeview Estates will be on the north side of the Millerton Rd. Gated community.
Style
Contemporary, Mid-Century Modern
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level, Electric Hook Up
Roofing
Composition
Foundation
Both
Kitchen
Built In Range/Oven, Dishwasher, Eating Area, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1211250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1338750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3831 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4331 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` = 1704392 OR `props-main`.`id` = 1701790 OR `props-main`.`id` = 1705553 OR `props-main`.`id` = 1694176 OR `props-main`.`id` = 1701958 OR `props-main`.`id` = 1701954 OR `props-main`.`id` = 1694254 OR `props-main`.`id` = 1665748 OR `props-main`.`id` = 1685816 OR `props-main`.`id` = 1691427 OR `props-main`.`id` = 1701955 OR `props-main`.`id` = 1701956 OR `props-main`.`id` = 1701957 OR `props-main`.`id` = 1709714 OR `props-main`.`id` = 1703881 OR `props-main`.`id` = 1703121 OR `props-main`.`id` = 1679045 OR `props-main`.`id` = 1685709 OR `props-main`.`id` = 1711263 OR `props-main`.`id` = 1711288 OR `props-main`.`id` = 1711289 OR `props-main`.`id` = 1679043 OR `props-main`.`id` = 1698984 OR `props-main`.`id` = 1698978 OR `props-main`.`id` = 1693961 OR `props-main`.`id` = 1701899 OR `props-main`.`id` = 1709735 OR `props-main`.`id` = 1701276 OR `props-main`.`id` = 1701272)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642233' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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
Courtesy of Madeline Preheim, Sierra Crest Properties - [email protected] Last modified 4 days ago Fresno MLS last checked for updates 24 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.
