A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 455050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 502950 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) >= 1157 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1657 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` = 1735298 OR `props-main`.`id` = 1740755 OR `props-main`.`id` = 1731020 OR `props-main`.`id` = 1737814 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` = 1741364 OR `props-main`.`id` = 1717627 OR `props-main`.`id` = 1737202 OR `props-main`.`id` = 1726911 OR `props-main`.`id` = 1738286 OR `props-main`.`id` = 1738694 OR `props-main`.`id` = 1730597 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1726255 OR `props-main`.`id` = 1740619 OR `props-main`.`id` = 1729500 OR `props-main`.`id` = 1728910 OR `props-main`.`id` = 1728871 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1714173 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1740628 OR `props-main`.`id` = 1738088 OR `props-main`.`id` = 1727413 OR `props-main`.`id` = 1723791 OR `props-main`.`id` = 1726065 OR `props-main`.`id` = 1723085 OR `props-main`.`id` = 1738303 OR `props-main`.`id` = 1738305 OR `props-main`.`id` = 1738347 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1723277 OR `props-main`.`id` = 1725270 OR `props-main`.`id` = 1730585 OR `props-main`.`id` = 1741012 OR `props-main`.`id` = 1741115 OR `props-main`.`id` = 1740592 OR `props-main`.`id` = 1721785 OR `props-main`.`id` = 1721787 OR `props-main`.`id` = 1726560 OR `props-main`.`id` = 1739421 OR `props-main`.`id` = 1692496 OR `props-main`.`id` = 1737421 OR `props-main`.`id` = 1718901 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1725868 OR `props-main`.`id` = 1737801 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1740609 OR `props-main`.`id` = 1727275 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1727754 OR `props-main`.`id` = 1738789 OR `props-main`.`id` = 1738790 OR `props-main`.`id` = 1729196 OR `props-main`.`id` = 1725550 OR `props-main`.`id` = 1732029 OR `props-main`.`id` = 1721810 OR `props-main`.`id` = 1723886 OR `props-main`.`id` = 1709706 OR `props-main`.`id` = 1738250 OR `props-main`.`id` = 1736565 OR `props-main`.`id` = 1737006 OR `props-main`.`id` = 1728125 OR `props-main`.`id` = 1728833 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1724044 OR `props-main`.`id` = 1737863 OR `props-main`.`id` = 1727635 OR `props-main`.`id` = 1729011 OR `props-main`.`id` = 1738657 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1726524 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1737994 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` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1730608 OR `props-main`.`id` = 1740836 OR `props-main`.`id` = 1721821)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist222134625' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$499,950
3
2
1,578
0.20
1275 Armstrong Dr
Manteca, CA 95336
$485,000
3
2
1,316
0.14
1064 Tioga
Manteca, CA 95337
$474,900
3
3
1,366
0.16
1037 Tenaya Ct
Manteca, CA 95337
$465,000
4
2
1,344
0.15
241 Martha St
Manteca, CA 95337
Courtesy of Steven Vanzetti, Spandrel Realty 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.
