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;

199 Crosby Drive
Bean Station, TN 37708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $309,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1863
Agency: Clinch Mountain Realty & Auction

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1976
Notes: MOTIVATED SELLERS ARE READY FOR OFFERS ! No HOA and No City Taxes. Freshly painted and ready to move in ! A Spacious 3 bedroom, 1.5 bathroom ranch style full brick home with a partially finished basement that includes a den, bonus room, 2 closets and a pantry. Main floor kitchen boasts unique custom cabinetry, crown molding, all stainless appliances, pantry, an island, track lighting with beautiful pendant lights. Laundry is located on the main floor. Full bath has floor to ceiling tile with walk in shower. Walk out from the kitchen door to recreational area. The side deck is covered with a TV and roll down privacy/sunscreens included. Steps from this deck leads down to a second deck attached to the above ground pool, then on to a Covered Outdoor kitchen with electric and water installed. The owner has taken great pride in the yard over the years, so someone else can now enjoy the mature flowers and trees. The back yard is completely fenced for the kids and the pets. The lower level Family room has a fireplace and plenty of space for family fun ! No need to leave the house when you have all this entertainment area at your own home. This is a quiet subdivision located only 3.6 miles from Hamblen County and has Access in the subdivision to Johnson Ridge Walking and Bike Trail that consists of approximately 100 acres of TVA land with Cherokee Lake frontage. Only an hour drive to Pigeon Forge , Dollywood, Gatlinburg or Knoxville . There are several public boat launching areas in Bean Station and also Marinas close by. Clinchview Golf & Country Club (an 18 hole course) is also located in Bean Station and only 5 miles from this home. Schedule a viewing soon before this Bean Station Gem gets away from you.
MlsNumber: 701981


Listing Provided By: Clinch Mountain Realty & Auction, original listing
Name: Clinch Mountain Realty & Auction
Phone: (423) 748-1081
Office Name: Clinch Mountain Realty & Auction
Office Phone: (865) 993-5263
Agent Name: Phyllis Reed
Disclaimer: Copyright © 2024 Lakeway Area 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App