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','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 = 2441 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 = 2441 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;

213 Splendor Way Way
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $340,500
Beds: 3
Baths: 2
Status: Pending
SqFt: 1400
Agency: Realty Executives Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Welcome to your ideal living space! This beautiful new construction 3-bedroom ranch home in Parrottsville, Tennessee offers the perfect blend of modern living and serene countryside charm. With a vaulted living area, split-bedroom layout and open-concept design, this home offers both comfort and functionality. The 3 bedroom 2 bathroom, custom built ranch home sits on a .55 acre lot. Enjoy the convenience of a dedicated laundry area, and relax on the covered front and back porches, which provide the perfect setting. Situated on over half an acre of land, this property offers a generous yard with great set-back, providing you with room to grow and truly make it your own. No HOA-You'll have the freedom to explore your landscaping and outdoor living ideas. Custom upgrades include a vaulted living area, NuCore Luxury vinyl plank flooring, pex plumbing, top tier insulation, 25 year architectural roofing shingles, Lansing energy efficient windows, ample counter space granite countertops in Cecilia Light (grey taupe, white and black tones), custom cabinets , recessed custom lighting in the kitchen and dining area, ceiling fans in living areas and bedrooms, custom ventless fireplace, brand name appliances modern and energy efficient (refrigerator, range oven, microwave, dishwasher) a full 2 car garage, open concept layout, 9 foot ceilings, covered front and back porches, The quiet community ensures a tranquil atmosphere, perfect for relaxation. Limited restrictions. Located conveniently in Parrottsville, you're just a stone's throw away from Interstate 40, and 321, shopping, hospitals, the breathtaking Smoky Mountains, Douglas and Cherokee Lake, Dandridge, and the airport. Embrace the best of country living without sacrificing access to essential amenities. Don't miss this incredible opportunity to own a new construction home with endless potential, stunning natural surroundings, and a location that offers the best of both worlds. Contact us today to arrange a viewing and start envisioning your future in this charming Tennessee home.
MlsNumber: 1256023


Listing Provided By: Realty Executives Associates, original listing
Name: Realty Executives Associates
Phone: (865) 588-3232
Office Name: Realty Executives Associates
Office Phone: (865) 588-3232
Agent Name: Abé Baah
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App