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

1832 Highway 64
Benton, TN 37307
Melody Smith with KW Cleveland, original listing - (423) 303-1200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $734,500
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1279 Square Feet
Agency: KW Cleveland
Agency Phone: (423) 303-1200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: WELCOME TO THE PERFECT RETREAT ON 5+ ACRES OF WATERFRONT PROPERTY! Prime waterfront location offering endless possibilities for commercial ventures! This rare gem boasts breathtaking views and unparalleled access to water activities, making it an ideal destination for businesses seeking to capitalize on the allure of waterfront living. With its strategic location and versatile zoning, this property presents a unique opportunity for a variety of commercial endeavors, from upscale dining establishments and boutique shops to recreational facilities and event venues. This stunning home offers unparalleled views of the Ocoee River, seamlessly blending one level living with serene natural beauty. This meticulously designed home was built in 2021 and features 2 bedrooms, 2 bathrooms, high ceilings, and luxury vinyl flooring throughout. Entertaining guests in style with the open floor plan that includes a spacious kitchen, dining, and living areas. Every detail has been carefully crafted to create a space that is both functional and inviting. From the sleek granite countertops and the Kraftmaid cabinets that provide lots of storage and stylish finishes, this kitchen is sure to impress. Step outside onto the expansive screened back porch, where the views set the stage for unforgettable outdoor gatherings. Whether you're hosting a barbecue with friends or enjoying a quiet evening, this versatile space offers endless possibilities. Discover the ultimate workshop or studio space in this exterior entry basement, perfect for entrepreneurs, artisans, or hobbyists. The possibilities are endless for storage, crafting, woodworking, or whatever your heart desires. Indulge in waterfront living with direct access for canoeing, kayaking, fishing, or swimming. Don't miss this rare opportunity to own a piece of waterfront tranquility. Schedule your showing today and experience the ultimate in waterfront living!
MlsNumber: --
ListingId: 20240937


Listing Provided By: KW Cleveland, original listing
Phone: (423) 595-0199
Office Phone: (423) 303-1200
Agent Name: Melody Smith
Disclaimer: Copyright © 2024 River Counties 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