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

1800 Wilkinson Pike
Maryville, TN 37803
Karen Bennett with Coldwell Banker Nelson Realtor, original listing - (865) 982-0500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,595,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 5700 Square Feet
Agency: Coldwell Banker Nelson Realtor
Agency Phone: (865) 982-0500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1944
Notes: A rare find in Maryville City; enjoy living at its finest! This exceptional 4 bedroom home offers an abundance of charm and character with hardwood floors, built-ins, solid wood doors, and large windows with lots of natural light throughout. Situated on nearly 3 acres and bordering the 140 acre Maryville College Woods with trail systems, you will love the peace and tranquility of your own private retreat, yet appreciate its fantastic central location to all that Maryville has to offer. Maryville College is within walking distance while Maryville City schools, downtown Maryville, Blount Memorial Hospital, shopping, groceries, parks, and restaurants are all within a 5-10 minute drive. The Knoxville Airport (TYS) and the Great Smoky Mountain National Park are within a 15-20 minute drive. The recently renovated gourmet eat-in kitchen boasts a large central island, plenty of cabinet storage, stainless steel countertops, two refrigerators, and two dishwashers. The Thermador Professional Range with double oven, 6 burner cooktop, and griddle will please the chefs in the family. In addition to the kitchen, the main level has plenty of room to spread out with a sunroom, dining room, library, bunk room with attached bathroom, large mudroom with built-in shelving, powder room, laundry room with washer and dryer, and study/office (AT&T Fiber available). Upstairs offers 3 spacious bedrooms, each with its own tiled bath. The owner's suite offers a soaking tub, walk-in shower, marble dual vanities, and a large walk-in closet with ample storage. In the finished basement you will find a bonus room for family games or movies, an exercise room, half bath, refrigerator, and plenty of extra storage space. You will be surrounded by a beautiful lawn, mature trees, and gardens when you step outside whether onto the expansive patio grilling on your Primo Ceramic Grill, one of the 3 porches, or playing in the fenced yard with your children or pets. There is a well on the property for watering your gardens. Timeless and traditional, this property is truly one of a kind!
MlsNumber: --
ListingId: 1284708


Listing Provided By: Coldwell Banker Nelson Realtor, original listing
Phone: (865) 740-0699
Office Phone: (865) 982-0500
Agent Name: Karen Bennett
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 = 2431 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 Paulina Perez
Paulina Perez
ASCIIGreater Impact Realty
Call Today!: (423) 231-3607

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App