A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 855000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 945000 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) >= 2468 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2968 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` = 1727607 OR `props-main`.`id` = 1741140 OR `props-main`.`id` = 1726466 OR `props-main`.`id` = 1712977 OR `props-main`.`id` = 1727613 OR `props-main`.`id` = 1714623 OR `props-main`.`id` = 1741196 OR `props-main`.`id` = 1721831 OR `props-main`.`id` = 1716838 OR `props-main`.`id` = 1740982 OR `props-main`.`id` = 1744152 OR `props-main`.`id` = 1735234 OR `props-main`.`id` = 1736172 OR `props-main`.`id` = 1736569 OR `props-main`.`id` = 1727967 OR `props-main`.`id` = 1695310 OR `props-main`.`id` = 1743955 OR `props-main`.`id` = 1735920 OR `props-main`.`id` = 1726698 OR `props-main`.`id` = 1743015 OR `props-main`.`id` = 1723690 OR `props-main`.`id` = 1732825 OR `props-main`.`id` = 1727548 OR `props-main`.`id` = 1725576 OR `props-main`.`id` = 1727212 OR `props-main`.`id` = 1711310 OR `props-main`.`id` = 1730626 OR `props-main`.`id` = 1723480 OR `props-main`.`id` = 1737907 OR `props-main`.`id` = 1725994 OR `props-main`.`id` = 1725924 OR `props-main`.`id` = 1728759 OR `props-main`.`id` = 1726379 OR `props-main`.`id` = 1719539 OR `props-main`.`id` = 1735298 OR `props-main`.`id` = 1719209 OR `props-main`.`id` = 1740755 OR `props-main`.`id` = 1726269 OR `props-main`.`id` = 1731020 OR `props-main`.`id` = 1727641 OR `props-main`.`id` = 1722277 OR `props-main`.`id` = 1719271 OR `props-main`.`id` = 1727988 OR `props-main`.`id` = 1740556 OR `props-main`.`id` = 1738694)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82044347' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-30' 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:
$855,000
4
4
2,660
0.23
655 Mono St
Manteca, CA 95337
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.
