A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503768.85 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556797.15 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1266 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1766 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` = 1714472 OR `props-main`.`id` = 1726255 OR `props-main`.`id` = 1724394 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1727414 OR `props-main`.`id` = 1727413 OR `props-main`.`id` = 1726065 OR `props-main`.`id` = 1723085 OR `props-main`.`id` = 1723109 OR `props-main`.`id` = 1723111 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1723277 OR `props-main`.`id` = 1725714 OR `props-main`.`id` = 1728073 OR `props-main`.`id` = 1724937 OR `props-main`.`id` = 1725923 OR `props-main`.`id` = 1727873 OR `props-main`.`id` = 1724504 OR `props-main`.`id` = 1721785 OR `props-main`.`id` = 1725198 OR `props-main`.`id` = 1721787 OR `props-main`.`id` = 1723650 OR `props-main`.`id` = 1725753 OR `props-main`.`id` = 1726560 OR `props-main`.`id` = 1727882 OR `props-main`.`id` = 1692496 OR `props-main`.`id` = 1724708 OR `props-main`.`id` = 1718901 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1727361 OR `props-main`.`id` = 1725868 OR `props-main`.`id` = 1727323 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1720648 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1727754 OR `props-main`.`id` = 1727636 OR `props-main`.`id` = 1727637 OR `props-main`.`id` = 1726501 OR `props-main`.`id` = 1725550 OR `props-main`.`id` = 1721810 OR `props-main`.`id` = 1723886 OR `props-main`.`id` = 1709706 OR `props-main`.`id` = 1713707 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1722677 OR `props-main`.`id` = 1728125 OR `props-main`.`id` = 1722106 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1724044 OR `props-main`.`id` = 1727635 OR `props-main`.`id` = 1695237 OR `props-main`.`id` = 1726229 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1726160 OR `props-main`.`id` = 1727638 OR `props-main`.`id` = 1727753 OR `props-main`.`id` = 1726524 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1725613 OR `props-main`.`id` = 1721579 OR `props-main`.`id` = 1727122 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1702640 OR `props-main`.`id` = 1716857 OR `props-main`.`id` = 1716205 OR `props-main`.`id` = 1722028 OR `props-main`.`id` = 1726687 OR `props-main`.`id` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1710143 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1724100 OR `props-main`.`id` = 1721821 OR `props-main`.`id` = 1727245 OR `props-main`.`id` = 1727081 OR `props-main`.`id` = 1727527 OR `props-main`.`id` = 1701269 OR `props-main`.`id` = 1713497 OR `props-main`.`id` = 1723141 OR `props-main`.`id` = 1726292)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41088025' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-23' 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();
9
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$550,000
3
2
1,600
0.14
1795 Brookside Dr
Manteca, CA 95336
$540,000
3
2
1,642
0.12
196 Dyer Ave
Manteca, CA 95336
$539,950
3
2
1,420
0.12
250 Dyer Ave
Manteca, CA 95336
$525,000
3
2
1,446
0.15
1266 Wimbledon Way
Manteca, CA 95336
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.
