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

704 Union Mcminn Rd
Niota, TN 37826

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 3190
Agency: Billy Houston Group, Realty Executives

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Are you looking for the perfect home in the country? Do NOT let this gem pass you by. The views and peaceful quietness alone are amazing. Beautiful covered front porch with stone accents and wood with plenty of room for rocking chairs, a swing and a table. Outside you will also find an in-ground, fenced in Saltwater pool along with a fenced in yard with plenty of room to roam whether it's you, the kids or fur babies. Hardwood floors greet you in the foyer and continue through out the home with the exception of Vinyl in the wet areas. The wood, tongue and grove cathedral ceiling in the great room not only makes it feel bigger but also gives it a rustic feel, while also having the balcony across the second floor where you can easily see or talk to one another. You are also met with a formal dining room as well as an office area. Gorgeous!! For the cook in the family, they will not want to miss out on this open Kitchen with ample cabinet space and an island and pantry. Appliance include a 5 burner gas cook top, 2 ovens & warming drawer, ice maker, trash compactor and eat in kitchen/breakfast area. The sink in the island makes prep work a breeze when cooking. The Walk in Utility/Laundry room has a sink with plenty of storage and a drying rack! Do not pass by the sunroom as you can enjoy this area year round and look at the views and enjoy all that is going on outside. This house flows perfect. Also on the main level you will find the owner suite with an en suite that, again, has ample storage space and a separate double vanity with both a walk in shower and a soaking tub. Upstairs you will find two oversized bedrooms with window seats and a hallway with a nook for you to sit a chair, make a bookshelf, gym equipment, whatever your heart desires. There is also another full bath and double vanity as well, it is an over sized bathroom and has room for everyone to get ready. Outside the back door, on one side...you will find a covered patio area where the pool is visible and you are still a part of the action while on the other side you will find an open deck for sunbathing or just enjoying the sun in general. Concrete patio area around the pool as well to help keep grass out. Also on this 5 acre FENCED property you will find an 8 stall barn with tack/feed room and a hay loft. You do NOT want to miss out on this beauty. <br /> Schedule your private appointment today! We look forward to seeing you!
MlsNumber: 1262305


Listing Provided By: Billy Houston Group, Realty Executives, original listing
Name: Billy Houston Group, Realty Executives
Phone: (865) 577-7653
Office Name: Billy Houston Group, Realty Executives
Office Phone: (865) 577-7653
Agent Name: Billy Houston
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 = 2485 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;
Dennis Opp, Broker Owner and Betty Hiefnar-Messer Managing Broker
ASCIIEXIT Provision Realty
Dennis: (423) 240-0231
Betty: (423) 595-8970

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App