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 = 2488 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 2488 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 2488 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;

212 Douglas Ave
Sweetwater, TN 37874
Lucas Haun with Keller Williams Signature, original listing - (865) 588-9300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3973 Square Feet
Agency: Keller Williams Signature
Agency Phone: (865) 588-9300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 1965
Notes: This home offers a touch of design while keeping all the things we love about traditional homes. Into the home and off the marbled floor foyer, a large living space unfolds with vaulted ceilings, exposed beams, large windows flooding the space with natural light and the most beautiful granite fireplace and custom mantle to anchor the room. The rich hardwood floors - which continue throughout most of the home -flow into the formal dining room with glass front built-in china cabinet for displaying china and crystal and storage for all your serving trays. A study or home library with gorgeous custom millwork built-ins is the perfect spot for the residential bibliophile or deal maker! The more informal living space with the second granite fireplace and custom mantle is off of the library/office and offers direct access to the bright and light-filled sunroom with brick flooring as well as the eat-in kitchen. The kitchen is complete with a breakfast bar, custom cabinetry, double ovens, warming drawer, stainless high-end appliances (Thermador, Miele, & Wolfe), gas cook-top and plenty of granite counter space for prepping and creating fabulous meals. The primary suite is large with vaulted ceilings, access to a private deck, oversized windows for ample light and an attached bath offering dual sinks and walk-in tub. The remaining bedrooms and baths complete this main level as well as storage. SO much storage with a huge walk-in closet, linen and china closets plus an oversized laundry room that allows everything to have its place! The lower-level recreation room is the perfect spot for a teenage hangout, mancave or additional living space. The exterior offers decking and patio space for enjoying the outdoors and all the landscaping on this large level lot. Enjoy the gardens planted with dogwoods, roses, hydrangeas and more along the brick path. A large custom dog-run with iron fencing allows your four-legged friends to play and run in a safe and secure enclosure. An additional heated brick work shop has even more storage as well as a greenhouse and potting shed for flowers and plants to thrive all year long. This home is convenient to shopping and dining while still remote enough to feel off of the beaten path.
MlsNumber: --
ListingId: 1296371


Listing Provided By: Keller Williams Signature, original listing
Phone: (865) 694-5904
Office Phone: (865) 588-9300
Agent Name: Lucas Haun
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 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 = 2488 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 Danielle Belcher
Danielle Belcher
ASCIIRealty Executives
Call Today!: (386) 663-5504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App