Courtesy of Billy Lovewell, eXp Realty of California, Inc. - [email protected]
Breathtaking mountain views define this custom 2022 haven situated at the peak of a private cul-de-sac. Spanning nearly 4 acres of pristine bluff-front terrain bordering a community greenbelt, this estate offers unmatched seclusion. Engineered for maximum fire-resilience, the residence features a smooth stucco exterior, high-efficiency tile roof, and steel gutters with integrated drainage. The interior boasts 12' ceilings, 8mil lifeproof flooring, and stunning quartz countertops throughout a spacious open floor plan featuring a chef's kitchen with a central island and dedicated bar nook. The primary suite offers a resort-style retreat with a jetted tub, dual sinks, walk-in shower, and dual closets with custom shelving. Designed for total autonomy, the home includes an interior fire sprinkler system, tankless propane water heater, and fully owned solar that historically eliminates the annual true-up. A custom walk-bridge connects the residence to a permitted, 1,250sqft insulated shop (25x50) featuring 12' walls, 15' ridge, dual 10' bay doors, a coffee bar, storage loft, and a finished tool room wired for a backup generator. Outdoor luxury is anchored by a heated soaking tub positioned for endless hilltop views, with an additional pad offering ADU potential. This fortified compound offers the ultimate Yosemite Lakes Park resort lifestyle with direct access to 7+ miles of trails, a community pool, and a private lake, while being minutes from the 9-hole golf course, Fairway Caf, and Blue Heron Restaurant. Truly turn-key living with a finished 3-car garage and oversized stamped concrete driveway. Shop tool room fixtures/items excluded. Vehicle lift excluded but negotiable. Buyer to verify permits and square footage.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$306
Price Per Acre
$178,772
Days On London
25
Cumulative Days On London
25
County
Madera
REO / Bank Owned
No
Cross Street Address
Long Hollow Dr
Directions
From CA-41 North, left onto Yosemite Springs Parkway, left onto Long Hollow, right onto Acorn CT.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Propane
Sewer / Water
Public Water, Septic Tank, Community Well
Energy Efficiency
Tankless Water Heater
Solar
Yes
Solar Type
Owned
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
APN
093 220 015 000
Association / Park Amenities
Pool, Club House, Tennis, Security Guard, Lake/Pond, Playground
HOA Dues
160.00
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Rivergold
School Type 3
Grade School
School Name 3
Rivergold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 733950 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) >= 2036 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2536 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` = 1694180 OR `props-main`.`id` = 1715005 OR `props-main`.`id` = 1715000 OR `props-main`.`id` = 1726369 OR `props-main`.`id` = 1686833 OR `props-main`.`id` = 1728389 OR `props-main`.`id` = 1717434 OR `props-main`.`id` = 1717601 OR `props-main`.`id` = 1717602 OR `props-main`.`id` = 1717603 OR `props-main`.`id` = 1717604 OR `props-main`.`id` = 1717605 OR `props-main`.`id` = 1716966 OR `props-main`.`id` = 1719903 OR `props-main`.`id` = 1733186 OR `props-main`.`id` = 1718910 OR `props-main`.`id` = 1718896 OR `props-main`.`id` = 1687706 OR `props-main`.`id` = 1731554 OR `props-main`.`id` = 1685636 OR `props-main`.`id` = 1731367 OR `props-main`.`id` = 1727867 OR `props-main`.`id` = 1727890 OR `props-main`.`id` = 1704295 OR `props-main`.`id` = 1703800 OR `props-main`.`id` = 1731418 OR `props-main`.`id` = 1735505 OR `props-main`.`id` = 1726763 OR `props-main`.`id` = 1726776 OR `props-main`.`id` = 1731326 OR `props-main`.`id` = 1731414 OR `props-main`.`id` = 1701727 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1727196 OR `props-main`.`id` = 1728052 OR `props-main`.`id` = 1731383 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1731331 OR `props-main`.`id` = 1731471 OR `props-main`.`id` = 1731531 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1708116 OR `props-main`.`id` = 1704149 OR `props-main`.`id` = 1704013 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1724833 OR `props-main`.`id` = 1726030 OR `props-main`.`id` = 1714763 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1729357 OR `props-main`.`id` = 1729449 OR `props-main`.`id` = 1736004 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1725990 OR `props-main`.`id` = 1721266 OR `props-main`.`id` = 1718871 OR `props-main`.`id` = 1700844 OR `props-main`.`id` = 1732169 OR `props-main`.`id` = 1718863 OR `props-main`.`id` = 1733220 OR `props-main`.`id` = 1733238 OR `props-main`.`id` = 1718510 OR `props-main`.`id` = 1718429 OR `props-main`.`id` = 1718458 OR `props-main`.`id` = 1700853 OR `props-main`.`id` = 1726153 OR `props-main`.`id` = 1731407 OR `props-main`.`id` = 1731450 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1722852 OR `props-main`.`id` = 1705132 OR `props-main`.`id` = 1726219 OR `props-main`.`id` = 1735425 OR `props-main`.`id` = 1736539 OR `props-main`.`id` = 1736528 OR `props-main`.`id` = 1725196 OR `props-main`.`id` = 1731691 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1703905 OR `props-main`.`id` = 1726456 OR `props-main`.`id` = 1726449 OR `props-main`.`id` = 1703925 OR `props-main`.`id` = 1703646 OR `props-main`.`id` = 1703657 OR `props-main`.`id` = 1703656 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1727402 OR `props-main`.`id` = 1727475 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1727542 OR `props-main`.`id` = 1727556 OR `props-main`.`id` = 1731483 OR `props-main`.`id` = 1709899 OR `props-main`.`id` = 1722725 OR `props-main`.`id` = 1709957 OR `props-main`.`id` = 1722836 OR `props-main`.`id` = 1674929 OR `props-main`.`id` = 1737177 OR `props-main`.`id` = 1737168 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1731676 OR `props-main`.`id` = 1725475 OR `props-main`.`id` = 1725481 OR `props-main`.`id` = 1714054 OR `props-main`.`id` = 1731506 OR `props-main`.`id` = 1714048 OR `props-main`.`id` = 1729575 OR `props-main`.`id` = 1716191 OR `props-main`.`id` = 1716166 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1728398 OR `props-main`.`id` = 1704611 OR `props-main`.`id` = 1736895 OR `props-main`.`id` = 1736889 OR `props-main`.`id` = 1725795 OR `props-main`.`id` = 1726113 OR `props-main`.`id` = 1722603 OR `props-main`.`id` = 1713573 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1683078 OR `props-main`.`id` = 1706819 OR `props-main`.`id` = 1731334 OR `props-main`.`id` = 1722853 OR `props-main`.`id` = 1667788 OR `props-main`.`id` = 1715021 OR `props-main`.`id` = 1731509 OR `props-main`.`id` = 1714993 OR `props-main`.`id` = 1715010 OR `props-main`.`id` = 1727118 OR `props-main`.`id` = 1711485 OR `props-main`.`id` = 1711501 OR `props-main`.`id` = 1717498 OR `props-main`.`id` = 1722589 OR `props-main`.`id` = 1723500 OR `props-main`.`id` = 1725496 OR `props-main`.`id` = 1737131 OR `props-main`.`id` = 1728752 OR `props-main`.`id` = 1728755 OR `props-main`.`id` = 1733236 OR `props-main`.`id` = 1733607 OR `props-main`.`id` = 1703830 OR `props-main`.`id` = 1703810 OR `props-main`.`id` = 1684942 OR `props-main`.`id` = 1732154 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1729602)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646098' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
1
Similar Properties
$699,000
4
3
2,286
3.91
29200 Acorn Ct
Coarsegold, CA 93614
Last modified 1 month 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.
