A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 361000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 399000 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) >= 1522 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2022 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` = 175921 OR `props-main`.`id` = 1688966 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1688767 OR `props-main`.`id` = 1653182 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` = 1688132 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1685236 OR `props-main`.`id` = 1625934 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1685496 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` = 1668550 OR `props-main`.`id` = 1668432 OR `props-main`.`id` = 1689723 OR `props-main`.`id` = 1681979 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1681425 OR `props-main`.`id` = 1685495 OR `props-main`.`id` = 1682417 OR `props-main`.`id` = 874388 OR `props-main`.`id` = 1682418 OR `props-main`.`id` = 1682852 OR `props-main`.`id` = 1680901 OR `props-main`.`id` = 1686795 OR `props-main`.`id` = 1637763 OR `props-main`.`id` = 1637752)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81976947' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-13' 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:
$394,900
4
2
1,705
0.19
6555 Eden Ave
Winton, CA 95388
$379,900
3
2
1,760
0.14
3478 Carrie Ct
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.
