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

396 Brinkmeier Lane
Dayton, TN 37321

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3844
Agency: Exit Realty Stumbo & Co

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Introducing your dream summer retreat! This stunning waterfront property features a 2-bedroom, 2-bath main residence complemented by a quaint 1-bedroom, 1-bath guest cottage, all set on a sprawling 2-acre level lot. Experience the perfect fusion of luxury, comfort, and playful charm in this idyllic summer haven.<br /> <br /> As you enter the main house, an open-concept living area welcomes you, leading to a state-of-the-art gourmet kitchen. This kitchen boasts top-tier appliances, beautiful cabinetry, and a large custom concrete island, ideal for both entertaining and culinary creations. The primary bedroom is a sanctuary of space and relaxation, complete with a spa-inspired en suite that offers a zero-entry shower and extensive closet space.<br /> <br /> Adjacent to the living areas, an expansive sunroom provides a versatile space for both relaxation and entertainment, with direct access to the sun-drenched outdoors. The nearby guest cottage offers a cozy bedroom, a well-appointed bathroom, and a charming living area, making it perfect for hosting guests but giving them their own dedicated space. <br /> <br /> The highlight of this property is the outdoor space....inviting you to enjoy water sports, fishing, or simply basking in the sun along the almost 600' of shoreline. The level, well-maintained lot also provides ample space for outdoor activities, from gardening to playing with pets. Make sure to notice the unique and historically significant fencing brought in from the Chattanooga Choo Choo. Dream big - there's space for a pool in the back yard!<br /> <br /> This captivating waterfront sanctuary is not just a home; it's a lifestyle. Seize the opportunity to make lasting memories in this picturesque setting, where every day feels like a vacation. Act now—your personal paradise awaits, offering endless enchanting summer days.
MlsNumber: 20241587


Listing Provided By: Exit Realty Stumbo & Co, original listing
Name: Exit Realty Stumbo & Co
Phone: (423) 428-9181
Office Name: simpliHOM
Office Phone: (423) 428-9181
Agent Name: Angie Stumbo
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