A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 403750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 446250 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) >= 1496 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1996 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` = 1622894 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1687293 OR `props-main`.`id` = 1687304 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1686909 OR `props-main`.`id` = 1685091 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1686565 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691221 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 1688629 OR `props-main`.`id` = 1688587 OR `props-main`.`id` = 1688598 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1688930 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1690886 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1686574 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1686912 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1690818 OR `props-main`.`id` = 1690813 OR `props-main`.`id` = 1690831 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 1686888 OR `props-main`.`id` = 1686925 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1688966 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1690054 OR `props-main`.`id` = 1688767 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1689672 OR `props-main`.`id` = 1688905 OR `props-main`.`id` = 1688907 OR `props-main`.`id` = 1675292 OR `props-main`.`id` = 1675274 OR `props-main`.`id` = 1675278 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1678627 OR `props-main`.`id` = 1678617 OR `props-main`.`id` = 1687328 OR `props-main`.`id` = 1687326 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1691164 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1690562 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 OR `props-main`.`id` = 1690158 OR `props-main`.`id` = 1678367 OR `props-main`.`id` = 1678343 OR `props-main`.`id` = 1678350 OR `props-main`.`id` = 1622832 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1686452 OR `props-main`.`id` = 1686453 OR `props-main`.`id` = 1683263 OR `props-main`.`id` = 1667509 OR `props-main`.`id` = 1686533 OR `props-main`.`id` = 1690963 OR `props-main`.`id` = 1668550 OR `props-main`.`id` = 1668432)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224062219' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-25' 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:
$434,500
4
2
1,634
0.14
1384 W Almador Ter
Atwater, CA 95301
$425,000
4
2
1,700
0.15
3386 Lagoon Ave
Atwater, CA 95301
$415,000
3
2
1,716
0.14
2092 Patriotic Dr
Atwater, CA 95301
$405,000
3
2
1,620
0.15
205 Clipper Ct
Atwater, CA 95301
Courtesy of Ashley Verna, Keller Williams Merced 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.