Title Page Background
DEBUG FN args: Array ( [0] => 1591 [1] => [2] => [3] => agent ) BEFORE: Site: 1591 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1591 Igate: njhud LocID: 1591 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 = 1591 AND i.igate IN ('mohud','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 = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1591 [1] => [2] => [3] => lender ) BEFORE: Site: 1591 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1591 Igate: njhud LocID: 1591 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 = 1591 AND i.igate IN ('mohud','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 = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1591 [1] => [2] => [3] => other ) BEFORE: Site: 1591 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1591 Igate: njhud LocID: 1591 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 = 1591 AND i.igate IN ('mohud','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 = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

137 Slickrock Road
Branson West, MO 65737

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,900,000
Beds: 8
Baths:
Status: Active
SqFt: 12595 Square Feet
Agency: Weichert, Realtors-The Griffin Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Live the Good Life on table Rock Lake in this custom 12,000 SF home with tremendous views in all directions, fully furnished, heated indoor pool and spacious recreational areas, soaring ceilings, special features throughout from lighting fixtures, expansive kitchen and dining options. The Ozark Lifestyle of outdoor living includes two 17 x 30 decks with outdoor kitchen, hot tub, casual seating areas and magnificent views of Table Rock Lake, the Silver Dollar City Fireworks and Lights from the Chateau, the Harbor and more. The ''Smart'' home is equipped with an elevator for easy transportation to 3 floors of entertainment. Main floor boasts of an open floorplan where entertaining and having a house full of guests is delightful. The custom double wood doors enter the Foyer where you will stop and be amazed at the beauty of the home and the views. The wall of glass doors to deck are retractable. On Main Level: Great room, formal dining, gigantic kitchen, breakfast area, 2 islands, coffee-margarita bar, 2 living areas, 2 Master suites, an office/Bedroom and 3.5 baths. The Tower has 2 Bedrooms and 1 Bath and is an intriguing suite for guests. And Then the Lower Level via elevator or two sets of stairs: The most fun recreational game room with pool table, ping pong and arcade games (all included) and an additional private poker/wine room and kitchenette and Bar. Heated Indoor Pool with slide, Plus guests LOVE spending the night in the 3 bedrooms/3baths located on this level where all the fun is. Lower Level #3 is where you can find the Media/Theater room and 1/2 bath, all accessories are included. The Dock is down the hill with easy access with the side by side vehicles. The dock has a nice swim platform and you get the Boat slip with lift, pontoon boat, 2 jet skis on floating platforms and 2 side-by-sides. There will only be an Exclusion List of Owners' gifts and personal items. Everything is here to make your 1st Night a Night to Remember. Buyers qualifications required.
MlsNumber: --


Listing Provided By: Weichert, Realtors-The Griffin Company, original listing
Phone: (417) 338-4500
Office Phone: (417) 338-4500
Agent Name: La Nora Kay
Disclaimer: Copyright © 2024 Southern Missouri Regional MLS, LLC (SOMO). All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => stone [3] => MO [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: stone State: MO Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: stone State: MO 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 = 1591 AND i.igate IN ('mohud','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 = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Danielle Schmidt
Danielle Schmidt
ASCIITriple Diamond Real Estate
Call Today!: (417) 551-1328

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App