London Properties

Realtor

Upgrade this listing

Website | (209) 358-0222
2605 First St, Atwater, CA 95301, USA

Opening Hours:
Monday: 8:30 AM – 5:00 PM
Tuesday: 8:30 AM – 5:00 PM
Wednesday: 8:30 AM – 5:00 PM
Thursday: 8:30 AM – 5:00 PM
Friday: 8:30 AM – 5:00 PM
Saturday: Closed
Sunday: Closed


Area Served:
Within 4 miles (6.4km) of 2605 First St, Atwater, CA 95301, USA
Get more exposure


userID = NADA user_id = NADA alreadySaidHowdy = 0 userFirstName = NADA userLastName = NADA userName = NADA userStreetAddy = NADA userCity = NADA userState = NADA userZip = NADA userPhoneMobile = NADA userPhoneOther = NADA userEmail = NADA userIsAdmin = 0 userIsMLS = 0 daAgentSiteLink = GETagent_SetABC = daHomePageUhDisSite = https://www.londonproperties.com/ siteAgentID = 0 siteAgentName = NADA layoutPrefix = londonproperties_jm-0 apiKey = londonproperties-0 layoutfile = londonproperties_jm-0/londonproperties_jm-0.php chosenlayoutfileMethod = C layoutcss = londonproperties_jm-0/londonproperties_jm-0.css emailcss = londonproperties_jm-0.php privacyPolicyName = London Properties agentLinkText = fbPixel = londonproperties-0 fb_chat = londonproperties-0 yahooPixel = londonproperties-0 yahooRetarget = londonproperties-0 instawidge = buyerzguide = sellerzguide = siteAgentBGPU = 0 siteAgentOHPU = 0 siteID = 0 thisAgentSiteID = NADA userCanEditSite = 0 userCanEditMenus = 0 isLegitClient = 0 therebeSearches = 0 therebeProperties = 0 agentloggedin = 0 siteAgentFirstName = siteAgentLastName = siteAgentSiteLayout = 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-06-03' 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

Google Rating: 3.3 out of 5 stars (3 total ratings)

Jacq von Jacq
3 Star
THE USUAL, THERE ARE A FEW PEOPLE HERE THAT ACT LIKE THEY HAVE ALL THE MONEY IN THE WORLD BUT YET THEY PAY WITH W.I.C.& EBT ON THE DOWN-LOW AT THE SUPERMARKET. RELAX SALESPERSON!
Thursday 23rd January 2020
Nicolas Torres
4 Star
Great service
Monday 17th May 2021
connie buker
3 Star

Saturday 29th February 2020