A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 512050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 565950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2100 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2600 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` = 1686705 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1689082 OR `props-main`.`id` = 1689397 OR `props-main`.`id` = 1689830 OR `props-main`.`id` = 1676144 OR `props-main`.`id` = 1678660 OR `props-main`.`id` = 1689359 OR `props-main`.`id` = 1658001 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1690174 OR `props-main`.`id` = 1660695 OR `props-main`.`id` = 1662021 OR `props-main`.`id` = 1684101 OR `props-main`.`id` = 1681503 OR `props-main`.`id` = 1689592 OR `props-main`.`id` = 1688169 OR `props-main`.`id` = 1676556 OR `props-main`.`id` = 1689296 OR `props-main`.`id` = 1690288 OR `props-main`.`id` = 1681349 OR `props-main`.`id` = 1690425 OR `props-main`.`id` = 1679400 OR `props-main`.`id` = 1679086 OR `props-main`.`id` = 1677754 OR `props-main`.`id` = 1685235 OR `props-main`.`id` = 1690156 OR `props-main`.`id` = 1688064 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1689596 OR `props-main`.`id` = 1689866 OR `props-main`.`id` = 1644786 OR `props-main`.`id` = 1678556 OR `props-main`.`id` = 1690026 OR `props-main`.`id` = 1687994 OR `props-main`.`id` = 1677611 OR `props-main`.`id` = 1689593 OR `props-main`.`id` = 1688350 OR `props-main`.`id` = 1681640 OR `props-main`.`id` = 1688192 OR `props-main`.`id` = 1661801 OR `props-main`.`id` = 1688435 OR `props-main`.`id` = 1683510 OR `props-main`.`id` = 1685329 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1678989 OR `props-main`.`id` = 1678015 OR `props-main`.`id` = 1682861 OR `props-main`.`id` = 1682680 OR `props-main`.`id` = 1687196 OR `props-main`.`id` = 1685788 OR `props-main`.`id` = 1680419 OR `props-main`.`id` = 1690043 OR `props-main`.`id` = 1681407 OR `props-main`.`id` = 1687054 OR `props-main`.`id` = 1678442 OR `props-main`.`id` = 1688085 OR `props-main`.`id` = 1671724 OR `props-main`.`id` = 1685422 OR `props-main`.`id` = 1673949 OR `props-main`.`id` = 1647268 OR `props-main`.`id` = 1673330 OR `props-main`.`id` = 1663529 OR `props-main`.`id` = 1669972 OR `props-main`.`id` = 1689373 OR `props-main`.`id` = 1681745 OR `props-main`.`id` = 1690489 OR `props-main`.`id` = 1673748 OR `props-main`.`id` = 1681750 OR `props-main`.`id` = 1686697 OR `props-main`.`id` = 1602762)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224066308' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-18' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$548,500
4
3
2,108
0.15
2104 Golden Leaf Ct
Modesto, CA 95355
$519,000
4
3
2,161
0.15
1900 Bridgewood Way
Modesto, CA 95355
Courtesy of Kitty Chan, HomeSmart PV & Associates 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.
