Located in the prestigious Hidden Lake Estates of Friant, this custom-designed home offers breathtaking views of Millerton Lake and refined living across 2,778 sq ft. With 3 spacious bedrooms and 2.5 baths, this home showcases soaring ceilings, striking architectural lines, and a chef's kitchen complete with a generous island, kitchen pantry; and a built-in coffee bar. The luxurious primary suite features a spa-inspired bath, dual vanities, and private deck access. Downstairs, enjoy a versatile family room with wet bar, two expansive decks for entertaining, and a beautifully landscaped backyard-perfect for savoring serene sunsets and lakeside tranquility.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1997
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$230
Price Per Acre
$761,904
Days On Market
29
Cumulative Days On Market
205
County
Madera
Special Features
Isolated Bedroom, Security System, Security Gate, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
Hidden Lakes Boulevard
Directions
Google Maps has proven to be effective. Drive North on Friant Rd. Turn left on North Fork Rd, Turn right onto Rd 145, Turn right on Hildreth Rd, Turn right on Rd 216. Turn left to stay on Hidden Lake Blvd. Turn left on Hidden Lake Blvd; Turn right.
Unit Description
Split Level
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Kennel
Kitchen
Built In Range/Oven, Gas Appliances, Dishwasher, Eating Area, Pantry, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Extra Rooms
Other
Flooring
Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Covered
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Solar
No
Parking Features
Potential RV Parking, Uncovered, Other
Garage Type
Detached
Garage Spaces
2
Site Amenities
Lake View
APN
051 252 009 000
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Spring Valley
School Type 3
Grade School
School Name 3
Spring Valley
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 671998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2528 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3028 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` = 1665970 OR `props-main`.`id` = 1666099 OR `props-main`.`id` = 1666100 OR `props-main`.`id` = 1679783 OR `props-main`.`id` = 1663281 OR `props-main`.`id` = 1688965 OR `props-main`.`id` = 1676726 OR `props-main`.`id` = 1691809 OR `props-main`.`id` = 1668391 OR `props-main`.`id` = 1685314 OR `props-main`.`id` = 1688127 OR `props-main`.`id` = 1691321 OR `props-main`.`id` = 1694390 OR `props-main`.`id` = 1694391 OR `props-main`.`id` = 1694393 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1663866 OR `props-main`.`id` = 1673250 OR `props-main`.`id` = 1670883 OR `props-main`.`id` = 1690958 OR `props-main`.`id` = 1666409)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638912' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-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 Saengkham Bunsy, Iron Key Real Estate - saeng@ironkeyrealestate.com Last modified 1 week 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.
