Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Ward Real Estate

Property view
Listing view 2
Listing view 3

28957 Tr 240, 
Fresno, OH 43824

$1


3

Beds


2

Baths


-

Sq Ft


Single Family


Virtual Tour

Pending

Listed by

Curtis L Yoder

Kaufman Realty & Auction, LLC.

330-852-4111

Last updated:

October 18, 2026, 08:10 AM

MLS#

5239984

Source:

OH NORMLS

About This Home

28957 Tr 240

Live Auction 9/22/2026 6:00 PM - Parcels 1-5 - An exceptional property coming to auction in Fresno! Accessed through a gated private drive at the end of a dead-end township road, this property offers privacy, recreation, income potential, and quality improvements throughout. The log-sided home features a great room with floor to ceiling fireplace, kitchen, dining area, sunroom on the main floor, master bedroom with full bath in the loft area, and a finished walkout basement with 2 bedrooms and full bath. The home has had major renovations over the years and is turnkey ready to move in. The 36’x60’ bank barn features an elevated apartment complex on main level and lower level has stalls and enclosures for animals. Attached to the barn is a 26’x48’ shop garage building with 2 car storage on upper level and huge equipment storage area in the lower level with overhead doors and service pit. The shop building is heated and has A/C. Additionally there are different smaller barns and enclosures on the property. The home & buildings are all serviced by a natural gas 17KW backup generator, free gas from the wells. The land is a sportsmen’s paradise with hunting all set up including 14 total stands & blinds, established food plot and bedding areas, and proven hunting. Additionally, there is a beautiful, stocked pond, a 10’ high fenced deer pen, and a rifle & archery range. The land has a good balance of wooded and open farmland currently planted with a Vetch and tillage turnip cover crop. This land has excellent building sites and is a turnkey recreational dream land. Offered in 5 parcels, this property is a one of kind buying opportunity with so many details not yet described.. Join us for the preview and experience for yourself the seclusion, peacefulness, and privacy this farm offers!

Home Facts

Single Family

2 Baths

3 Bedrooms

Built in 1900

Price Summary

1

MLS #:

5239984

Last Updated:

October 18, 2026, 08:10 AM

Added:

1 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2


Structure

Structure

Year Built:

1900


Lot

Lot Size (Sq. Ft):

3,898,620


Finances & Disclosures

Finances

Price:

$1

MLS Logo
The information being provided by Mls Now is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 Mls Now All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.