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

3816 Turnberry Court
Duluth, GA 30096
Jenifer Cusick with Alpharetta / North Fulton Office, original listing - (770) 475-0505

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,775,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 9100 Square Feet
Agency: Alpharetta / North Fulton Office
Agency Phone: (770) 475-0505

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13,504 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Welcome to a truly extraordinary home! Nestled in the sought-after neighborhood of Sweet Bottom Plantation along the banks of the Chattahoochee River, in Duluth, GA, this property is unlike any other. Beautifully renovated & meticulously maintained, this 6 Bedroom, 5 1/2 Bathroom, southern-style residence seamlessly blends Greek Revival architecture with modern amenities, offering a captivating yet comfortable lifestyle. Step inside to discover an open floor plan with 12' ceilings that seamlessly integrates a chef's kitchen with an exceptional butler's pantry, family room and sunroom. A full home renovation in 2014, included a 2-story addition of a sunroom and second owner's suite closet and dressing area. The sunroom bathes the space in natural light, offering serene views of the private backyard adjoining wooded conservation land and the family room is centered around a fireplace with hand cut stone. The kitchen renovation included custom cabinetry, an expansive island with storage, high end appliances including a double convection oven, 6 burner gas cooktop with griddle, 2 dishwashers, full standing freezer and more. The banquet sized dining room, perfect for entertaining, is across from the two-story living room with a masonry fireplace. The spacious rooftop deck provides a tranquil escape, featuring a seating area, dining space, and a hot tub, making it an excellent location for both relaxation and entertainment. The owner's retreat includes a private upper porch, morning kitchen, luxurious bath with custom vanities and Carrera marble countertops, and two oversized walk-in closets. Every room in this home is generously proportioned, boasting ample closet space and organized storage areas throughout. The second level features the owner's suite, library open to the living room below, laundry room and guest suite. The third level offers 3 bedrooms and 2 bathrooms with gorgeous site-finished hardwood floors installed in March 2025. Additionally, a nanny suite with bathroom ready to customize offers versatility and could serve as a second owner's suite on the third level. The two-tier basement is an entertainer's dream, complete with a full bar, pool room, game area, media space, and a full bath. Additionally, a full unfinished apartment over the 3-car garage provides endless possibilities. Situated in a cul-de-sac, the front porches offer picturesque views of the park-like common area, while the backyard is a private paradise. With inspiration from the Victorian Shipley-Lydecker House in Shipley Hill, MD, the home was designed to resemble the architecture of Disneyland's Haunted Mansion. Historical features include upper and lower level front porches with elaborate cast iron railings, a center staircase designed to enhance vertical air circulation and a bird cage style elevator shaft to accommodate a future elevator if desired. Residents of gated Sweet Bottom Plantation enjoy access to a clubhouse, pool, tennis courts, pickleball court and playground, as well as walking paths throughout the community. Showings begin on Saturday, March 22nd!
MlsNumber: --
ListingId: 10482774


Listing Provided By: Alpharetta / North Fulton Office, original listing
Phone: (404) 932-4962
Office Phone: (770) 475-0505
Agent Name: Jenifer Cusick
Disclaimer: Copyright © 2025 Berkshire Hathaway HomeServices Georgia Properties. 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 = 3284 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 Lakia Mack
Lakia Mack
ASCIILOKATION REAL ESTATE
Call Today!: (470) 948-5545

Local Mortgage Pro

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 = 3284 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;
Real Estate Expert Photo for Tim Arrington NMLS#717914
Tim Arrington NMLS#717914
ASCIIMortgage Core
Call Today!: (770) 856-6397

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App