A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 826 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1326 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` = 1666060 OR `props-main`.`id` = 1666344 OR `props-main`.`id` = 1678496 OR `props-main`.`id` = 1673040 OR `props-main`.`id` = 1682993 OR `props-main`.`id` = 1689376 OR `props-main`.`id` = 1666005 OR `props-main`.`id` = 1667877 OR `props-main`.`id` = 1666307 OR `props-main`.`id` = 1660642 OR `props-main`.`id` = 1655556 OR `props-main`.`id` = 1631102 OR `props-main`.`id` = 1638339 OR `props-main`.`id` = 1660693 OR `props-main`.`id` = 1675318 OR `props-main`.`id` = 1668765 OR `props-main`.`id` = 1688681 OR `props-main`.`id` = 1688197 OR `props-main`.`id` = 1689424 OR `props-main`.`id` = 1630528 OR `props-main`.`id` = 1660521 OR `props-main`.`id` = 1668703 OR `props-main`.`id` = 1686723 OR `props-main`.`id` = 1677888 OR `props-main`.`id` = 1597205 OR `props-main`.`id` = 1681339 OR `props-main`.`id` = 1679326 OR `props-main`.`id` = 1674673 OR `props-main`.`id` = 1675055 OR `props-main`.`id` = 1664197 OR `props-main`.`id` = 1665782 OR `props-main`.`id` = 1665783 OR `props-main`.`id` = 1687990 OR `props-main`.`id` = 1687961 OR `props-main`.`id` = 1665786 OR `props-main`.`id` = 1665774 OR `props-main`.`id` = 1665779 OR `props-main`.`id` = 1665777 OR `props-main`.`id` = 1665772 OR `props-main`.`id` = 1664207 OR `props-main`.`id` = 1666234 OR `props-main`.`id` = 1665780 OR `props-main`.`id` = 1665781 OR `props-main`.`id` = 1665784 OR `props-main`.`id` = 1687443 OR `props-main`.`id` = 1665773 OR `props-main`.`id` = 1665768 OR `props-main`.`id` = 1665788 OR `props-main`.`id` = 1665787 OR `props-main`.`id` = 1665776 OR `props-main`.`id` = 1665789 OR `props-main`.`id` = 1665785 OR `props-main`.`id` = 1665770 OR `props-main`.`id` = 1688470 OR `props-main`.`id` = 1665771 OR `props-main`.`id` = 1665775 OR `props-main`.`id` = 1686712 OR `props-main`.`id` = 1665769 OR `props-main`.`id` = 1638710 OR `props-main`.`id` = 1673110 OR `props-main`.`id` = 1668872 OR `props-main`.`id` = 1687959 OR `props-main`.`id` = 1687863 OR `props-main`.`id` = 1674084 OR `props-main`.`id` = 1663303 OR `props-main`.`id` = 1667982 OR `props-main`.`id` = 1674045 OR `props-main`.`id` = 1665778 OR `props-main`.`id` = 1687263 OR `props-main`.`id` = 1633589 OR `props-main`.`id` = 1646289 OR `props-main`.`id` = 1668939 OR `props-main`.`id` = 1666029 OR `props-main`.`id` = 1637624 OR `props-main`.`id` = 1666239 OR `props-main`.`id` = 1633604 OR `props-main`.`id` = 1676448 OR `props-main`.`id` = 1676446 OR `props-main`.`id` = 1679314 OR `props-main`.`id` = 1677563 OR `props-main`.`id` = 1657575 OR `props-main`.`id` = 1683234 OR `props-main`.`id` = 1683227 OR `props-main`.`id` = 1688608 OR `props-main`.`id` = 1689512 OR `props-main`.`id` = 1665710 OR `props-main`.`id` = 1649111 OR `props-main`.`id` = 1649113 OR `props-main`.`id` = 1666209 OR `props-main`.`id` = 1687082 OR `props-main`.`id` = 1672915 OR `props-main`.`id` = 1668610 OR `props-main`.`id` = 1665995 OR `props-main`.`id` = 1665925 OR `props-main`.`id` = 1685861 OR `props-main`.`id` = 1676362 OR `props-main`.`id` = 1690193 OR `props-main`.`id` = 1679770 OR `props-main`.`id` = 1658364 OR `props-main`.`id` = 1673042 OR `props-main`.`id` = 1671269 OR `props-main`.`id` = 1689328 OR `props-main`.`id` = 1665926 OR `props-main`.`id` = 1575200 OR `props-main`.`id` = 1671300 OR `props-main`.`id` = 1673903 OR `props-main`.`id` = 1665930 OR `props-main`.`id` = 1634644 OR `props-main`.`id` = 1665928 OR `props-main`.`id` = 1665927 OR `props-main`.`id` = 1688744 OR `props-main`.`id` = 1671971 OR `props-main`.`id` = 1679523)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno607549' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-19' 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: