A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 926250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1023750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3086 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3586 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` = 1687492 OR `props-main`.`id` = 1714965 OR `props-main`.`id` = 1705511 OR `props-main`.`id` = 1706088 OR `props-main`.`id` = 1706006 OR `props-main`.`id` = 1705833 OR `props-main`.`id` = 1706063 OR `props-main`.`id` = 1714818 OR `props-main`.`id` = 1716813 OR `props-main`.`id` = 1714388 OR `props-main`.`id` = 1714241 OR `props-main`.`id` = 1705541 OR `props-main`.`id` = 1712576 OR `props-main`.`id` = 1714758 OR `props-main`.`id` = 1705530 OR `props-main`.`id` = 1689695 OR `props-main`.`id` = 1712966 OR `props-main`.`id` = 1714122 OR `props-main`.`id` = 1714564 OR `props-main`.`id` = 1714820 OR `props-main`.`id` = 1713788 OR `props-main`.`id` = 1705533 OR `props-main`.`id` = 1714132 OR `props-main`.`id` = 1715456 OR `props-main`.`id` = 1714642 OR `props-main`.`id` = 1718261 OR `props-main`.`id` = 1717064 OR `props-main`.`id` = 1718089 OR `props-main`.`id` = 1716548 OR `props-main`.`id` = 1714097 OR `props-main`.`id` = 1705542 OR `props-main`.`id` = 1716570 OR `props-main`.`id` = 1705485 OR `props-main`.`id` = 1711110 OR `props-main`.`id` = 1710212 OR `props-main`.`id` = 1715685 OR `props-main`.`id` = 1716339 OR `props-main`.`id` = 1714503 OR `props-main`.`id` = 1714702 OR `props-main`.`id` = 1705512 OR `props-main`.`id` = 1714566 OR `props-main`.`id` = 1705816 OR `props-main`.`id` = 1708448 OR `props-main`.`id` = 1717441 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1710232 OR `props-main`.`id` = 1717442 OR `props-main`.`id` = 1705976 OR `props-main`.`id` = 1717126 OR `props-main`.`id` = 1708135 OR `props-main`.`id` = 1718683 OR `props-main`.`id` = 1716408 OR `props-main`.`id` = 1701168 OR `props-main`.`id` = 1714403 OR `props-main`.`id` = 1717247 OR `props-main`.`id` = 1714817 OR `props-main`.`id` = 1705504 OR `props-main`.`id` = 1714794 OR `props-main`.`id` = 1714210 OR `props-main`.`id` = 1703721 OR `props-main`.`id` = 1717662)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226038048' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-28' 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
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,400 active listings.
Courtesy of Roxanne Schilling, 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.
