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

47 Fern Leaf
Newnan, GA 30265
Cindy Barnard with Keller Williams Realty Atl. Partners, original listing - (770) 632-1112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,150,000
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 10305 Square Feet
Agency: Keller Williams Realty Atl. Partners
Agency Phone: (770) 632-1112

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: This exquisite estate, located in the prestigious Arbor Springs community, is a masterpiece of luxury and comfort. The main level welcomes you with a grand two-story foyer that opens to a formal dining room with custom built-ins and a great room featuring a stone fireplace. Adjacent is a bright sunroom, also with a stone fireplace and stone floors, both providing access to a covered grilling deck and an additional open-air deck-perfect for entertaining. The chef's kitchen is a culinary dream, boasting a professional-grade gas stove, pot filler, large work island with bar seating, abundant cabinetry, and a spacious pantry. The inviting keeping room just off the kitchen features rustic beams and a fireplace, making it ideal for cozy gatherings. Also on the main level is a well-equipped laundry room with built-in cabinetry, a second refrigerator, washer and dryer, a utility sink, and upper and lower cabinets for extra storage. The expansive primary suite, located on the main level, is a luxurious retreat, complete with a cozy sitting area, a fireplace, custom closet system, and a spa-like ensuite with custom vanities, a soaking tub, and a spacious shower. Upstairs, a central hallway leads to three generously sized bedrooms, each with its own private bath. The upper level also includes a built-in computer desk with cabinetry and a light-filled bonus room. Additionally, there's a second bonus room over the three-car garage, along with finished and unfinished knee wall closets providing ample storage space. The terrace level is designed for entertainment and relaxation, offering a bright and spacious billiards room, complete with custom built-ins for displaying awards, books, or whatever you wish. A spiral staircase in the billiards room leads to a light-filled catwalk that overlooks the space, enhancing the open and airy feel. This level also features a full gym, a great room with a fireplace, and a home theater ready for your video equipment. A bar area and wine cellar are perfect for entertaining, and the level also includes a bedroom, full bath, and half bath. Additionally, there's an extra garage door area, ideal for storing recreational vehicles or equipment. Outside, a covered porch with a fireplace and second grilling station is perfect for outdoor dining and gatherings. The property's beautifully landscaped grounds offer a serene outdoor escape, featuring stone retaining walls, topiary trees, cedar light sculptures, and a perimeter lined with cedar trees and hardwoods. A full-size basketball court and a space that can be transformed into a fire pit area or children's playground further enhance the recreational possibilities. This estate is more than just a home-it's a harmonious blend of luxury and nature, all within the sought-after Arbor Springs community, which offers tennis, a pool, and proximity to Ashley Park Mall and Hartsfield Jackson airport . Located in the desirable Northgate school district, this home is a true gem.
MlsNumber: --
ListingId: 10383666


Listing Provided By: Keller Williams Realty Atl. Partners, original listing
Phone: (770) 632-1112
Office Phone: (770) 632-1112
Agent Name: Cindy Barnard
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.


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 = 428 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 Wendy Creel
Wendy Creel
ASCIISouthern Classic Realtors
Call Today!: (770) 658-4455

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App