Title Page Background
DEBUG FN args: Array ( [0] => 2512 [1] => [2] => [3] => agent ) BEFORE: Site: 2512 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2512 Igate: njhud LocID: 2512 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2512 [1] => [2] => [3] => lender ) BEFORE: Site: 2512 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2512 Igate: njhud LocID: 2512 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2512 [1] => [2] => [3] => other ) BEFORE: Site: 2512 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2512 Igate: njhud LocID: 2512 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

403 Catawba Street
Erwin, TN 37650
Melissa Townsend with REMAX Checkmate, Inc. Realtors, original listing - (423) 282-0432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $534,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2798 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: 1915
Notes: This natural beauty has been resurrected from the past to appear as a modern home with tasteful upgrades - while maintaining the charm of yester year:<br /> This beautiful home offers new exterior, new metal roof, new or refinished windows, new plumbing, new electrical, new floors, new walls . . . the list just keeps going.<br /> Beautiful coffered ceiling in dining area and original mantles have been refinished. Solid hardwood floors along with tile and shiplap style walls make this home very unique.<br /> New kitchen cabinets and counter top line the comfortable kitchen layout. The bathrooms have been outfitted with high end finishes, including an oversized tiled walk in shower.<br /> Anyone focused on garages will appreciate that the doors were positioned to open at an incline enabling the installation of a 4 post car lift if so desired. This enables either storage of multiple cars in one bay or the opportunity to work on a car while in the climate controlled environment.<br /> More than $25,000 was put into new concrete sidewalks and drive alone.<br /> Builder is willing to put in 30 or 50 amp service on the side of the garage on the parking pad for an RV if buyer makes full price offer.<br /> Builder states house is approximately 2,000 square feet finished with more than 800 square feet in covered porch and the garage is approximately another 700 square feet (it too is heated and cooled).<br /> All information deemed reliable. Buyer / buyer's agent to verify all information. R# 1630
MlsNumber: --
ListingId: 9980472


Listing Provided By: REMAX Checkmate, Inc. Realtors, original listing
Phone: (423) 416-2249
Office Phone: (423) 282-0432
Agent Name: Melissa Townsend
Disclaimer: Copyright © 2025 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