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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

19 Oak Leaf Circle
Fairfield Glade, TN 38558

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $747,500
Beds: 3
Baths: 3
Status: Active
SqFt: 2362
Agency: Glade Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: This exquisite, like new, 3 Bd 3 BA home is located in The Cottages of Hickory Ridge...Fairfield Glade's popular neighborhood with underground utilities and natural gas. Owners spared no expense in interior design with luxurious upgrades. Craftsman trim throughout, coffered ceilings, and tongue and groove wood stained ceiling on covered porch and front entry foyer. Inviting Great Room features coffered ceiling, tiled natural gas fireplace, engineered hardwood floors and custom built-in bookshelves. You'll love this fabulous kitchen with gorgeous granite counters, gas cooktop, soft-close cabinetry, large island breakfast bar and walk-in pantry. Spacious main level primary bedroom is highlighted by the spa-like en-suite bath featuring double sink vanity with granite counters, curbless tile shower and customized walk-in closet. Also on the main level is a guest bedroom and guest bath, office/study with built-in bookshelves ,and laundry room. Just off the great room is a fabulous screen porch featuring Trex decking and a dry-stack stone gas fireplace to enjoy this space nearly year 'round. The finished bonus room/ bedroom upstairs includes a full bath with shower. Main floor HVAC upgraded to a 95% efficient gas unit. A gas Generac generator has been installed with 200 amp auto transfer switch. Crawlspace is encapsulated with dehumidifier. Tankless water heater. Termite barrier system installed around perimeter of the home. Professional landscaping with underground sprinkler system, includes large stone patio with firepit in the backyard perfect for enjoying summer evenings. The Cottages POA includes mowing of lawns, edging around sidewalks, driveway and home perimeter, blowing, trimming of bushes, chemical application to lawn and leaf removal. You'll love living here with the freedom to travel and just ''lock the door and go''!
MlsNumber: 1258544


Listing Provided By: Glade Realty, original listing
Name: Glade Realty
Phone: (931) 484-3734
Office Name: Glade Realty
Office Phone: (931) 484-3734
Agent Name: Jane Wenger
Disclaimer: Copyright © 2024 Knoxville Area 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