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

1432 Grandeur Avenue
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $348,500
Beds: 3
Baths: 2
Status: Pending
SqFt: 1404
Agency: Realty Executives Associates Bearden

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2024
Notes: Grandview Ridge 1 level living at its finest! New construction custom built ranch home situated on a beautiful property just over half of an acre in Cocke County. This sun filled property sits on a quiet street in a pristine and friendly neighborhood. Custom upgrades include coveted 9 foot ceilings, New Core Luxury vinyl plank flooring in taupe ombre, pex plumbing,top tier insulation, 25 year architectural roofing shingles, Lansing energy efficient windows, walk in shower, granite countertops in Cecilia Light (grey taupe, white and black tones), custom cabinets with soft close drawers, recessed LED can lights in the kitchen and dining area, ceiling fans in living areas and bedrooms, brand name appliances modern and energy efficient (range oven, microwave, dishwasher) 2 car garage, open concept split floor plan layout, tray ceiling in the owner's suite. Ample counter space, closets, a full laundry room and multiple linen and storage closets. The floor plan is an organized open concept. Upon entry you walk into the living area with site lines to the back patio, and custom kitchen. The owner's suite includes a walk-in closet, an ensuite bath, and sits on the opposite wing of the layout creating privacy from the additional bedrooms. You will enjoy making memories on the oversized front porch with panoramic views as well as entertaining on the back patio/porch in the extra spacious backyard. One year warranty from the builder on all systems and construction. Additional customization options are also available. Centrally located and convenient to Sevierville, Morristown and Newport, just 10 minutes to Interstate 40, so you're never far from the essentials and entertainment, ensuring you have access to everything you need while maintaining your secluded lifestyle. Don't miss this exceptional opportunity to secure your own private haven on this 1.03-acre property. With its level terrain, unmatched privacy, and mountain views, this property is a true gem. Contact us today to arrange a viewing and start making your dream home a reality. Walk-through video available. See Grandviewridge.com
MlsNumber: 702180


Listing Provided By: Realty Executives Associates Bearden, original listing
Name: Realty Executives Associates Bearden
Phone: (865) 588-3232
Office Name: Realty Executives Associates (1892)
Office Phone: (865) 588-3232
Agent Name: Abe' Baah
Disclaimer: Copyright © 2024 Lakeway Area 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