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;

2363 Heavenly Vw
Ooltewah, TN 37363

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,000,000
Beds: 7
Baths: Full: 8, ½: 1
Status: Active
SqFt: 11200 Square Feet
Agency: The James Company Real Estate Brokers & Development
Agency Phone: (423) 499-9999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: ''The Windy Hill Estate''. Prime Ooltewah, TN location. Gated privacy. Breathtaking views. ''Heavenly Views'' A rare find to say the least. Endless southeastern views of ''The Horizons,'' and/or southwestern views Lookout Mountain and city lights. Eleven acres at the top of White Oak Mountain, at the end of a cul-de-sac street. This luxurious estate features elegance and comfort (built like a fortress). Quality custom built featuring the finest craftmanship of stone throughout the estate (inside and outside). Main house consists of 8800 Sq Ft. 5 bedrooms, 5.5 baths. Luxurious master suite and luxurious master bath with his and hers walk in closets all on the main level. Soaring high ceilings throughout. Beautiful and/or elegant marble staircase thereby showcasing a grand chandelier. Elegant 2 story foyer. Elevator. Open floor plan features a piano bar that includes a wet bar, dishwasher, and ice maker. Separate dining room, family room, separate sitting room (living room), custom butler's pantry which features a dishwasher, ice maker, and sink. Breakfast room that features a Scenic City view. Second level foyer overlooking the grand marble stone staircase, along with the front entry foyer and at the same capturing eastern and western view. 5th bedroom is currently customized as an office with custom built-in cabinetry. All bedrooms feature full bathrooms. Custom, gourmet kitchen includes a Thermador gas cook top with warming shelves, Thermador double (wall) ovens and side by side built-in Sub-Zero refrigerator and freezer. Island with second sink and Kitchen Aid dishwasher. Main house features side rear entry attached 3 car garage. Large laundry room with sink, custom cabinets, built-ins, and pull-outs galore. Plantation shutters throughout. Custom trey ceilings throughout. House consist of Pella Windows and Doors. Lush landscaping with water fountains, flower beds, and retaining walls. The overall layout and/or presentation is simply elegant. The separate guest house consists of 2400 Sq Ft, 2 bedrooms, 2.5 baths, which includes panoramic views. The grand design outdoor entertainment area has too many features to mention in doing the subject justice. Multi-level pool side features are nothing less than spectacular. The grandeur display of quality and custom marble features is breathtaking. The pool and pool house features are all new and/or under construction and near completion. Pool side entertainment features are incredible: Unite (with pebble tech) heated pool and hot tub. Pool features zero entry and tanning deck 1 & 2. Two badu jets. Swim up bar to fire pit with custom sunken seating. 2 accent fire bowls flanking the pool side. Poolside basketball goal. Custom Mushroom foundation. Pool house/outdoor kitchen equipped with state-of-the-art appliances, allowing you to entertain guests with gourmet meals. All sports court includes basketball and pickle ball courts overlooking the western brow with scenic city view. The pool house features a theater room, a wine cellar room, and a full bathroom along with a gourmet kitchen and grilling with open air full retracting sliding doors to the pool, thereby capturing the scenic city, brow front views. Perfect for hosting poolside parties and enjoying a vibrant outdoor atmosphere. Providing endless entertainment options for you and your guests within this luxurious back yard oasis. All of the water features create a soothing ambiance. LED lighting creates an enchanting nighttime pool atmosphere with fire bowls, mushroom fountains, and waterfall via an integrated hot tub along with many customized features, all overlooking breathtaking views, yet with seclusion and tranquility. A private retreat with resort inspired luxuries.
MlsNumber: --
ListingId: 1387944


Listing Provided By: The James Company Real Estate Brokers & Development, original listing
Phone: (423) 400-2424
Office Phone: (423) 499-9999
Agent Name: James Perry
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