A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 359565.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 397414.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1612 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2112 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` = 1685869 OR `props-main`.`id` = 1659517 OR `props-main`.`id` = 1659541 OR `props-main`.`id` = 1632345 OR `props-main`.`id` = 1635210 OR `props-main`.`id` = 1685827 OR `props-main`.`id` = 1685909 OR `props-main`.`id` = 1685901 OR `props-main`.`id` = 1685907 OR `props-main`.`id` = 1685918 OR `props-main`.`id` = 1685826 OR `props-main`.`id` = 1687222 OR `props-main`.`id` = 1687238 OR `props-main`.`id` = 1680813 OR `props-main`.`id` = 1679923 OR `props-main`.`id` = 1680790 OR `props-main`.`id` = 1685849 OR `props-main`.`id` = 1685867 OR `props-main`.`id` = 1687221 OR `props-main`.`id` = 1685853 OR `props-main`.`id` = 1653253 OR `props-main`.`id` = 1655568 OR `props-main`.`id` = 1685848 OR `props-main`.`id` = 1680240 OR `props-main`.`id` = 1669881 OR `props-main`.`id` = 1654971 OR `props-main`.`id` = 1680638 OR `props-main`.`id` = 1689102 OR `props-main`.`id` = 1665546 OR `props-main`.`id` = 1660964 OR `props-main`.`id` = 1583345 OR `props-main`.`id` = 1623971 OR `props-main`.`id` = 1623919 OR `props-main`.`id` = 1665547 OR `props-main`.`id` = 1663562 OR `props-main`.`id` = 1637788 OR `props-main`.`id` = 1625924 OR `props-main`.`id` = 1625916)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230714' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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();

CAME_FROM_PROP_SITE: