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;

1452 Grandeur Avenue
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $387,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1600
Agency: Realty Executives Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: One level living at its finest! Another impeccable LMB home is Parrottsville Tennessee is underway and seamlessly blends modern living with countryside charm. This version of the Abby Model is a generous 1,600 square feet, features a true full 2 car garage, vaulted living area at entry, a split-bedroom layout, and an open-concept design, ensuring both comfort and functionality and sits on a .48 acre corner lot. The home includes numerous custom upgrades such as a vaulted living area, custom siding, NuCore luxury vinyl plank flooring, pex plumbing, top-tier insulation, 25-year architectural roofing shingles, Lansing energy-efficient windows, and granite countertops in Cecilia Light (featuring gray, taupe, white, and black tones). The kitchen is equipped with custom cabinets, custom granite, recessed lighting, and modern energy-efficient appliances, including a refrigerator, range oven, microwave, and dishwasher. Additional features include ceiling fans in living areas and bedrooms, a custom ventless fireplace, a full 2-car garage, an open concept layout, and 9-foot ceilings. Inside, near the garage wing, enjoy the convenience of a dedicated laundry area that opens up to the custom kitchen and unwind on the covered front and back porches, ideal for relaxation. With no HOA, you have the freedom to explore and implement your landscaping and outdoor living ideas. Inside, near the garage wing enjoy the convenience of a dedicated laundry area that opens up to the custom kitchen. and unwind on the covered front and back porches, ideal for relaxation. With no HOA, you have the freedom to explore and implement your landscaping and outdoor living ideas. <br /> Located in a quiet community, this home offers a tranquil atmosphere perfect for unwinding. Its convenient location in Parrottsville places you close to Interstate 40, Highway 321, shopping, hospitals, the breathtaking Smoky Mountains, Douglas and Cherokee Lakes, Dandridge, and the airport. This home allows you to embrace country living without sacrificing access to essential amenities. Don't miss the chance 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: 1265489


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.


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 = 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;
Real Estate Expert Photo for Deanna Parker Workman
Deanna Parker Workman
ASCIICountry Living Realty
Call Today!: (423) 608-6886

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App