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 = 532 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 = 532 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 = 532 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;

120 Howard Street Se
Atlanta, GA 30317

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,500
Beds: 3
Baths: 2
Status: Active
SqFt: 1585
Agency: Keller Knapp Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Rental
Year Built: 1910
Notes: Get ready to live your best life in this beautifully furnished rental! ALL utilities included, Pets allowed, professional management, and flexible lease terms. Perfect for film/production travel, corporate relocation, insurance stays, etc. <br /> <br /> We've got all the bells and whistles covered - and by bells, we mean a sleek induction range in the newly renovated chef's kitchen that will make you feel like a culinary wizard. And who needs whistles when you have ultra fast WiFi that can download cat videos faster than you can say "meow"?<br /> <br /> Picture yourself on the front porch, sipping your morning coffee as you watch the world go by. If you're more of a backyard lover, our sunny deck overlooking the fenced yard is perfect for contemplating life's mysteries. <br /> <br /> Parking? We've got you covered with an electric gated driveway and a quiet street – because nothing says luxury like avoiding the eternal struggle for a parking spot.<br /> <br /> And for the fitness enthusiasts, we've thrown in a Peloton bike because why run outside when you can pretend to bike through the French countryside from the comfort of your own home?<br /> <br /> This Kirkwood castle is not just a house; it's a lifestyle upgrade with 3 bedrooms and 2 full baths. The primary bedroom has 1x king bed. The second bedroom has 1x queen bed. The third bedroom has 2 twin beds, a desk/office setup and a Peloton. Come see what makes this place the hottest castle in town!<br /> <br /> This dreamy castle is just a block away from the heart of historic downtown Kirkwood. Picture yourself sipping coffee at Taproom, indulging in delectable treats at Evergreen Butcher + Baker, or finding your zen at Seviin Yoga. Craving a lively atmosphere? Kirkyard Public House is ready to welcome you, and for unconventional pizza lovers, Urban Pie is just around the corner. Your culinary and cultural adventure starts right outside your doorstep. Welcome to your happily ever after, one block from flavor-packed bliss!<br /> <br /> <br /> <br /> Pricing varies by length of stay: <br /> All utilities included<br /> <br /> <br /> Email David today for more info or to set up a tour!
MlsNumber: 7304896


Listing Provided By: Keller Knapp Inc, original listing
Name: Keller Knapp Inc
Phone: (678) 358-4321
Office Name: Keller Knapp
Office Phone: (404) 370-0092
Agent Name: David Holcombe
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.


Local Real Estate Expert

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 = 532 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;
Real Estate Expert Photo for Deena Simmons
Deena Simmons
ASCIIeXp Realty
Call Today!: (706) 333-1119

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App