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

7998 Giorgio Circle
Ooltewah, TN 37363

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,900,000
Beds: 6
Baths: 8
Status: Active
SqFt: 16150
Agency: Real Estate Partners Chatt, Ll

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Welcome to 7998 Giorgio Circle, one of Chattanooga's premier luxury estates. Perfectly situated on 4.28 +/- acres with year-round water in the highly sought-after golf community of Hampton on the Lake in Ooltewah, Tennessee. Hampton on the Lake is a gated community with lake access offering membership at The Ooltewah Club (https://theooltewahclub.com/) with golfing, restaurant, and pool. This exquisite property boasts over 16,000 +/- sq. ft. of custom-designed living space with six bedrooms, six and two half bathrooms, six-car garage and RV storage, workshop, and a separate living guest house/living quarter.<br /> As you approach this luxury estate, the expansive circular paver driveway sets the stage for the grandeur within and what awaits beyond the front door. Upon entering, you'll be captivated by the elaborate woodwork, superior craftsmanship, exquisite design, and rich materials used throughout this elegant home. A beautiful entry flows seamlessly into a sunken, spacious den with its rounded wall of windows and beam ceiling accent that is perfect for entertaining. Leading further into the home is the oversized living and dining area that boasts a fireplace and a wall of glass doors and windows to showcase the stunning and relaxing lake views. The gourmet and designer kitchen are an absolute work of art featuring a large island, Thermador double ovens, a Sub-Zero refrigerator/freezer, lien/China closet, and a 10x15 +/- walk-in pantry. The kitchen is completely open to the keeping room/leisure room with a wall of windows inviting you to take in the serene lake views, floor to ceiling mountain stone fireplace, beam ceiling accents, and a wall of cabinets and desk. Main level master suite with custom shelving in the oversized walk-in closet, along with office/nursery, private sunroom, and spiral staircase to the lower level. There is an additional bedroom with a private bath on the main level, along with an office/specialty room. A grand staircase and a second staircase led to the upper level, where you'll discover three to four additional bedrooms, including a second master suite. The circular conservatory leads you to the top of the striking copper domed tower, while the lower level offers an exercise room, full kitchen, den, office/bedroom, storage rooms, and multiple outdoor living spaces. An elevator provides effortless access to each of the three levels of the home. <br /> The separate guest house/living quarters offers additional accommodations complete with two bedrooms, one bath, den, and a full kitchen. The three-car garage and RV/boat bay is below the guest house/living quarters. In addition, there is a dog room, dog lot, workshop, and a full bath. <br /> Outside of your luxury home, you'll be delighted to find a private boathouse with two boat slips, two sea doo ports inside the boathouse, floating dock, and a gazebo on the water which is perfect for entertaining or simply enjoying the tranquility of the lake. Additional features include an outside waterfall and numerous outdoor living spaces surrounding the house to fully enjoy the beautiful surroundings.<br /> Experience the epitome of luxury living with an ideal location and in a sought-after luxury community at 7998 Giorgio in Ooltewah, Tennessee. It is truly a one-of-a-kind estate that offers the finest in lakeside living where every detail has been thoughtfully designed for the ultimate in comfort, elegance, and relaxation. <br /> The buyer is responsible to do their due diligence to verify that all information is correct, accurate, and for obtaining any and all restrictions for the property. The number of bedrooms listed above complies with local appraisal standards only.
MlsNumber: 20238058


Listing Provided By: Real Estate Partners Chatt, Ll, original listing
Name: Real Estate Partners Chatt, Ll
Phone: (423) 362-8333
Office Name: Real Estate Partners Chatt (Stein Dr)
Office Phone: (423) 362-8333
Agent Name: Paula McDaniel
Disclaimer: Copyright © 2024 River Counties Association of Realtors. 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 = 2459 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 Emily Wiersema
Emily Wiersema
ASCIIColdwell Banker Pryor Realty Inc
Call Today!: (423) 432-3578

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App