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

2995 Laurel Hill Road
Henderson, TN 38340
Kim Gray with Five Star Real Estate Services, original listing - (731) 661-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3579 Square Feet
Agency: Five Star Real Estate Services
Agency Phone: (731) 661-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 70 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2001
Notes: If you’re an outdoor enthusiast searching for the perfect one of a kind custom built home located on just over 70 beautiful acres, then look no further … this is it! With 3,579 heated sq. ft, this 4 bedroom 2.5 bath with bonus room, sunroom, 4 car garage with insulated doors including heat and air on one side and beautiful front and reach porches overlooking the most beautiful country landscape imaginable won’t last long so be sure this one is at the top of your list to view! The home boasts a beautiful large kitchen with solid oak cabinets, large built in pantry with pull out drawers, large eat in kitchen area with tongue and groove sassafras wood on the walls, large great room with beautiful solid oak floors, cypress trim and ceiling beams with 15’ vaulted ceiling, sunroom with walnut tongue and groove walls overlooking a beautiful large screened in back porch with a stunning countryside view, beautiful large tile shower, jacuzzi tub and much more! The two large 2 car garages have plenty of space including closet space, work bench and even a half bath! You’ll also be getting a Yamaha generator with plug in and long power cord to maintain partial electricity if needed, 1,000 gallon buried propane tank, a beautiful gazebo with large walk in storm shelter that you can actually stay in overnight comfortably if you desire and a stainless Holland outdoor propane grill with side burner. There are multiple beautiful Nuttall Oak trees on this property, multiple enclosed deer stands, lots of wildlife, 24 x 36 shop with two 12’ roll up metal doors, storage shed with 3 large open bays and so much more! Schedule your private tour today and do not miss out on this one! All information is deemed accurate but not warranted by the seller, agent or company. All square footages including room sizes should be verified by a licensed appraiser. This document is to be used for reference only and is not a valid part of the sales contract.
MlsNumber: --
ListingId: 245222


Listing Provided By: Five Star Real Estate Services, original listing
Phone: (731) 234-3705
Office Phone: (731) 661-9000
Agent Name: Kim Gray
Disclaimer: Copyright © 2024 Central West Tennessee 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