A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 489250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 540750 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) >= 1714 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2214 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` = 1713337 OR `props-main`.`id` = 1713468 OR `props-main`.`id` = 1713597 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1714627 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1718769 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1714891 OR `props-main`.`id` = 1714888 OR `props-main`.`id` = 1715535 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1714734 OR `props-main`.`id` = 1714733 OR `props-main`.`id` = 1705804 OR `props-main`.`id` = 1707152 OR `props-main`.`id` = 1705917 OR `props-main`.`id` = 1705889 OR `props-main`.`id` = 1707126 OR `props-main`.`id` = 1707154 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1714858 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1714381 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1714822 OR `props-main`.`id` = 1710069 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1716596 OR `props-main`.`id` = 1713267 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1719235 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1719056 OR `props-main`.`id` = 1717369 OR `props-main`.`id` = 1713318 OR `props-main`.`id` = 1713316 OR `props-main`.`id` = 1713327 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1714626 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1717379 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1705044 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1705151 OR `props-main`.`id` = 1718717 OR `props-main`.`id` = 1718711 OR `props-main`.`id` = 1718743 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1708125 OR `props-main`.`id` = 1708155 OR `props-main`.`id` = 1707998 OR `props-main`.`id` = 1716448 OR `props-main`.`id` = 1708182 OR `props-main`.`id` = 1717717 OR `props-main`.`id` = 1717725 OR `props-main`.`id` = 1713374 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1715695 OR `props-main`.`id` = 1715654 OR `props-main`.`id` = 1715898 OR `props-main`.`id` = 1715888 OR `props-main`.`id` = 1715890 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1717948 OR `props-main`.`id` = 1688816)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224153716' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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,000 active listings.
Courtesy of Larissa Sherman, London Properties, LTD 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.
