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` = 1775542 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` = 1773539 OR `props-main`.`id` = 1756172 OR `props-main`.`id` = 1728987 OR `props-main`.`id` = 1756173 OR `props-main`.`id` = 1728595 OR `props-main`.`id` = 1773697 OR `props-main`.`id` = 1773413 OR `props-main`.`id` = 1773577 OR `props-main`.`id` = 1773282 OR `props-main`.`id` = 1773451 OR `props-main`.`id` = 1742991 OR `props-main`.`id` = 1743363 OR `props-main`.`id` = 1751439 OR `props-main`.`id` = 1771515 OR `props-main`.`id` = 1781113 OR `props-main`.`id` = 1779710 OR `props-main`.`id` = 1761474 OR `props-main`.`id` = 1773253 OR `props-main`.`id` = 1773457 OR `props-main`.`id` = 1773446 OR `props-main`.`id` = 1726897 OR `props-main`.`id` = 1773698 OR `props-main`.`id` = 1773495 OR `props-main`.`id` = 1773259 OR `props-main`.`id` = 1773400 OR `props-main`.`id` = 1757779 OR `props-main`.`id` = 1773375 OR `props-main`.`id` = 1718261 OR `props-main`.`id` = 1761440 OR `props-main`.`id` = 1773563 OR `props-main`.`id` = 1773685 OR `props-main`.`id` = 1717064 OR `props-main`.`id` = 1765816 OR `props-main`.`id` = 1764175 OR `props-main`.`id` = 1773618 OR `props-main`.`id` = 1773240 OR `props-main`.`id` = 1728235 OR `props-main`.`id` = 1716570 OR `props-main`.`id` = 1724949 OR `props-main`.`id` = 1711110 OR `props-main`.`id` = 1728634 OR `props-main`.`id` = 1710212 OR `props-main`.`id` = 1775763 OR `props-main`.`id` = 1773407 OR `props-main`.`id` = 1773500 OR `props-main`.`id` = 1745928 OR `props-main`.`id` = 1760232 OR `props-main`.`id` = 1773343 OR `props-main`.`id` = 1773387 OR `props-main`.`id` = 1773449 OR `props-main`.`id` = 1732097 OR `props-main`.`id` = 1773436 OR `props-main`.`id` = 1749677 OR `props-main`.`id` = 1750890 OR `props-main`.`id` = 1773492 OR `props-main`.`id` = 1751161 OR `props-main`.`id` = 1773801 OR `props-main`.`id` = 1773456 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1760364 OR `props-main`.`id` = 1773506 OR `props-main`.`id` = 1772319 OR `props-main`.`id` = 1718683 OR `props-main`.`id` = 1773219 OR `props-main`.`id` = 1773438 OR `props-main`.`id` = 1773493 OR `props-main`.`id` = 1779116 OR `props-main`.`id` = 1773908 OR `props-main`.`id` = 1759283 OR `props-main`.`id` = 1754457 OR `props-main`.`id` = 1736807 OR `props-main`.`id` = 1754764 OR `props-main`.`id` = 1746947 OR `props-main`.`id` = 1773498 OR `props-main`.`id` = 1770215 OR `props-main`.`id` = 1773396 OR `props-main`.`id` = 1780838 OR `props-main`.`id` = 1728709 OR `props-main`.`id` = 1764140 OR `props-main`.`id` = 1741778 OR `props-main`.`id` = 1779935 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` = 1773445 OR `props-main`.`id` = 1773353 OR `props-main`.`id` = 1781085 OR `props-main`.`id` = 1737005 OR `props-main`.`id` = 1754383 OR `props-main`.`id` = 1773696)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226110574' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-25' 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.
