Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/643857/20746-Hidden-Lake-Blvd/Friant/https://www.londonproperties.com/images/props/fresno/full/643857.jpgLondon Properties Friant Real Estate | 20746 Hidden Lake Blvd
This lakeview home features three bedrooms and two full baths. A game loft overlooks the living room and wood burning fireplace with insert. A chef's kitchen includes a JennAire surface mount cook stove with six full burners and griddle plus a microwave and wine cooler. A KitchenAide double oven and double door refrigerator rounds out the kitchen ware. The seller has also just completed a new water purification system. Three bedrooms on the ground floor as is the hall bathroom. The hall bath includes a jetted tub and over-sized shower. Granite sink and custom wood cabinetry and woodwork finish it off. The 1660 sq/ft outbuilding measures 48 feet across and will support storage for three vehicles together with a 22-foot boat. If you don't have a boat, now is the chance to get one. It is a fully finished building with black and white tile on the main floor and 40 feet of storage along the west wall. Upstairs is a 16'x28' utility room that has been used as an extras bedroom, media room, or office space. It is WiFi equipped. There is 220v for EV charging in both the lower and upper garage. There is also a half bath on the ground floor. Parking space for motorhome on concrete. Both the main home and outbuilding have a metal roof with Hardi Plank siding and four new garage doors. The owned 24 solar panels provide power and the annual tru-up for usage last year was a total of $70. That is less than $5.25/month. This home has over 1400 square feet of exterior redwood decking (w/steel powder coated posts) that has been recently treated. There is also a 2200 GENERAC whole house emergency propane powered backup available if needed.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$203
Price Per Acre
$310,526
Days On London
7
Cumulative Days On London
7
County
Madera
Reports Available
Water Potability, CC&Rs, Prelim Title Report
Leased Equipment
Propane
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Water Filter, Satellite Dish, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Hidden Lake Blvd
Directions
Friant Rd to Road 206, Road 206 to Hwy 145, north on Hwy 145/Road 211, to Hildreth Rd., right on Hildreth to Road 216. Right to Hidden Lake Blvd. Stay on Hidden Lake Blvd to property. Stay on payment and follow yellow road marking.
Special Disclosure
See Remrks/Attchmnts
Style
Ranch
Heating & Cooling
Evaporative Cool
Laundry
Inside, Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Metal
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Shower, Jetted Tub
Extra Rooms
Office, Family Room, Loft, Other
Flooring
Hardwood
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Vinyl
Pool
No
Pool
No
Spa
No
Patio Features
Uncovered, Wood Deck
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Not Applicable
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Owned
Parking Features
Existing RV Parking, Uncovered, Work/Shop Area, Drive Thru, Other
Garage Type
Attached
Garage Spaces
2
Site Amenities
Lake View
APN
051 092 006 000
Association / Park Amenities
Other/None
HOA Dues
100.00
Frequency
Annually
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
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 560499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 619498.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) >= 2650 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3150 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` = 1708078 OR `props-main`.`id` = 1704932 OR `props-main`.`id` = 1705058 OR `props-main`.`id` = 1711322 OR `props-main`.`id` = 1697189 OR `props-main`.`id` = 1701766 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` = 1695901 OR `props-main`.`id` = 1708359 OR `props-main`.`id` = 1698887 OR `props-main`.`id` = 1673250 OR `props-main`.`id` = 1670883 OR `props-main`.`id` = 1666409)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643857' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Thomas White, London Properties-Clovis - [email protected] Last modified 4 days ago Fresno MLS last checked for updates 41 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.
