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

322 Mystical Creek Way
Cosby, TN 37722
Kristi Street with Keller Williams Smoky Mountains, original listing - (865) 999-8601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,800,000
Beds: 7
Baths: Full: 7, ½: 1
Status: Active
SqFt: 4631 Square Feet
Agency: Keller Williams Smoky Mountains
Agency Phone: (865) 999-8601

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Amazing Investment Opportunity - 6 Bedroom Luxury Log Cabin with Indoor Pool and New 1 Bedroom Cabin on 22.74, gated, unrestricted acres! Beautiful Mountain Views and Over 1,000 feet of creek frontage! With a multitude of building sites, this property is the perfect location for your own Smoky Mountain Resort or Wedding Venue! Both existing cabins are absolutely beautiful, well maintained and 1 owner. The 6 bedroom cabin was recently stained, pool liner replaced, pool deck resurfaced, and flooring in the kitchen, dining and theater was upgraded in 2023. The 1 bedroom cabin was completed in 2023 and has only been used for friends/family. 6 Bedroom Cabin: Spread out over 2 levels, with over 3,900 sq.ft. of living space, this beautiful, custom built cabin boasts 6 bedrooms, 6.5 bathrooms, large game room, theater room, private indoor pool, outdoor hot tub and firepit area. Entering into the open kitchen/dining area, you'll immediately notice the cabin's wood walls, floors and ceiling. The kitchen, with its gleaming countertops and stainless appliances, also features bar seating. Just beyond the dining area is the spacious living area, complete with a stacked stone electric fireplace and vaulted, double height ceiling. The main level is also home to a home theater, complete with stadium seating, an indoor 14x17, 3-5 feet deep pool and a convenient half bath. Upstairs you'll find the spacious game room with a pool table, air hockey and arcades. Each of the cabins 6 oversized bedrooms feature an ensuite bathroom. 4 of the bedroom suites are located on the upper level and 2 on the main level. 1 Bedroom Cabin: This custom built log cabin was built with relaxation in mind. Featuring a lovely fire pit area and porch swing, both overlooking the rushing waters of the creek. Its solid wood interior, cathedral ceiling and open floor plan lend a spacious feel. The fully equipped kitchen is complete with stainless appliances. Just beyond the living area, you'll find the spacious bedroom and ensuite bathroom. From the bedroom you can slip onto the back deck and into the private bubbling hot tub. Seller has already completed ground work for 2 additional cabins, with septic approvals already obtained, and a second road has already been cut in at the top of the property. Utility sewer coming to the area soon. City officials state work is set to begin in August to establish sewer to Cosby High School, just across the highway from this property.
MlsNumber: --
ListingId: 301525


Listing Provided By: Keller Williams Smoky Mountains, original listing
Phone: (865) 246-9162
Office Phone: (865) 999-8601
Agent Name: Kristi Street
Disclaimer: Copyright © 2024 Great Smoky Mountains 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 = 2441 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 Robert Tucker, Making Your Realty Dreams Reality
Robert Tucker, Making Your Realty Dreams Reality
ASCIIWeichert, Realtors - Tiger Real Estate
Call Today!: (865) 919-6831

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App