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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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,150,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5200 Square Feet
Agency: Ansley Real Estate| Christie's International Real Estate
Agency Phone: (404) 480-8805

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2013
Notes: Experience the stunning fall colors and natural splendor of the season at this remarkable property! Located in the highly sought-after gated community of Waterside Estates, this home offers a rare opportunity to enjoy breathtaking lake and mountain views from every room. Nestled on a sprawling 2-acre lot, this 5-bedroom, 4 1/2-bathroom home is the perfect blend of luxury, privacy, and convenience. Comps value the lot alone at close to a million dollars with its unobstructed views of Lake Allatoona and Red Top Mountain State Park as your backyard playground with all the hiking, boating, kayaking, picnic, and public beaches. Only 5 minutes to downtown Cartersville museums, shops, restaurants and Publix grocery, close to Lake Point Sports Complex, 15 minutes to Governor's Towne Club and Spa for a round of Golf and 40 minutes to Atlanta International Airport with easy access to 175. Upon arrival, you'll be greeted by a porte cochere that leads to a three-car garage, adding both elegance and functionality. Inside, the master suite on the main level offers a serene retreat, while the open-concept design seamlessly connects the living areas. The gourmet kitchen is a chef's dream, featuring custom cabinetry, granite countertops, and top-of-the-line appliances, including a Bosch dishwasher, KitchenAid 6-burner double oven, and microwave drawer. A glass tile backsplash and custom hood vent add a modern touch, while the dining room's wainscoting and coffered ceiling make it perfect for formal gatherings. The home is filled with thoughtful details like hardwood floors, a vaulted den with wood beams, and a stone fireplace. For entertainment, the terrace level offers versatile spaces for a media room, bunk room, or remote work areas. A recently added suite with an upgraded bathroom boasts champagne gold fixtures for an extra touch of luxury. There is plenty of space to personalize as an entertainment area, additional bedrooms and en suite. Outside, the covered deck, complete with a stone fireplace, TV mount, and gas grill, offers the ultimate outdoor living experience. The upper and lower decks, recently stained and equipped with new screens for unobstructed views, are perfect for enjoying the beautiful surroundings. The expansive, buildable rear portion provides the perfect spot for a pool with a recent addition of "Belgium" Belgrade paver patios and firepit already built out, ideal for outdoor entertaining and relaxation to take in the magnificent views. A level front yard adds to the home's charm, creating a welcoming entrance for family and guests alike. Practical amenities include a central vacuum system, radon system, 250-gallon propane tank, and in-ground sprinkler system. The neighborhood also offers a pool, tennis courts, and a clubhouse, all within a secure gated community. This incredible property in Waterside Estates offers an unparalleled blend of luxury, comfort, and exclusivity. Schedule your private tour today to experience the true grandeur of this exceptional home.
MlsNumber: --
ListingId: 7476500


Listing Provided By: Ansley Real Estate| Christie's International Real Estate, original listing
Phone: (678) 570-0550
Office Phone: (404) 480-8805
Agent Name: Amy Mollohan
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. 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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Brian Norton
Brian Norton
ASCIIKey Real Estate Solutions
Call Today!: (678) 777-4923

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App