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 = 1041 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1041 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1041 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

82 G Haselwood Rd
Summersville, KY 42782
Heizer Durrett with Durrett Realty Company, original listing - (270) 932-5651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $965,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2016 Square Feet
Agency: Durrett Realty Company
Agency Phone: (270) 932-5651

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 90 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2001
Notes: For Sale New Listing! 82 G Haselwood Rd. Summersville Ky 42782 Outstanding opportunity awaiting. Enjoy the country with this three bedroom, two bath brick home and 90 +/- acres with a recent survey. The home is in immaculate condition and has the following features: Three bedrooms, and two baths on the main floor, the master bath has a large tile shower, his/her sinks, and a large master closet. The kitchen has custom oak cabinets, ample counter space, large island, an adjoining dining area with room for a large family table as seen in the pictures. There is a 4th room that could be used as a bedroom which is currently used as a home office. Living room has plenty of room for entertainment and offers nice built-in book shelves. The laundry hook ups are on the main floor. The basement is finished and includes a large open den area, additional large bedroom, one full bath and the basement has tile flooring throughout. The 90 acre farm includes the following. 1. A large 60 x60 shop with concrete floors, a bathroom with shower. (2) 12ft overhead doors, (2) 14ft overhead doors. 2. A hay barn which is 54 x 48, with a 10 overhang. 3. A 58 x48 livestock. Barn has several pins, a working chute, loading area, and concrete flooring. 4. a 30 x 90 concrete feed pad or heavy use area. The land is mostly open with some wooded areas. For the most part this property is fenced in woven wire, with all wood post, there are some barbed wire fencing. Property was previously used for cattle but has recently been used for hay production. Farm does have a Richie automatic waterer. This is a rare chance to be able to purchase this type of property. These do not come to the market very often. If you're looking for a nice well kept, move in ready home with acreage don't fail to see this property. It is easy to see the owners have used and cared for this property to the best, and they are ready to slow down and let someone else enjoy and care for it. All info is believed to be correct but potential buyers should inspect to his/her satisfaction prior to submitting an offer.
MlsNumber: --
ListingId: 11504656


Listing Provided By: Durrett Realty Company, original listing
Phone: (270) 405-3329
Office Phone: (270) 932-5651
Agent Name: Heizer Durrett
Disclaimer: Copyright © 2025 My State MLS. 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 = 1041 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Mobile: (241) 555-1812
Beware of the Bear - Look I am a Hooman

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App