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

589 Harbor Point Road
Butler, TN 37640
Jerry Redden with Redden Realty, original listing - (423) 727-3021

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,049,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2995 Square Feet
Agency: Redden Realty
Agency Phone: (423) 727-3021

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: SPECTACULAR HOME WITH 2 FIREPLACES, ELEVATOR, 5 CAR GARAGE, LAKE VIEWS, LAKE ACCESS, NATIONAL FOREST AND MOUNTAIN VIEWS! This GRANDE home has a LARGE LIVING ROOM with STONE FIREPLACE TO 24 FOOT VAULTED CEILING, lots of windows with gorgeous views of Watauga lake, mountains and Cherokee national forest, WOOD FLOORS, GOURMET KITCHEN, BRIZILIAN GRANITE COUNTERTOPS AND LARGE ISLAND, JENN-AIR COOK TOP/OUTSIDE VENT, WET BAR, custom MAPLE WOOD CABINETS, counter lighting, PANTRY, BREAKFAST AREA, dining area, laundry room with sink & closet, , New elegant handmade wrought iron stair railing. HUGE MASTER BEDROOM SUITE with walk in closet, master bath, TWO SINKS, WALK IN SHOWER, SKYLIGHTS, tile floor, CIELO JETTED TUB with lake and mountain views, LARGE FAMILY/RECREATION OR BEDROOM WITH STONE FIREPLACE , lots of windows with lake, national forest & mountain views, SIMO DOORS & WIN DOWS, ARCHITECT SHINGLE ROOF, HUGH DECK, fenced yard, energy smart hot water heater, 5 CAR GARAGE- 3 CAR ATTACHED (30 FEET LONG) AND 2 CAR DETACHED GARAGE with attic & WORKSHOP, flood lights, NEW HEAT PUMP heat/air conditioning, public water, SKYBEST INTERNET SERVICE, LARGE PAVED DRIVEWAY with easy turn around, EASY ACCESS off paved road, LAKE ACCESS, walk to WATAUGA LAKE WITH COMMUNITY BOAT RAMP, SWIMMING DOCK AND TRAILER PARKING AND TURN AROUND! Close to Appalachian Trail, Doe Mountain Recreation Area, Boone, NC, Virginia Creeper Trail and Bristol Raceway! ENJOY WATAUGA LAKE FROM YOUR WRAP AROUND DECK OR FROM INSIDE THE HOME! TAKE YOUR PICK!! EXPERIENCE BEAUTIFUL SUNSETS ON THE LAKE, FISHING OR BOATING OR JUST ENJOY THE VIEWS OF THE MOUNTAINS SURROUNDING THE LAKE! Information to be verified by buyer/buyer's agent. Call to schedule your private showing.
MlsNumber: --
ListingId: 9979990


Listing Provided By: Redden Realty, original listing
Phone: (423) 512-1430
Office Phone: (423) 727-3021
Agent Name: Jerry Redden
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