A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 213750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 236250 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) >= 1463 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1963 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` = 1702046 OR `props-main`.`id` = 1701488 OR `props-main`.`id` = 1697091 OR `props-main`.`id` = 1702103 OR `props-main`.`id` = 1690032 OR `props-main`.`id` = 1701374 OR `props-main`.`id` = 1699012 OR `props-main`.`id` = 1697094 OR `props-main`.`id` = 1681564 OR `props-main`.`id` = 1698440 OR `props-main`.`id` = 1715724 OR `props-main`.`id` = 1714907 OR `props-main`.`id` = 1705462 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1719610 OR `props-main`.`id` = 1719760 OR `props-main`.`id` = 1704126 OR `props-main`.`id` = 1704322 OR `props-main`.`id` = 1691288 OR `props-main`.`id` = 1719693 OR `props-main`.`id` = 1705388 OR `props-main`.`id` = 1719263 OR `props-main`.`id` = 1713492 OR `props-main`.`id` = 1683103 OR `props-main`.`id` = 1707918 OR `props-main`.`id` = 1717478 OR `props-main`.`id` = 1713037 OR `props-main`.`id` = 1713045 OR `props-main`.`id` = 1701781 OR `props-main`.`id` = 1666327 OR `props-main`.`id` = 1680010 OR `props-main`.`id` = 1696424 OR `props-main`.`id` = 1718173 OR `props-main`.`id` = 1701669 OR `props-main`.`id` = 1719157 OR `props-main`.`id` = 1719517 OR `props-main`.`id` = 1666338 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1718172 OR `props-main`.`id` = 1708219 OR `props-main`.`id` = 1703613 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1715941 OR `props-main`.`id` = 1702590 OR `props-main`.`id` = 1717157 OR `props-main`.`id` = 1719280 OR `props-main`.`id` = 1703649 OR `props-main`.`id` = 1712376 OR `props-main`.`id` = 1704310 OR `props-main`.`id` = 1692127 OR `props-main`.`id` = 1702485 OR `props-main`.`id` = 1654292 OR `props-main`.`id` = 1705358 OR `props-main`.`id` = 1681366 OR `props-main`.`id` = 1681364 OR `props-main`.`id` = 1681362 OR `props-main`.`id` = 1717138 OR `props-main`.`id` = 1681344 OR `props-main`.`id` = 1681343 OR `props-main`.`id` = 1681342 OR `props-main`.`id` = 1715665 OR `props-main`.`id` = 1712861 OR `props-main`.`id` = 1712947 OR `props-main`.`id` = 1696292 OR `props-main`.`id` = 1696288 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1718772 OR `props-main`.`id` = 1712377 OR `props-main`.`id` = 1702892 OR `props-main`.`id` = 1718865 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1700848 OR `props-main`.`id` = 1696514 OR `props-main`.`id` = 1709701 OR `props-main`.`id` = 1718039 OR `props-main`.`id` = 1649227 OR `props-main`.`id` = 1694019 OR `props-main`.`id` = 1719012 OR `props-main`.`id` = 1713995 OR `props-main`.`id` = 1709976 OR `props-main`.`id` = 1609082 OR `props-main`.`id` = 1705959 OR `props-main`.`id` = 1716262 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1716853 OR `props-main`.`id` = 1714920 OR `props-main`.`id` = 1718430 OR `props-main`.`id` = 1709539 OR `props-main`.`id` = 1697261 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1719317 OR `props-main`.`id` = 1714205 OR `props-main`.`id` = 1719404 OR `props-main`.`id` = 1690827 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1716190 OR `props-main`.`id` = 1689918 OR `props-main`.`id` = 1709716 OR `props-main`.`id` = 1705880 OR `props-main`.`id` = 1694096 OR `props-main`.`id` = 1702121 OR `props-main`.`id` = 1684123 OR `props-main`.`id` = 1661123 OR `props-main`.`id` = 1717682 OR `props-main`.`id` = 1715552 OR `props-main`.`id` = 133282 OR `props-main`.`id` = 1718966 OR `props-main`.`id` = 1712415 OR `props-main`.`id` = 1718125 OR `props-main`.`id` = 1719682)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno615366' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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: