A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1520000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1680000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2215 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2715 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` = 1692233 OR `props-main`.`id` = 1736542 OR `props-main`.`id` = 1732642 OR `props-main`.`id` = 1726483 OR `props-main`.`id` = 1716860 OR `props-main`.`id` = 1715036 OR `props-main`.`id` = 1623331 OR `props-main`.`id` = 1696571 OR `props-main`.`id` = 1716893 OR `props-main`.`id` = 1623354 OR `props-main`.`id` = 1623384 OR `props-main`.`id` = 1678374 OR `props-main`.`id` = 1737405 OR `props-main`.`id` = 1747806 OR `props-main`.`id` = 1736470 OR `props-main`.`id` = 1683861 OR `props-main`.`id` = 1715717 OR `props-main`.`id` = 1684502 OR `props-main`.`id` = 1719212 OR `props-main`.`id` = 1683859 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1683858 OR `props-main`.`id` = 1680741 OR `props-main`.`id` = 1749652 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1726784 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1707099 OR `props-main`.`id` = 1695227 OR `props-main`.`id` = 1717408 OR `props-main`.`id` = 1702074 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1744692 OR `props-main`.`id` = 1623333 OR `props-main`.`id` = 1732244 OR `props-main`.`id` = 1727305 OR `props-main`.`id` = 1738590 OR `props-main`.`id` = 1716981 OR `props-main`.`id` = 1737962 OR `props-main`.`id` = 1713385 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1716934 OR `props-main`.`id` = 1739306 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1697849 OR `props-main`.`id` = 1723851 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1684624 OR `props-main`.`id` = 1728016 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1707241 OR `props-main`.`id` = 1728193 OR `props-main`.`id` = 1715618 OR `props-main`.`id` = 1705320 OR `props-main`.`id` = 1722387 OR `props-main`.`id` = 1749795 OR `props-main`.`id` = 1701337 OR `props-main`.`id` = 1731899 OR `props-main`.`id` = 1720247 OR `props-main`.`id` = 1720246 OR `props-main`.`id` = 1731139 OR `props-main`.`id` = 1731898 OR `props-main`.`id` = 1712964 OR `props-main`.`id` = 1740248 OR `props-main`.`id` = 1750795 OR `props-main`.`id` = 1683862 OR `props-main`.`id` = 1727043 OR `props-main`.`id` = 1724170 OR `props-main`.`id` = 1716927 OR `props-main`.`id` = 1716365 OR `props-main`.`id` = 1729220 OR `props-main`.`id` = 1738345 OR `props-main`.`id` = 1738352 OR `props-main`.`id` = 1717678 OR `props-main`.`id` = 1723026 OR `props-main`.`id` = 1702959 OR `props-main`.`id` = 1623314 OR `props-main`.`id` = 1716521 OR `props-main`.`id` = 1744599 OR `props-main`.`id` = 1691955 OR `props-main`.`id` = 1614985 OR `props-main`.`id` = 1741806 OR `props-main`.`id` = 1736543 OR `props-main`.`id` = 1738744 OR `props-main`.`id` = 1716270 OR `props-main`.`id` = 1739251 OR `props-main`.`id` = 1623520 OR `props-main`.`id` = 1697865 OR `props-main`.`id` = 1725659 OR `props-main`.`id` = 1623374 OR `props-main`.`id` = 1712962 OR `props-main`.`id` = 1741632 OR `props-main`.`id` = 1623339 OR `props-main`.`id` = 1723323 OR `props-main`.`id` = 1685474 OR `props-main`.`id` = 1719964 OR `props-main`.`id` = 1623334 OR `props-main`.`id` = 1716928 OR `props-main`.`id` = 1742759 OR `props-main`.`id` = 1623498 OR `props-main`.`id` = 1725971 OR `props-main`.`id` = 1696938 OR `props-main`.`id` = 1723367 OR `props-main`.`id` = 1739671 OR `props-main`.`id` = 1748258 OR `props-main`.`id` = 1690042 OR `props-main`.`id` = 1723699 OR `props-main`.`id` = 1723700 OR `props-main`.`id` = 1660475 OR `props-main`.`id` = 1660474 OR `props-main`.`id` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1737076 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1750790 OR `props-main`.`id` = 1741820 OR `props-main`.`id` = 1742215 OR `props-main`.`id` = 1705895 OR `props-main`.`id` = 1713011 OR `props-main`.`id` = 1658009 OR `props-main`.`id` = 1713151 OR `props-main`.`id` = 1719620)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651911' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-20' 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: