
Land with Home for Sale in Fresno, Ohio
28957 Tr 240, Fresno, OH 43824
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.
Location
- Street address
- 28957 Tr 240
- County
- Coshocton County
- Zip code
- 43824
- School district
- Ridgewood LSD - 1602
- Elevation
- 1,086 feet
Directions
From Shanesville, head south on SR-93 for 10 miles, turning left onto TR-89. In one mile, turn right onto Ridge Rd SW, then left onto TR-240 or Bretzius Rd SW. Property is 0.4 miles down the driveway. Alternative address is best used to find the property from internet/map services: 8000 Bretzius Rd SW, Fresno OH 43824
Property details
- Acreage
- 89.5 acres
- MLS #
- NEOHREX 5220169
- Posted
Property taxes
- 2025
- $2,796
Parcels
- 0020000006300
Details and features
Listing
- Type
- Residential
- Subtype
- Single Family Residence
Exterior
- Parking
- Garage
Structure
- Stories
- 2
- Water
- Private, Well
- Sewer
- Private Sewer, Septic Tank
- Heating
- Forced Air, Natural Gas
- Cooling
- Central Air
- Materials
- Brick, Wood Siding
- Roof
- Metal
Interior
- Rooms
- Basement, Bathroom x 2, Bedroom x 3
- Fireplaces
- Yes
- Features
- Beamed Ceilings, Cathedral Ceilings, Granite Counters, Kitchen Island, Natural Woodwork, Open Floorplan, Pantry, Walk In Closets
Property utilities
| Category | Type | Status |
|---|---|---|
| Gas | Natural Gas | Connected |
Listing history
| Date | Event | Price | Change | Source |
|---|---|---|---|---|
| June 18, 2026 | New listing | $2,800,000 | — | NEOHREX |

















































