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;

8024 Hampton Cove Dr
Ooltewah, TN 37363

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $874,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3791
Agency: Keller Williams Realty Greater Downtown

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2014
Notes: This stunning, 5 bedroom, 3 full and 2 half bath home offers a fantastic opportunity to the discerning buyer seeking a well-maintained home in the Hampton Cove gated community in the heart of Ooltewah. The home exudes curb appeal with its mostly brick exterior that is accented by both Hardie shingles and stone and a pleasing front elevation and lush landscaping. The quality interior finishes and the versatile floor plan are equally pleasing, and you will love the beautiful hardwoods and tile throughout, the crown moldings, specialty ceilings, open living concept, the bonus rooms, and the fact that there are 4 bedrooms on the main level, including the primary suite. You will also appreciate the recent improvements, including the new lighting, new closets systems, new garage cabinetry and overhead shelving, new main level heat pump, new paint, new decking, new backyard patio and more. Your tour begins with the foyer that has a side hall to a bedroom on the right that is currently being utilized as an office, and the formal dining room on the left. The great room is straight ahead and has a 2-story coffered ceiling, a gas fireplace with brick and stone, French doors to the screened in porch and is open to the kitchen. The kitchen has a large center island with pendant lighting, granite countertops, tile backsplash, under-cabinet lighting, stainless appliances, and an arched doorway to the breakfast room. A hallway from the kitchen leads to the double garage and has a walk-in pantry with a barn door, a powder room, a 2nd pantry and a laundry room with granite counter, sink and cabinetry. The primary bedroom is off of the great room and has a vaulted ceiling, wonderful natural lighting and the primary bath that has a double granite vanity with a center make-up vanity, a jetted tub, a separate shower with tile and glass surround, a water closet and a walk-in closet with organizer system. Two additional bedrooms are on the opposite side of the house and are adjoined by a J and J bath. The upper level is a suite unto itself or a great bonus room with a full hall bath, a walk-in closet and walk-out attic storage. Head downstairs to the basement where you will find a family/media room, another half bath, a walk-in closet and a partially finished storage room with vinyl flooring and separate door to the exterior. This space could easily be used as an exercise or hobby room or could be further finished out if desired. All of this, and the neighborhood offers a community pool and clubhouse and is just down the street from the Ooltewah Club which offers both social and golf memberships. It is also just minutes to schools, the interstate and the shopping and restaurants at Cambridge Square, so please call for more information and to schedule your private showing today. Information is deemed reliable but not guaranteed. Buyer to verify and and all information they deem important.
MlsNumber: 1389328


Listing Provided By: Keller Williams Realty Greater Downtown, original listing
Name: Keller Williams Realty Greater Downtown
Phone: (423) 664-1900
Office Name: Keller Williams Realty
Office Phone: (423) 664-1900
Agent Name: Jay Robinson
Disclaimer: Copyright © 2024 Greater Chattanooga 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