A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 398905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 440895 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) >= 1070 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1570 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` = 1687905 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1649276 OR `props-main`.`id` = 1689812 OR `props-main`.`id` = 1681153 OR `props-main`.`id` = 1685917 OR `props-main`.`id` = 1681630 OR `props-main`.`id` = 1677576 OR `props-main`.`id` = 1688348 OR `props-main`.`id` = 1676452 OR `props-main`.`id` = 1659614 OR `props-main`.`id` = 1686573 OR `props-main`.`id` = 1683382 OR `props-main`.`id` = 1684670 OR `props-main`.`id` = 1684645 OR `props-main`.`id` = 1684531 OR `props-main`.`id` = 1683135 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1689031 OR `props-main`.`id` = 1681198 OR `props-main`.`id` = 1688577 OR `props-main`.`id` = 1668166 OR `props-main`.`id` = 1685802 OR `props-main`.`id` = 1687208 OR `props-main`.`id` = 1684513 OR `props-main`.`id` = 1690177 OR `props-main`.`id` = 1677752 OR `props-main`.`id` = 1657403 OR `props-main`.`id` = 1690068 OR `props-main`.`id` = 1662178 OR `props-main`.`id` = 1685288 OR `props-main`.`id` = 1690457 OR `props-main`.`id` = 1684990 OR `props-main`.`id` = 1683580 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1668014 OR `props-main`.`id` = 1685127 OR `props-main`.`id` = 1690428 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1681894 OR `props-main`.`id` = 1685855 OR `props-main`.`id` = 1671828 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` = 1679577 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` = 1685634 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` = 1689356 OR `props-main`.`id` = 1673007 OR `props-main`.`id` = 1686705 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1683656 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` = 1689082 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` = 1689359 OR `props-main`.`id` = 1658001 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` = 1662021 OR `props-main`.`id` = 1684101 OR `props-main`.`id` = 1682690 OR `props-main`.`id` = 1689115 OR `props-main`.`id` = 1689592 OR `props-main`.`id` = 1688169 OR `props-main`.`id` = 1676556 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` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1689596 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` = 1661801 OR `props-main`.`id` = 1688435 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` = 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224068197' 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();
15
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
$435,000
3
2
1,501
0.15
2109 Bodega Ln
Modesto, CA 95350
$435,000
3
2
1,462
0.21
2013 Sherwood Ave
Modesto, CA 95350
$434,900
3
2
1,478
0.15
2201 Presidio Ave
Modesto, CA 95355
Courtesy of Kimberly VanPetten, Berkshire Hathaway HomeServices-Drysdale Properties 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.
