A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435748.95 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) >= 1320 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1820 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` = 72047 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1714734 OR `props-main`.`id` = 1714733 OR `props-main`.`id` = 1705804 OR `props-main`.`id` = 1707152 OR `props-main`.`id` = 1705917 OR `props-main`.`id` = 1705889 OR `props-main`.`id` = 1707126 OR `props-main`.`id` = 1707154 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1714858 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1714381 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1714822 OR `props-main`.`id` = 1710069 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1714402 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 1690474 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1716596 OR `props-main`.`id` = 1713267 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1719235 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1719056 OR `props-main`.`id` = 1717369 OR `props-main`.`id` = 1713318 OR `props-main`.`id` = 1713316 OR `props-main`.`id` = 1713327 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1714626 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1717379 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1718717 OR `props-main`.`id` = 1718711 OR `props-main`.`id` = 1718743 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1716448 OR `props-main`.`id` = 1717717 OR `props-main`.`id` = 1717725 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1715695 OR `props-main`.`id` = 1715654 OR `props-main`.`id` = 1715898 OR `props-main`.`id` = 1715888 OR `props-main`.`id` = 1715890 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1717948 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1719698 OR `props-main`.`id` = 1712385 OR `props-main`.`id` = 1711526 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224030603' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$419,900
3
2
1,378
0.17
2913 Soquel Ave
Atwater, CA 95301
$395,000
3
2
1,692
0.18
729 Mulberry
Atwater, CA 95301
Courtesy of Catrina Girard, The Girard Group 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.
