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

2200 Anderson Bend Rd
Russellville, TN 37860
Bruce Hull with Lake Homes Realty, original listing - (866) 525-3466

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $680,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3033 Square Feet
Agency: Lake Homes Realty
Agency Phone: (866) 525-3466

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1997
Notes: This 4.38 acre East Hamblen County home has a full length front porch perfect for swinging and taking in the seasonal Cherokee lake view! Should you ever grow tired of this and decide to enter the home you will find nearly 3,000 sq ft of finished space, not counting the full unfinished basement, main level 2 car garage or the large screened in back porch overlooking your private wooded back yard. The kitchen remodel was completed with entertaining and hosting in mind. Whether you are an experienced chef or not you will love this space! It features an induction cooktop, Electrolux convection double ovens, in-island microwave, a coffee bar, appliance garage and a walk-in pantry. Main level living makes this home perfect for almost anybody. The master bedroom features two spaces that can be individualized however you prefer them. The current owner uses one for a sitting room/clothing storage and the other as a sleeping area. The attached bathroom offers double vanities, a step-in shower and a whirlpool tub. This floor also features a formal dining room, breakfast nook, laundry room, an office and a living room with a gas fireplace and cathedral ceilings. Off from the living room is the previously mentioned screened-in porch that is perfect for relaxing in the evenings, drinking coffee in the mornings and bug-free outdoor dinners. With an additional patio off from this you have so many options as far as outdoor spaces are concerned. Back inside you will find two additional bedrooms and a full bath with a beautifully restored claw foot tub and separate shower upstairs and a full unfinished basement that is perfect for storage or just waiting for someone else's finishing touches should you require more square footage. The two car garage incudes an additional heated/cooled multipurpose room as well as a floored storage space above it with a pull down ladder access that is at least 20' long and more than 6' tall in the center with multiple electrical outlets should you ever need them. If ever a 'view' of the lake is not enough, a public boat launch is just a few miles away. This home has been meticulously cared for, maintained and upgraded over the years. Schedule a showing today to see for yourself if this is the house you should call home. Some drone photography was used. Buyers and or their agents to verify all information from tax records and from current sellers.
MlsNumber: --
ListingId: 1287233


Listing Provided By: Lake Homes Realty, original listing
Phone: (865) 207-6859
Office Phone: (866) 525-3466
Agent Name: Bruce Hull
Disclaimer: Copyright © 2025 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.


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 = 2458 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 Alicia Duncan
Alicia Duncan
ASCIIGreater Impact Realty
Call Today!: (334) 360-6042

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App