What a unique property! Located in Hidden Lake Estates. This house has 2 kitchens, 2 living rooms, 5 bedrooms, 4 bathrooms, plus a game room and den. Upstairs has 1 kitchen, large living room with great views of Millerton lake, 3 bedrooms and 2 bathrooms and a large wood deck overlooking the lake. Downstairs there is a kitchen, cozy living room, 2 bedrooms, 2 bathrooms, game room, den and a patio overlooking the lake. Fresh interior paint, some new floor coverings, lights and plumbing fixtures. This property has many great possibilities. Call your favorite Real Estate agent to setup a private showing! Bedroom count differs from tax records, buyer to verify.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1982
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$199
Price Per Acre
$454,412
Days On Market
8
Cumulative Days On Market
8
County
Madera
Leased Equipment
Propane
REO / Bank Owned
Yes
Cross Street Address
W/ Hidden Lake Blvd
Directions
From Friant Take Northfork Rd, right On 211rt On Hidden Lake Estates Rd, right On Galileo Ct.
Heating & Cooling
Central Heat & Cool, Ductless or Split
Laundry
Inside, Utility Room, On Lower Level
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub
Extra Rooms
Game Room, Wine Room
Flooring
Carpet, Tile, Vinyl
# of Fireplaces
2
Fireplace Type
Masonry, Wood Insert
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Concrete, Wood Deck
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Tankless Water Heater
Solar
Yes
Solar Type
Owned
Parking Features
Potential RV Parking
Site Amenities
Cul De Sac, Lake View
APN
051 272 012 000
Association / Park Amenities
Other/None
HOA Dues
100.00
Frequency
Annual
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) >= 587100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 648900 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2852 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3352 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` = 1668078 OR `props-main`.`id` = 1665970 OR `props-main`.`id` = 1666099 OR `props-main`.`id` = 1666100 OR `props-main`.`id` = 1679783 OR `props-main`.`id` = 1628967 OR `props-main`.`id` = 1663281 OR `props-main`.`id` = 1676726 OR `props-main`.`id` = 1654810 OR `props-main`.`id` = 1668391 OR `props-main`.`id` = 1684753 OR `props-main`.`id` = 1685314 OR `props-main`.`id` = 1685478 OR `props-main`.`id` = 1685665 OR `props-main`.`id` = 1663866 OR `props-main`.`id` = 1665947 OR `props-main`.`id` = 1673250 OR `props-main`.`id` = 1670883 OR `props-main`.`id` = 1652422 OR `props-main`.`id` = 1666409)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637014' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-21' 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 Rick Hauff, London Properties-Lender Servi - rick@londonproperties.com Last modified 1 week 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.
