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

119 Morris Road
Erwin, TN 37650
Stephanie Goebbel with Fathom Realty, original listing - (888) 455-6040

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $659,900
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2378 Square Feet
Agency: Fathom Realty
Agency Phone: (888) 455-6040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Welcome to the Jewel Branch Cabin! <br /> <br /> This cabin is hand crafted with the highest quality materials. Logs from approximately 200 year old historic log cabins were dismantled and reassembled here to create this log cabin. <br /> Solid rough sawn hardwoods are used throughout the cabin on both the walls and floors to create an authentic warm ambiance and the aroma of freshly cut wood. Antique furniture, art and memorabilia take you back to a relaxing and simpler time but you have all the modern amenities and comforts here.<br /> The kitchen cabinets are crafted from solid black walnut from a well known ancient tree that fell at the Unicoi County Heritage Museum.<br /> Sit in the rocking chairs on the huge covered wrap around porch and take in the beautiful mountain views and lovely sunrises and sunsets while you enjoy the fresh mountain air. <br /> All furnishings and accessories will convey with the property.<br /> Enjoy the amazing hot tub and explore the 5.48 acres which are a stone's throw from 100 acres of Erwin Watershed Property and over 2000 acres of US National Forest land.<br /> There are numerous outdoor activities nearby; Unaka Bike Park, hiking, fishing, and rafting. Downtown Erwin is nearby with great restaurants, shops and festivals year round. Please ask if you would like a complete list of activities.<br /> This cabin is currently a very successful listing on Airbnb, so all viewings must be arranged between short term stays. <br /> Buyers/buyers' agent to verify all information. Some listing information is from third parties.
MlsNumber: --
ListingId: 9965779


Listing Provided By: Fathom Realty, original listing
Phone: (423) 737-8705
Office Phone: (888) 455-6040
Agent Name: Stephanie Goebbel
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App