Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 106 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 106 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 106 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5630 Timson Lane
Johns Creek, GA 30022

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 6
Baths: 5
Status: Pending
SqFt: 4438
Agency: Dream Homes Realty Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1991
Notes: RARE FIND! ONE OWNER! Location! Location! Location! This Pristine home is in a desirable community in Johns Creek, with an incredible location and AWESOME neighborhood - MEDLOCK BRIDGE. Make this your new forever home. You will be welcomed inside a two-story foyer, a two-story great room, hardwood floors, and natural light. This home has the ideal layout, boasting a tremendous open floor plan from the kitchen into the main living area. It has six bedrooms, five full baths, a Hugh outside deck with a built-in hot tub, and a finished basement. You will fall in love the moment you walk into this beautiful home. The kitchen has white cabinets with granite counters. <br /> Only a few minutes to Avalon - Live shows every Friday and upscale boutiques. Amenities GALORE: walking trail that follows a creek, two swimming pools with lifeguards, a waterslide, hiking trails, lakes, twelve tennis courts, a soccer field, a basketball court, two playgrounds, two clubhouses, pickleball, and an active swim team. Johns Creek/Alpharetta has been named the "50 best places to live in America." Everything is walkable and quaint, with abundant shopping nearby, tons of dining, and lots of year-round entertainment. AWARD WINNING SCHOOLS! This beautiful home is truly a WIN! It's perfect for family and friends gatherings where memories are made. All within the sought-after Johns Creek High School District! This is a fantastic opportunity to own your piece of Medlock Bridge in the heart of Johns Creek! <br /> Your search is over! This is it! You just found your home! Start packing and be ready for NEW BEGINNINGS IN YOUR NEW HOME!
MlsNumber: 7352764


Listing Provided By: Dream Homes Realty Inc., original listing
Name: Dream Homes Realty Inc.
Phone: (770) 945-7774
Office Name: Dream Homes Realty, Inc.
Office Phone: (678) 725-2786
Agent Name: Peggy Clouse
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App