Title Page Background
DEBUG FN args: Array ( [0] => 2438 [1] => [2] => [3] => agent ) BEFORE: Site: 2438 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2438 Igate: njhud LocID: 2438 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2438 [1] => [2] => [3] => lender ) BEFORE: Site: 2438 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2438 Igate: njhud LocID: 2438 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2438 [1] => [2] => [3] => other ) BEFORE: Site: 2438 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2438 Igate: njhud LocID: 2438 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

375 Glendale Road
Henderson, TN 38340
Tori Wilkerson with Hickman Realty Group Inc.-Jack, original listing - (731) 664-1006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3090 Square Feet
Agency: Hickman Realty Group Inc.-Jack
Agency Phone: (731) 664-1006

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Welcome to 375 Glendale Road, also affectionately known as Pierce Point. You won't find a more beautiful, manicured or pristinely cared for property. Only five minutes and two turns from downtown, you will love this private, 40-acre retreat in Henderson, TN. With fenced, wooded and open land, the possibilities are endless. <br /> The custom-built main house boasts 5 bedrooms, 3 full baths and 2 half baths (and an outdoor shower!). You will also find an office, formal and informal dining and separate laundry and mud room. All new stainless appliances, fresh paint, new lighting and updated flooring make this meticulously kept home like new and move in ready. Too many custom touches to mention!<br /> The second residence on the property can function as an in-law suite or Airbnb (as it has successfully done for the past five years as a top 5% rental) You will find this 2300 sqft barndominium has 630 well-appointed and functional square feet ready to move in with one bedroom, one bath and a full kitchen. There are also 770 heated and cooled square feet that could serve as a shop, hobby area, office or easily add on to the current living space. Lastly, the space has an additional 900 square feet custom built for RV storage with water, sewer and 50 amp electric service.<br /> Last, but definitely not least, you will find the outdoor spaces to be just as impressive as the indoor spaces and just as pristine. The extra large salt water pool and custom grilling area can literally be enjoyed from every direction. The sizeable covered back porch overlooks the pool where you will enjoy the most magnificent sunsets. A custom grilling area has been constructed with reclaimed brick accents from the historic Henderson Courthouse. With incredible landscaping and landscape lighting, you will find this to be a restful and relaxing retreat. If you like a little work with your leisure, utilize the high-tinsel fenced area of the property with chute and work pen for livestock. There is also beautiful split rail fencing along the road and drive. You will find the 30x50 pole barn on the property perfect for hay, tractor or implement storage. There are trails throughout this well-manicured property making it easy to navigate and enjoy. <br /> If a move in ready country oasis is what you need, you have found it! Also, take advantage of the opportunities to make this an income producing property-whether it is farming or airbnb'ing....the sky is the limit, and I can't wait for you to see this big, beautiful sky in Henderson, TN.
MlsNumber: --
ListingId: 2500850


Listing Provided By: Hickman Realty Group Inc.-Jack, original listing
Phone: (731) 664-1006
Office Phone: (731) 664-1006
Agent Name: Tori Wilkerson
Disclaimer: Copyright © 2025 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