A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 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) >= 1333 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1833 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` = 1689625 OR `props-main`.`id` = 1642942 OR `props-main`.`id` = 1642948 OR `props-main`.`id` = 1657579 OR `props-main`.`id` = 1684570 OR `props-main`.`id` = 1677250 OR `props-main`.`id` = 1677249 OR `props-main`.`id` = 1657591 OR `props-main`.`id` = 1677290 OR `props-main`.`id` = 1677251 OR `props-main`.`id` = 1657560 OR `props-main`.`id` = 1658135 OR `props-main`.`id` = 1645852 OR `props-main`.`id` = 1658216 OR `props-main`.`id` = 1679958 OR `props-main`.`id` = 1674564 OR `props-main`.`id` = 1658786 OR `props-main`.`id` = 1685162 OR `props-main`.`id` = 1689274 OR `props-main`.`id` = 1689544 OR `props-main`.`id` = 1652701 OR `props-main`.`id` = 1689026 OR `props-main`.`id` = 1689396 OR `props-main`.`id` = 1676617 OR `props-main`.`id` = 1675231 OR `props-main`.`id` = 1668336 OR `props-main`.`id` = 1686870 OR `props-main`.`id` = 1684116 OR `props-main`.`id` = 1684162 OR `props-main`.`id` = 1680325 OR `props-main`.`id` = 1656866 OR `props-main`.`id` = 1685183 OR `props-main`.`id` = 1668402 OR `props-main`.`id` = 1674380 OR `props-main`.`id` = 1679858 OR `props-main`.`id` = 1630494 OR `props-main`.`id` = 1685087 OR `props-main`.`id` = 1685101 OR `props-main`.`id` = 1686846 OR `props-main`.`id` = 1685131 OR `props-main`.`id` = 1685122 OR `props-main`.`id` = 1685124 OR `props-main`.`id` = 1685664 OR `props-main`.`id` = 1686790 OR `props-main`.`id` = 1678894)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230757' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$379,000
3
2
1,573
0.16
1482 Betty St
Exeter, CA 93221
Courtesy of Kathleen Hagin, RE/MAX Success
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.
