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

1331 Se Diamond Avenue
Atlanta, GA 30316

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $785,000
Beds: 5
Baths: 4
Status: Active
SqFt: --
Agency: Keller Williams Realty Atlanta Partners Perimeter

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Welcome to an embodiment of opulent living in a highly sought-after Atlanta neighborhood. This exquisite modern farmhouse-style residence features 5 bedrooms and 3.5 bathrooms, exuding luxury at every corner. As you enter, you'll be greeted by soaring ceilings and an open-concept living space designed for seamless entertaining. The spacious kitchen is a culinary enthusiast's delight, with a generously sized island providing ample space for meal preparation and casual dining. The reflective backsplash adds a touch of elegance and sophistication, while the spacious pathways ensure easy movement throughout the kitchen and dining areas. The master bedroom offers a serene retreat, featuring a spacious walk-in shower with seating and double vanities that provide ample space for your morning routine. The freestanding tub, set against a stylish backdrop, invites relaxation, complemented by contemporary design elements that exude refinement and style. Each of the 5 bedrooms has been thoughtfully designed for maximum comfort and rest, bathed in natural light and adorned with modern finishes. The bathrooms are equally impressive, with sleek fixtures and finishes that seamlessly blend modernity with practicality. The expansive backyard is an ideal space for outdoor gatherings and entertainment, offering ample room for a pool or garden. Enjoy the sunshine and fresh air on the spacious decks both in the front and rear of the residence, where you can unwind while taking in scenic views. This home is a true haven for hosting, with a seamless indoor-outdoor flow and generous living spaces that are perfect for showcasing architectural and design excellence. Don't miss the opportunity to make it your own and experience the pinnacle of luxury living in Atlanta's prime location.
MlsNumber: 10269777


Listing Provided By: Keller Williams Realty Atlanta Partners Perimeter, original listing
Name: Keller Williams Realty Atlanta Partners Perimeter
Phone: (678) 252-1900
Office Name: Keller Williams Realty Atl. Partners
Office Phone: (678) 252-1900
Agent Name: Kereen Henry
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. 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