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

2114 Stonview Drive
Dandridge, TN 37725
Kesley Tucker with KES Realty, original listing - (865) 850-3332

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,890,000
Beds: 7
Baths: Full: 5, ½: 2
Status: Active
SqFt: 9800 Square Feet
Agency: KES Realty
Agency Phone: (865) 850-3332

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Nestled on the tranquil shores of Douglas Lake, this breathtaking lakefront masterpiece is the epitome of luxury and comfort. With a sprawling 9800 square feet of meticulously designed living space, this fully furnished sanctuary boasts every imaginable amenity to elevate your lakeside living experience. As you step inside, you're greeted by the grandeur of cathedral ceilings adorned with warm wood accents, seamlessly merging the natural beauty of the outdoors with the refined interiors. The standard 10-foot ceilings that gracefully enhance the sense of space and freedom are throughout the remaining areas of the home. The massive 10x12-inch beams magnificently adorn the home while adding tremendous strength to the structure. Elegance and craftsmanship are on full display with custom-made rod iron and wood chandeliers that illuminate the main floor, casting a soft glow over gatherings and creating an ambiance of sophistication. The carefully chosen materials, such as the reclaimed wood floors that span two levels and the custom handcrafted 2-inch thick solid doors throughout, elevate the aesthetic appeal of every corner. Indulge your culinary passions in the dual gourmet commercial kitchens, fully equipped with high-end appliances and adorned with rare exotic Brazilian stone countertops. The rich patina of copper sinks adds an elegant touch, while the custom solid wood cabinets provide ample storage for your culinary essentials. The lakefront oasis is perfect for relaxation and entertainment, boasting an expansive outdoor deck crafted from reclaimed wood, where you can bask in the sun's embrace or unwind beneath the stars. Enjoy the gentle sway of teak twin swings, a harmonious symphony of nature's melody. This lakeside haven offers not one but two slips on the dock, constructed with commercial-grade precision and crowned by a second-floor sun deck, providing stunning panoramic views of the lake. With 400 amps of electric service, no comfort or convenience has been spared. Discover your private retreat within the master suite, featuring a travertine-clad bathroom complete with a gas log fireplace, providing a serene ambiance for relaxation. The allure of eight fireplaces throughout the home beckons you to cozy up on chilly evenings. A custom movie theater with plush leather seating and optic fiber lighting offers an immersive cinematic experience, while the fully equipped walk-in butler's pantry with white granite countertops and copper prep sink ensures effortless entertaining. Embrace the pinnacle of technology with the integrated Sonos sound system that envelops the interior and outdoor spaces with premium audio quality. From the 11-foot hand forged copper hood vent to the Miami Dade Hurricane Rated Triple Thick glass windows and sliders, every detail has been carefully curated for both luxury and safety. Outside, the driveway is adorned with charming European Street Lights, guiding you to your exclusive haven. The attention to detail is further showcased with custom-made garage doors that beautifully complement the design language of the house, and a massive fountain centers the landscape. In every aspect, this lakefront gem redefines opulent living. Experience the artistry of design, the embrace of nature, and the epitome of comfort in this unrivaled 7-bedroom, 5-full bathroom, 2-half bathroom abode on Douglas Lake. Welcome to a life of unparalleled luxury.
MlsNumber: --
ListingId: 260899


Listing Provided By: KES Realty, original listing
Phone: (865) 850-3332
Office Phone: (865) 850-3332
Agent Name: Kesley Tucker
Disclaimer: Copyright © 2024 Great Smoky Mountains 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.


Local Real Estate Expert

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 = 2471 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;
Real Estate Expert Photo for Robert Tucker, Making Your Realty Dreams Reality
Robert Tucker, Making Your Realty Dreams Reality
ASCIIWeichert, Realtors - Tiger Real Estate
Call Today!: (865) 919-6831

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App