A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 446487.65 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 493486.35 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) >= 1388 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1888 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` = 1718089 OR `props-main`.`id` = 1714097 OR `props-main`.`id` = 1714503 OR `props-main`.`id` = 1714702 OR `props-main`.`id` = 1705512 OR `props-main`.`id` = 1720292 OR `props-main`.`id` = 1708448 OR `props-main`.`id` = 1705180 OR `props-main`.`id` = 1717441 OR `props-main`.`id` = 1718025 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1710232 OR `props-main`.`id` = 1714796 OR `props-main`.`id` = 1689989 OR `props-main`.`id` = 1717442 OR `props-main`.`id` = 1714815 OR `props-main`.`id` = 1705479 OR `props-main`.`id` = 1716006 OR `props-main`.`id` = 1705976 OR `props-main`.`id` = 1705482 OR `props-main`.`id` = 1708035 OR `props-main`.`id` = 1717126 OR `props-main`.`id` = 1708135 OR `props-main`.`id` = 1714559 OR `props-main`.`id` = 1688898 OR `props-main`.`id` = 1716778 OR `props-main`.`id` = 1718683 OR `props-main`.`id` = 1718026 OR `props-main`.`id` = 1708395 OR `props-main`.`id` = 1705535 OR `props-main`.`id` = 1714403 OR `props-main`.`id` = 1696108 OR `props-main`.`id` = 1717247 OR `props-main`.`id` = 1714145 OR `props-main`.`id` = 1705529 OR `props-main`.`id` = 1714817 OR `props-main`.`id` = 1714137 OR `props-main`.`id` = 1714554 OR `props-main`.`id` = 1719644 OR `props-main`.`id` = 1714144 OR `props-main`.`id` = 1584926 OR `props-main`.`id` = 1714701 OR `props-main`.`id` = 1706913 OR `props-main`.`id` = 1717476 OR `props-main`.`id` = 1714794 OR `props-main`.`id` = 1697375 OR `props-main`.`id` = 1717246 OR `props-main`.`id` = 1714210 OR `props-main`.`id` = 1714142 OR `props-main`.`id` = 1703721 OR `props-main`.`id` = 1708243 OR `props-main`.`id` = 1719707 OR `props-main`.`id` = 1711100 OR `props-main`.`id` = 1714289 OR `props-main`.`id` = 1716306 OR `props-main`.`id` = 1712972 OR `props-main`.`id` = 1705310 OR `props-main`.`id` = 1717588 OR `props-main`.`id` = 1709242 OR `props-main`.`id` = 1714301 OR `props-main`.`id` = 1714552 OR `props-main`.`id` = 1714563 OR `props-main`.`id` = 1712637 OR `props-main`.`id` = 1715994 OR `props-main`.`id` = 1715995 OR `props-main`.`id` = 1714141 OR `props-main`.`id` = 1714562 OR `props-main`.`id` = 1712776 OR `props-main`.`id` = 1714553 OR `props-main`.`id` = 1714062 OR `props-main`.`id` = 1717654 OR `props-main`.`id` = 1716488 OR `props-main`.`id` = 1714849 OR `props-main`.`id` = 1717489 OR `props-main`.`id` = 1712471 OR `props-main`.`id` = 1705303 OR `props-main`.`id` = 1714715 OR `props-main`.`id` = 1690349 OR `props-main`.`id` = 1717662 OR `props-main`.`id` = 1700190 OR `props-main`.`id` = 1704710 OR `props-main`.`id` = 1714821 OR `props-main`.`id` = 1706067 OR `props-main`.`id` = 1718158 OR `props-main`.`id` = 1706676 OR `props-main`.`id` = 1716650 OR `props-main`.`id` = 1714457 OR `props-main`.`id` = 1705490 OR `props-main`.`id` = 1718141 OR `props-main`.`id` = 1714816 OR `props-main`.`id` = 1714456 OR `props-main`.`id` = 1714695 OR `props-main`.`id` = 1714143 OR `props-main`.`id` = 1713749 OR `props-main`.`id` = 1714555 OR `props-main`.`id` = 1705534 OR `props-main`.`id` = 1714773 OR `props-main`.`id` = 1714658 OR `props-main`.`id` = 1714819 OR `props-main`.`id` = 1714565 OR `props-main`.`id` = 1714411 OR `props-main`.`id` = 1714338)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224039237' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$450,000
3
2
1,884
1.00
1415 Papoose Dr
Copperopolis, CA 95228
Courtesy of Camila Heredia, Realty ONE Group Zoom 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.
