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;

5429 Lakeshore Drive
Bean Station, TN 37708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $459,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3192
Agency: Greater Impact Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1984
Notes: Lake life is calling you! Come see this fully updated three (3) bedroom, three (3) bathroom home that is minutes from Lake Cherokee! This home boasts 2,452 finished square feet, all on the main level. New Bamboo flooring throughout most of the home, with LVP in the newly remodeled laundry room. The kitchen was also recently remodeled and has a fresh, inviting feel. The home has an office, which could be used as a fourth bedroom, if needed. You will also find spacious living and family rooms on the main floor, as well as a large dining room. Off the kitchen, an inviting covered porch beckons you, where you can sit and take in the splendor of the back yard. Downstairs, you will discover a large, unfinished basement, which has HVAC ventilation to keep this area at a comfortable temperature. The options in this area are many. Storage, game room, a workout area... or even the option of finishing it for more living space. Exit the basement to a covered patio area that is an accommodating space for entertaining! The nearly one-acre yard is fully fenced, level and has plenty of room to store your boat, RV and toys. A covered two-car carport, with an attached workshop / storage area, is located at the rear of the home. A new architectural shingle roof was installed in February of this year. The home is located within minutes of several boat launch locations, so your travel to the lake is brief. This home has been cared for by owners who took the time to ensure the remodeling was quality workmanship. This amazing home will not last long, so schedule your tour today!! All information is obtained from a third party. Buyer / agent should verify all information.
MlsNumber: 9966600


Listing Provided By: Greater Impact Realty LLC, original listing
Name: Greater Impact Realty LLC
Phone: (423) 973-8634
Office Name: Greater Impact Realty Jonesborough
Office Phone: (423) 973-8634
Agent Name: Andy Phillips
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