Title Page Background
DEBUG FN args: Array ( [0] => 2504 [1] => [2] => [3] => agent ) BEFORE: Site: 2504 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2504 Igate: njhud LocID: 2504 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2504 AND i.igate IN ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2504 [1] => [2] => [3] => lender ) BEFORE: Site: 2504 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2504 Igate: njhud LocID: 2504 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2504 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2504 [1] => [2] => [3] => other ) BEFORE: Site: 2504 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2504 Igate: njhud LocID: 2504 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2504 AND i.igate IN ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

604 Cherokee Orchard Rd
Gatlinburg, TN 37738
Ryan Coleman with Hometown Realty, LLC, original listing - (865) 693-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,599,000
Beds: 6
Baths: Full: 8, ½: 1
Status: Active
SqFt: 6309 Square Feet
Agency: Hometown Realty, LLC
Agency Phone: (865) 693-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 2023
Notes: An opportunity like no other! Check out this incredible new construction in the heart of downtown Gatlinburg close to all the action and attractions this highly sought area has to offer! Coming early 2025, is a professional pickleball and basketball court designed for endless enjoyment. This state-of-the-art space features daytime and nighttime glow lights, perfect for entertaining family and friends. A dedicated bar and food area adds to the convenience, creating a hub for fun and relaxation. With numerous area tournaments scheduled for 2025, this court is perfect for practicing and honing your skills right at home. With rental projections of $250,000 per year makes this cabin a perfect 1031 for the seasoned investor not to mention walking distance to downtown. This voluminous 6,309 SQFT residence will exceed every expectation with six bedrooms and multiple living spaces that easily accommodate every need. This sublime home invites you to indulge in moments of blissful relaxation with the most in-demand amenities including an indoor pool, game and theatre room plus multiple outdoor destinations including a hot tub with a view! A covered front porch surrounded by manicured landscaping grants a warm welcome into an amazing open concept layout with huge windows that drench the interiors in natural light while framing out spectacular vistas of the scenery by day and the lights of the strip come twilight. Imagine unwinding beside the linear stacked stone fireplace in the living room or savoring delectable meals in the huge dining room. Embrace the culinary delights of the amazing chef's kitchen anchored by an oversized island and accompanied by premium stainless steel appliances including a large double door refrigerator. Custom cabinets and pendant lighting truly exemplify elegant design in this stunning chef's suite! Soaring ceilings crown both the living room and kitchen, creating a larger than life feel that is so bright and spacious while inviting comfort for any activity. Even more opportunities for relaxation and recreation await as you venture further inside, starting in the upstairs landing which offers more seating as well as views over the living room. Next up is a phenomenal game room with theatre that includes tiered seating, while the indoor pool is the pièce de resistance, offering a place to swim and relax any time of year, along with a convenient bathroom changing room. Head outdoors where multiple alfresco lounges await your pleasure including a porch swing, while the hot tub is the perfect place to kick back and take in the sights. This sprawling residence sleeps 32 and every bedroom is like a little slice of paradise with plenty of space and contemporary style, from the bunk room to the private suites! This 1-year-young construction is a perfect peace-of-mind investment with fire sprinklers and a premier location within walking distance of plenty of shopping and entertainment options. There is lots of WOW packed in this beauty! Don't miss the opportunity to own a piece of paradise in Gatlinburg. Buyer to verify all information.
MlsNumber: --
ListingId: 1302165


Listing Provided By: Hometown Realty, LLC, original listing
Phone: (865) 693-7653
Office Phone: (865) 693-7653
Agent Name: Ryan Coleman
Disclaimer: Copyright © 2025 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 Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => sevier [3] => TN [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: sevier State: TN Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: sevier State: TN Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2504 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Aaron Ramsey NMLS#2478795
Aaron Ramsey NMLS#2478795
ASCIIFoundation Mortgage Company
Call Today!: (865) 603-9563

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App