Please provide the following information and Jesse Marin will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.jessemarin-realtor.com/agent/15109/jesse-marin/property/link/metrolist/226600326/31540-Lucian-Dr/Coarsegold/https://www.jessemarin-realtor.com/images/props/metrolist/full/226600326.jpgLondon Properties Coarsegold Real Estate | 31540 Lucian Dr
Private country living on a park-like 2.9-acre parcel with amazing views, mature oak trees, and natural rock outcroppings. Tucked away on a quiet cul-de-sac, this single-story home offers space, privacy, and a peaceful setting. Vaulted ceilings in main living area. Functional kitchen with tile counters, center island, and ample cabinetry opens to a spacious dining area. Large concrete patio is ideal for outdoor entertaining, relaxing, or taking in the scenery. Fully fenced with gated entry, attached garage, and additional parking. Ideal for those seeking land, privacy, and true rural living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1999
Levels
One
Home Warranty
No
Directions to Property
North on Highway 41 to Road 416 to left on Savage to left on Lucian
Cross Street
Savage Rd / Lucian Dr
County
Madera
Construction Materials
Stucco
Roof
Tile
Heating
Central
Cooling
Central
Laundry Features
Inside Area
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Free Standing
Flooring
Laminate, Tile, Carpet
Appliances
Microwave, Disposal, Dishwasher
Kitchen Features
Pantry, Breakfast Area
Dining Room Features
Dining/Living Combo
Pool
No
Spa
No
Utilities
Propane, Public
Sewer
Holding Tank
Energy Efficient
Windows
Parking Features
RV Possible, Attached
Garage Spaces
2.00
APN
545 200 290 00
Horse Property
No
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Madera
Elementary School District
Yosemite Unified
Middle or Junior School District
Yosemite Unified
Senior High School District
Yosemite Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 470250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 519750 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) >= 2098 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2598 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` = 1689800 OR `props-main`.`id` = 1720964 OR `props-main`.`id` = 1720988 OR `props-main`.`id` = 1726519 OR `props-main`.`id` = 1704611 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1716811 OR `props-main`.`id` = 1731334 OR `props-main`.`id` = 1719848 OR `props-main`.`id` = 1727118 OR `props-main`.`id` = 1717498 OR `props-main`.`id` = 1695425 OR `props-main`.`id` = 1622991 OR `props-main`.`id` = 1722835 OR `props-main`.`id` = 1731309 OR `props-main`.`id` = 1731485 OR `props-main`.`id` = 1731525 OR `props-main`.`id` = 1731699 OR `props-main`.`id` = 1704425 OR `props-main`.`id` = 1731430 OR `props-main`.`id` = 1722723 OR `props-main`.`id` = 1732337 OR `props-main`.`id` = 1731670 OR `props-main`.`id` = 1719176 OR `props-main`.`id` = 1719070 OR `props-main`.`id` = 1726037 OR `props-main`.`id` = 1720089 OR `props-main`.`id` = 1711484 OR `props-main`.`id` = 1711502 OR `props-main`.`id` = 1708115 OR `props-main`.`id` = 1731399 OR `props-main`.`id` = 1708102 OR `props-main`.`id` = 1714393 OR `props-main`.`id` = 1665717 OR `props-main`.`id` = 1687535 OR `props-main`.`id` = 1716812 OR `props-main`.`id` = 1687573 OR `props-main`.`id` = 1665915 OR `props-main`.`id` = 1731464 OR `props-main`.`id` = 1709430 OR `props-main`.`id` = 1720783 OR `props-main`.`id` = 1717404 OR `props-main`.`id` = 1719738 OR `props-main`.`id` = 1681245 OR `props-main`.`id` = 1687501 OR `props-main`.`id` = 1722178 OR `props-main`.`id` = 1725484 OR `props-main`.`id` = 1722419 OR `props-main`.`id` = 1725498 OR `props-main`.`id` = 1723235 OR `props-main`.`id` = 1690456 OR `props-main`.`id` = 1687556 OR `props-main`.`id` = 1722179 OR `props-main`.`id` = 1728448)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226600326' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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
Courtesy of Jesus Marin, London Properties LTD IDX provided by Reliance Marketing
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.
