A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 390450 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 431550 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) >= 1250 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1750 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` = 1705541 OR `props-main`.`id` = 1705530 OR `props-main`.`id` = 1689695 OR `props-main`.`id` = 1710282 OR `props-main`.`id` = 1710832 OR `props-main`.`id` = 1711055 OR `props-main`.`id` = 1705497 OR `props-main`.`id` = 1710356 OR `props-main`.`id` = 1710915 OR `props-main`.`id` = 1705520 OR `props-main`.`id` = 1710811 OR `props-main`.`id` = 1710318 OR `props-main`.`id` = 1705542 OR `props-main`.`id` = 1710863 OR `props-main`.`id` = 1705485 OR `props-main`.`id` = 1711110 OR `props-main`.`id` = 1710212 OR `props-main`.`id` = 1710764 OR `props-main`.`id` = 1710978 OR `props-main`.`id` = 1705512 OR `props-main`.`id` = 1710834 OR `props-main`.`id` = 1705816 OR `props-main`.`id` = 1708448 OR `props-main`.`id` = 1705180 OR `props-main`.`id` = 1688349 OR `props-main`.`id` = 1710823 OR `props-main`.`id` = 1710232 OR `props-main`.`id` = 1689989 OR `props-main`.`id` = 1711051 OR `props-main`.`id` = 1705479 OR `props-main`.`id` = 1710826 OR `props-main`.`id` = 1705976 OR `props-main`.`id` = 1710825 OR `props-main`.`id` = 1705482 OR `props-main`.`id` = 1708035 OR `props-main`.`id` = 1710254 OR `props-main`.`id` = 1708135 OR `props-main`.`id` = 1710827 OR `props-main`.`id` = 1688898 OR `props-main`.`id` = 1710829 OR `props-main`.`id` = 1710824 OR `props-main`.`id` = 1708395 OR `props-main`.`id` = 1701168 OR `props-main`.`id` = 1705535 OR `props-main`.`id` = 1710654 OR `props-main`.`id` = 1705525 OR `props-main`.`id` = 1696108 OR `props-main`.`id` = 1710369 OR `props-main`.`id` = 1705529 OR `props-main`.`id` = 1711053 OR `props-main`.`id` = 1710361 OR `props-main`.`id` = 1710821 OR `props-main`.`id` = 1705504 OR `props-main`.`id` = 1705521 OR `props-main`.`id` = 1710368 OR `props-main`.`id` = 1584926 OR `props-main`.`id` = 1710976 OR `props-main`.`id` = 1706913 OR `props-main`.`id` = 1702000 OR `props-main`.`id` = 1692111 OR `props-main`.`id` = 1697375 OR `props-main`.`id` = 1710440 OR `props-main`.`id` = 1710366 OR `props-main`.`id` = 1703721 OR `props-main`.`id` = 1708243 OR `props-main`.`id` = 1711100 OR `props-main`.`id` = 1686352 OR `props-main`.`id` = 1710520 OR `props-main`.`id` = 1705486 OR `props-main`.`id` = 1705310 OR `props-main`.`id` = 1709242 OR `props-main`.`id` = 1710531 OR `props-main`.`id` = 1710819 OR `props-main`.`id` = 1710831 OR `props-main`.`id` = 1710365 OR `props-main`.`id` = 1710830 OR `props-main`.`id` = 1710820 OR `props-main`.`id` = 1705532 OR `props-main`.`id` = 1710835 OR `props-main`.`id` = 1710257 OR `props-main`.`id` = 1705303 OR `props-main`.`id` = 1691249 OR `props-main`.`id` = 1710990 OR `props-main`.`id` = 1690349 OR `props-main`.`id` = 1709699 OR `props-main`.`id` = 1700190 OR `props-main`.`id` = 1706652 OR `props-main`.`id` = 1704710 OR `props-main`.`id` = 1697553 OR `props-main`.`id` = 1706067 OR `props-main`.`id` = 1704167 OR `props-main`.`id` = 1706676 OR `props-main`.`id` = 1710711 OR `props-main`.`id` = 1710966 OR `props-main`.`id` = 1705490 OR `props-main`.`id` = 1711052 OR `props-main`.`id` = 1710710 OR `props-main`.`id` = 1710969 OR `props-main`.`id` = 1710367 OR `props-main`.`id` = 1705488 OR `props-main`.`id` = 1710822)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226016751' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$429,999
3
2
1,571
0.41
4833 Pueblo Trl
Copperopolis, CA 95228
Courtesy of Rebecca King, Berkshire Hathaway HomeServices-Drysdale Properties 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.
