A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 331550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 366450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 590 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1090 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` = 1675004 OR `props-main`.`id` = 1688274 OR `props-main`.`id` = 1688269 OR `props-main`.`id` = 1689951 OR `props-main`.`id` = 1688004 OR `props-main`.`id` = 1684410 OR `props-main`.`id` = 1685743 OR `props-main`.`id` = 1690659 OR `props-main`.`id` = 1686575 OR `props-main`.`id` = 1683622 OR `props-main`.`id` = 1642963 OR `props-main`.`id` = 1678300 OR `props-main`.`id` = 1679621 OR `props-main`.`id` = 1679065 OR `props-main`.`id` = 1690512 OR `props-main`.`id` = 1682634 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1686557 OR `props-main`.`id` = 1686558 OR `props-main`.`id` = 1686459 OR `props-main`.`id` = 1686495 OR `props-main`.`id` = 1689519 OR `props-main`.`id` = 1682577 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1682930 OR `props-main`.`id` = 1675179 OR `props-main`.`id` = 1686491 OR `props-main`.`id` = 1673314 OR `props-main`.`id` = 1673305 OR `props-main`.`id` = 1690180 OR `props-main`.`id` = 1638924 OR `props-main`.`id` = 1686477 OR `props-main`.`id` = 1688054 OR `props-main`.`id` = 1668130 OR `props-main`.`id` = 1683577 OR `props-main`.`id` = 1689692 OR `props-main`.`id` = 1684821 OR `props-main`.`id` = 1676974 OR `props-main`.`id` = 1684690 OR `props-main`.`id` = 1673254 OR `props-main`.`id` = 1690093 OR `props-main`.`id` = 1680781 OR `props-main`.`id` = 1689303 OR `props-main`.`id` = 1688912 OR `props-main`.`id` = 1686619 OR `props-main`.`id` = 1686854 OR `props-main`.`id` = 1685983 OR `props-main`.`id` = 1690812 OR `props-main`.`id` = 1673098 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1649276 OR `props-main`.`id` = 1681153 OR `props-main`.`id` = 1688710 OR `props-main`.`id` = 1681630 OR `props-main`.`id` = 1690942 OR `props-main`.`id` = 1686320 OR `props-main`.`id` = 1690828 OR `props-main`.`id` = 1675279 OR `props-main`.`id` = 1673085 OR `props-main`.`id` = 1688348 OR `props-main`.`id` = 1676452 OR `props-main`.`id` = 1659614 OR `props-main`.`id` = 1684963 OR `props-main`.`id` = 1654922 OR `props-main`.`id` = 1690069 OR `props-main`.`id` = 1683382 OR `props-main`.`id` = 1688468 OR `props-main`.`id` = 1684670 OR `props-main`.`id` = 1684531 OR `props-main`.`id` = 1691042 OR `props-main`.`id` = 1683135 OR `props-main`.`id` = 1665543 OR `props-main`.`id` = 1645539 OR `props-main`.`id` = 1681198 OR `props-main`.`id` = 1688512 OR `props-main`.`id` = 1689453 OR `props-main`.`id` = 1668166 OR `props-main`.`id` = 1685802 OR `props-main`.`id` = 1687208 OR `props-main`.`id` = 1678500 OR `props-main`.`id` = 1689410 OR `props-main`.`id` = 1657403 OR `props-main`.`id` = 1690852 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1689735 OR `props-main`.`id` = 1684990 OR `props-main`.`id` = 1686561 OR `props-main`.`id` = 1690228 OR `props-main`.`id` = 1683580 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1687076 OR `props-main`.`id` = 1689547 OR `props-main`.`id` = 1686988 OR `props-main`.`id` = 1668014 OR `props-main`.`id` = 1685127 OR `props-main`.`id` = 1686197 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1678151 OR `props-main`.`id` = 1689595 OR `props-main`.`id` = 1657140 OR `props-main`.`id` = 1664563 OR `props-main`.`id` = 1685634 OR `props-main`.`id` = 1689356 OR `props-main`.`id` = 1675339)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81976934' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$350,000
3
3
884
0.18
409 Thrasher Ave
Modesto, CA 95354
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.
