A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1893 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2393 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` = 1723479 OR `props-main`.`id` = 1725606 OR `props-main`.`id` = 1728987 OR `props-main`.`id` = 1725001 OR `props-main`.`id` = 1722413 OR `props-main`.`id` = 1728595 OR `props-main`.`id` = 1714818 OR `props-main`.`id` = 1716813 OR `props-main`.`id` = 1720679 OR `props-main`.`id` = 1728707 OR `props-main`.`id` = 1721888 OR `props-main`.`id` = 1712576 OR `props-main`.`id` = 1714758 OR `props-main`.`id` = 1705530 OR `props-main`.`id` = 1720677 OR `props-main`.`id` = 1720266 OR `props-main`.`id` = 1732045 OR `props-main`.`id` = 1714122 OR `props-main`.`id` = 1714564 OR `props-main`.`id` = 1722691 OR `props-main`.`id` = 1721307 OR `props-main`.`id` = 1726897 OR `props-main`.`id` = 1714820 OR `props-main`.`id` = 1713788 OR `props-main`.`id` = 1725003 OR `props-main`.`id` = 1731973 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` = 1728235 OR `props-main`.`id` = 1728071 OR `props-main`.`id` = 1727143 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` = 1722160 OR `props-main`.`id` = 1715685 OR `props-main`.`id` = 1728687 OR `props-main`.`id` = 1716339 OR `props-main`.`id` = 1714503 OR `props-main`.`id` = 1714702 OR `props-main`.`id` = 1721587 OR `props-main`.`id` = 1732097 OR `props-main`.`id` = 1720292 OR `props-main`.`id` = 1728027 OR `props-main`.`id` = 1722541 OR `props-main`.`id` = 1717441 OR `props-main`.`id` = 1731231 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1710232 OR `props-main`.`id` = 1717442 OR `props-main`.`id` = 1732028 OR `props-main`.`id` = 1717126 OR `props-main`.`id` = 1725636 OR `props-main`.`id` = 1708135 OR `props-main`.`id` = 1718683 OR `props-main`.`id` = 1728672 OR `props-main`.`id` = 1726918 OR `props-main`.`id` = 1717247 OR `props-main`.`id` = 1720450 OR `props-main`.`id` = 1728203 OR `props-main`.`id` = 1714817 OR `props-main`.`id` = 1720685 OR `props-main`.`id` = 1724698 OR `props-main`.`id` = 1731204 OR `props-main`.`id` = 1714794 OR `props-main`.`id` = 1703721)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226600015' 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
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 10,400 active listings.
Courtesy of Rachel Perkins, 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.
