A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 679250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 750750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3210 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3710 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` = 1694180 OR `props-main`.`id` = 1715005 OR `props-main`.`id` = 1715000 OR `props-main`.`id` = 1726369 OR `props-main`.`id` = 1686833 OR `props-main`.`id` = 1728389 OR `props-main`.`id` = 1717601 OR `props-main`.`id` = 1717602 OR `props-main`.`id` = 1717603 OR `props-main`.`id` = 1717604 OR `props-main`.`id` = 1717605 OR `props-main`.`id` = 1719903 OR `props-main`.`id` = 1733186 OR `props-main`.`id` = 1687706 OR `props-main`.`id` = 1685636 OR `props-main`.`id` = 1731367 OR `props-main`.`id` = 1727867 OR `props-main`.`id` = 1727890 OR `props-main`.`id` = 1726763 OR `props-main`.`id` = 1726776 OR `props-main`.`id` = 1731326 OR `props-main`.`id` = 1731414 OR `props-main`.`id` = 1701727 OR `props-main`.`id` = 1703501 OR `props-main`.`id` = 1727196 OR `props-main`.`id` = 1728052 OR `props-main`.`id` = 1731383 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1731331 OR `props-main`.`id` = 1731471 OR `props-main`.`id` = 1731531 OR `props-main`.`id` = 1666180 OR `props-main`.`id` = 1708116 OR `props-main`.`id` = 1704149 OR `props-main`.`id` = 1704013 OR `props-main`.`id` = 1625902 OR `props-main`.`id` = 1724833 OR `props-main`.`id` = 1726030 OR `props-main`.`id` = 1714763 OR `props-main`.`id` = 1725288 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1729357 OR `props-main`.`id` = 1729449 OR `props-main`.`id` = 1714047 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1725990 OR `props-main`.`id` = 1721266 OR `props-main`.`id` = 1718871 OR `props-main`.`id` = 1700844 OR `props-main`.`id` = 1732169 OR `props-main`.`id` = 1718863 OR `props-main`.`id` = 1733220 OR `props-main`.`id` = 1733238 OR `props-main`.`id` = 1718510 OR `props-main`.`id` = 1718429 OR `props-main`.`id` = 1718458 OR `props-main`.`id` = 1700853 OR `props-main`.`id` = 1726153 OR `props-main`.`id` = 1731407 OR `props-main`.`id` = 1731450 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1705132 OR `props-main`.`id` = 1726219 OR `props-main`.`id` = 1725196 OR `props-main`.`id` = 1731691 OR `props-main`.`id` = 1705139 OR `props-main`.`id` = 1703905 OR `props-main`.`id` = 1726456 OR `props-main`.`id` = 1726449 OR `props-main`.`id` = 1703925 OR `props-main`.`id` = 1717940 OR `props-main`.`id` = 1712355 OR `props-main`.`id` = 1712541 OR `props-main`.`id` = 1731483 OR `props-main`.`id` = 1709899 OR `props-main`.`id` = 1722725 OR `props-main`.`id` = 1709957 OR `props-main`.`id` = 1722836 OR `props-main`.`id` = 1722396 OR `props-main`.`id` = 1731676 OR `props-main`.`id` = 1725475 OR `props-main`.`id` = 1725481 OR `props-main`.`id` = 1689800 OR `props-main`.`id` = 1714054 OR `props-main`.`id` = 1731506 OR `props-main`.`id` = 1714048 OR `props-main`.`id` = 1729575 OR `props-main`.`id` = 1720964 OR `props-main`.`id` = 1720988 OR `props-main`.`id` = 1716191 OR `props-main`.`id` = 1716166 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1728398 OR `props-main`.`id` = 1726519 OR `props-main`.`id` = 1704611 OR `props-main`.`id` = 1725795 OR `props-main`.`id` = 1726113 OR `props-main`.`id` = 1722603 OR `props-main`.`id` = 1713573 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1716811 OR `props-main`.`id` = 1683078 OR `props-main`.`id` = 1706819 OR `props-main`.`id` = 1731334 OR `props-main`.`id` = 1667788 OR `props-main`.`id` = 1715021 OR `props-main`.`id` = 1731509 OR `props-main`.`id` = 1714993 OR `props-main`.`id` = 1715010 OR `props-main`.`id` = 1727118 OR `props-main`.`id` = 1711485 OR `props-main`.`id` = 1711501 OR `props-main`.`id` = 1717498 OR `props-main`.`id` = 1722589 OR `props-main`.`id` = 1723500 OR `props-main`.`id` = 1725496 OR `props-main`.`id` = 1728752 OR `props-main`.`id` = 1728755 OR `props-main`.`id` = 1733236 OR `props-main`.`id` = 1733607 OR `props-main`.`id` = 1722835 OR `props-main`.`id` = 1722723 OR `props-main`.`id` = 1703810 OR `props-main`.`id` = 1732337 OR `props-main`.`id` = 1732154 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1708115 OR `props-main`.`id` = 1731399 OR `props-main`.`id` = 1708102)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643386' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-08' 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: