Title Page Background
DEBUG FN args: Array ( [0] => 3282 [1] => [2] => [3] => agent ) BEFORE: Site: 3282 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3282 Igate: njhud LocID: 3282 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3282 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3282 [1] => [2] => [3] => lender ) BEFORE: Site: 3282 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3282 Igate: njhud LocID: 3282 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3282 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3282 [1] => [2] => [3] => other ) BEFORE: Site: 3282 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3282 Igate: njhud LocID: 3282 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3282 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1358 Wynbrook Trace
Smyrna, GA 30126

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,434,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 8755 Square Feet
Agency: Ansley Real Estate| Christie's International Real Estate
Agency Phone: (770) 284-9900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Stunning in every way, this custom-built estate home is an entertainer's dream with a pool, spa, full sport court with professional lighting, and a five-hole putting green complete with three chipping pads! Located in the exclusive Manor section of popular Vinings Estates, this home has easy access to a groomed trail leading to Whitefield Academy. In addition, the incredible lot is perfectly landscaped and completely level for ease of use. The interior of the home is gorgeous with professional interior design throughout with high-end finishes and renovations that are magazine level perfection! As you walk through the grand entrance the dining room is on your right and the large formal living room is to your left - perfect setting for the piano player, pre-dinner cocktails, or an office. Down the hall is a powder room to the left and through the left hallway is an oversized bedroom that can be used as a second primary bedroom due to its size. Light and bright, this bedroom opens up to the upper deck overlooking the pool and has an ensuite full bath. In the center of the main floor is the living room that opens up to the Chef's kitchen that has a separate dining area, a large white marble island with additional seating and high-end stainless-steel appliances. Access to the upper deck/grilling area is just off the kitchen and adjacent to the cozy keeping room with a stacked stone fireplace and custom bookshelves. The upper floor has the primary bedroom and three additional oversized bedrooms that all have their own bathrooms. The primary bedroom suite is over the top luxury with its own sitting area, fireplace, and separate office space. The bedroom was renovated with an elegant tray ceiling layered with wood and a TV that comes down from the ceiling with the click of a button! The primary spa-like bathroom is also a superstar with marble throughout, steam shower, his and her water closets and massive custom walk-in closets. Last but not least is the terrace level that is perfect for family or school gatherings. There is a kitchen area for serving food and drinks, a media area, game room, billiards, a home gym and plenty of seating for fun times and conversation. Just outside is everything you could ever want to experience outdoors - grilling, dining, watching tv, the sleek pool and spa, sport court, trampoline, glass fire pit and for the golf enthusiast, a putting green complete with chipping pads! The golf and trampoline area of the property are on an additional lot the owner purchased separately. So much to see in this gorgeous home, but what you don't see that's fantastic- a whole house generator, plenty of storage, doggie room with access to the fully fenced backyard, 2 laundry rooms, a panic room compete with an escape hatch and wide staircases throughout. Located close to Vinings, the airport, Buckhead, the Battery/Braves stadium, come see all that this massive estate offers!
MlsNumber: --
ListingId: 7459506


Listing Provided By: Ansley Real Estate| Christie's International Real Estate, original listing
Phone: (678) 602-8620
Office Phone: (770) 284-9900
Agent Name: Ali Van Dillen
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cobb-southeast [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cobb-southeast State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cobb-southeast State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3282 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
CINDY A.S HADDON
ASCIIeXp Realty
Call Today!: (678) 348-0528

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App