Please provide the following information and Connie Wilson-Velasco and Portia Luttrell will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.connieandportiahomes.com/agent/22125/conniewilsonvelasco-andportialuttrell/property/link/fresno/619246/20746-Hidden-Lake-Blvd/Friant/https://www.connieandportiahomes.com/images/props/fresno/full/619246.jpgLondon Properties Friant Real Estate | 20746 Hidden Lake Blvd
Welcome to your new Lake View home. Overlooking Finegold Bay on Millerton Lake sits a great place to spend the rest of your life. This 2900 square foot, 3-bedroom, 2 1/2 bath home has been built with practicality in mind. Construction of this home was initially started in 1985 and has been continually updated. Views from the surrounding decks of Finegold Bay and the mesa to the East will always be there for your enjoyment as there are parcels of land also included in the purchase that will deter any future construction to block your views and maintain your privacy. There is a 2-car garage attached to the main home with 220v. In addition, there is a 1660 sq/ft home/office/shop that has 220 electrical service with a 4-car garage. There is a 24x48 RV concrete pad. This one-owner home has a metal roof, hardi-plank siding and fresh paint. The chef's kitchen is enhanced with a copper farm sink & granite counter tops and six-burner Jenn-Aire with griddle and range hood. This home has owned solar with 24 panels installed in 2020. The total electric bill for last year was $285, and this includes the true-up. There is a 2200 Generac included and a new personal water purification system recently installed in addition to the new water system installed by Madera County for the benefit of the Subdivision. The loft area is ideal for family fun nights with the big screen. The home stays cool with numerous overhead fans located in each room. Over all a very impressive home!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$224
Price Per Acre
$341,526
Days On Market
70
Cumulative Days On Market
70
County
Madera
Reports Available
Water Potability, CC&Rs, Prelim Title Report
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.
Style
Ranch
Heating & Cooling
Evaporative Cool
Laundry
Inside, Utility Room, On Lower Level, 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
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 616455 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 681345 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` = 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`) != 'fresno619246' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-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();
1
Similar Properties
$618,000
5
4
3,102
1.36
20515 Galileo Ct
Friant, CA 93626
Courtesy of Thomas White, London Properties-Clovis - tomwhite708@gmail.com Last modified 4 days 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.
