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

1331 Bright Hope Road
Greeneville, TN 37743
Darbi Neas with Envision Realty Group, original listing - (423) 525-5767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3758 Square Feet
Agency: Envision Realty Group
Agency Phone: (423) 525-5767

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 34 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Situated within an enchanting 34-acre estate of serene countryside, this magnificent equestrian estate offers privacy with Nolichucky River access, this property has it all. This stunning property offers a traditional style home with 4 Bedrooms, including primary ensuite with trey ceiling, 2 Full Bathrooms, formal entry, piano room, oversized family room featuring 22 ft cathedral ceilings, floor to ceiling windows, flooding the space with natural lighting, wood burning fireplace with ornamental mantel, hardwood floors, built in cabinetry, open floor plan to the spacious kitchen offering custom cabinetry and bar area! Oversized laundry room! 2 car attached garage, 2 car-detached garage, ample storage space, 12x12 finished office and tantum parking in basement. Enjoy nature from 8x35 screened porch or farm views from the covered front porch offering farm views. Equestrian features: Covered arena consisting of 2500 sq ft, metal roof with all-weather sand footing and 4 rail fencing. Equestrian 4 strand electric poly wire fencing surrounding pastures. The stunning 48 x 56 ft horse barn offers 4 12x10 stalls with tongue and V groove treated pine walls with heavy rubber mats, tack room heated and cooled, wash bay, electric stair hoist to loft and ample space for hay storage. Ample storage space for equipment. This property offers underground electricity to the home and barns. Automated Sprinkler System. There is a primitive log cabin with electricity and wood burning stove on the property overlooking the Nolichucky River perfect for camping. Mature landscaping throughout the property includes Crepe Myrtle's adorn the entrance to the farm, Rhododendron, Rose of Sharon and Althea. Every aspect of this exudes sophistication, tranquility and function! This property is located within an easy drive to the Great Smoky Mountains National Park and Gatlinburg, Pigeon Forge, Douglas and Cherokee lakes. Buyer & Buyer's agent to verify exact information.
MlsNumber: --
ListingId: 9975094


Listing Provided By: Envision Realty Group, original listing
Phone: (423) 525-5767
Office Phone: (423) 525-5767
Agent Name: Darbi Neas
Disclaimer: Copyright © 2025 Tennessee Virginia Regional Multiple Listing Service. 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 = 2456 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 Alicia Duncan
Alicia Duncan
ASCIIGreater Impact Realty
Call Today!: (334) 360-6042

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App