Courtesy of Donna Pride, London Properties, Ltd. - [email protected]
No need to look any further! This INSANE property is where mountain retreat meets Martha Stewart meets peaceful living and it is truly one of a kind! Tucked away at the end of a quiet cul-de-sac, this property offers the privacy, serenity, and feeling of being miles away from everything, yet you are surprisingly close to town and just a beautiful drive from Yosemite National Park. It is the best of mountain living without giving up convenience. A lovely driveway winds its way up to the gorgeous, completely remodeled home and incredible shop. The landscaping is truly out of a magazine, creating a private mountain oasis with multiple patios, gathering areas, and peaceful places to enjoy the outdoors. Whether you are entertaining friends, sipping your morning coffee, watching the sunset, or soaking in the huge spa while taking in the beautiful ridge views, outdoor living is a huge part of what makes this property so special! The entire home has been remodeled inside and out with fresh interior and exterior paint, new kitchen appliances, engineered hardwood flooring downstairs, and brand-new LVP flooring upstairs. The primary bedroom is conveniently located downstairs and is an absolute dream, opening directly onto the gorgeous outdoor living area. The home blends beautifully with its natural mountain surroundings while offering the comfort and style you want in a true retreat. And then there is the incredible drive-through shop! Whether you have mountain toys, multiple vehicles, a boat, RV, ATVs, a workshop, or simply need an amazing amount of storage, this space is ready for whatever mountain life brings. The property also features three water storage tanks, including one for additional fire protection with fire hookups and another designed to capture and recycle rain runoff for landscaping. A new hot water heater and a back-up generac generator are also added features!.There is simply WAY too much here to explain in an MLS description. Does this belong in a mountain living magazine, on the set of a Hallmark movie, or as one of the most successful and unique vacation properties in the area? Maybe all three! Come experience this extraordinary mountain retreat for yourself. You may never want to leave!!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1990
Region
Foothill
# of Stories
Two
Price Per Square Foot
$318
Price Per Acre
$323,237
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Propane
Special Features
Water Softener
REO / Bank Owned
No
Cross Street Address
Rd 426
Directions
From Oakhurst
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Lower Level
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Refrigerator
Existing RV Parking, Work/Shop Area, Drive Thru, Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Cul De Sac
APN
066 231 008
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Yosemite
School Type 3
Grade School
School Name 3
Oakhurst
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 817950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2202 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2702 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` = 1722630 OR `props-main`.`id` = 1722627 OR `props-main`.`id` = 1725362 OR `props-main`.`id` = 1750941 OR `props-main`.`id` = 1665802 OR `props-main`.`id` = 1687546 OR `props-main`.`id` = 1753378 OR `props-main`.`id` = 1753373 OR `props-main`.`id` = 1704571 OR `props-main`.`id` = 1722607 OR `props-main`.`id` = 1722605 OR `props-main`.`id` = 1679689 OR `props-main`.`id` = 1750841 OR `props-main`.`id` = 1750825 OR `props-main`.`id` = 1679681 OR `props-main`.`id` = 1757110 OR `props-main`.`id` = 1744964 OR `props-main`.`id` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1728827 OR `props-main`.`id` = 1721998 OR `props-main`.`id` = 1725136 OR `props-main`.`id` = 1725616 OR `props-main`.`id` = 1762417 OR `props-main`.`id` = 1762419 OR `props-main`.`id` = 1726471 OR `props-main`.`id` = 1726397 OR `props-main`.`id` = 1766543 OR `props-main`.`id` = 1708101 OR `props-main`.`id` = 1708086 OR `props-main`.`id` = 1666389 OR `props-main`.`id` = 1761777 OR `props-main`.`id` = 1761776 OR `props-main`.`id` = 1753687 OR `props-main`.`id` = 1753685 OR `props-main`.`id` = 1723104 OR `props-main`.`id` = 1711360 OR `props-main`.`id` = 1764802 OR `props-main`.`id` = 1716257 OR `props-main`.`id` = 1716235 OR `props-main`.`id` = 1730747 OR `props-main`.`id` = 1730719 OR `props-main`.`id` = 1719802 OR `props-main`.`id` = 1754789 OR `props-main`.`id` = 1703772 OR `props-main`.`id` = 1719818 OR `props-main`.`id` = 1720602 OR `props-main`.`id` = 1725699 OR `props-main`.`id` = 1724494 OR `props-main`.`id` = 1692450 OR `props-main`.`id` = 1692558 OR `props-main`.`id` = 1694054 OR `props-main`.`id` = 1723815 OR `props-main`.`id` = 1764798 OR `props-main`.`id` = 1728881 OR `props-main`.`id` = 1728903 OR `props-main`.`id` = 1760690 OR `props-main`.`id` = 1702609 OR `props-main`.`id` = 1741508 OR `props-main`.`id` = 1732954 OR `props-main`.`id` = 1702613 OR `props-main`.`id` = 1699976 OR `props-main`.`id` = 1699978 OR `props-main`.`id` = 1719668 OR `props-main`.`id` = 1728186 OR `props-main`.`id` = 1721258 OR `props-main`.`id` = 1751566 OR `props-main`.`id` = 1751565 OR `props-main`.`id` = 1721259 OR `props-main`.`id` = 1755532 OR `props-main`.`id` = 1755523 OR `props-main`.`id` = 1722262 OR `props-main`.`id` = 1722266 OR `props-main`.`id` = 1731615 OR `props-main`.`id` = 1746459 OR `props-main`.`id` = 1747197 OR `props-main`.`id` = 1747216 OR `props-main`.`id` = 1713324 OR `props-main`.`id` = 1746236 OR `props-main`.`id` = 1728593 OR `props-main`.`id` = 1758731 OR `props-main`.`id` = 1707103 OR `props-main`.`id` = 1728429 OR `props-main`.`id` = 1730661 OR `props-main`.`id` = 1730679 OR `props-main`.`id` = 1723885 OR `props-main`.`id` = 1723883 OR `props-main`.`id` = 1716163 OR `props-main`.`id` = 1715911 OR `props-main`.`id` = 1736015 OR `props-main`.`id` = 1735970 OR `props-main`.`id` = 1723749 OR `props-main`.`id` = 1719508 OR `props-main`.`id` = 1723737 OR `props-main`.`id` = 1746794 OR `props-main`.`id` = 1746838 OR `props-main`.`id` = 1733283 OR `props-main`.`id` = 1734047 OR `props-main`.`id` = 1700176 OR `props-main`.`id` = 1700181)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654234' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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
Last modified 2 hours ago Fresno MLS last checked for updates 2 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.
