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;

1485 Sloans Gap Road
Ocoee, TN 37361

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1800
Agency: RE/MAX Real Estate Professional's

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2020
Notes: Welcome to the best that log home living has to offer. This absolutely gorgeous custom built log home is surrounded by 2.19 acres of a peaceful paradise. The curb appeal feels like a destination complete with the birds singing from the fruit trees, frogs croaking from the pond that is stocked with bass, redear, bluegill, grass carp and river catfish, squirrels scampering around the blueberry patch, and the rocking chair front porch to relax your cares away. All will enter through a solid Mahogany front door into an open floorplan highlighted by tongue and groove pine walls and ceilings, hand scraped hickory flooring, custom built shelves and desk and a fireplace complete with a heart pine mantle designed from a tree over 400 years old! It has a split bedroom plan and the bathrooms boast of large walk-in showers and unique vanities in both. The kitchen is a chef's dream boasting a wall convection oven, microwave convection combo, induction cooktop, granite counter tops, plenty of cabinetry, a breakfast area, and bar to enjoy a charcuterie tray and cocktail. The rear covered porch is designed for ultimate entertaining purposes featuring a firepit and a built-in propane grill. Additional interior features are a large laundry room with a pantry and water softener system. Exterior features a 3-car garage, matching the home's craftsmanship, which currently also serves as a workshop, covered area to protect lawnmowers or store hay bales, a fishing pond, and an abundance of outdoor space to play or bar-b-que. The 2 car is currently used as a woodworking dream shop. You can use it as a 3rd garage for all your toys or workshop. Remember you are just a few minutes away from the Cherokee National Forest for ultimate hiking or biking trails, the Ocoee River for the best in paddling or Parksville Lake for you boating pleasure. Ask your real estate agent for an up-to-date custom features list today!
MlsNumber: 20242032


Listing Provided By: RE/MAX Real Estate Professional's, original listing
Name: RE/MAX Real Estate Professional's
Phone: (423) 476-7300
Office Name: RE/MAX Real Estate Professionals
Office Phone: (423) 476-7300
Agent Name: Chuck Jones
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