A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 527250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 582750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1408 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1908 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` = 1674733 OR `props-main`.`id` = 1679469 OR `props-main`.`id` = 1695757 OR `props-main`.`id` = 1674747 OR `props-main`.`id` = 1633152 OR `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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238340' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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.
