A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498750 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) >= 1038 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1538 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` = 1701362 OR `props-main`.`id` = 1701363 OR `props-main`.`id` = 1701309 OR `props-main`.`id` = 1701308 OR `props-main`.`id` = 1701310 OR `props-main`.`id` = 1712846 OR `props-main`.`id` = 1719209 OR `props-main`.`id` = 1719667 OR `props-main`.`id` = 1716372 OR `props-main`.`id` = 1716577 OR `props-main`.`id` = 1701743 OR `props-main`.`id` = 1708099 OR `props-main`.`id` = 1714660 OR `props-main`.`id` = 1674365 OR `props-main`.`id` = 1706662 OR `props-main`.`id` = 1719410 OR `props-main`.`id` = 1700923 OR `props-main`.`id` = 1717627 OR `props-main`.`id` = 1718162 OR `props-main`.`id` = 1712696 OR `props-main`.`id` = 1718046 OR `props-main`.`id` = 1713650 OR `props-main`.`id` = 1717150 OR `props-main`.`id` = 1709988 OR `props-main`.`id` = 1714256 OR `props-main`.`id` = 1716132 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1689348 OR `props-main`.`id` = 1719616 OR `props-main`.`id` = 1719397 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1719634 OR `props-main`.`id` = 1718505 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1679946 OR `props-main`.`id` = 1719152 OR `props-main`.`id` = 1714662 OR `props-main`.`id` = 1714746 OR `props-main`.`id` = 1714333 OR `props-main`.`id` = 1616278 OR `props-main`.`id` = 1714330 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1714236 OR `props-main`.`id` = 1709227 OR `props-main`.`id` = 1713456 OR `props-main`.`id` = 1719608 OR `props-main`.`id` = 1689362 OR `props-main`.`id` = 1713774 OR `props-main`.`id` = 1709847 OR `props-main`.`id` = 1714484 OR `props-main`.`id` = 1707967 OR `props-main`.`id` = 1709752 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1716936 OR `props-main`.`id` = 1713252 OR `props-main`.`id` = 1697654 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1716211 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1716343 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1667438 OR `props-main`.`id` = 1716616 OR `props-main`.`id` = 1719628 OR `props-main`.`id` = 1712970 OR `props-main`.`id` = 1718501 OR `props-main`.`id` = 1717525 OR `props-main`.`id` = 1712910 OR `props-main`.`id` = 1711224 OR `props-main`.`id` = 1708320 OR `props-main`.`id` = 1717098 OR `props-main`.`id` = 1719119 OR `props-main`.`id` = 1709706 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1715488 OR `props-main`.`id` = 1718893 OR `props-main`.`id` = 1718376 OR `props-main`.`id` = 1708267 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1695237 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1711330 OR `props-main`.`id` = 1703891 OR `props-main`.`id` = 1703898 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1706036 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1719133 OR `props-main`.`id` = 1702640 OR `props-main`.`id` = 1716857 OR `props-main`.`id` = 1716205 OR `props-main`.`id` = 1707899 OR `props-main`.`id` = 1715832 OR `props-main`.`id` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1713541 OR `props-main`.`id` = 1713642 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1719796 OR `props-main`.`id` = 1712359 OR `props-main`.`id` = 1718413 OR `props-main`.`id` = 1719232 OR `props-main`.`id` = 1711578 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1719580 OR `props-main`.`id` = 1717196 OR `props-main`.`id` = 1705953 OR `props-main`.`id` = 1713619 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1694561)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224073029' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();