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

200 Spike Trail
Smyrna, GA 30080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $639,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2437
Agency: Harry Norman, REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Absolutely the best opportunity for luxury townhome living in Smyrna! This light filled end unit is practically brand new. Immaculate condition with numerous upgrades and features. Front entry opens into a light filled stairway from an abundance of windows. The living room area is open to the entry and boasts a beautiful gas fireplace flanked by custom built-in bookcases and storage cabinetry. The floor to ceiling windows floods the home with light and a center double door opens to a Juliette balcony to allow for fresh air during pretty days! The open concept of the main living floor flows seamlessly. Gourmet cooks kitchen offer a huge center island perfect for gathering around and entertaining. Beautiful custom cabinetry with quartz countertops, GALLERY Stainless Steel appliance package including a 5-Burner gas range, dishwasher, Vent-hood,, and Refrigerator /Freezer are included. Custom tiled backsplash and designer hardware, lighting and fixtures complete the dream! There is a dining area with custom built-in cabinetry with quartz countertop for additional storage of kitchen appliances etc. The large keeping room offers flex space as a den or study. There is also an additional room off the kitchen that could serve as a sunroom, office, or study that opens out to a large deck (recently stained and sealed) that overlooks the rear of the community! Upstairs you will find the large owners suite with a large walk-in closet. There is a sitting room/study just off the bedroom area as well. The Owners bath has a large walk-in shower with framed glass enclosure, a private water closet, and double vanities with custom cabinetry and stone countertops. There is a hall laundry room that offers storage options as well. Two secondary bedrooms offer double closets for great storage. A full tub/shower hall bath services these two bedrooms. The terrace level is perfect with great light and access to a privacy fenced and gated backyard area. The basement area offers the ability to close off from main living areas from the main living area to make it the perfect rental space. There is a living room/media room space and an additional large bedroom with closet. A full tub/shower bath with designer tile and fixtures & finishes. The terrace level would work nicely for an in-law or for weekend guest. The two-car garage with auto doors is generous and offers a storage closet. The home is sunny and bright! All the windows have custom blinds, beautiful EVP flooring w/ Oak Wood stairs, Trim details, fresh carpeting is light and neutral, RING Doorbell/Security systems with motion detectors, fire sprinkler system, freshly painted, and barely lived in! Groomed community with dog park! The Lennar Limited Warranty transfers with the home, there is a limited 2 year warranty on systems and a limited 10-year warranty on structural elements. Minutes to shopping and interstate access, THE BRAVES at Truist Park / The Battery is less than ,5 mile! This home is a homerun!
MlsNumber: 7343591


Listing Provided By: Harry Norman, REALTORS, original listing
Name: Harry Norman, REALTORS
Phone: (404) 897-5558
Office Name: Harry Norman REALTORS
Office Phone: (404) 897-5558
Agent Name: Andy Philhower
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 = 96 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;
Real Estate Expert Photo for Neil Blindauer
Neil Blindauer
ASCIIOak Realty
Mobile: (480) 797-1824

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App