A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 687800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 760200 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3559 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4059 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` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1768036 OR `props-main`.`id` = 1762035 OR `props-main`.`id` = 1755447 OR `props-main`.`id` = 1766675 OR `props-main`.`id` = 1755089 OR `props-main`.`id` = 1756258 OR `props-main`.`id` = 1774385 OR `props-main`.`id` = 1776123 OR `props-main`.`id` = 1755422 OR `props-main`.`id` = 1755449 OR `props-main`.`id` = 1774260 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1720520 OR `props-main`.`id` = 1755406 OR `props-main`.`id` = 1755404 OR `props-main`.`id` = 1762056 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1775656 OR `props-main`.`id` = 1755401 OR `props-main`.`id` = 1775657 OR `props-main`.`id` = 1767617 OR `props-main`.`id` = 1775466 OR `props-main`.`id` = 1771693 OR `props-main`.`id` = 1768039 OR `props-main`.`id` = 1722155 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1753744 OR `props-main`.`id` = 1725920 OR `props-main`.`id` = 1732592 OR `props-main`.`id` = 1762790 OR `props-main`.`id` = 1762797 OR `props-main`.`id` = 1763402 OR `props-main`.`id` = 1772299 OR `props-main`.`id` = 1740835 OR `props-main`.`id` = 1760637 OR `props-main`.`id` = 1774373 OR `props-main`.`id` = 1772064 OR `props-main`.`id` = 1760884 OR `props-main`.`id` = 1761707 OR `props-main`.`id` = 1733382 OR `props-main`.`id` = 1733342 OR `props-main`.`id` = 1733388 OR `props-main`.`id` = 1735820 OR `props-main`.`id` = 1773704 OR `props-main`.`id` = 1773098 OR `props-main`.`id` = 1769904 OR `props-main`.`id` = 1747640 OR `props-main`.`id` = 1753034 OR `props-main`.`id` = 1752947 OR `props-main`.`id` = 1775806 OR `props-main`.`id` = 1773089 OR `props-main`.`id` = 1769980 OR `props-main`.`id` = 1753427 OR `props-main`.`id` = 1724772 OR `props-main`.`id` = 1724773 OR `props-main`.`id` = 1717233 OR `props-main`.`id` = 1725304 OR `props-main`.`id` = 1768038 OR `props-main`.`id` = 1756002 OR `props-main`.`id` = 1756006 OR `props-main`.`id` = 1756005 OR `props-main`.`id` = 1755484 OR `props-main`.`id` = 1770872 OR `props-main`.`id` = 1773753 OR `props-main`.`id` = 1756004 OR `props-main`.`id` = 1736796 OR `props-main`.`id` = 1725240 OR `props-main`.`id` = 1757165 OR `props-main`.`id` = 1736244 OR `props-main`.`id` = 1746235 OR `props-main`.`id` = 1748996 OR `props-main`.`id` = 1767760 OR `props-main`.`id` = 1767588 OR `props-main`.`id` = 1748963 OR `props-main`.`id` = 1736324 OR `props-main`.`id` = 1747604 OR `props-main`.`id` = 1746778 OR `props-main`.`id` = 1762759 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1760558 OR `props-main`.`id` = 1727120 OR `props-main`.`id` = 1722536 OR `props-main`.`id` = 1727693 OR `props-main`.`id` = 1753054 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1726412 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1726625 OR `props-main`.`id` = 1770360 OR `props-main`.`id` = 1775954 OR `props-main`.`id` = 1752619 OR `props-main`.`id` = 1763427 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1775137 OR `props-main`.`id` = 1762614 OR `props-main`.`id` = 1719473 OR `props-main`.`id` = 1757437 OR `props-main`.`id` = 1757436 OR `props-main`.`id` = 1757438 OR `props-main`.`id` = 1757439 OR `props-main`.`id` = 1757440 OR `props-main`.`id` = 1757441 OR `props-main`.`id` = 1719866 OR `props-main`.`id` = 1719864 OR `props-main`.`id` = 1774794 OR `props-main`.`id` = 1763030 OR `props-main`.`id` = 1773887 OR `props-main`.`id` = 1771321 OR `props-main`.`id` = 1755402 OR `props-main`.`id` = 1774816 OR `props-main`.`id` = 1768033 OR `props-main`.`id` = 1771137 OR `props-main`.`id` = 1719975)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244097' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-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: