In 2022 London Properties closed over 1.1 billion in sales. For the past 50 years, London Properties has become the Central Valley's largest and most historied family-owned real estate brokerage. The success of our associates has also earned us the reputation as the most trusted name in real estate; it's a reputation you can count on.
SELECT * FROM `lpdotcom`.`props-main` WHERE `City` = 'Fresno' AND CAST(`ListingPrice` AS DECIMAL) > '200000' AND `ShowAddressToPublic` = '1' AND ((`PropertyType` = 'Residential' AND (`PropertySubtype1` = '1 House on Lot' OR `PropertySubtype2` = '1 House on Lot' OR `PropertySubtype3` = '1 House on Lot' OR `PropertySubtype1` = 'Cabin' OR `PropertySubtype2` = 'Cabin' OR `PropertySubtype3` = 'Cabin' OR `PropertySubtype1` = 'House on Lot' OR `PropertySubtype2` = 'House on Lot' OR `PropertySubtype3` = 'House on Lot' OR `PropertySubtype1` = 'Own Your Own' OR `PropertySubtype2` = 'Own Your Own' OR `PropertySubtype3` = 'Own Your Own' OR `PropertySubtype1` = 'Rural Residence' OR `PropertySubtype2` = 'Rural Residence' OR `PropertySubtype3` = 'Rural Residence' OR `PropertySubtype1` = 'Rural/Residence' OR `PropertySubtype2` = 'Rural/Residence' OR `PropertySubtype3` = 'Rural/Residence' OR `PropertySubtype1` LIKE '%fam%' OR `PropertySubtype2` LIKE '%fam%' OR `PropertySubtype3` LIKE '%fam%'))) AND `PictureCount` > 0 AND (`ExpiredDate` >= '2023-05-27' OR `ExpiredDate` IS NULL OR TRIM(`ExpiredDate`) = '') AND `Status` != 'Unapproved' AND (`DupeOf` IS NULL OR TRIM(`DupeOf`) = '') AND `Delayed` = 0 GROUP BY `id` ORDER BY `ListingDate` DESC,CAST(`ListingPrice` AS DECIMAL) DESC LIMIT 4
Website designed and built by Reliance Marketing
Outstanding
Personalized
Comprehensive