A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524895 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) >= 1865 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2365 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` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1688277 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1690155 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1689931 OR `props-main`.`id` = 1689932 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1676251 OR `props-main`.`id` = 1689687 OR `props-main`.`id` = 1687278 OR `props-main`.`id` = 1687269 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1690470 OR `props-main`.`id` = 1690474 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1685091 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1639779 OR `props-main`.`id` = 1675140 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1682874 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690092 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1690054 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1689672)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24152487' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-19' 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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$495,000
4
2
1,997
0.21
1620 Fairway Dr
Atwater, CA 95301
$495,000
3
2
1,888
0.87
3026 Station Ave
Atwater, CA 95301
$489,000
4
2
2,035
0.20
630 Juniper
Atwater, CA 95301
$479,000
4
3
2,310
0.17
851 BOULDER
Atwater, CA 95301
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.
