A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 251750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 278250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1042 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1542 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` = 1679817 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1614339 OR `props-main`.`id` = 1613599 OR `props-main`.`id` = 1615157 OR `props-main`.`id` = 1681309 OR `props-main`.`id` = 1681282 OR `props-main`.`id` = 1681541 OR `props-main`.`id` = 1679384 OR `props-main`.`id` = 1676378 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1680932 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1681149 OR `props-main`.`id` = 1682178 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1676227 OR `props-main`.`id` = 1676226 OR `props-main`.`id` = 1676217 OR `props-main`.`id` = 1682179 OR `props-main`.`id` = 1678155 OR `props-main`.`id` = 1681402 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1683401 OR `props-main`.`id` = 1668724 OR `props-main`.`id` = 1681542 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1652718 OR `props-main`.`id` = 1684096 OR `props-main`.`id` = 1684127 OR `props-main`.`id` = 1684151 OR `props-main`.`id` = 1684099 OR `props-main`.`id` = 1684134 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1632242 OR `props-main`.`id` = 1681546 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1662106 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1671536 OR `props-main`.`id` = 1671732 OR `props-main`.`id` = 1671537 OR `props-main`.`id` = 1681495 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1669910 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1654951 OR `props-main`.`id` = 1683328 OR `props-main`.`id` = 1670944 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1682180 OR `props-main`.`id` = 1682191 OR `props-main`.`id` = 1683019 OR `props-main`.`id` = 1683020 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1684009 OR `props-main`.`id` = 1684029 OR `props-main`.`id` = 1667587 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1673900 OR `props-main`.`id` = 1673882 OR `props-main`.`id` = 1683803 OR `props-main`.`id` = 1683824 OR `props-main`.`id` = 1662046 OR `props-main`.`id` = 1683815 OR `props-main`.`id` = 1679088 OR `props-main`.`id` = 1683806 OR `props-main`.`id` = 1672980 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1683085 OR `props-main`.`id` = 1674596 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1678612 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1680519 OR `props-main`.`id` = 1683329 OR `props-main`.`id` = 1676838 OR `props-main`.`id` = 1683236 OR `props-main`.`id` = 1683077 OR `props-main`.`id` = 1683210 OR `props-main`.`id` = 1683137 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1667477 OR `props-main`.`id` = 1646488 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1675158 OR `props-main`.`id` = 1680442 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1675217 OR `props-main`.`id` = 1680222 OR `props-main`.`id` = 1680260 OR `props-main`.`id` = 1680241)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings232647' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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: