A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 460950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '6' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 758 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1258 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` = 1781145 OR `props-main`.`id` = 1773833 OR `props-main`.`id` = 1782455 OR `props-main`.`id` = 1783135 OR `props-main`.`id` = 1783136 OR `props-main`.`id` = 1771381 OR `props-main`.`id` = 1781342 OR `props-main`.`id` = 1757826 OR `props-main`.`id` = 1726526 OR `props-main`.`id` = 1735828 OR `props-main`.`id` = 1768874 OR `props-main`.`id` = 1768876 OR `props-main`.`id` = 1769384 OR `props-main`.`id` = 1769385 OR `props-main`.`id` = 1784256 OR `props-main`.`id` = 1737350 OR `props-main`.`id` = 1749192 OR `props-main`.`id` = 1779772 OR `props-main`.`id` = 1779771 OR `props-main`.`id` = 1784141 OR `props-main`.`id` = 1787590 OR `props-main`.`id` = 1783803 OR `props-main`.`id` = 1784127 OR `props-main`.`id` = 1729292 OR `props-main`.`id` = 1731907 OR `props-main`.`id` = 1731070 OR `props-main`.`id` = 1781661 OR `props-main`.`id` = 1780946 OR `props-main`.`id` = 1780973 OR `props-main`.`id` = 1783372 OR `props-main`.`id` = 1772003 OR `props-main`.`id` = 1790383 OR `props-main`.`id` = 1725695 OR `props-main`.`id` = 1780751 OR `props-main`.`id` = 1719587 OR `props-main`.`id` = 1792027 OR `props-main`.`id` = 1762035 OR `props-main`.`id` = 1755089 OR `props-main`.`id` = 1756258 OR `props-main`.`id` = 1778364 OR `props-main`.`id` = 1742508 OR `props-main`.`id` = 1779199 OR `props-main`.`id` = 1776372 OR `props-main`.`id` = 1784783 OR `props-main`.`id` = 1783330 OR `props-main`.`id` = 1783379 OR `props-main`.`id` = 1781912 OR `props-main`.`id` = 1717106 OR `props-main`.`id` = 1787107 OR `props-main`.`id` = 1763457 OR `props-main`.`id` = 1785399 OR `props-main`.`id` = 1790600 OR `props-main`.`id` = 1752729 OR `props-main`.`id` = 1762056 OR `props-main`.`id` = 1728113 OR `props-main`.`id` = 1790584 OR `props-main`.`id` = 1775656 OR `props-main`.`id` = 1790875 OR `props-main`.`id` = 1790878 OR `props-main`.`id` = 1790880 OR `props-main`.`id` = 1789697 OR `props-main`.`id` = 1775657 OR `props-main`.`id` = 1784289 OR `props-main`.`id` = 1788032 OR `props-main`.`id` = 1767617 OR `props-main`.`id` = 1775466 OR `props-main`.`id` = 1768039 OR `props-main`.`id` = 1753744 OR `props-main`.`id` = 1725920 OR `props-main`.`id` = 1772299 OR `props-main`.`id` = 1763029 OR `props-main`.`id` = 1774373 OR `props-main`.`id` = 1787461 OR `props-main`.`id` = 1791295 OR `props-main`.`id` = 1760884 OR `props-main`.`id` = 1761707 OR `props-main`.`id` = 1790388 OR `props-main`.`id` = 1791361 OR `props-main`.`id` = 1773098 OR `props-main`.`id` = 1769904 OR `props-main`.`id` = 1747640 OR `props-main`.`id` = 1789597 OR `props-main`.`id` = 1775806 OR `props-main`.`id` = 1761921 OR `props-main`.`id` = 1753427 OR `props-main`.`id` = 1717233 OR `props-main`.`id` = 1725304 OR `props-main`.`id` = 1756006 OR `props-main`.`id` = 1770872 OR `props-main`.`id` = 1773753 OR `props-main`.`id` = 1756004 OR `props-main`.`id` = 1784189 OR `props-main`.`id` = 1725240 OR `props-main`.`id` = 1746235 OR `props-main`.`id` = 1767760 OR `props-main`.`id` = 1787587 OR `props-main`.`id` = 1767588 OR `props-main`.`id` = 1778367 OR `props-main`.`id` = 1792037 OR `props-main`.`id` = 1780748 OR `props-main`.`id` = 1736324 OR `props-main`.`id` = 1784083 OR `props-main`.`id` = 1789696 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` = 1677929 OR `props-main`.`id` = 1789551 OR `props-main`.`id` = 1775954)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244680' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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: