Attached, Boat Dock, Garage Door Opener, Garage Facing Front
Garage Spaces
2.00
Lot Features
Gated Community, Lake Access, Landscape Back, Landscape Front, Low Maintenance
APN
061 050 012 000
Land Use
Residential
Topography
Downslope, Level
Frontage Type
Waterfront, Lakefront
View Description
Water, Lake, Mountains
Fencing
Back Yard, Fenced
Horse Property
No
Road Surface Type
Paved
Zoning Description
R1-Single Family
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
153
Association Fee Frequency
Monthly
Association Features
Recreation Facilities, Tennis Courts, Lake
Senior Community
No
School District (County)
Calaveras
Elementary School District
Mark Twain Union
Middle or Junior School District
Mark Twain Union
Senior High School District
Brett Harte Union
Census Tract
1.23
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2610600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2885400 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2747 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3247 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` = 1736535 OR `props-main`.`id` = 1786485 OR `props-main`.`id` = 1705511 OR `props-main`.`id` = 1759620 OR `props-main`.`id` = 1758858 OR `props-main`.`id` = 1723479 OR `props-main`.`id` = 1757190 OR `props-main`.`id` = 1786649 OR `props-main`.`id` = 1756172 OR `props-main`.`id` = 1728595 OR `props-main`.`id` = 1786931 OR `props-main`.`id` = 1786495 OR `props-main`.`id` = 1786698 OR `props-main`.`id` = 1786368 OR `props-main`.`id` = 1786537 OR `props-main`.`id` = 1786028 OR `props-main`.`id` = 1786033 OR `props-main`.`id` = 1786027 OR `props-main`.`id` = 1771515 OR `props-main`.`id` = 1786894 OR `props-main`.`id` = 1761474 OR `props-main`.`id` = 1786339 OR `props-main`.`id` = 1786545 OR `props-main`.`id` = 1786531 OR `props-main`.`id` = 1726897 OR `props-main`.`id` = 1782222 OR `props-main`.`id` = 1786932 OR `props-main`.`id` = 1786600 OR `props-main`.`id` = 1786345 OR `props-main`.`id` = 1791149 OR `props-main`.`id` = 1786479 OR `props-main`.`id` = 1757779 OR `props-main`.`id` = 1786452 OR `props-main`.`id` = 1718261 OR `props-main`.`id` = 1761440 OR `props-main`.`id` = 1786680 OR `props-main`.`id` = 1786842 OR `props-main`.`id` = 1717064 OR `props-main`.`id` = 1765816 OR `props-main`.`id` = 1764175 OR `props-main`.`id` = 1786759 OR `props-main`.`id` = 1790118 OR `props-main`.`id` = 1786326 OR `props-main`.`id` = 1728235 OR `props-main`.`id` = 1716570 OR `props-main`.`id` = 1724949 OR `props-main`.`id` = 1728634 OR `props-main`.`id` = 1710212 OR `props-main`.`id` = 1786532 OR `props-main`.`id` = 1786486 OR `props-main`.`id` = 1786606 OR `props-main`.`id` = 1745928 OR `props-main`.`id` = 1760232 OR `props-main`.`id` = 1786421 OR `props-main`.`id` = 1786464 OR `props-main`.`id` = 1786534 OR `props-main`.`id` = 1732097 OR `props-main`.`id` = 1749677 OR `props-main`.`id` = 1750890 OR `props-main`.`id` = 1786597 OR `props-main`.`id` = 1751161 OR `props-main`.`id` = 1786854 OR `props-main`.`id` = 1786543 OR `props-main`.`id` = 1786919 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1760364 OR `props-main`.`id` = 1786616 OR `props-main`.`id` = 1789093 OR `props-main`.`id` = 1772319 OR `props-main`.`id` = 1773219 OR `props-main`.`id` = 1786518 OR `props-main`.`id` = 1786598 OR `props-main`.`id` = 1786889 OR `props-main`.`id` = 1773908 OR `props-main`.`id` = 1759283 OR `props-main`.`id` = 1736807 OR `props-main`.`id` = 1754764 OR `props-main`.`id` = 1746947 OR `props-main`.`id` = 1786604 OR `props-main`.`id` = 1770215 OR `props-main`.`id` = 1786474 OR `props-main`.`id` = 1786903 OR `props-main`.`id` = 1728709 OR `props-main`.`id` = 1764140 OR `props-main`.`id` = 1741778 OR `props-main`.`id` = 1786887 OR `props-main`.`id` = 1786710 OR `props-main`.`id` = 1712637 OR `props-main`.`id` = 1715994 OR `props-main`.`id` = 1715995 OR `props-main`.`id` = 1728549 OR `props-main`.`id` = 1728950 OR `props-main`.`id` = 1786431 OR `props-main`.`id` = 1781085 OR `props-main`.`id` = 1737005 OR `props-main`.`id` = 1786146 OR `props-main`.`id` = 1786577 OR `props-main`.`id` = 1786930)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226110574' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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 Michael Mayer, RE/MAX GOLD Copperopolis 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.
