Courtesy of Katie Miller, London Properties, Ltd. - [email protected]
3.72 fenced and gated acres in the prestigious Quartz Mountain neighborhood, this colonial-style property offers privacy, flexibility, and sweeping panoramic views. The home has been freshly painted and features a newer HVAC system, providing comfort and peace of mind. With two separate entrances, the layout supports multiple uses, ideal for guests, multi-generational living, or future expansion. A detached ADU adds immediate income or guest potential, while the workshop and barn provide space for hobbies, storage, or small-scale agricultural use. The property also includes an orchard, enhancing both the lifestyle appeal and the long-term value of the land. The expansive acreage allows room to breathe, entertain, or simply enjoy the surrounding scenery, all while remaining in a highly sought-after setting. Whether you're seeking a private estate, a flexible investment opportunity, or a refined country retreat, this Quartz Mountain property delivers both lifestyle and upside.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2000
Region
Foothill
# of Stories
Two
Price Per Square Foot
$213
Price Per Acre
$195,968
Days On London
123
Cumulative Days On London
123
County
Madera
Reports Available
CC&Rs
Leased Equipment
Water Softener
Special Features
Security Gate, Water Softener
REO / Bank Owned
No
Cross Street Address
Road 417
Directions
Hwy 41, turn onto Road 417, turn right onto Quartz Mountain Rd, turn right onto Longview Ln W, property on right.
Style
Colonial
Heating & Cooling
Central Heat & Cool, Evaporative Cool, Floor or Wall Unit
Laundry
In Garage, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Barn, Shed, Other/See Remarks
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Microwave, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 692550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 765450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3178 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3678 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` = 1703154 OR `props-main`.`id` = 1717727 OR `props-main`.`id` = 1717714 OR `props-main`.`id` = 1622991 OR `props-main`.`id` = 1735362 OR `props-main`.`id` = 1731465 OR `props-main`.`id` = 1706720 OR `props-main`.`id` = 1706689 OR `props-main`.`id` = 1665733 OR `props-main`.`id` = 1665734 OR `props-main`.`id` = 1687540 OR `props-main`.`id` = 1687541 OR `props-main`.`id` = 1731198 OR `props-main`.`id` = 1727052 OR `props-main`.`id` = 1733161 OR `props-main`.`id` = 1711503 OR `props-main`.`id` = 1711512 OR `props-main`.`id` = 1734080 OR `props-main`.`id` = 1733374 OR `props-main`.`id` = 1733314 OR `props-main`.`id` = 1735470 OR `props-main`.`id` = 1722178 OR `props-main`.`id` = 1725484 OR `props-main`.`id` = 1725498 OR `props-main`.`id` = 1723235 OR `props-main`.`id` = 1690456 OR `props-main`.`id` = 1722179 OR `props-main`.`id` = 1665689 OR `props-main`.`id` = 1731337 OR `props-main`.`id` = 1665648 OR `props-main`.`id` = 1731530 OR `props-main`.`id` = 1717119 OR `props-main`.`id` = 1717142)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643474' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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
$729,000
5
5
3,428
3.72
31140 Quartz Mountain Rd
Coarsegold, CA 93614
Last modified 12 hours ago Fresno MLS last checked for updates 22 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.
