A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 270750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 299250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 946 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1446 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` = 1676148 OR `props-main`.`id` = 1676149 OR `props-main`.`id` = 1675072 OR `props-main`.`id` = 1674773 OR `props-main`.`id` = 1627891 OR `props-main`.`id` = 1636635 OR `props-main`.`id` = 1689632 OR `props-main`.`id` = 1689643 OR `props-main`.`id` = 1688896 OR `props-main`.`id` = 1689426 OR `props-main`.`id` = 1673792 OR `props-main`.`id` = 1688547 OR `props-main`.`id` = 1671286 OR `props-main`.`id` = 1671295 OR `props-main`.`id` = 1671251 OR `props-main`.`id` = 1671289 OR `props-main`.`id` = 1684823 OR `props-main`.`id` = 1684824 OR `props-main`.`id` = 1684832 OR `props-main`.`id` = 1673638 OR `props-main`.`id` = 1668655 OR `props-main`.`id` = 1648690 OR `props-main`.`id` = 1648312 OR `props-main`.`id` = 1687581 OR `props-main`.`id` = 1640378 OR `props-main`.`id` = 1655923 OR `props-main`.`id` = 1686911 OR `props-main`.`id` = 1625479 OR `props-main`.`id` = 1665953 OR `props-main`.`id` = 1639886 OR `props-main`.`id` = 1640929 OR `props-main`.`id` = 1683716 OR `props-main`.`id` = 1622930 OR `props-main`.`id` = 1687844 OR `props-main`.`id` = 1669690 OR `props-main`.`id` = 1676875 OR `props-main`.`id` = 1685118 OR `props-main`.`id` = 1687958 OR `props-main`.`id` = 1655605 OR `props-main`.`id` = 1687649 OR `props-main`.`id` = 1652666 OR `props-main`.`id` = 1655507 OR `props-main`.`id` = 1685350 OR `props-main`.`id` = 1685341 OR `props-main`.`id` = 1688345 OR `props-main`.`id` = 1646393 OR `props-main`.`id` = 1683773 OR `props-main`.`id` = 1682164 OR `props-main`.`id` = 1690484 OR `props-main`.`id` = 1687058 OR `props-main`.`id` = 1687074 OR `props-main`.`id` = 1689542 OR `props-main`.`id` = 1687279 OR `props-main`.`id` = 1634320 OR `props-main`.`id` = 1686590 OR `props-main`.`id` = 1674526 OR `props-main`.`id` = 1674525 OR `props-main`.`id` = 1688770)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare229709' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-19' 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,700 active listings.
Courtesy of Roy Contreras Mora, Legacy Real Estate 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.
