A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1540 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2040 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` = 1709256 OR `props-main`.`id` = 1711061 OR `props-main`.`id` = 1711036 OR `props-main`.`id` = 1710631 OR `props-main`.`id` = 1690812 OR `props-main`.`id` = 1710617 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1697766 OR `props-main`.`id` = 1708185 OR `props-main`.`id` = 1710727 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1697495 OR `props-main`.`id` = 1697572 OR `props-main`.`id` = 1708256 OR `props-main`.`id` = 1695792 OR `props-main`.`id` = 1701832 OR `props-main`.`id` = 1710576 OR `props-main`.`id` = 1710200 OR `props-main`.`id` = 1691042 OR `props-main`.`id` = 1698163 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1689031 OR `props-main`.`id` = 1711097 OR `props-main`.`id` = 1710901 OR `props-main`.`id` = 1703059 OR `props-main`.`id` = 1698477 OR `props-main`.`id` = 1708083 OR `props-main`.`id` = 1709969 OR `props-main`.`id` = 1692578 OR `props-main`.`id` = 1710996 OR `props-main`.`id` = 1710542 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1709200 OR `props-main`.`id` = 1701740 OR `props-main`.`id` = 1711323 OR `props-main`.`id` = 1697884 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1701138 OR `props-main`.`id` = 1697394 OR `props-main`.`id` = 1703385 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1710771 OR `props-main`.`id` = 1701906 OR `props-main`.`id` = 1703336 OR `props-main`.`id` = 1710164 OR `props-main`.`id` = 1709507 OR `props-main`.`id` = 1705412 OR `props-main`.`id` = 1708272 OR `props-main`.`id` = 1705434 OR `props-main`.`id` = 1710656 OR `props-main`.`id` = 1702533 OR `props-main`.`id` = 1697583 OR `props-main`.`id` = 1709886 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1711022 OR `props-main`.`id` = 1710774 OR `props-main`.`id` = 1701553 OR `props-main`.`id` = 1697854 OR `props-main`.`id` = 1702884 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1711219 OR `props-main`.`id` = 1709418 OR `props-main`.`id` = 1710000 OR `props-main`.`id` = 1694651 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1708484 OR `props-main`.`id` = 1703357 OR `props-main`.`id` = 1710987 OR `props-main`.`id` = 1708218 OR `props-main`.`id` = 1704041 OR `props-main`.`id` = 1701188 OR `props-main`.`id` = 1706866 OR `props-main`.`id` = 1704578 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1705345 OR `props-main`.`id` = 1704885 OR `props-main`.`id` = 1702432 OR `props-main`.`id` = 1695775 OR `props-main`.`id` = 1708026 OR `props-main`.`id` = 1702971 OR `props-main`.`id` = 1697912 OR `props-main`.`id` = 1695782 OR `props-main`.`id` = 1703452 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1709519 OR `props-main`.`id` = 1710063 OR `props-main`.`id` = 1711357 OR `props-main`.`id` = 1695600 OR `props-main`.`id` = 1711017 OR `props-main`.`id` = 1697814 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1702186 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1709294 OR `props-main`.`id` = 1710983 OR `props-main`.`id` = 1701671 OR `props-main`.`id` = 1693498 OR `props-main`.`id` = 1710064 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1710159 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1706033 OR `props-main`.`id` = 1709545 OR `props-main`.`id` = 1702834 OR `props-main`.`id` = 1705003 OR `props-main`.`id` = 1705009 OR `props-main`.`id` = 1702956 OR `props-main`.`id` = 1711308 OR `props-main`.`id` = 1711065 OR `props-main`.`id` = 1703775 OR `props-main`.`id` = 1705185)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226013576' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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: