A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1875 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2375 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` = 1686961 OR `props-main`.`id` = 1686967 OR `props-main`.`id` = 1689044 OR `props-main`.`id` = 1663985 OR `props-main`.`id` = 1685809 OR `props-main`.`id` = 1668447 OR `props-main`.`id` = 1673131 OR `props-main`.`id` = 1687401 OR `props-main`.`id` = 1684937 OR `props-main`.`id` = 1660586 OR `props-main`.`id` = 1660576 OR `props-main`.`id` = 1680235 OR `props-main`.`id` = 1680319 OR `props-main`.`id` = 1680320 OR `props-main`.`id` = 1667402 OR `props-main`.`id` = 1667478 OR `props-main`.`id` = 1615248 OR `props-main`.`id` = 1659352 OR `props-main`.`id` = 1689079 OR `props-main`.`id` = 1680789 OR `props-main`.`id` = 1679909 OR `props-main`.`id` = 1641233 OR `props-main`.`id` = 1679937 OR `props-main`.`id` = 1674209 OR `props-main`.`id` = 1679150 OR `props-main`.`id` = 1656407 OR `props-main`.`id` = 1615582 OR `props-main`.`id` = 1688033 OR `props-main`.`id` = 1688035 OR `props-main`.`id` = 1688037 OR `props-main`.`id` = 1688036 OR `props-main`.`id` = 1680674 OR `props-main`.`id` = 1687935 OR `props-main`.`id` = 1680187 OR `props-main`.`id` = 1688885 OR `props-main`.`id` = 1676697 OR `props-main`.`id` = 1688516 OR `props-main`.`id` = 1634648 OR `props-main`.`id` = 1664537 OR `props-main`.`id` = 1688997 OR `props-main`.`id` = 1615347 OR `props-main`.`id` = 1678866 OR `props-main`.`id` = 1675128 OR `props-main`.`id` = 1684916 OR `props-main`.`id` = 1684921 OR `props-main`.`id` = 1655595 OR `props-main`.`id` = 1686677 OR `props-main`.`id` = 1667884 OR `props-main`.`id` = 1668461 OR `props-main`.`id` = 1671652 OR `props-main`.`id` = 1689152 OR `props-main`.`id` = 1678056 OR `props-main`.`id` = 1676308 OR `props-main`.`id` = 1676309 OR `props-main`.`id` = 1689620 OR `props-main`.`id` = 1680536 OR `props-main`.`id` = 1689639 OR `props-main`.`id` = 1688205 OR `props-main`.`id` = 1681095 OR `props-main`.`id` = 1680655 OR `props-main`.`id` = 1687919 OR `props-main`.`id` = 1648379 OR `props-main`.`id` = 1664760 OR `props-main`.`id` = 1674208 OR `props-main`.`id` = 1648164 OR `props-main`.`id` = 1678737 OR `props-main`.`id` = 1689237 OR `props-main`.`id` = 1666211 OR `props-main`.`id` = 1680333 OR `props-main`.`id` = 1680354 OR `props-main`.`id` = 1686253 OR `props-main`.`id` = 1677954 OR `props-main`.`id` = 1668480 OR `props-main`.`id` = 1686251 OR `props-main`.`id` = 1679512 OR `props-main`.`id` = 1679542 OR `props-main`.`id` = 1604069 OR `props-main`.`id` = 1679773 OR `props-main`.`id` = 1685729 OR `props-main`.`id` = 1685820 OR `props-main`.`id` = 1685755 OR `props-main`.`id` = 1685759 OR `props-main`.`id` = 1674182 OR `props-main`.`id` = 1684534 OR `props-main`.`id` = 1670839 OR `props-main`.`id` = 1648192 OR `props-main`.`id` = 1689189 OR `props-main`.`id` = 1681874 OR `props-main`.`id` = 1688751 OR `props-main`.`id` = 1684022 OR `props-main`.`id` = 1667824 OR `props-main`.`id` = 1688866 OR `props-main`.`id` = 1688865 OR `props-main`.`id` = 1688873 OR `props-main`.`id` = 1688934)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230666' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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,800 active listings.
Courtesy of Geraldine Cerda, Modern Broker
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.
