Courtesy of Donna Pride, London Properties, Ltd. - [email protected]
Rare horse property with breathtaking 240-degree mountain views, serene privacy, and beautifully upgraded outdoor living. Extensive vinyl fencing, cross-fencing, a spacious arena, and expansive usable land make this property perfect for horses or other livestock.The main home boasts multiple large windows capturing the stunning surroundings, a great room with a floor-to-ceiling stone fireplace, an extremely large primary bedroom, and an upgraded Trex deck wrapping around the home making it ideal for entertaining or relaxing.Outbuildings include an 18'x33' shop with 240-volt electric, 9000 lb lift, cooling, and waterproofed floor, plus two additional insulated structures with concrete floors and electric in all but one. The oversized garage rivals many homes with cabinets, closets, a car charger, a large hobby room, and a full bathroom. Also included is a custom chicken coop.A custom observatory with a roll-back roof, multiple trees, and professionally installed sprinklers and drippers on timers enhance the property's charm and usability. Every detail, especially the outdoor spaces, has been thoughtfully upgraded to create easy, elegant country living in a stunning mountain setting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$314
Days On London
176
Cumulative Days On London
176
County
Madera
Leased Equipment
Propane
Special Features
Security System, Built In Cabinets, Water Filter, Horses Allowed, Horse Setup
REO / Bank Owned
No
Cross Street Address
Rd 628
Directions
From Oakhurst, head out on Hwy 49, turn right on Rd 628, and turn right on Leach Rd to property
Heating & Cooling
Central Heat & Cool, Whole House Fan, Other
Laundry
Inside
Roofing
Tile
Foundation
Both
Detached Structures
Shop, Shed
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Trash Compactor, Eating Area, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 840750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 929250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2570 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3070 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` = 1727996 OR `props-main`.`id` = 1731952 OR `props-main`.`id` = 1731636 OR `props-main`.`id` = 1723576 OR `props-main`.`id` = 1699201 OR `props-main`.`id` = 1699153 OR `props-main`.`id` = 1705902 OR `props-main`.`id` = 1705887 OR `props-main`.`id` = 1731459 OR `props-main`.`id` = 1726581 OR `props-main`.`id` = 1722180 OR `props-main`.`id` = 1726566 OR `props-main`.`id` = 1731611 OR `props-main`.`id` = 1723664 OR `props-main`.`id` = 1731635 OR `props-main`.`id` = 1723658 OR `props-main`.`id` = 1722176 OR `props-main`.`id` = 1715530 OR `props-main`.`id` = 1731510 OR `props-main`.`id` = 1697446 OR `props-main`.`id` = 1731400 OR `props-main`.`id` = 1729079 OR `props-main`.`id` = 1729091 OR `props-main`.`id` = 1705691 OR `props-main`.`id` = 1706718 OR `props-main`.`id` = 1716004 OR `props-main`.`id` = 1714989 OR `props-main`.`id` = 1725485 OR `props-main`.`id` = 1728503 OR `props-main`.`id` = 1666393 OR `props-main`.`id` = 1731684 OR `props-main`.`id` = 1725626 OR `props-main`.`id` = 1729045)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640988' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-05' 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
$885,000
3
2
2,820
0.00
43319 Leach Rd
Ahwahnee, CA 93601
Last modified 2 months ago Fresno MLS last checked for updates 16 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.
