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

822 Cumberland St
Harriman, TN 37748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2712
Agency: Coldwell Banker Jim Henry & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1900
Notes: Beautiful home in Cornstalks Heights in downtown Harriman! There is so much to mention! Downstairs first enter into the party/family room, fully equipped with a bar countertop, dishwasher, under counter fridge, ice maker, beverage cooler and plenty of space to entertain. This room also has its own split air unit. Then walk into the large formal dining room with gas log fireplace. Next you have an entryway from the front of the home that takes you into a smaller dine-in room, hall storage and office with a full bath and walk-in Bathfitter shower. Next is the completely remodeled kitchen with all new appliances, oven with built in air fryer, 2nd dishwasher, 2nd fridge, new countertops, garbage disposal and laundry area off to the side. Brand new Whirlpool washer and dryer with a steamer.<br /> <br /> Upstairs you will find 4 bedrooms and 2 full baths. From here you can access 2 decks, a smaller one leading down towards the guest house and a 2nd oversized patio perfect for relaxing outside or entertaining and not to mention the low maintenance composite decking material.<br /> <br /> Lots of natural light, beautiful shutter blinds on the windows, all new flooring, tankless water heater, 2 HVAC units, new roof, upgraded plumbing and electrical, Google nest system. Outside there is a 1-car garage and tons of extra parking space for the whole family, an RV, or even a boat! Make sure to not miss the gorgeous brick driveway specially designed by the owner!<br /> <br /> The 1BR/1BA guest house is perfect for using as a rental, an in-law suite, or for the college kids! 2-car garage downstairs and extra outside parking. Very nice private, level lot. This would make a great Airbnb and bring in that extra income! Both homes are just a block away from city schools making it very convenient for the kiddos! Also close by are two city parks, a full on community center, splash pad & more! You can also be in Oak Ridge or Knoxville in about 30 mins!
MlsNumber: 1263900


Listing Provided By: Coldwell Banker Jim Henry & Associates, original listing
Name: Coldwell Banker Jim Henry & Associates
Phone: (865) 603-7230
Office Name: Coldwell Banker Jim Henry
Office Phone: (865) 376-2121
Agent Name: Brandy Catron
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.


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 = 2499 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 Steve Larimer
Steve Larimer
ASCIIKnox Realty
Mobile: (703) 342-9163
Office: (865) 357-8800

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App