Equestrian estate on 50 acres just minutes to the highway. This Americana-inspired farmhouse overlooks a picturesque 3-acre pond, primary suites on both floors, Florida room, sunroom, and a beautifully renovated kitchen. This home does such a beautiful job of holding on to the timeless charm, while carrying modern updates. The property includes two barns, Barn 1 is insulated with 6 12x12 stalls, a h/c wash rack, cedar-lined tack room, feed room with w/d, and storage for shavings and hay. The Second has 4 stalls with workshop. There is an outdoor arena, perm. roundpen, and 4 pastures. Enjoy scenic groomed trails through the woods leading to a peaceful creek and two crop fields ideal for hay, farming, or pasture. Next to the barn is a 2 bd 1 bath home ready for your finishing touches. Perfect for caretaker for a family compound. The 4 car Carriage house is oversized with a loft, 1/2 bath, and dog kennels/ runs. There are so many opportunities waiting for you. No viewing W/O appointment
Details
MLS #
1888576
Listing Type
For Sale
Style
Farm or Ranch
Sub-Type
Resale
Status
Active
Year
1960
Days On Site
95
Listing Provided By
eXp Realty | Jessica Bloom
Features
Bed(s)
5
Bath(s)
5 Total
SQ Feet
4,057
Garage
6
Basement
Y
Story(s)
2
Zoning
Agricultural
Acreage
49.63
Property View
Lake, Pond
Interior
Rooms Total
13
Heating
Baseboard, Mini-Split, Heat Pump
Cooling
Central Air, Mini-Split
Window Features
Vinyl, Wood
Appliances
Dishwasher, Microwave, Oven/Range, Refrigerator
Interior Features
Natural Woodwork
Fireplace Features
Wood
Fireplaces Total
1
Exterior
Roof
Shingle
Exterior Features
Covered Deck/Patio, Enclosed Porch, Patio, Porch
Construction Materials
Brick
Topography
Cleared, Lake/Pond, Level, Pasture, Rolled
Foundation Details
Slab
Parking
Parking Features
Gravel
Utilities
Sewer
Aerobic Septic
Gas
None
Taxes
Property
5041
Area Information
State
OH
County
Warren
City
Franklin
Zip Code
45005
Area
Warren E15
Subarea
Warren E15
Community Name
Franklin
School District
Franklin City SD
High School
Franklin City SD
Listing VS Median (in Franklin)
Price: $1,490,000
low | high
Med: $219,950
100% of Average
sqft: 4,057
low | high
Med: 1,598
100% of Average
$ / sqft: $367
low | high
Med: $138
100% of Average
On site: 95
low | high
Med: 27.5
100% of Average
Sourced by Back At You
Market Activity 45005
Date
Sales
Avg $ Per SqFt
Min Sale Price
Max Sale Price
Med Sale Price
Date: Sep 2026
Sales: 8
Avg $ Per SqFt: $175.43
Min Sale Price: $137,000
Max Sale Price: $389,900
Med Sale Price: $230,000
Date: Aug 2026
Sales: 22
Avg $ Per SqFt: $178.37
Min Sale Price: $63,800
Max Sale Price: $763,624
Med Sale Price: $282,000
Date: Jul 2026
Sales: 25
Avg $ Per SqFt: $170.89
Min Sale Price: $170,000
Max Sale Price: $742,829
Med Sale Price: $315,000
Date: Jun 2026
Sales: 27
Avg $ Per SqFt: $162.82
Min Sale Price: $35,000
Max Sale Price: $725,000
Med Sale Price: $288,000
Date: May 2026
Sales: 38
Avg $ Per SqFt: $182.22
Min Sale Price: $60,000
Max Sale Price: $620,000
Med Sale Price: $270,000
Date: Apr 2026
Sales: 23
Avg $ Per SqFt: $185.88
Min Sale Price: $40,000
Max Sale Price: $647,295
Med Sale Price: $272,000
Date: Mar 2026
Sales: 22
Avg $ Per SqFt: $188.2
Min Sale Price: $85,000
Max Sale Price: $600,000
Med Sale Price: $265,000
Date: Feb 2026
Sales: 21
Avg $ Per SqFt: $179.29
Min Sale Price: $40,000
Max Sale Price: $800,000
Med Sale Price: $230,000
Date: Jan 2026
Sales: 15
Avg $ Per SqFt: $151.07
Min Sale Price: $169,000
Max Sale Price: $512,000
Med Sale Price: $263,000
Date: Dec 2025
Sales: 12
Avg $ Per SqFt: $151.91
Min Sale Price: $79,000
Max Sale Price: $670,000
Med Sale Price: $272,450
Date: Nov 2025
Sales: 20
Avg $ Per SqFt: $182.43
Min Sale Price: $134,000
Max Sale Price: $519,000
Med Sale Price: $271,000
Sourced by Back At You
Sep 2026
Sales:
8
Avg $ Per SqFt:
$175.43
Min Sale Price:
$137,000
Max Sale Price:
$389,900
Med Sale Price:
$230,000
Aug 2026
Sales:
22
Avg $ Per SqFt:
$178.37
Min Sale Price:
$63,800
Max Sale Price:
$763,624
Med Sale Price:
$282,000
Jul 2026
Sales:
25
Avg $ Per SqFt:
$170.89
Min Sale Price:
$170,000
Max Sale Price:
$742,829
Med Sale Price:
$315,000
Jun 2026
Sales:
27
Avg $ Per SqFt:
$162.82
Min Sale Price:
$35,000
Max Sale Price:
$725,000
Med Sale Price:
$288,000
May 2026
Sales:
38
Avg $ Per SqFt:
$182.22
Min Sale Price:
$60,000
Max Sale Price:
$620,000
Med Sale Price:
$270,000
Apr 2026
Sales:
23
Avg $ Per SqFt:
$185.88
Min Sale Price:
$40,000
Max Sale Price:
$647,295
Med Sale Price:
$272,000
Mar 2026
Sales:
22
Avg $ Per SqFt:
$188.2
Min Sale Price:
$85,000
Max Sale Price:
$600,000
Med Sale Price:
$265,000
Feb 2026
Sales:
21
Avg $ Per SqFt:
$179.29
Min Sale Price:
$40,000
Max Sale Price:
$800,000
Med Sale Price:
$230,000
Jan 2026
Sales:
15
Avg $ Per SqFt:
$151.07
Min Sale Price:
$169,000
Max Sale Price:
$512,000
Med Sale Price:
$263,000
Dec 2025
Sales:
12
Avg $ Per SqFt:
$151.91
Min Sale Price:
$79,000
Max Sale Price:
$670,000
Med Sale Price:
$272,450
Nov 2025
Sales:
20
Avg $ Per SqFt:
$182.43
Min Sale Price:
$134,000
Max Sale Price:
$519,000
Med Sale Price:
$271,000
MLS Number: 1888576
Jessica Bloom – jbloom.equilux@gmail.com
eXp Realty – (216) 242-2322
Request a showing
Request a showing
The information is being provided by CincyMLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 CincyMLS. All Rights Reserved.