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

251 Fee Trail
Ewing, VA 24248
Dwayne Powell with Weichert Realtors Saxon Clark KPT, original listing - (423) 765-9118

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,990,000
Beds: 6
Baths: Full: 6
Status: Active
SqFt: 5900 Square Feet
Agency: Weichert Realtors Saxon Clark KPT
Agency Phone: (423) 765-9118

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 104 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2013
Notes: Come on out to your little piece of paradise!! Beautiful 360-degree view of mountains from this newly built 6-bedroom 6 bath home With a Full Kitchen in the Basement built for the nature lover. Buyers will assume current assessed value on property as per tax office - Buyer to verify. Mountain views from every room. The house has a very open floor plan, and a 3 Car attached Garage with an overhead Bonus Room has so many upgrades such as the two Geothermal Heat Pumps, 600 Amp Electric Service, the perfectly separated Pex Plumbing System, the house is built with 2X8 and 2X6 Walls. The breakfast Area is overlooking the serene park like setting again with the most awesome view of the mountains. This is only the tip of the many amenities that this property has to offer. See Photos... Other perks would be the Saltwater Pool, The Hot Tub is right outside the door of the Master Bedroom. The Metal Barn is neat, organized, clean and ready for the farm operation. You can drive a 4-wheel truck over the 104+/- Acres that has already been fenced. A survey will be required. The property has 2 ponds that are spring feed, one of which is a stocked pond. Check out the creek at the back of the property! On top of the property, you can see mountains for 100's of miles. Like it was stated previously this is a slice of paradise. You could raise a lot of cattle, have a really nice horse farm, create a beautiful Bed and Breakfast. There are simply so many possibilities. This is a custom-built Craftsman Home with amazing million-dollar views. It is located between Kentucky and Tennessee and only minutes to Shopping and Civilization. Pre-Approval Letter or Proof of Funds are required prior to any showings.
MlsNumber: --
ListingId: 9976559


Listing Provided By: Weichert Realtors Saxon Clark KPT, original listing
Phone: (423) 863-4514
Office Phone: (423) 765-9118
Agent Name: Dwayne Powell
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App