A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 293550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 324450 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) >= 962 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1462 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` = 1728361 OR `props-main`.`id` = 1697281 OR `props-main`.`id` = 1697836 OR `props-main`.`id` = 1723716 OR `props-main`.`id` = 1728565 OR `props-main`.`id` = 1719452 OR `props-main`.`id` = 1728126 OR `props-main`.`id` = 1728497 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1713901 OR `props-main`.`id` = 1719814 OR `props-main`.`id` = 1728276 OR `props-main`.`id` = 1720930 OR `props-main`.`id` = 1724846 OR `props-main`.`id` = 1727519 OR `props-main`.`id` = 1720001 OR `props-main`.`id` = 1720680 OR `props-main`.`id` = 1706056 OR `props-main`.`id` = 1706114 OR `props-main`.`id` = 1727566 OR `props-main`.`id` = 1725049 OR `props-main`.`id` = 1727160 OR `props-main`.`id` = 1727161 OR `props-main`.`id` = 1727198 OR `props-main`.`id` = 1727149 OR `props-main`.`id` = 1727512 OR `props-main`.`id` = 1723251 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1709174 OR `props-main`.`id` = 1719989 OR `props-main`.`id` = 1718588 OR `props-main`.`id` = 1723938 OR `props-main`.`id` = 1723924 OR `props-main`.`id` = 1723947 OR `props-main`.`id` = 1725581 OR `props-main`.`id` = 1702075 OR `props-main`.`id` = 1702079 OR `props-main`.`id` = 1720095 OR `props-main`.`id` = 1716772)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240429' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-24' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 10,200 active listings.
Courtesy of Darin Kong, Bloom Group, Inc.
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.
