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 = 3403 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3403 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3403 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

161 Durham Lake Parkway
Fairburn, GA 30213

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 5
Baths: 4
Status: Active
SqFt: 3649
Agency: Intown Focus Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: ******PRICE DROP!! 100.0% FINANCING AVAILABLE!!!******<br /> <br /> Fantastic Lake-Front Showstopper in Durham Lakes Golf & Country Club! From the dramatic 2-story family room to the gracious lakefront location steps away from the golf course, this Stephen Elliot designed home will meet your every need. The open concept kitchen and family room have enough space for the family chef to whip up the most elaborate meals in the Frigidaire double-oven and the 4-burner cooktop yet not miss out on family fun. The kitchen also features abundant counter space, plentiful custom cabinetry, a large pantry as well as an expansive island. This grand, soaring 2-story entry foyer will make greeting guests a delight. The dining room's coffered ceilings and paneled walls will add a touch of elegance to formal meals. The guest suite on the main level is the perfect retreat for visitors, while upstairs each room is its own cozy sanctuary of space and privacy. A spacious office area accommodates the requirements of work-from-home dynamics in this post-pandemic era. Finished in four-sided brick and beautiful landscaping, there's a side-entry garage and the home's ideal lakefront location makes for gracious outdoor entertaining or quiet relaxation. Durham Lakes Golf & Country Club is a master-planned community featuring a premier championship 18-hole golf course, two amenity centers a clubhouse, basketball court, playground, junior olympic pool, covered cabana, and tennis Courts. It is conveniently located just 2.5 miles from I-85, the amenities and shopping of Camp Creek Marketplace, Downtown College Park, and Hartsfield-Jackson International Airport. This home is a unique opportunity - don't hesitate to book your tour now and make this one yours!
MlsNumber: 7351517


Listing Provided By: Intown Focus Realty, original listing
Name: Intown Focus Realty
Phone: (404) 585-5975
Office Name: Intown Focus Realty, LLC.
Office Phone: (404) 585-5975
Agent Name: Douglas Jones
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