Title Page Background
DEBUG FN args: Array ( [0] => 3410 [1] => [2] => [3] => agent ) BEFORE: Site: 3410 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3410 Igate: njhud LocID: 3410 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 = 3410 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3410 [1] => [2] => [3] => lender ) BEFORE: Site: 3410 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3410 Igate: njhud LocID: 3410 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 = 3410 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3410 [1] => [2] => [3] => other ) BEFORE: Site: 3410 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3410 Igate: njhud LocID: 3410 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 = 3410 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2003 Burnt Hickory Road
Marietta, GA 30064

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,295,000
Beds: 5
Baths:
Status: Active
SqFt: 7294 Square Feet
Agency: Atlanta Communities

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: STEP INTO A WORLD OF PRIVACY AND BEAUTIFUL VIEWS IN THIS ELEGANT GATED ENCLAVE OF ONLY 4 ESTATE HOMES/ENJOY BEING CLOSE TO KENNESAW MTN PARK/MT PARAN PRIVATE SCHOOL/MARIETTA COUNTRY CLUB/MARIETTA SQUARE YET FEEL LIKE YOU ARE IN THE COUNTRY W/6 ACRES IN FRONT OF THE ENCLAVE & THIS ELEGANT & IMMACULATE CUSTOM BUILT ESTATE HOME IS ADJACENT & ALSO ENJOYS ITS OWN 2 ACRES AS WELL AS VIEWS THE PASTORAL SETTING ADJACENT/DESIGNED BY RENOWNED ARCHITECT ROGER CALDWELL-THIS DUAL LIGHTED LANTERN STACKED STONE COLUMNED DRIVEWAY ENTRY TO THE HOME HAS A BEAUTIFUL FLAGSTONE WALKWAY & COVERED FRONT PORCH ENTRY & LARGE MOTOR COURT/ADD'L PARKING PADS FOR GUESTS TOO/THE CURVED DUAL SOLID MAHOGANY ENTRY DOORS STAND OUT AS YOU ENTER THE MAIN FOYER W/NEWLY FINISHED SOLID OAK FLOORING THROUGHOUT MAIN FLOOR/LARGE OPEN FLOOR PLAN GREAT FOR ENTERTAINING FAMILY & FRIENDS/AMAZING DINING ROOM OPENS UP TO THE FRONT PORCH-SO MUCH NATURAL LIGHT THRU-OUT THIS HOME/THE OVER SIZED GREAT RM VIEWS THE STUNNING PASTORAL SETTING & ELEGANT POOL/SPA SETTING/STACKED STONE FIREPLACE IS FLANKED WITH BOOKCASES/STUNNING CEDAR BEAMS & COLUMNS ACCENT THIS SOPHISTICATED GREAT RM THAT OPENS TO THE WONDERFUL KITCHEN INCL. LARGE BAR AREA FOR ENTERTAINING/WORK ISLAND W/ ADD'L SINK/IMPRESSIVE SOLID WALNUT CABINETRY W/TONS OF STORAGE/INCREDIBLE AMOUNT OF QUARTZ COUNTER TOPS FOR PREP WORK/ SIX BURNER GAS STOVE/LARGE SIDE BY SIDE REFRIGERATOR & ALL OPENS TO A LIGHT FILLED CASUAL DINING AREA WHERE YOU CAN STEP RIGHT OUTSIDE TO THE OVER SIZED TREX DECK THAT STEPS DOWN TO THE GORGEOUS POOL/SPA SETTING WITH PLENTY OF LAND FOR THE CHILDREN TO ENJOY! STUDY IS ON MAIN FLOOR W/ BUILT IN SHELVES/LARGE LAUNDRY RM/MUD RM/PANTRY/& CONVENIENT LAUNDRY CHUTE THERE TOO/OVER SIZED 3 CAR GARAGE W/ PRIVATE ARCHED ENTRY ADJACENT/AREA ALSO LEADS TO THE POOL FOR THOSE WHO PARK IN THE LARGE MOTOR COURT BY GARAGES/ OWNER'S SUITE ON MAIN HAS STUNNING VIEWS ACROSS THE BACK INCLUDING BALCONY WHERE YOU CAN ENJOY THE POOL & PASTORAL VIEWS/TRAVERTINE FLOORED OWNER'S SPA HAS SEAMLESS GLASS SHOWER/SOAKING TUB W/PASTORAL VIEWS TOO/LARGE DUAL QUARTZ VANITIES & HIS-HERS CUSTOM CLOSET/SOLID OAK LARGE STEPS W/WROUGHT IRON RAILING LEAD YOU TO 3 OVER SIZED BEDROOMS W/EACH HAVING OWN BATH- ONE HAS LARGE STUDY NICHE/FLOORED STORAGE IS UPSTAIRS TOO/OPEN STAIR ENTRY FROM GREAT RM CONVENIENTLY LEADS YOU TO AN ELEGANT LARGE GUEST SUITE W/FULL BATH & OPENS TO THE POOL/PATIO AREAS/A SHOW STOPPING WALNUT BAR & STACKED STONE FIRESIDE GAME & GREAT ROOM W/CASUAL DINING TOO/SECOND OFFICE HERE & EXERCISE RM W/SAUNA/ CONVENIENT ADD'L BATH ADJACENT TO POOL/COVERED PATIO AREA TOO/STEP TO AN AMAZING COVERED ENTERTAINMENT AREA & OVER SIZED POOL PATIO W/FLAGSTONE COPING/WATERFALL SPA/DIVING BOARD/FABULOUS FUN YARD AREA & GORGEOUS BREATHTAKING PASTORAL VIEWS-WHAT A WONDERFUL ENTERTAINMENT AREA & PRIVATE TOO/LIKE NEW ROOF SYSTEM/IRRIGATION THRU-OUT/ELEGANT LANDSCAPE LIGHTING/SO CLOSE TO ENJOY THE MARIETTA COUNTRY CLUB FOR FAMILY ENTERTAINMENT & 27 CHAMPIONSHIP HOLES FOR GOLF/OLYMPIC SIZE POOL & FIRESIDE BAR PAVILION/12 LIGHTED TENNIS & NEW PICKLE BALL COURTS/EXERCISE FACILITY/GORGEOUS CLUBHOUSE W/2 WONDERFUL RESTAURANTS/OVER SIZED SPORTS BAR ALL FACING KENNESAW MOUNTAIN WHICH IS CLOSE BY W/OVER 3000 ACRES OF WALKING TRAILS/AWARD WINNING MT PARAN PRIVATE SCHOOL CLOSE BY/WALKER PRIVATE SCHOOL & FUN SHOPPING & RESTAURANTS AT THE NEARBY MARIETTA SQUARE TOO!
MlsNumber: --


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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cobb-southwest [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cobb-southwest State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cobb-southwest 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 = 3410 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Leo King
Leo King
ASCIIRE/MAX Premier
Call Today!: (404) 384-9048

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App