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

146 Topside Court
Bean Station, TN 37708
Michael Morton with The REAL ESTATE Office, original listing - (865) 851-5578

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1500 Square Feet
Agency: The REAL ESTATE Office
Agency Phone: (865) 851-5578

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2013
Notes: Virtual Tour HERE: https://www.youtube.com/watch?v=1lAusj4RSDo&feature=youtu.be<br /> <br /> One of several beautiful, custom homes in the exclusive, gated community of Bayside Subdivision. Enjoy views of the mountains and seasonal views of Cherokee Lake through the 2-story wall of windows. The vaulted ceiling is topped with gorgeous beams emphasizing the airy, openness of the home. Add to that the loads of natural light and you've got a place you'll love to call home. The deck was just completely rebuilt so you can enjoy those mountain and lake views from both inside or out. <br /> <br /> The primary suite is on the main level with a large walk-in closet and ensuite bathroom with dual sinks. Upstairs is a bedroom loft complete with a closet and 2nd full bathroom. The views from up there are dreamy! The owner seldom used this space so everything about it is pristine. <br /> <br /> The basement level 2-car garage is super deep making the perfect space for extra storage or a workshop. <br /> <br /> Bayside Subdivision has its own boat slips for owners to enjoy seasonally when the water levels are up. Quick and easy access straight to Cherokee Lake! The subdivision also provides a small area for storing outdoor toys such as campers or boats. <br /> <br /> Grainger County is widely known for its famously declicious tomatoes, so you don't want to miss the annual Grainger County Tomato Festival. Rutledge, the countyseat, is just 10 minutes down the road and Morristown is less than 20 minutes for all sorts of shopping, restaurants, and entertainment. <br /> <br /> Please call to schedule your private showing. You will NOT be able to drive into this subdivision without an agent. The gate remains closed at all times.<br /> <br /> Copy and paste the following link for the virtual tour: https://www.youtube.com/watch?v=1lAusj4RSDo&feature=youtu.be
MlsNumber: --
ListingId: 1283981


Listing Provided By: The REAL ESTATE Office, original listing
Phone: (865) 851-5578
Office Phone: (865) 851-5578
Agent Name: Michael Morton
Disclaimer: Copyright © 2024 East Tennessee Realtors®. 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