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 = 398 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 = 398 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 = 398 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 Waterside Drive Se
Cartersville, GA 30121

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,300,000
Beds: 5
Baths: 5
Status: Active
SqFt: 5200
Agency: Atlanta Communities Real Estate Brokerage, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2013
Notes: Introducing an exceptional residence nestled within the prestigious gated community of Waterside Estates, this home stands out as a true marvel. Revel in awe-inspiring views of the lake and mountains from every room, creating a serene haven that combines seclusion with convenience. Positioned on a sprawling 2-acre lot, this luxurious home boasts a level front yard and a fully buildable rear section, distinguishing it from others. Featuring 5 bedrooms and 4 bathrooms, this open-concept dwelling is tailor-made for families of all sizes. Upon arrival, a porte-cochre leads to a three-car garage, enhancing both the elegance and functionality of the home. The main level hosts a master suite, providing a sanctuary for rest and relaxation. The centerpiece of this residence is its meticulously designed kitchen, complete with custom cabinets, granite countertops, and top-of-the-line appliances such as a Bosch dishwasher, KitchenAid 6-burner double oven, and KitchenAid microwave drawer. The dining room is a masterpiece of millwork, featuring wainscoting and a coffered ceiling, perfect for hosting formal gatherings. Gleaming hardwood floors grace the main level, stairs, and lower entertainment areas, creating an inviting atmosphere. An Onkyo home sound system elevates the whole-home audio experience, while an ACS-home security system offers peace of mind. A wine bar with a light system adds a touch of luxury, and custom closet systems throughout optimize storage. The vaulted den boasts wood beams and a stone fireplace, complemented by custom cabinetry with downlights. The main level bedroom serves as an ideal space for guests or a home office. The terrace level provides endless possibilities, from an entertainment room to a bunk room and flexible workspaces for remote work or play. A recently added suite with an upgraded bathroom features champagne gold faucets and fixtures, ensuring both comfort and style. Meticulously maintained, this home showcases a covered deck with a stone fireplace, outdoor TV mount, and a gas grill Co an ideal setup for alfresco dining and relaxation. Recent enhancements, including stained upper and lower decks, front door, and columns, enhance its curb appeal. Practical features include abundant storage, a central vacuum system, radon mediation system, and a 250-gallon propane tank for the stove, fireplaces, and grill. Two 50-gallon electric hot water heaters and HVAC ionizers with UV lights contribute to comfort and efficiency. An in-ground sprinkler system maintains the lush landscape. The neighborhood amenities, including a pool, tennis courts, and a clubhouse, add to the allure of this gated community. Seize the opportunity to make this splendid lake and mountain view home your own, complete with top-rated schools and a perfect blend of luxury and functionality in Waterside Estates. This is the perfect location just minutes from: I-75, Park Marina and Allatoona Landing for boating, miles of hiking trails, Lakepoint Sports Complex and Wakeboarding and more. It doesn't seem possible that you can find all this and only be about 45 minutes from Atlanta. Schedule your private tour to experience the grandeur firsthand.
MlsNumber: 10247152


Listing Provided By: Atlanta Communities Real Estate Brokerage, LLC, original listing
Name: Atlanta Communities Real Estate Brokerage, LLC
Phone: (770) 240-2000
Office Name: Atlanta Communities
Office Phone: (770) 240-2004
Agent Name: Heather Bontrager
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 = 398 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;
CHERYL ILER
ASCIIAtlanta Communities Real Estate Brokerage
Call Today!: (770) 842-3082

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App