Title Page Background
DEBUG FN args: Array ( [0] => 3411 [1] => [2] => [3] => agent ) BEFORE: Site: 3411 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3411 Igate: njhud LocID: 3411 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3411 [1] => [2] => [3] => lender ) BEFORE: Site: 3411 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3411 Igate: njhud LocID: 3411 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3411 [1] => [2] => [3] => other ) BEFORE: Site: 3411 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3411 Igate: njhud LocID: 3411 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2305 Whiting Bay Courts
Kennesaw, GA 30152
Diane Tatum with Atlanta Communities, original listing - (770) 240-2004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,400,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 7413 Square Feet
Agency: Atlanta Communities
Agency Phone: (770) 240-2004

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: IF YOU IMAGINE YOURSELF LIVING IN A RESORT WITH TIMELESS LUXURY AND SOPHISTICATED ELEGANCE, THIS IS YOUR NEXT DREAM HOME! SUPERIOR CRAFTSMANSHIP AND ARCHITECTURAL EXCELLENCE -ALL DESIGNED BY BEVERLY BARIBAULT DESIGN GROUP & MARK WHITLOCK/EVERY DETAIL OF THIS TOTALLY RENOVATED ESTATE HOME EXUDES STYLE & THOUGHTFUL PLANNING! UNIQUE TO THIS AREA, THIS HOME HAS A GORGEOUS WALK OUT MAIN FLOOR POOL/SPA/FIRESIDE CABANA/GOLF COURSE AND LAKE VIEWS SETTING ALL ENJOYED FROM MANY STUNNING AREAS INCLUDING PANORAMA OVER SIZED GLASS DOORS TO THE BEAUTIFUL VAULTED FLAGSTONE LANAI-PERFECT TO ENJOY AL FRESCO DINING WITH FAMILY & FRIENDS/2025 NEW ROOF SYSTEM/NEW OR RECENTLY INSTALLED HVAC SYSTEMS/ALL NEW EXTERIOR & INTERIOR PAINT/THE STUNNING ENTRY OPENS TO LARGE ENTERTAINMENT AREAS FULL OF NATURAL LIGHT & WITH GORGEOUS CUSTOM LIGHTING/ELEGANT MILL WORK/ART NICHES/SOPHISTICATED UNIQUE TILED WALL WET BAR AREA ADJACENT W/SUBZERO WINE COOLER & GORGEOUS CABINETRY/FIRESIDE GRAND ROOM W/LIMESTONE FIREPLACE/COLUMNED FORMAL DINING/IMPECCABLE CUSTOM CABINETRY THROUGHOUT INCL. WHITE OAK CUSTOM CABINETRY WITH GORGEOUS INSET ETCHED OPAQUE GLASS DETAILS IN THE OPEN KITCHEN TO CEDAR BEAMED FLOOR TO CEILING STACKED STONE OVER SIZED FIREPLACE W/CUSTOM LIT FLANKING SHELVING/SIDE BY SIDE SUBZERO/WOLF 48" PRO RANGE W/GRIDDLE & DOUBLE OVENS/GIRABALDI LIMESTONE CUSTOM BUILT HOOD/LARGE QUARTZITE COUNTER TOP WORK AREAS & OGEE FINISH QUARTZITE ISLAND W/CABINETRY & BAR/DUAL CUSTOM CABINETS MIRROR THE SUBZERO CABINETRY & ARE PANTRY AREAS/CASUAL DINING AREA ALL OVERLOOK THE FABULOUS GOLF COURSE & LAKE VIEWS & POOL/SPA VIEWS/FLAGSTONE PATIO AREAS LEAD TO THE STACKED STONE FIRESIDE POOL CABANA W/CUSTOM LIGHTING & OUTDOOR KITCHEN AREA W/BLAZE BBQ & UNDER COUNTER REFRIGERATOR/STONE TOP BAR/POOL & SPA ALL NEW PEBBLETEC/NEW POOL EQUIPMENT/NEW CABANA ROOF/ELEGANT BACK YARD W/PLENTY OF ROOM FOR CHILDREN TO PLAY INCL. STEPS TO A WONDERFUL BASKETBALL COURT/ ELEGANT FLOOR TO CEILING CUSTOM TILED FIRESIDE STUDY NEAR WET BAR AREA/STUNNING OWNER'S SUITE FACING GOLF-POOL-LAKE VIEWS W/PRIVATE ENTRY TO COVERED LANAI & POOL AREAS/SPA LIKE BATH W/MARBLE HEATED FLOOR SYSTEM/REMOTE CONTROL SHADE OVER SOAKING TUB/EXPANSIVE DOUBLE VANITY AREA W/MARBLE COUNTER TOPS/CUSTOM CABINETRY/HUGE WALK IN CUSTOM CLOSET W/SHOE CLOSET & CENTER ISLAND CABINETRY/LAUNDRY ROOM W/ QUARTZITE COUNTERS/SINK/CABINETRY/ WONDERFUL MUD ROOM AREA W/CUSTOM CABINETRY/NEW EPOXY FLOORED GARAGES W/EV CHARGERS/STORAGE CABINETRY/ UPSTAIRS HAS ELEGANT BEDROOM SUITES EACH WITH UNIQUE MARBLE OR QUARTZITE TILE DESIGNS/SEAMLESS GLASS SHOWERS/TUB IN ONE BATH/CUSTOM CLOSETS IN ALL BEDROOMS/LARGE RETREAT ROOM W/BUILT IN BAR/REFRIGERATOR/VIEWS OF THE GOLF COURSE HERE TOO/ TERRACE LEVEL IS RESORT STYLE ENTERTAINING W/GORGEOUS CUSTOM GLASS ENTRY WINE CELLAR/SUBZERO WINE FRIDGE/SPORTS BAR W/LEATHERED GRANITE COUNTER TOPS & ETCHED MIRROR BACK AREA/SUBZERO WINE COOLER/SCOTSMAN ICE MAKER/MIELE DISHWASHER/COVE CUSTOM SEATING AREA ADJACENT TO BILLIARDS ROOM/EXERCISE ROOM W/MATTING/AMAZING GOLF SIMULATOR W/TRU-FLIGHT 2 TRACKING SYSTEM-PUTTING GREEN/CAN BE HOME THEATER/GUEST BEDROOM W/LARGE CUSTOM CLOSET/BEAUTIFUL SEAMLESS GLASS QUARTZITE TILED SHOWER BATH/ALL NEW ELECTRICAL PANELS INSTALLED/ALL NEW LANDSCAPE LIGHTING-FRONT GABLED AREAS/SONOS SOUND SYSTEM W/12 INTERIOR & 3 EXTERIOR ZONES/ART LIGHTING THRU-OUT/REMOTE CONTROLLED SHADES/ALL HARDWOODS REFINISHED-EURO WAX COATING/ALL NEW TOTO TOILETS/POLISHED NICKEL HARDWARE/ALL NEW INSULATED GARAGE DOORS/MOTORS-(2)50 AMP OUTLETS FOR EV CHARGING/ADDITIONAL TANDEM 2 CAR PARKING PAD WITH NEW LARGE MOTOR COURT/ALL ON A BEAUTIFUL PRIVATE CUL-DE-SAC/OVERLOOK AT MARIETTA COUNTRY CLUB ALSO HAS LARGE POOL/HUGE CHILDREN'S SLIDE/TENNIS COURTS/PLAYGROUND/LARGE CLUBHOUSE & COVERED AREAS FOR ENTERTAINING/ALL ACROSS THE STREET FROM THE AWARD WINNING MT. PARAN PRIVATE SCHOOL/ JOIN THE MARIETTA COUNTRY CLUB AND PLAY 27 HOLES OF CHAMPIONSHIP GOLF/12 LIGHTED TENNIS COURTS/PICKLEBALL COURTS/FABULOUS POOL/PAVILION TOO!
MlsNumber: --
ListingId: 7554987


Listing Provided By: Atlanta Communities, original listing
Phone: (678) 640-4758
Office Phone: (770) 240-2004
Agent Name: Diane Tatum
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cobb-northwest [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cobb-northwest State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cobb-northwest State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Renita Gwyn
Renita Gwyn
ASCIIColdwell Banker - Marietta
Call Today!: (404) 819-7004

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App