A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 261250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 288750 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) >= 1095 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1595 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` = 1697281 OR `props-main`.`id` = 1752319 OR `props-main`.`id` = 1764425 OR `props-main`.`id` = 1760883 OR `props-main`.`id` = 1759163 OR `props-main`.`id` = 1759161 OR `props-main`.`id` = 1769188 OR `props-main`.`id` = 1755452 OR `props-main`.`id` = 1685045 OR `props-main`.`id` = 1755399 OR `props-main`.`id` = 1755463 OR `props-main`.`id` = 1760070 OR `props-main`.`id` = 1739927 OR `props-main`.`id` = 1758606 OR `props-main`.`id` = 1771487 OR `props-main`.`id` = 1732851 OR `props-main`.`id` = 1732871 OR `props-main`.`id` = 1764497 OR `props-main`.`id` = 1771381 OR `props-main`.`id` = 1763720 OR `props-main`.`id` = 1759683 OR `props-main`.`id` = 1754271 OR `props-main`.`id` = 1749732 OR `props-main`.`id` = 1757826 OR `props-main`.`id` = 1768611 OR `props-main`.`id` = 1737350 OR `props-main`.`id` = 1749192 OR `props-main`.`id` = 1749195 OR `props-main`.`id` = 1748060 OR `props-main`.`id` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1772003 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` = 1742508 OR `props-main`.`id` = 1755422 OR `props-main`.`id` = 1755449 OR `props-main`.`id` = 1726532 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1763457 OR `props-main`.`id` = 1720520 OR `props-main`.`id` = 1755406 OR `props-main`.`id` = 1756159 OR `props-main`.`id` = 1755404 OR `props-main`.`id` = 1754531 OR `props-main`.`id` = 1752729 OR `props-main`.`id` = 1769388 OR `props-main`.`id` = 1769386 OR `props-main`.`id` = 1754553 OR `props-main`.`id` = 1762056 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1754584 OR `props-main`.`id` = 1771134 OR `props-main`.`id` = 1769389 OR `props-main`.`id` = 1754529 OR `props-main`.`id` = 1763684 OR `props-main`.`id` = 1736790 OR `props-main`.`id` = 1766434 OR `props-main`.`id` = 1762336 OR `props-main`.`id` = 1755401 OR `props-main`.`id` = 1761142 OR `props-main`.`id` = 1767617 OR `props-main`.`id` = 1766559 OR `props-main`.`id` = 1768039 OR `props-main`.`id` = 1722155 OR `props-main`.`id` = 1716994 OR `props-main`.`id` = 1753744 OR `props-main`.`id` = 1725486 OR `props-main`.`id` = 1725920 OR `props-main`.`id` = 1762790 OR `props-main`.`id` = 1762797 OR `props-main`.`id` = 1763402 OR `props-main`.`id` = 1772299 OR `props-main`.`id` = 1763029 OR `props-main`.`id` = 1740835 OR `props-main`.`id` = 1772064 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` = 1763027 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` = 1773089 OR `props-main`.`id` = 1769980 OR `props-main`.`id` = 1761921 OR `props-main`.`id` = 1753427 OR `props-main`.`id` = 1763026 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` = 1756004 OR `props-main`.`id` = 1736796 OR `props-main`.`id` = 1752344 OR `props-main`.`id` = 1725240 OR `props-main`.`id` = 1757165 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243942' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-07' 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: