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

951 Sweet Creek Road
Eidson, TN 37731
Cynthia Jackson with Cynthia Bundren Jackson Realty, original listing - (423) 272-4400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2424 Square Feet
Agency: Cynthia Bundren Jackson Realty
Agency Phone: (423) 272-4400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: The name says it all: SWEET CREEK! As you drive the winding road by which SWEET creek flows, you have no idea of the SWEET surprise that awaits you. If you are looking for SWEET seculsion and SWEET views, this is the place for you. Nice home, acreage, plenty of indoor and outdoor entertaining space and wonderful views. The home is open concept with vaulted ceilings, a large stone gas fireplace in the living room and a wood burning stove. Dining area to the left of the amazing wood stairway and dining furniture conveys. Gourmet kitchen with island has granite countertops, a farmhouse sink, cooktop, dishwasher, refrigerator,double wall ovens, microwave and a large walk-in pantry. Laundry room/mud room is off the kitchen and connects to the attached 2 car garage with built-ins, a half bath and another refrigerator. Master is on the main level and has a walk-in closet, claw foot tub and walk-in shower. An open loft/office overlooks the living room with it's stone fireplace. This home is a wood lover's dream. 2 bedrooms and another full bath complete the upstairs. Lots of storage space. Covered front porch, screened-in back porch and back deck. The ''Pool House'' is not your traditional pool house. It has electricity and hot and cold running water. It has a full service kitchen with a pizza oven, sink, grill and refrigerator. One end of the building opens up for bar seating on the outside. The other end has an indoor bar with a sink. It overlooks the inground salt water pool. New pool pump and filter in July 2024. Propane heat, water heater, fireplace and range. It has a propane GENERAC generator and is situated on 6.33 acres. The grounds include a barn, 3 chicken coops a wood shed and a garden spot. Schedule an appointment to view this SWEET property soon! Information deemed reliable but not guaranteed. Buyer/buyer's agent to verify all information.
MlsNumber: --
ListingId: 9979037


Listing Provided By: Cynthia Bundren Jackson Realty, original listing
Phone: (423) 754-3502
Office Phone: (423) 272-4400
Agent Name: Cynthia Jackson
Disclaimer: Copyright © 2025 Tennessee Virginia Regional Multiple Listing Service. 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