Courtesy of Joe Sciarrone, London Properties, Ltd. - [email protected]
Surrounded by ancient oaks just 15 minutes from town, this Cornerstone-built custom estate offers gated privacy, sweeping hilltop views and exceptional indoor-outdoor living. A private drive winds past owned solar, a craft shop with roll-up door and a large shop with 1,000 sf of living space, bar, game room, private patio, deck and generous storage. Inside the main home, wood floors and floor-to-ceiling windows frame the views. The open kitchen features a distressed wood-plank ceiling, full-wall brick backsplash, quartzite island, handcrafted cabinetry, walk-in pantry, temperature controlled wine cellar and premium appliances, including a 60-inch built-in refrigerator. The main-level primary retreat offers a fireplace, spacious walk-in closets and a spa inspired bath with soaking tub, dual vanities and large shower. A wood-paneled office, private guest suite, two baths, large laundry room and luggage/storage room complete this level. Upstairs are two spacious bedrooms, a study area and theater with wet bar, projector and large screen. Outdoor entertaining comes to life around an infinity pool with water features, three fire pits and custom lighting. A built-in kitchen, generous lawn and outdoor living room with fireplace and TV complete this peaceful rural retreat.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2017
Region
Rural
# of Stories
Two
Price Per Square Foot
$634
Price Per Acre
$67,500
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Isolated Bedroom, Isolated Bathroom, Security Gate, Built In Cabinets, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Rd 210 (Hildreth)/Rd 211
Directions
From 41, turn rt. on Rd. 145, which will turn into Rd 211, then Rt. on Rd. 207 (Hildreth)
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Detached Structures
Shop, Other/See Remarks
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
Dining Room Features
Formal
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Shower, Tub
Extra Rooms
Great Room, Loft, Game Room
Basement
None
Flooring
Carpet, Tile, Hardwood
# of Fireplaces
2
Fireplace Type
Zero Clearance
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Patio Features
Covered, Concrete
Yard
Sprinklers Front, Mature Landscape, Synthetic Lawn, Drip System
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows, Tankless Water Heater
Solar
Yes
Solar Type
Owned
Parking Features
Existing RV Parking, Work/Shop Area, Auto Opener, Circular Driveway
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Bluff View, Cross Fenced, Pasture
APN
051 055 012 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
Seller Will Consider
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2565000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2835000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4010 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4510 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` = 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` = 1791659 OR `props-main`.`id` = 1666409 OR `props-main`.`id` = 1779533)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656774' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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 1 hour ago Fresno MLS last checked for updates 35 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.
