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

535 Whitetail Road
Church Hill, TN 37642
Jil Piercy with Property Executives Johnson City, original listing - (423) 952-0226

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $589,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3774 Square Feet
Agency: Property Executives Johnson City
Agency Phone: (423) 952-0226

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Beautiful home in Lovely Deerfield Plantation Subdivision. Home features a very inviting setting with pretty mature trees all on 1.66 Acres of property with walking trail leading to top of property for nice view of nature. Inside this custom built home features a pretty foyer with an open spacious floor plan. Formal living room with tray ceiling and dining room area, all with lovely hardwood flooring. Kitchen with pretty wood cabinets and recently added Granite countertops with extended bar area , All new appliances, tile backsplash and newer lighting. A spacious Den with gas logs fireplace and vaulted ceilings , Pretty Sunroom with recently added low E windows and vinyl flooring. Laundry room on main with washer & Dryer to convey. Main level Owners suite features tray ceiling, hardwood floors and pretty bathroom with recently added Deep soaking tub and separate shower, Granite counter top, new lighting and a nice walk-in closet with shelving. Second level features 2 bedrooms , one full bathroom, nice setting room with overlook that looks over den area. Storage room and a walk-in attic area. Basement is partly finished and features den with fireplace and Full bathroom. Unfinished Basement area is spacious and has a garage door, workshop area and storage space. Outside of home features a back deck and lower patio perfect for relaxing and cooking out. Shed with more place for storage. Lovely trees and wildlife all around. Home is wired for security system. Spacious 2 Car garage. This home is a must see to appreciate. Main level and second floor of Home was painted in 2023, New Granite, sink and faucet, tile backsplash in Kitchen 2023. Some New lighting 2023, New Appliances in kitchen 2023, Owners main bathroom remodeled 2023 New tub and shower with new plumbing, granite counter top, faucets and lighting. Most lighting changed to LED bulbs. New wood flooring in Owners suite 2023. Buyer to verify all information, square footage is approximate and buyer to verify.
MlsNumber: --
ListingId: 9974835


Listing Provided By: Property Executives Johnson City, original listing
Phone: (423) 741-1182
Office Phone: (423) 952-0226
Agent Name: Jil Piercy
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