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

3208 Cates Avenue Ne
Brookhaven, GA 30319

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,375,000
Beds: 4
Baths: 6
Status: Active
SqFt: 4356
Agency: Engel & Völkers Sandy Springs

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 2022
Notes: This is a phenomenal opportunity to live in this spectacular new construction home built in 2022 in the heart of Lynwood Park. This 4 bedroom, 5 and a half bathroom home features a modern exterior design with clean lines and loads of character that you won't see anywhere else in Brookhaven. Once inside, you will fall in love with the amazing upgrades including 7-inch European hardwoods throughout, new designer lighting, Jeld-Wen casement windows, and custom accent walls. The main level has a large open floor plan with a seamless flow in between the family room, kitchen, and open dining area which all open up to a covered deck w/ a fireplace. All levels include new blinds with automated blinds in main living level and owner’s suite. The chef's kitchen features custom cabinets, a large island with seating, 6-burner stove top, a gorgeous custom wood range hood, stainless steel appliances, open shelving with dimensional tile backsplash, and beautiful countertops. The owner suite is located on the third level and features a stunning beam ceiling, spa-like bathroom with amazing tile details, and a huge custom walk-in closet. Terrace level Complete with an entertainment room, full bathroom, and plenty of storage. The oversized and extra tall 2-car garage with rear private entry off Antioch Drive. The newly landscaped, pavers and rear fence is beautiful and is the perfect complement to this gorgeous home. The Lynwood Park area is being completely redeveloped with an $11 million dollar park renovation including a swimming pool, tennis, basketball courts, and soccer fields. This incredible location is convenient to all the Hospitals and top-rated Schools.
MlsNumber: 7314841


Listing Provided By: Engel & Völkers Sandy Springs, original listing
Name: Engel & Völkers Sandy Springs
Phone: (404) 845-7724
Office Name: Engel & Völkers Sandy Springs
Office Phone: (404) 845-7724
Agent Name: Matt Lamarsh
Disclaimer: Copyright © 2024 Engel & Völkers. 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