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 = 2441 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2441 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 2441 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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;

1364 Old Parrottsville Highway
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 2
Baths: 1
Status: Active
SqFt: 1250
Agency: Realty Executives Associates, North

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1930
Notes: Walk-through video available. Own a piece of beautiful Parrottsville Tennessee. This classic one level ranch farmhouse sits on .77 unrestricted acres and has several updates (all new plumbing, updated and approved septic, new wiring, new electric panel, new water heater, new insulation, and drywall) while maintaining character and charm. Updates include all new duct work, light fixtures, water heater and expansion tank, Luxury Vinyl Plank flooring throughout, granite countertops, tiled backsplash in the kitchen, a full sized dining area, fully tiled bathroom with a brand new tub shower combo, new tub fixtures (2024), new kitchen fixtures, new kitchen hardware, and new paint throughout. Upon entering the home the open floor plan makes for great sight lines . The full formal dining room is located just off of the large and open living room adjacent to the kitchen with room for a full-sized 6 to 8 person dining table comfortably. The large and bright kitchen can accommodate both an at-home chef or those who like to entertain, contains updated stainless steel appliances, chestnut tone cabinets, and granite countertops with plenty of room for an island. There is also a full sized pantry and room for additional storage. The owner's suite is located just off of the living area and is large enough to accomodate full sized furniture, an entertainment center and a king sized bed. The wide corridor hallway leads to the 2nd bedroom which contains an extra large closet and is just off of the spacious and updated full bathroom. The full laundry room is located at the rear of the home where you will find another large storage area and access to the large back lot. With ample space for development, the .77-acre parcel of land has a primarily level grade and can accomodate an RV and multiple large vehicles with direct and easy access to the main road, plenty of room for a garage, an additional workshop, out building, garden, and outdoor entertainment. The location is exactly where you want to be in Parrottsville; just 20 miles to Morristown TN, 30 miles to Sevierville TN, 25 minutes to Douglas Lake and Dandridge TN and within reach of 2 major airports. This beautiful home is a very rare find with quality finishes. Schedule your showing today.
MlsNumber: 300462


Listing Provided By: Realty Executives Associates, North, original listing
Name: Realty Executives Associates, North
Phone: (865) 588-3232
Office Name: Realty Executives Associates
Office Phone: (865) 588-3232
Agent Name: Ab Baah
Disclaimer: Copyright © 2024 Great Smoky Mountains Association of Realtors. 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