Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524895 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) >= 2585 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3085 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` = 1713843 OR `props-main`.`id` = 1713678 OR `props-main`.`id` = 1719552 OR `props-main`.`id` = 1719544 OR `props-main`.`id` = 1713615 OR `props-main`.`id` = 1709281 OR `props-main`.`id` = 1709283 OR `props-main`.`id` = 1718821 OR `props-main`.`id` = 1718792 OR `props-main`.`id` = 1718188 OR `props-main`.`id` = 1718208 OR `props-main`.`id` = 1718322 OR `props-main`.`id` = 1718357 OR `props-main`.`id` = 1716664 OR `props-main`.`id` = 1716342 OR `props-main`.`id` = 1689913 OR `props-main`.`id` = 1719504 OR `props-main`.`id` = 1719081 OR `props-main`.`id` = 1719036 OR `props-main`.`id` = 1719519 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1716115 OR `props-main`.`id` = 1716195 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1699201 OR `props-main`.`id` = 1699153 OR `props-main`.`id` = 1687673 OR `props-main`.`id` = 1687672 OR `props-main`.`id` = 1712491 OR `props-main`.`id` = 1611124 OR `props-main`.`id` = 1611151)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24116405' 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.
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.
