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;

394 Webster Rd
Harriman, TN 37748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 4
Baths: 2
Status: Pending
SqFt: 2321
Agency: United Real Estate Solutions

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1969
Notes: Previous buyer backed out prior to any inspections scheduled, no fault of the seller and less than 18 hours after their offer was accepted.<br /> Welcome to 394 Webster Rd. This ranch style home sits on 1.6 unrestricted acres where modern luxury meets comfort in every detail. This 4-bedroom, 2-bathroom haven boasts an array of upscale features designed to elevate daily living.<br /> <br /> Enter into the living room of the home which flows into the kitchen that shines as a culinary masterpiece. Equipped with a gas range, pot filler, under-mount farmhouse style composite sink, stainless appliances, stunning granite countertops with a waterfall edge and granite backsplash. This space is both functional and elegant. Soft-closing cabinets and drawers add a touch of sophistication to your cooking experience.<br /> <br /> Retreat to the spacious primary bedroom, where relaxation awaits. Unwind by the electric fireplace that also can heat the room. Enjoy the convenience of a walk-in closet and ensuite bathroom featuring a white freestanding tub and tiled shower.<br /> <br /> Three additional bedrooms share a full bathroom, ensuring comfort for family and guests alike. The large laundry room offers practicality with a folding area, butcher block countertops, and white shaker style cabinets.<br /> <br /> While comfort reigns indoors, the exterior delights with a new back deck, perfect for al fresco dining and entertaining. Recent upgrades including fresh interior and exterior paint, serviced HVAC with new duct work and dual dehumidifiers, tankless natural gas water heater, and a crawl space vapor barrier ensure peace of mind for years to come.<br /> <br /> From top to bottom, this home has been meticulously upgraded with attention to detail. With new toilets, flooring, vanities, mirrors, lighting, appliances, exterior shutters, electrical updates, and more, every aspect has been thoughtfully considered.<br /> <br /> Don't miss the opportunity to make 394 Webster Rd your own slice of East Tennessee paradise, where luxury living awaits at every turn.<br /> <br /> Information deemed reliable, not guaranteed. Buyer to verify. Drone photography used.
MlsNumber: 1260842


Listing Provided By: United Real Estate Solutions, original listing
Name: United Real Estate Solutions
Phone: (865) 621-2040
Office Name: United Real Estate Solutions
Office Phone: (865) 444-2400
Agent Name: Heather Zonar
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