A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 523950 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) >= 1242 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1742 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` = 1779980 OR `props-main`.`id` = 1753630 OR `props-main`.`id` = 1777751 OR `props-main`.`id` = 1743458 OR `props-main`.`id` = 1743459 OR `props-main`.`id` = 1766705 OR `props-main`.`id` = 1763538 OR `props-main`.`id` = 1741199 OR `props-main`.`id` = 1777886 OR `props-main`.`id` = 1738176 OR `props-main`.`id` = 1728623 OR `props-main`.`id` = 1768403 OR `props-main`.`id` = 1748460 OR `props-main`.`id` = 1779811 OR `props-main`.`id` = 1780530 OR `props-main`.`id` = 1779934 OR `props-main`.`id` = 1765384 OR `props-main`.`id` = 1776767 OR `props-main`.`id` = 1749625 OR `props-main`.`id` = 1761731 OR `props-main`.`id` = 1771151 OR `props-main`.`id` = 1771377 OR `props-main`.`id` = 1775660 OR `props-main`.`id` = 1770852 OR `props-main`.`id` = 1752568 OR `props-main`.`id` = 1758956 OR `props-main`.`id` = 1771613 OR `props-main`.`id` = 1774636 OR `props-main`.`id` = 1757594 OR `props-main`.`id` = 1748746 OR `props-main`.`id` = 1771584 OR `props-main`.`id` = 1757220 OR `props-main`.`id` = 1773994 OR `props-main`.`id` = 1780413 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1748784 OR `props-main`.`id` = 1761042 OR `props-main`.`id` = 1756417 OR `props-main`.`id` = 1760916 OR `props-main`.`id` = 1776700 OR `props-main`.`id` = 1745646 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1779981 OR `props-main`.`id` = 1752579 OR `props-main`.`id` = 1721528 OR `props-main`.`id` = 1778669 OR `props-main`.`id` = 1779400 OR `props-main`.`id` = 1775553 OR `props-main`.`id` = 1759477 OR `props-main`.`id` = 1773274 OR `props-main`.`id` = 1767618 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1776745 OR `props-main`.`id` = 1749653 OR `props-main`.`id` = 1737016 OR `props-main`.`id` = 1761742 OR `props-main`.`id` = 1766163 OR `props-main`.`id` = 1770874 OR `props-main`.`id` = 1774324 OR `props-main`.`id` = 1727527 OR `props-main`.`id` = 1759037 OR `props-main`.`id` = 1760185 OR `props-main`.`id` = 1767782 OR `props-main`.`id` = 1774358 OR `props-main`.`id` = 1746775 OR `props-main`.`id` = 1773843 OR `props-main`.`id` = 1755126 OR `props-main`.`id` = 1773867 OR `props-main`.`id` = 1778208 OR `props-main`.`id` = 1772827 OR `props-main`.`id` = 1778533 OR `props-main`.`id` = 1722330 OR `props-main`.`id` = 1780367 OR `props-main`.`id` = 1749517 OR `props-main`.`id` = 1779635 OR `props-main`.`id` = 1778414 OR `props-main`.`id` = 1773554 OR `props-main`.`id` = 1773555 OR `props-main`.`id` = 1773662 OR `props-main`.`id` = 1773663 OR `props-main`.`id` = 1773660 OR `props-main`.`id` = 1773664)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist222132457' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-24' 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();
8
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$519,000
2
2
1,633
0.13
1534 Maple Valley St
Manteca, CA 95336
$515,000
2
2
1,633
0.14
2443 Plumcreek
Manteca, CA 95336
$509,999
3
2
1,674
0.17
264 Dana Ct
Manteca, CA 95336
$478,000
3
2
1,456
0.16
1372 Ruffino Ct
Manteca, CA 95336
Courtesy of Heather Ryans, Union Strong Homeowners, Inc. 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.
