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

2330 Tayside Crossing Nw
Kennesaw, GA 30152
Jill B Harris with Keller Williams Realty Atl North, original listing - (770) 509-0700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,999
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 8020 Square Feet
Agency: Keller Williams Realty Atl North
Agency Phone: (770) 509-0700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Introducing a spectacular 2017-built golf course home, meticulously upgraded and renovated for modern luxury living. This stunning residence offers unparalleled outdoor and indoor spaces, perfect for both relaxation and entertaining.<br /> The expansive outdoor areas feature a charming rocking-chair front porch, a covered patio, and a screened-in back porch with electronically controlled screens. The meticulously landscaped front and back yards surround a breathtaking Pebbletec pool with mother-of-pearl accents and self-cleaning saltwater system, complemented by an infinity-edge spa, arching luminaires, copper fire bowls, tiki lights, and a sunbathing shelf—all set against gorgeous travertine decking and a cozy fire pit.<br /> For indoor entertainment, the finished basement is an entertainer’s dream, featuring a cozy fireplace, custom bar, pool table room, workout space, and a dedicated home theater with Sony 4K projector, Paradigm speakers, and luxurious leather reclining chairs with cup holders and lights.<br /> The gourmet kitchen is designed for culinary enthusiasts with a massive quartz island, updated lighting, and a 48" Viking built-in refrigerator. The inviting breakfast room includes one of the home’s three fireplaces. The spacious family room boasts 10' coffered ceilings, creating a grand and open atmosphere. The luxurious primary suite is conveniently located on the main level and includes direct access to the porch, while the spa-like primary bath features a double vanity, separate makeup counter, and both a tub and shower. Every closet has been custom designed by Creative Closets, offering unparalleled organization and storage, including extensive cabinetry in the garages.<br /> Additional features include a whole-house Aquasana water filtration system, UV light air purifiers on all three HVACs, a leak defense system with app control, landscape lighting, and epoxy-coated garage floors.<br /> Enjoy easy access to the Marietta Country Club via a neighborhood golf cart tunnel under Stilesboro Rd. Located less than a mile from Mt. Paran Christian School, and only 5 miles to the scenic Kennesaw Mountain hiking trails, this home offers the perfect balance of serenity and convenience. Dining, entertainment, and breweries at Marietta Square are just 7 miles away.<br /> <br /> This is more than just a home—it’s a lifestyle. Don't miss your opportunity to make it yours!
MlsNumber: --
ListingId: 7507325


Listing Provided By: Keller Williams Realty Atl North, original listing
Phone: (770) 509-0700
Office Phone: (770) 509-0700
Agent Name: Jill B Harris
Disclaimer: Copyright © 2025 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 = 3411 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;
Cindy Moran
ASCIIFathom Realty
Call Today!: (678) 492-7988

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App