This 3 Bed 3 Bath home provides immediate views of the Millerton Lake landscape captivating any guests as they come into the living room. Large sliding glass doors open onto the balcony boasting the view of the lake. The dining room is also charmed by views of the scenery to enjoy at every meal while a sliding glass door leads out onto the front porch. The kitchen looks out onto the front porch . Also on the main level, the primary bedroom has a large window offering the scenic lake views letting in lush natural light, the bathroom is fixated with a dual vanity sink and full shower. Downstairs, the second living room is captivated by another lakeview balcony with two more bedrooms on the lower level. One bedroom has an ensuite bath with a large jetted tub while the other bedroom with lake views has an adjoining bathroom connecting to the living room with a full shower and tub. This home also has owned solar, spa, and Generac whoe home generator for the event of power outage it will kick in automatically. In the surrounding area of Millerton Lake enjoy Brighton Crest Country Club and its golf course, stroll the beautiful hiking trails, stop by Millerton Lake Marina for boat or jetski rentals, or try your luck at Table Mountain Casino! Home is currently used as AirBnB so all furnitures and kitchen wares are negotiable.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1965
Region
Foothill
# of Stories
Two
Price Per Square Foot
$389
Price Per Acre
$4,975,089
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Sky Harbour Rd
Directions
From Millerton Rd by Table Mountain Casino, take Sky Harbour Rd all the way to property.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Lower Level, Electric Hook Up
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Jetted Tub
Extra Rooms
Converted Garage
Flooring
Hardwood
# of Fireplaces
1
Fireplace Type
Gas Insert, Zero Clearance
Exterior
Other
Pool
No
Pool
No
Spa
Yes
Gas & Electric
Public Utilities, Propane, Generator
Sewer / Water
Public Water, Public Sewer, Shared Well, Community Well
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 733950 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) >= 1546 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2046 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` = 1786934 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` = 1753041 OR `props-main`.`id` = 1743884 OR `props-main`.`id` = 1732373 OR `props-main`.`id` = 1718010 OR `props-main`.`id` = 1789116 OR `props-main`.`id` = 1781429 OR `props-main`.`id` = 1753308 OR `props-main`.`id` = 1768436 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1725630 OR `props-main`.`id` = 1783121 OR `props-main`.`id` = 1729237 OR `props-main`.`id` = 1734749 OR `props-main`.`id` = 1716252)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656450' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-09' 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 7 hours ago Fresno MLS last checked for updates 19 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.
