A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461895 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) >= 1484 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1984 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` = 1773667 OR `props-main`.`id` = 1773666 OR `props-main`.`id` = 1702482 OR `props-main`.`id` = 1778969 OR `props-main`.`id` = 1774082 OR `props-main`.`id` = 1778369 OR `props-main`.`id` = 1773484 OR `props-main`.`id` = 1761086 OR `props-main`.`id` = 1774635 OR `props-main`.`id` = 1773300 OR `props-main`.`id` = 1780193 OR `props-main`.`id` = 1778773 OR `props-main`.`id` = 1761571 OR `props-main`.`id` = 1773626 OR `props-main`.`id` = 1779358 OR `props-main`.`id` = 1763601 OR `props-main`.`id` = 1773596 OR `props-main`.`id` = 1773597 OR `props-main`.`id` = 1772826 OR `props-main`.`id` = 1773430 OR `props-main`.`id` = 1773431 OR `props-main`.`id` = 1709991 OR `props-main`.`id` = 1771858 OR `props-main`.`id` = 1730377 OR `props-main`.`id` = 1745679 OR `props-main`.`id` = 1779469 OR `props-main`.`id` = 1771645 OR `props-main`.`id` = 1774861 OR `props-main`.`id` = 1757217 OR `props-main`.`id` = 1773118 OR `props-main`.`id` = 1754962 OR `props-main`.`id` = 1776265 OR `props-main`.`id` = 1771732 OR `props-main`.`id` = 1757243 OR `props-main`.`id` = 1771637 OR `props-main`.`id` = 1744264 OR `props-main`.`id` = 1746385 OR `props-main`.`id` = 1759547 OR `props-main`.`id` = 1763258 OR `props-main`.`id` = 1762457 OR `props-main`.`id` = 1773369 OR `props-main`.`id` = 1761688 OR `props-main`.`id` = 1773368 OR `props-main`.`id` = 1773370 OR `props-main`.`id` = 1765047 OR `props-main`.`id` = 1722074 OR `props-main`.`id` = 1773458 OR `props-main`.`id` = 1747606 OR `props-main`.`id` = 1736744 OR `props-main`.`id` = 1774664 OR `props-main`.`id` = 1773868 OR `props-main`.`id` = 1776768)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist222134335' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 12,700 active listings.
Courtesy of Jose Diaz, Exit Realty Consultants IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
