A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1345 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1845 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` = 1774104 OR `props-main`.`id` = 1773845 OR `props-main`.`id` = 1773139 OR `props-main`.`id` = 1783388 OR `props-main`.`id` = 1782866 OR `props-main`.`id` = 1766145 OR `props-main`.`id` = 1783282 OR `props-main`.`id` = 1760036 OR `props-main`.`id` = 1773985 OR `props-main`.`id` = 1783284 OR `props-main`.`id` = 1771136 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1755397 OR `props-main`.`id` = 1748816 OR `props-main`.`id` = 1782855 OR `props-main`.`id` = 1783283 OR `props-main`.`id` = 1766141 OR `props-main`.`id` = 1782927 OR `props-main`.`id` = 1783219 OR `props-main`.`id` = 1750992 OR `props-main`.`id` = 1783111 OR `props-main`.`id` = 1755418 OR `props-main`.`id` = 1723324 OR `props-main`.`id` = 1755398 OR `props-main`.`id` = 1777021 OR `props-main`.`id` = 1782884 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1755427 OR `props-main`.`id` = 1782883 OR `props-main`.`id` = 1755407 OR `props-main`.`id` = 1755470 OR `props-main`.`id` = 1755473 OR `props-main`.`id` = 1774999 OR `props-main`.`id` = 1769740 OR `props-main`.`id` = 1779925 OR `props-main`.`id` = 1773141 OR `props-main`.`id` = 1743097 OR `props-main`.`id` = 1721490 OR `props-main`.`id` = 1780351 OR `props-main`.`id` = 1778362 OR `props-main`.`id` = 1775551 OR `props-main`.`id` = 1782953 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1780781 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1764611 OR `props-main`.`id` = 1764625 OR `props-main`.`id` = 1764621 OR `props-main`.`id` = 1784771 OR `props-main`.`id` = 1761670 OR `props-main`.`id` = 1774626 OR `props-main`.`id` = 1760038 OR `props-main`.`id` = 1744565 OR `props-main`.`id` = 1757653 OR `props-main`.`id` = 1737434 OR `props-main`.`id` = 1770891 OR `props-main`.`id` = 1725194 OR `props-main`.`id` = 1759374 OR `props-main`.`id` = 1763339 OR `props-main`.`id` = 1763250 OR `props-main`.`id` = 1782919 OR `props-main`.`id` = 1782893 OR `props-main`.`id` = 1769309 OR `props-main`.`id` = 1767800 OR `props-main`.`id` = 1732749 OR `props-main`.`id` = 1719132 OR `props-main`.`id` = 1777746 OR `props-main`.`id` = 1748218 OR `props-main`.`id` = 1778361 OR `props-main`.`id` = 1767715 OR `props-main`.`id` = 1771323 OR `props-main`.`id` = 1723215 OR `props-main`.`id` = 1783268 OR `props-main`.`id` = 1763830 OR `props-main`.`id` = 1782942 OR `props-main`.`id` = 1755413 OR `props-main`.`id` = 1764249 OR `props-main`.`id` = 1755396 OR `props-main`.`id` = 1783153 OR `props-main`.`id` = 1783392 OR `props-main`.`id` = 1783035 OR `props-main`.`id` = 1759008 OR `props-main`.`id` = 1779923 OR `props-main`.`id` = 1785008 OR `props-main`.`id` = 1776668 OR `props-main`.`id` = 1752340 OR `props-main`.`id` = 1748876 OR `props-main`.`id` = 1782928 OR `props-main`.`id` = 1783141 OR `props-main`.`id` = 1783206 OR `props-main`.`id` = 1687173 OR `props-main`.`id` = 1783335 OR `props-main`.`id` = 1782955 OR `props-main`.`id` = 1709760 OR `props-main`.`id` = 1770453 OR `props-main`.`id` = 1778058 OR `props-main`.`id` = 1768474 OR `props-main`.`id` = 1783390 OR `props-main`.`id` = 1783057 OR `props-main`.`id` = 1783151 OR `props-main`.`id` = 1736891 OR `props-main`.`id` = 1736894 OR `props-main`.`id` = 1774200 OR `props-main`.`id` = 1776268 OR `props-main`.`id` = 1774613 OR `props-main`.`id` = 1770807 OR `props-main`.`id` = 1719499 OR `props-main`.`id` = 1782977 OR `props-main`.`id` = 1727594 OR `props-main`.`id` = 1773117 OR `props-main`.`id` = 1775758 OR `props-main`.`id` = 1772847 OR `props-main`.`id` = 1782910 OR `props-main`.`id` = 1782909 OR `props-main`.`id` = 1322227 OR `props-main`.`id` = 1782873)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244438' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-01' 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();