A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 413250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 456750 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) >= 1099 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1599 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` = 1690068 OR `props-main`.`id` = 1662178 OR `props-main`.`id` = 1685288 OR `props-main`.`id` = 1690457 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1668014 OR `props-main`.`id` = 1685127 OR `props-main`.`id` = 1690428 OR `props-main`.`id` = 1690911 OR `props-main`.`id` = 1685855 OR `props-main`.`id` = 1671828 OR `props-main`.`id` = 1690741 OR `props-main`.`id` = 1690635 OR `props-main`.`id` = 1686994 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1687303 OR `props-main`.`id` = 1680907 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1689595 OR `props-main`.`id` = 1689354 OR `props-main`.`id` = 1678109 OR `props-main`.`id` = 1664563 OR `props-main`.`id` = 1687792 OR `props-main`.`id` = 1687363 OR `props-main`.`id` = 1643766 OR `props-main`.`id` = 1680763 OR `props-main`.`id` = 1673207 OR `props-main`.`id` = 1690336 OR `props-main`.`id` = 1680494 OR `props-main`.`id` = 1685835 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1690661 OR `props-main`.`id` = 1673007 OR `props-main`.`id` = 1686705 OR `props-main`.`id` = 1690719 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1683656 OR `props-main`.`id` = 1690768 OR `props-main`.`id` = 1663888 OR `props-main`.`id` = 1685949 OR `props-main`.`id` = 1684928 OR `props-main`.`id` = 1682140 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1690552 OR `props-main`.`id` = 1684864 OR `props-main`.`id` = 1689397 OR `props-main`.`id` = 1690289 OR `props-main`.`id` = 1690509 OR `props-main`.`id` = 1689830 OR `props-main`.`id` = 1678660 OR `props-main`.`id` = 1678014 OR `props-main`.`id` = 1658001 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1668779 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1689576 OR `props-main`.`id` = 1660695 OR `props-main`.`id` = 1690258 OR `props-main`.`id` = 1689411 OR `props-main`.`id` = 1682690 OR `props-main`.`id` = 1681178 OR `props-main`.`id` = 1689115 OR `props-main`.`id` = 1689592 OR `props-main`.`id` = 1688169 OR `props-main`.`id` = 1690745 OR `props-main`.`id` = 1689296 OR `props-main`.`id` = 1690288 OR `props-main`.`id` = 1686159 OR `props-main`.`id` = 1681349 OR `props-main`.`id` = 1690425 OR `props-main`.`id` = 1679086 OR `props-main`.`id` = 1677754 OR `props-main`.`id` = 1685235 OR `props-main`.`id` = 1690524 OR `props-main`.`id` = 1690156 OR `props-main`.`id` = 1688064 OR `props-main`.`id` = 1687195 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1689873 OR `props-main`.`id` = 1689915 OR `props-main`.`id` = 1689866 OR `props-main`.`id` = 1644786 OR `props-main`.`id` = 1678556 OR `props-main`.`id` = 1690026 OR `props-main`.`id` = 1678486 OR `props-main`.`id` = 1677611 OR `props-main`.`id` = 1689593 OR `props-main`.`id` = 1688192 OR `props-main`.`id` = 1690891 OR `props-main`.`id` = 1683510 OR `props-main`.`id` = 1676779 OR `props-main`.`id` = 1676352 OR `props-main`.`id` = 1685329 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1678989 OR `props-main`.`id` = 1682861 OR `props-main`.`id` = 1682680 OR `props-main`.`id` = 1688375 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` = 1685422 OR `props-main`.`id` = 1676668 OR `props-main`.`id` = 1673949 OR `props-main`.`id` = 1647268 OR `props-main`.`id` = 1673330 OR `props-main`.`id` = 1681069 OR `props-main`.`id` = 1684865 OR `props-main`.`id` = 1663529)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24152402' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
11
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$439,999
3
2
1,296
0.15
3808 Thornbury Way
Modesto, CA 95356
$439,900
3
2
1,373
0.08
2244 Southport Ln
Modesto, CA 95356
$435,000
3
2
1,259
0.11
1528 Citrus Dr
Modesto, CA 95350
$434,900
3
2
1,478
0.15
2201 Presidio Ave
Modesto, CA 95355
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.