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

409 Ohio Avenue
Erwin, TN 37650
Shane O'Hare with REMAX Checkmate, Inc. Realtors, original listing - (423) 282-0432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2842 Square Feet
Agency: REMAX Checkmate, Inc. Realtors
Agency Phone: (423) 282-0432

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Come check out this completely remodeled pottery home on one of the most desirable streets in the quaint town of Erwin.<br /> <br /> For it's size, this home packs a tremendous punch. When a person walks up to the front door, they immediately get a sense of the quality and crafstmanship of the home. Studs, plaster, lath, electrical and plumbing have either been replaced or updated. Now you're greeted with bright LED lights, superior flooring, crisp sharp lines on the finish throughout and inviting colors. In the kitchen you'll find oft close doors , a coffee bar incorporated into the cabinets and an open feeling which is rare in older homes. The gas range outfitted with wooden hoodvent is a focal point as you peer down the oversized kitchen island. The owners have wired the home so door locks, lights and main HVAC (2022) are smart controlled, operated by phone app. If that type of utility doesn't appeal to you, it's still set up for traditional use. <br /> <br /> The primary bedroom and bathroom are located on the main level and offer plenty of storage. The tiled walk in shower and L shaped walk-in closet with barn door offer modern comfort and features. The built in electric fireplace and tv mounts indicate a sense of charm and purpose in the design.<br /> <br /> The upstairs feature two comfortably sized bedrooms along with a completely remodeled bathroom - all of which continue with the theme of being modern, yet very comforting.<br /> <br /> Just a few feet away is an incredible garage that offers a heated and cooled section that is currently used as an office and work out area, but could accommodate other functions. The garage itself is outfitted with a double door on the front and an oversized door on the back with direct access to the alleyway - drive straight through the garage. Homes of this quality and finish are a rare find - schedule your showing immediately and bring your prequalification letter.<br /> Information deemed reliable. Buyer / buyer's agent to verify all information. R# 1463
MlsNumber: --
ListingId: 9974325


Listing Provided By: REMAX Checkmate, Inc. Realtors, original listing
Phone: (423) 833-7371
Office Phone: (423) 282-0432
Agent Name: Shane O'Hare
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