A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1424050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1573950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '7' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '6' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 9750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 10250 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` = 1649097 OR `props-main`.`id` = 1697152 OR `props-main`.`id` = 1697128 OR `props-main`.`id` = 1686404 OR `props-main`.`id` = 1697127 OR `props-main`.`id` = 1697131 OR `props-main`.`id` = 1648516 OR `props-main`.`id` = 1659540 OR `props-main`.`id` = 1671876 OR `props-main`.`id` = 1686841 OR `props-main`.`id` = 1684606 OR `props-main`.`id` = 1684601 OR `props-main`.`id` = 1695337 OR `props-main`.`id` = 1691120 OR `props-main`.`id` = 1672861 OR `props-main`.`id` = 1648368 OR `props-main`.`id` = 1632224 OR `props-main`.`id` = 1697819 OR `props-main`.`id` = 1696970 OR `props-main`.`id` = 1673115 OR `props-main`.`id` = 1684224 OR `props-main`.`id` = 1587884 OR `props-main`.`id` = 1677304 OR `props-main`.`id` = 1696367 OR `props-main`.`id` = 1696327 OR `props-main`.`id` = 1692742 OR `props-main`.`id` = 1696341 OR `props-main`.`id` = 1693769 OR `props-main`.`id` = 1697833)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare236288' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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 9,100 active listings.
Courtesy of Diana Jules, Sierra Real Estate
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.
