A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 512050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 565950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1737 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2237 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` = 1765796 OR `props-main`.`id` = 1766154 OR `props-main`.`id` = 1765783 OR `props-main`.`id` = 1766682 OR `props-main`.`id` = 1754373 OR `props-main`.`id` = 168045 OR `props-main`.`id` = 1755061 OR `props-main`.`id` = 1776430 OR `props-main`.`id` = 1766401 OR `props-main`.`id` = 1756102 OR `props-main`.`id` = 1775140 OR `props-main`.`id` = 1742089 OR `props-main`.`id` = 1779642 OR `props-main`.`id` = 1754877 OR `props-main`.`id` = 1773828 OR `props-main`.`id` = 1747287 OR `props-main`.`id` = 1745712 OR `props-main`.`id` = 1774360 OR `props-main`.`id` = 1775377 OR `props-main`.`id` = 1774177 OR `props-main`.`id` = 1736527 OR `props-main`.`id` = 1737708 OR `props-main`.`id` = 1774076 OR `props-main`.`id` = 1770676 OR `props-main`.`id` = 1770677 OR `props-main`.`id` = 1770183 OR `props-main`.`id` = 1761048 OR `props-main`.`id` = 1757715 OR `props-main`.`id` = 1778604 OR `props-main`.`id` = 1780124 OR `props-main`.`id` = 1780126 OR `props-main`.`id` = 1770707 OR `props-main`.`id` = 1780158 OR `props-main`.`id` = 1725324 OR `props-main`.`id` = 1715576 OR `props-main`.`id` = 1752925 OR `props-main`.`id` = 1738541 OR `props-main`.`id` = 1778605 OR `props-main`.`id` = 1728045 OR `props-main`.`id` = 1745144 OR `props-main`.`id` = 1742623 OR `props-main`.`id` = 735701 OR `props-main`.`id` = 1732856 OR `props-main`.`id` = 1758805 OR `props-main`.`id` = 1715922 OR `props-main`.`id` = 1728456 OR `props-main`.`id` = 1709869 OR `props-main`.`id` = 1747455 OR `props-main`.`id` = 1763245 OR `props-main`.`id` = 1756175 OR `props-main`.`id` = 1771258 OR `props-main`.`id` = 165776 OR `props-main`.`id` = 1776601 OR `props-main`.`id` = 1708358 OR `props-main`.`id` = 1722101 OR `props-main`.`id` = 1765341 OR `props-main`.`id` = 1736538 OR `props-main`.`id` = 1749172 OR `props-main`.`id` = 1768744 OR `props-main`.`id` = 1748592 OR `props-main`.`id` = 1770180 OR `props-main`.`id` = 1774746 OR `props-main`.`id` = 1759375 OR `props-main`.`id` = 1748089 OR `props-main`.`id` = 1774487 OR `props-main`.`id` = 1765632 OR `props-main`.`id` = 1769271 OR `props-main`.`id` = 1758915 OR `props-main`.`id` = 1770538 OR `props-main`.`id` = 1723147 OR `props-main`.`id` = 1723157 OR `props-main`.`id` = 1747288 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1746060 OR `props-main`.`id` = 1757169 OR `props-main`.`id` = 1754640 OR `props-main`.`id` = 1758207 OR `props-main`.`id` = 1779288 OR `props-main`.`id` = 1779276 OR `props-main`.`id` = 1771894 OR `props-main`.`id` = 1765843 OR `props-main`.`id` = 1755515 OR `props-main`.`id` = 1733315 OR `props-main`.`id` = 1770141 OR `props-main`.`id` = 1705942 OR `props-main`.`id` = 1774046 OR `props-main`.`id` = 1754683 OR `props-main`.`id` = 1766481 OR `props-main`.`id` = 1756966 OR `props-main`.`id` = 1780009 OR `props-main`.`id` = 1780010 OR `props-main`.`id` = 1754230 OR `props-main`.`id` = 1772183 OR `props-main`.`id` = 1755152 OR `props-main`.`id` = 1774094 OR `props-main`.`id` = 1773726 OR `props-main`.`id` = 1770993 OR `props-main`.`id` = 1765114 OR `props-main`.`id` = 1770611 OR `props-main`.`id` = 1738927 OR `props-main`.`id` = 1771060 OR `props-main`.`id` = 1769289 OR `props-main`.`id` = 1768561 OR `props-main`.`id` = 1762837 OR `props-main`.`id` = 1762059 OR `props-main`.`id` = 1777027 OR `props-main`.`id` = 1688490 OR `props-main`.`id` = 1747290 OR `props-main`.`id` = 1742345 OR `props-main`.`id` = 1744652 OR `props-main`.`id` = 1725161 OR `props-main`.`id` = 1778052 OR `props-main`.`id` = 1765635 OR `props-main`.`id` = 1741761 OR `props-main`.`id` = 1741782)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652640' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-23' 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();