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;

7526 Twisting Creek Ln
Ooltewah, TN 37363

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,285,000
Beds: 5
Baths: Full: 6, ½: 1
Status: Active
SqFt: 7786 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: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Lake Front Paradise - Prestigious Savannah Shores. Custom quality construction. Lush level 1.5 acre lot. 190 ft. of water frontage of which includes a solid brick sea wall, concrete launching ramp, custom sandy beach. Custom covered boathouse with two large boat slips with two boat lifts and jet ski lifts and storage closet. This outdoor living showplace also includes a large, covered cabana with mountain stone and tile flooring outdoor kitchen with stainless steel ''Fire Magic'' outdoor refrigerator and ''FireMagic'' outdoor grill, ''FireMagic griddle'' and sink with granite countertops that features multiplug outlets for cookout cook offs. Featuring a mountain stone outdoor fireplace a 24 x 40 foot in ground gas heated swimming pool with diving board. This all brick two-story is in impeccable condition with low maintenance decking and railings, also includes lakeside covered porch/sitting area. Family room with wood burning fireplace with gas logs and vaulted 18-foot ceilings, hardwood Wainscoting. Luxurious master suite with cathedral ceiling and master bath on main level. The master bath features separate ''Bubble Jetted'' garden tub, an extra-large doorless shower with multiple shower heads, a beautiful designer walk in closet with beautiful custom cabinets throughout the master bath. Custom designer light fixtures.<br /> Very comfortable floor plan...whereas all the rooms are large and spacious. Banquet sized dining room, Grand Foyer with 2 hardwood staircases. Gourmet kitchen with stainless appliances, gas cooktop, warming drawer, LG glass front designer refrigerator, wall oven with convection microwave, dishwasher, hardwood cabinets and granite countertops with coffee bar. Large laundry room with built-in cabinets, refrigerator/freezer, utility sink. Main level powder room, solid wood interior doors. Upper-level features: Bonus room #1 with custom built-ins as office space. 3 large bedrooms as bedroom suites. Bonus room #2 features kitchenette and built-in cabinetry and bookcases. Garden level consists of rec room/billiards room, family room/den with fireplace with gas logs, wet bar, guest bedroom #5 and #5 full bathroom, storm shelter/storage room and full bath #6 (with pool access both serving outdoor space and den wet bar area.) Extra-large 4th and 5th garage with separate side driveway, large enough for man cave garage combo. Truly a beautiful setting all around. Lakeside privacy and house is set back off the road a long distance with street scape privacy all located on a quiet cul-de-sac one street subdivision. Not only great lakefront views but views include White Oak Mountains in the distance. Excellent Ooltewah location off of charming Snowhill Road. Convenient to grocery stores with pharmacy, restaurants, charming Cambridge Square and Publix Center. Also, convenient to emergency care and medical clinics, state parks, marinas and multiplex, first-class golf courses. Too many features to mention. Boating and jet ski pleasure riding is the best. Multiple restaurants by water and even boating access to downtown Chattanooga's waterfront docking capabilities.
MlsNumber: --
ListingId: 1391499


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