28957 TR 240
28957 TR 240 photo 2
28957 TR 240 photo 3
28957 TR 240 photo 4
28957 TR 240 photo 5
28957 TR 240 photo 6
28957 TR 240 photo 7
28957 TR 240 photo 8
28957 TR 240 photo 9
28957 TR 240 photo 10
28957 TR 240 photo 11
28957 TR 240 photo 12
28957 TR 240 photo 13
28957 TR 240 photo 14
28957 TR 240 photo 15
28957 TR 240 photo 16
28957 TR 240 photo 17
28957 TR 240 photo 18
28957 TR 240 photo 19
28957 TR 240 photo 20
28957 TR 240 photo 21
28957 TR 240 photo 22
28957 TR 240 photo 23
28957 TR 240 photo 24
28957 TR 240 photo 25
28957 TR 240 photo 26
28957 TR 240 photo 27
28957 TR 240 photo 28
28957 TR 240 photo 29
28957 TR 240 photo 30
28957 TR 240 photo 31
28957 TR 240 photo 32
28957 TR 240 photo 33
28957 TR 240 photo 34
28957 TR 240 photo 35
28957 TR 240 photo 36
28957 TR 240 photo 37
28957 TR 240 photo 38
28957 TR 240 photo 39
28957 TR 240 photo 40
28957 TR 240 photo 41
28957 TR 240 photo 42
28957 TR 240 photo 43
28957 TR 240 photo 44
28957 TR 240 photo 45
28957 TR 240 photo 46
28957 TR 240 photo 47
28957 TR 240 photo 48
28957 TR 240 photo 49
28957 TR 240 photo 50
50 photos

$2,800,000

28957 TR 240
Fresno, OH 43824
Listed by Curtis L Yoder · Kaufman Realty & Auction, LLC.
Bedrooms
3
Bathrooms
2
Living area
1,522 sqft
Year built
1900

About this home

Exceptional 89.5± acre turnkey estate and sportsman’s paradise in the heart of Ohio’s Amish Country. Accessed by 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 farmhouse, completely remodeled in 2000, features approximately 1,522 sq. ft., 3 bedrooms, 2 full baths, a vaulted great room with exposed hand-hewn beams, massive stone fireplace, granite kitchen, sunroom, walkout basement, security system, whole-house Generac generator, natural gas service, and updated HVAC, windows, and doors. Improvements include a 60’x36’ bank barn with finished apartment and entertainment area, a 48’x26’ heated and cooled two-story shop/garage with service pit, plus additional outbuildings. Approximately 50 acres of productive tillable ground provide income potential and are currently leased for farming operations. Outdoor amenities include miles of maintained trails, a 450-yard rifle range, 70-yard archery range, food plots, deer stands, feeders, orchards, berry patches, and exceptional wildlife habitat. A spring-fed stocked pond offers fishing for bass, trout, catfish, and bluegill. Additional features include fenced pastures, deer enclosure, invisible pet fence, two drilled wells, developed springs, water filtration system, and free natural gas from on-site wells. Mineral rights transfer with the sale. Ideal as a private residence, hunting retreat, family compound, corporate getaway, or recreational investment property. Properties of this caliber seldom become available. Combining luxury living, productive farmland, valuable mineral rights, free natural gas, exceptional hunting, fishing, and shooting amenities, this turnkey estate offers a unique opportunity for a private family retreat, executive getaway, or legacy property to be enjoyed for generations. Property Video: https://www.youtube.com/watch?v=oAeJg6A1Bjo

Highlights

Fireplace

Property details

MLS #
5220169
Property type
SingleFamilyResidence
Subdivision
N/A
Status
Active
Days on market
14
On market date
N/A
Stories
2
Garage spaces
4
Lot size
89.5 acres
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

Elementary
Baltic Elementary School
4.84 mi away · Grades 0-6
Nearest school -- attendance-zone data not available here
3.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
136
Student:teacher ratio
17.0:1
District
Garaway Local
Middle
Ridgewood Middle School
7.39 mi away · Grades 4-7
Nearest school -- attendance-zone data not available here
2.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
360
Student:teacher ratio
18.9:1
District
Ridgewood Local
High
Ridgewood High School
7.54 mi away · Grades 8-12
Nearest school -- attendance-zone data not available here
2.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
493
Student:teacher ratio
19.0:1
District
Ridgewood Local

Mortgage calculator

Estimate only — actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$17,012/mo
$560,000 down
$2,240,000 loan
Principal & interest$14,529
Property tax (est.)$2,333
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by NOWDD via Trestle/CoreLogic. Last updated July 2, 2026.

Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.