A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 302860 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 334740 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) >= 1850 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2350 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` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 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` = 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` = 1686895 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 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` = 1686587 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1685030 OR `props-main`.`id` = 1685056 OR `props-main`.`id` = 1670944 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1682180 OR `props-main`.`id` = 1682191 OR `props-main`.`id` = 1687212 OR `props-main`.`id` = 1687213 OR `props-main`.`id` = 1687244 OR `props-main`.`id` = 1687245 OR `props-main`.`id` = 1687246 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1687256 OR `props-main`.`id` = 1679888 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1667587 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1689496 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1689498 OR `props-main`.`id` = 1662046 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1683085 OR `props-main`.`id` = 1674596 OR `props-main`.`id` = 1686355 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1676838 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1685298 OR `props-main`.`id` = 1667477 OR `props-main`.`id` = 1686593 OR `props-main`.`id` = 1679624 OR `props-main`.`id` = 1689425 OR `props-main`.`id` = 1679881 OR `props-main`.`id` = 1686714 OR `props-main`.`id` = 1688641 OR `props-main`.`id` = 1688642 OR `props-main`.`id` = 1688643 OR `props-main`.`id` = 1688644 OR `props-main`.`id` = 1688645 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1664767 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1685719 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1675217 OR `props-main`.`id` = 1685720 OR `props-main`.`id` = 1612813 OR `props-main`.`id` = 1684013 OR `props-main`.`id` = 1684461 OR `props-main`.`id` = 1686360 OR `props-main`.`id` = 1627122 OR `props-main`.`id` = 1677676 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1683692 OR `props-main`.`id` = 1677493 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1688562 OR `props-main`.`id` = 1615610 OR `props-main`.`id` = 1614319 OR `props-main`.`id` = 1613643 OR `props-main`.`id` = 1685519 OR `props-main`.`id` = 1685528 OR `props-main`.`id` = 1688188 OR `props-main`.`id` = 1657694 OR `props-main`.`id` = 1689489 OR `props-main`.`id` = 1688211 OR `props-main`.`id` = 1686898 OR `props-main`.`id` = 1686890 OR `props-main`.`id` = 1686908 OR `props-main`.`id` = 1688614 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1688546 OR `props-main`.`id` = 1688559 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1688539 OR `props-main`.`id` = 1685164 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1678533 OR `props-main`.`id` = 1678527 OR `props-main`.`id` = 1678528 OR `props-main`.`id` = 1678529 OR `props-main`.`id` = 1668628 OR `props-main`.`id` = 1673503 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1668942 OR `props-main`.`id` = 1688835 OR `props-main`.`id` = 1688838)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings230110' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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: