A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 266000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 294000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 770 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1270 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` = 1698038 OR `props-main`.`id` = 1694206 OR `props-main`.`id` = 1626116 OR `props-main`.`id` = 1626120 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1700290 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1694201 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1702190 OR `props-main`.`id` = 1702702 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1698649 OR `props-main`.`id` = 1693668 OR `props-main`.`id` = 1693865 OR `props-main`.`id` = 1702606 OR `props-main`.`id` = 1692046 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1703152 OR `props-main`.`id` = 1703140 OR `props-main`.`id` = 1703157 OR `props-main`.`id` = 1701836 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1703114 OR `props-main`.`id` = 1703056 OR `props-main`.`id` = 1698513 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1701340 OR `props-main`.`id` = 1702666 OR `props-main`.`id` = 1698568 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1699087 OR `props-main`.`id` = 1696438 OR `props-main`.`id` = 1695897 OR `props-main`.`id` = 1702360 OR `props-main`.`id` = 1699041 OR `props-main`.`id` = 1691606 OR `props-main`.`id` = 1695517 OR `props-main`.`id` = 1696094 OR `props-main`.`id` = 1696112 OR `props-main`.`id` = 1696509 OR `props-main`.`id` = 1695651 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1702324 OR `props-main`.`id` = 1703024 OR `props-main`.`id` = 1701306 OR `props-main`.`id` = 1701203)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233455' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-16' 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();