A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 617452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1700 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2200 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` = 1704359 OR `props-main`.`id` = 1717613 OR `props-main`.`id` = 1714110 OR `props-main`.`id` = 1718144 OR `props-main`.`id` = 1687989 OR `props-main`.`id` = 1717698 OR `props-main`.`id` = 1717823 OR `props-main`.`id` = 1714641 OR `props-main`.`id` = 1714640 OR `props-main`.`id` = 1718435 OR `props-main`.`id` = 1719294 OR `props-main`.`id` = 1717548 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1719757 OR `props-main`.`id` = 1714609 OR `props-main`.`id` = 1712345 OR `props-main`.`id` = 1714608 OR `props-main`.`id` = 1714610 OR `props-main`.`id` = 1716260 OR `props-main`.`id` = 1716856 OR `props-main`.`id` = 1718989 OR `props-main`.`id` = 1717399 OR `props-main`.`id` = 1715720 OR `props-main`.`id` = 1716423 OR `props-main`.`id` = 1714639 OR `props-main`.`id` = 1716007 OR `props-main`.`id` = 1716590 OR `props-main`.`id` = 1716375 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1714350 OR `props-main`.`id` = 1714690 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1716243 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1718728 OR `props-main`.`id` = 1718874 OR `props-main`.`id` = 1715937 OR `props-main`.`id` = 1714529 OR `props-main`.`id` = 1715825 OR `props-main`.`id` = 1717586 OR `props-main`.`id` = 1719847 OR `props-main`.`id` = 1714442 OR `props-main`.`id` = 1714507 OR `props-main`.`id` = 1714215 OR `props-main`.`id` = 1720267 OR `props-main`.`id` = 1720268 OR `props-main`.`id` = 1716005 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1714305 OR `props-main`.`id` = 1714861 OR `props-main`.`id` = 1714868 OR `props-main`.`id` = 1717281 OR `props-main`.`id` = 1717892 OR `props-main`.`id` = 1692292 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1714322 OR `props-main`.`id` = 1703426 OR `props-main`.`id` = 1713155 OR `props-main`.`id` = 1709971 OR `props-main`.`id` = 1718716 OR `props-main`.`id` = 1718033 OR `props-main`.`id` = 1714764 OR `props-main`.`id` = 1718929 OR `props-main`.`id` = 1717316 OR `props-main`.`id` = 1712588)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist223104274' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,400 active listings.
Courtesy of Orlando Bustos, Bustos Real Estate 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.
