A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1140000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1260000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3973 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4473 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` = 1681256 OR `props-main`.`id` = 1690297 OR `props-main`.`id` = 1689323 OR `props-main`.`id` = 1689345 OR `props-main`.`id` = 1683472 OR `props-main`.`id` = 1636126 OR `props-main`.`id` = 1675039 OR `props-main`.`id` = 1668534 OR `props-main`.`id` = 1685407 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 1685561 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1690017 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1684171 OR `props-main`.`id` = 1689193 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1689868 OR `props-main`.`id` = 1687175 OR `props-main`.`id` = 1686218 OR `props-main`.`id` = 1688403 OR `props-main`.`id` = 1689969 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1685455 OR `props-main`.`id` = 1679887 OR `props-main`.`id` = 1686671 OR `props-main`.`id` = 1670793 OR `props-main`.`id` = 1688288 OR `props-main`.`id` = 1685804 OR `props-main`.`id` = 1688603 OR `props-main`.`id` = 1686173 OR `props-main`.`id` = 1686132 OR `props-main`.`id` = 1684081 OR `props-main`.`id` = 1676774 OR `props-main`.`id` = 1685828 OR `props-main`.`id` = 1688876 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1688986 OR `props-main`.`id` = 1686862 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1687385 OR `props-main`.`id` = 1665909 OR `props-main`.`id` = 1685292 OR `props-main`.`id` = 1656704 OR `props-main`.`id` = 1667490 OR `props-main`.`id` = 1680286 OR `props-main`.`id` = 1686133 OR `props-main`.`id` = 1690274 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1665639 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1679516 OR `props-main`.`id` = 1684006 OR `props-main`.`id` = 1689400 OR `props-main`.`id` = 1685077 OR `props-main`.`id` = 1685076 OR `props-main`.`id` = 1685065 OR `props-main`.`id` = 1689252 OR `props-main`.`id` = 1685067 OR `props-main`.`id` = 1685069 OR `props-main`.`id` = 1685064 OR `props-main`.`id` = 1685063 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1688988 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1689279 OR `props-main`.`id` = 1684067 OR `props-main`.`id` = 1690721 OR `props-main`.`id` = 1690350 OR `props-main`.`id` = 1688990 OR `props-main`.`id` = 1690416 OR `props-main`.`id` = 1686437 OR `props-main`.`id` = 1687299 OR `props-main`.`id` = 1670896 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1665959 OR `props-main`.`id` = 1687972)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare235390' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-22' 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: