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

208 Barton Drive
Atlanta, GA 30354

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $260,000
Beds: 4
Baths: 1
Status: Pending
SqFt: 1304
Agency: Peachtree Road Realty Associates LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1964
Notes: Welcome to this charming estate property nestled in historic Hapeville. Meticulously maintained with many updates throughout, this move in ready home offers a perfect blend of classic charm and modern convenience. As you step inside, you're greeted by gleaming hardwood floors that flow seamlessly throughout the main level. The family/living room features a cozy fireplace, perfect for chilly evenings and creating a welcoming ambiance. The separate dining room provides an ideal space for gatherings and entertaining, while the screened-in porch off the kitchen offers peaceful views of the private and expansive backyard. Whether you're hosting a barbecue with friends, enjoying nature watching, or simply seeking a quiet moment of reflection, this outdoor oasis provides the perfect backdrop. With four bedrooms and one bathroom, this home provides ample space for family living. Additionally, there's potential to easily add a second bathroom on the second story, providing even more convenience and functionality. Constructed with four-sided brick, this home exudes solidity and durability, promising years of low-maintenance living. Situated on a large flat lot with mature landscaping, the outdoor space is perfect for enjoying Georgia's beautiful weather and entertaining guests. The location couldn't be more convenient, with close proximity to Hartsfield Jackson International Airport, Porsche headquarters, Downtown Hapeville shopping and restaurants, Arches Brewing, Downtown Atlanta, and Interstates I-285 and I-75/85. Whether you're looking for a family home to create lasting memories or seeking a savvy investment opportunity, this property has it all. With room for updates and your own creative touches, it's just waiting for you to make it your own. Don't miss your chance to own a piece of history in the heart of Hapeville! Estate owned. Sold As Is with right to inspect
MlsNumber: 7350132


Listing Provided By: Peachtree Road Realty Associates LLC, original listing
Name: Peachtree Road Realty Associates LLC
Phone: (404) 419-3501
Office Name: Keller Williams Realty Peachtree Rd.
Office Phone: (404) 419-3500
Agent Name: Angela Carpinella
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