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;

9312 Gabrielle Rd
Strawberry Plains, TN 37871
Debbie Williams with Southern Homes & Farms, LLC, original listing - (865) 471-0070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 3
Baths: Full: 2
Status: Pending
SqFt: 2132 Square Feet
Agency: Southern Homes & Farms, LLC
Agency Phone: (865) 471-0070

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: This 2021 custom built Underwood home has it all. Located on over an acre in the Lyons Creek Subdivision, this is a must see home. From year-round gardens to lavish outdoor living, this one of a kind deal won't last long. Nothing in this beautiful home is standard builder grade - upgraded, custom selections throughout!<br /> <br /> Look at this! Wood burning stove in Great Room with stone surrounding, spanning wall to ceiling.<br /> A beautiful trey ceiling in master bedroom with spacious master bath, including built-in storage, stone floors, walk-in closet, custom stone/tile walk-in shower, and separate water closet.<br /> <br /> The great room is open concept with hardwood floors, The kitchen features a large ''leathered'' granite top island for eating or prepping. Easily seats 4-6 people<br /> Multi-option separate area could be used as a formal dining area or a den-like sitting area. KitchenAid appliances include an induction stove with convection oven, double-door fridge, and dishwasher.<br /> Split bedroom floor plan. One bedroom is carpeted and includes a fold down queen size ''murphy bed'' that, when up, provides shelves. Room also has two large closets. Second spare room has hardwood floors and a spacious closet. Ideal for a home office.<br /> Second full bath between the two bedrooms stone floor and tile wall above tub and shower.<br /> Screened-in porch off the Great Room with stunning views of private yard, complete with large cement patio and built-in Weber gas grill ideal for entertaining.<br /> Grand front entry with stone pillars and extended front porch perfect for enjoying cool breezes on hot summer days.<br /> Upstairs is a carpeted bonus room big enough for guests, a playroom, or an extra den. Includes a closet with access to HVAC system and separate mini-split AC wall unit.<br /> Fixed, custom window shades and roman blinds throughout the home with ceiling fans in all rooms.<br /> Home Aqua-Clear water filtration system and alarm system by Safe and Sound.<br /> Laundry room complete with washer and dryer.<br /> Immaculate 2-car garage with separate side entry door. <br /> 15 minutes to University of Tennessee and Market Square, or a short drive to the Smokies, Pigeon Forge, Gatlinburg.<br /> <br /> Your dream house awaits and is move-in ready. Once you see it, you will say ''Welcome Home!''
MlsNumber: --
ListingId: 1279901


Listing Provided By: Southern Homes & Farms, LLC, original listing
Phone: (865) 765-0434
Office Phone: (865) 471-0070
Agent Name: Debbie Williams
Disclaimer: Copyright © 2024 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 = 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