A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 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) >= 560 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1060 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` = 1720887 OR `props-main`.`id` = 1716880 OR `props-main`.`id` = 1717474 OR `props-main`.`id` = 1721089 OR `props-main`.`id` = 1718751 OR `props-main`.`id` = 1697079 OR `props-main`.`id` = 1716655 OR `props-main`.`id` = 1716157 OR `props-main`.`id` = 1717329 OR `props-main`.`id` = 1702183 OR `props-main`.`id` = 1721161 OR `props-main`.`id` = 1715808 OR `props-main`.`id` = 1718824 OR `props-main`.`id` = 1720355 OR `props-main`.`id` = 1713121 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1713860 OR `props-main`.`id` = 1718825 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1717580 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1718093 OR `props-main`.`id` = 1709456 OR `props-main`.`id` = 1720741 OR `props-main`.`id` = 1717869 OR `props-main`.`id` = 1719482 OR `props-main`.`id` = 1721649 OR `props-main`.`id` = 1721788 OR `props-main`.`id` = 1717156 OR `props-main`.`id` = 1696835 OR `props-main`.`id` = 1719543 OR `props-main`.`id` = 1721650 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1721610 OR `props-main`.`id` = 1702208 OR `props-main`.`id` = 1717844 OR `props-main`.`id` = 1709205 OR `props-main`.`id` = 1712675 OR `props-main`.`id` = 1721530 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1720816 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1709901 OR `props-main`.`id` = 1719394 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1692526 OR `props-main`.`id` = 1718053 OR `props-main`.`id` = 1718060 OR `props-main`.`id` = 1718054 OR `props-main`.`id` = 1709218 OR `props-main`.`id` = 1704482 OR `props-main`.`id` = 1706686 OR `props-main`.`id` = 1719839 OR `props-main`.`id` = 1694788 OR `props-main`.`id` = 1697415 OR `props-main`.`id` = 1719513 OR `props-main`.`id` = 1692117 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1711140 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1707233 OR `props-main`.`id` = 1703701 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1716591 OR `props-main`.`id` = 1717372 OR `props-main`.`id` = 1713975 OR `props-main`.`id` = 1717450 OR `props-main`.`id` = 1721206 OR `props-main`.`id` = 1718677 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1721535 OR `props-main`.`id` = 1721541 OR `props-main`.`id` = 1721492 OR `props-main`.`id` = 1716552 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 1706856 OR `props-main`.`id` = 1714850 OR `props-main`.`id` = 1718515 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1715737 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1709524 OR `props-main`.`id` = 1709479 OR `props-main`.`id` = 1718474 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1721066 OR `props-main`.`id` = 1721860 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1718789 OR `props-main`.`id` = 1718483 OR `props-main`.`id` = 1709968 OR `props-main`.`id` = 1692098 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1692107 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1717261 OR `props-main`.`id` = 1721120 OR `props-main`.`id` = 1720606 OR `props-main`.`id` = 1706150 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1717466 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1693905 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 OR `props-main`.`id` = 1720801 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1721507 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1718000 OR `props-main`.`id` = 1719566 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 1713568 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1721072)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645975' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-15' 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: