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;

683 Tarpley Rd Nw
Kennesaw, GA 30152

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,300,000
Beds: 6
Baths: 8
Status: Pending
SqFt: 11740
Agency: Atlanta Communities Real Estate Brokerage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2004
Notes: ENTER A DREAM WORLD AT VILLA DE CIELO-WHICH MEANS HOME IN HEAVEN! THIS MAGNIFICENT CUSTOM BUILT TUSCAN INSPIRED GATED ESTATE HOME ON 21 ACRES OFFERS LUXURY & CLASSIC ELEGANCE AT ITS FINEST/ THIS ESTATE HAS BEEN FEATURED IN MANY MAGAZINES AS ONE OF THE TOP ATLANTA HOMES, AS WELL AS IN MANY FEATURE FILMS & TV PRODUCTIONS/ IT IS A TRUE ITALIAN ESTATE AS ORIGINAL OWNERS FLEW IN ARTISANS FROM ALL OVER THE WORLD TO COMPLETE THE HAND PAINTED FRESCOS/BURLED WALNUT SITE FINISHED CABINETRY/HAND CARVED MAHOGANY DOORS FROM EUROPEAN CASTLES/SOLID CHIPPED LIMESTONE EXTERIOR/FLASH FIRED CLAY ROOF/18TH CENTURY HAND HEWN BEAMS FROM THE SAVANNAH RIVER/ALL PERIOD LIGHTING & CHANDELIERS/HOME IS ON PUBLIC WATER BUT HAS AN AMAZING ARTESIAN WELL THAT SERVICES IRRIGATION TO THE PROPERTY & CAN BE USED IN THE HOME/CURRENT OWNERS HAVE RENOVATED HOME TO INCLUDE 48 KW WHOLE HOME GENERATOR/ALL NEW INSULATED ANDERSON WINDOWS/RENOVATED POOL/SPA/PEBBLETEC & EQUIPMENT/ADDED FABULOUS TREX DECK SYSTEM OVERLOOKING ADJACENT LAKE & LAND/NEW HVAC SYSTEMS/WATER HEATERS/NEW LANDSCAPE LIGHTING TO THE STREET & TOTAL BACKYARD & GARDENS/ADDED LARGE CATERING PANTRY/2ND LAUNDRY UPSTAIRS INCL. ADDITIONAL CLOSET SYSTEMS/NEW FLOORING IN BEDROOMS & TERRACE LEVEL/NEW KITCHEN APPLIANCES/NEW UPGRADED HOME THEATER SYSTEM/GORGEOUS OVER SIZED BAR IN TERRACE LEVEL W/GLASS FRONT WINE CELLAR/COOLER/ENJOY HEATED BATH FLOORING THRUOUT/ADDED GORGEOUS FULL POOL BATH ADJACENT TO NEW PORCELAIN TILED CABANA-THERE IS SO MUCH TO SEE HERE AT VILLA DE CIELO! THE GROUNDS & VIEWS ARE AMAZING/ YOU DO HAVE THE ABILITY TO BUILD ADDITIONAL HOMES ON THE LEFT SIDE OF THE PROPERTY/ HORSES CAN BE HERE TOO! RECENTLY DONE ASPHALT DRIVEWAY CAN ACCOMMODATE 2 CARS GOING SIDE BY SIDE! THIS HOME HAS ITS OWN FIRE HYDRANT TOO! ENERGY EFFICIENT- THE PLASTER WALLS ARE SO THICK IT HOLDS THE HEAT OR COOL AIR AMAZINGLY! YOU MUST SEE THIS ELEGANT ESTATE TO BELIEVE IT! https://shorturl.at/efrs6
MlsNumber: 7376293


Listing Provided By: Atlanta Communities Real Estate Brokerage, original listing
Name: Atlanta Communities Real Estate Brokerage
Phone: (770) 240-2001
Office Name: Atlanta Communities
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

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;
Nan Hayes
ASCIICentury 21 Connect Realty
Call Today!: (404) 918-5389

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App