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

151 Golden Road
Surgoinsville, TN 37873
Tonya Lee Estevez with Kornerstone Properties, original listing - (423) 327-9634

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2782 Square Feet
Agency: Kornerstone Properties
Agency Phone: (423) 327-9634

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Ready to escape to your own exclusive paradise with this remarkable 17.5 (+/-) acre riverfront property?? Stroll down to your very own riverbank (over apx 1500 feet) and enjoy all the water activities from fishing to boating on your private oasis. Overlooking the riverfront retreat is a beautifully built charming home features three spacious bedrooms and three bathrooms- with an extra bonus room off the kitchen. The bathroom off the kitchen also houses the washer and dryer. The rustic kitchen offers a space for eating in and lets you appreciate the inviting glow of the fireplace. Or enjoy a cozy evening by snuggling up in front of one of the other 3 inviting fireplaces (for a total of 4) creating the perfect ambiance throughout the home. Exposed beams, wood walls and hardwood floors throughout the home welcome you with open arms. The oversized stairs lead to a landing and 3 bedrooms. The primary room has a fireplace and ensuite bathroom. One of the bedrooms has the a fireplace, small balcony and the jack/jill bathroom that it shares bedroom. Step outside to your expansive covered porch, where you can soak in the serene views of the river and surrounding landscape. The leaf gutter system installed has a lifetime warranty. The propane tank onsite services the fireplaces and water heater. New windows have been installed in last year. There is also a small barn on property. When you are ready to relax and unwind- the saltwater pool is calling your name. It offers a refreshing refuge for relaxation and recreation under the sun or stars! No matter what you are looking for- this property could be perfect for you! Don't miss this unique opportunity to own a slice of happiness! Any and all information has been taken from the current owner and CRS. Information is deemed reliable but not guaranteed. Buyer and buyers agent to verify all information.
MlsNumber: --
ListingId: 705228


Listing Provided By: Kornerstone Properties, original listing
Phone: (423) 754-0752
Office Phone: (423) 327-9634
Agent Name: Tonya Lee Estevez
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