A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 255550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 282450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 695 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1195 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` = 1694673 OR `props-main`.`id` = 1698655 OR `props-main`.`id` = 1698936 OR `props-main`.`id` = 1696678 OR `props-main`.`id` = 1698548 OR `props-main`.`id` = 1676827 OR `props-main`.`id` = 1698535 OR `props-main`.`id` = 1701927 OR `props-main`.`id` = 1677321 OR `props-main`.`id` = 1694035 OR `props-main`.`id` = 1690896 OR `props-main`.`id` = 1698902 OR `props-main`.`id` = 1698239 OR `props-main`.`id` = 1693561 OR `props-main`.`id` = 1690412 OR `props-main`.`id` = 1690415 OR `props-main`.`id` = 1701547 OR `props-main`.`id` = 1701545 OR `props-main`.`id` = 1696402 OR `props-main`.`id` = 1698205 OR `props-main`.`id` = 1673302 OR `props-main`.`id` = 1673303 OR `props-main`.`id` = 1661841 OR `props-main`.`id` = 1655866 OR `props-main`.`id` = 1655879 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1648402 OR `props-main`.`id` = 1695159 OR `props-main`.`id` = 1701658 OR `props-main`.`id` = 1694790 OR `props-main`.`id` = 1697782 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1698634 OR `props-main`.`id` = 1684725 OR `props-main`.`id` = 1698616 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1698594 OR `props-main`.`id` = 1687298 OR `props-main`.`id` = 1697940 OR `props-main`.`id` = 1698959 OR `props-main`.`id` = 1694065 OR `props-main`.`id` = 1686171 OR `props-main`.`id` = 1690943 OR `props-main`.`id` = 1699011 OR `props-main`.`id` = 1696919 OR `props-main`.`id` = 1696419 OR `props-main`.`id` = 1696435 OR `props-main`.`id` = 1700135 OR `props-main`.`id` = 1698114 OR `props-main`.`id` = 1701578 OR `props-main`.`id` = 1701584 OR `props-main`.`id` = 1701572 OR `props-main`.`id` = 1701574 OR `props-main`.`id` = 1701573 OR `props-main`.`id` = 1701579 OR `props-main`.`id` = 1701166 OR `props-main`.`id` = 1685817 OR `props-main`.`id` = 1698728 OR `props-main`.`id` = 1681737 OR `props-main`.`id` = 1696889 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1681801 OR `props-main`.`id` = 1683997)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239081' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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();