Quality thruout, custom blt home feat 3200 sf. Home sits on 3.234 ac priv setting w/pond. 1st flr mstr br, 5 bths. Hdwd flrs, lg eat-in kit, brkfst rm area. Frml DR, 2 stone fps, Frml LR w/w-out to deck area, finished LL w/wet bar, fam rm, rec rm.
Single-familyProperty Type
1999Year Built
3.23 acresLot Size
$240Est. Price/Sq.Ft.
2 car garageParking
Listed by Regina Hamilton• Sibcy Cline Harrison
•513-615-1517 (agent)
•teamhamilton@sibcycline.com (agent)
•513-367-1900 (broker)
•ssabato@sibcycline.com (broker)
Listed by Gary Hamilton• Sibcy Cline Harrison
•513-367-1900 (broker)
•ssabato@sibcycline.com (broker)
Bought with Dianna Caldwell• RE/MAX Affiliates Two
•513-421-0345 (broker)
•KentDailey@remax.net (broker)
Source:Cincy MLS #1458686
Redfin Estimate
$763,984
$184K since sold in April 2021$1,000 since September
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 58.2% higher than the average sale price ($483K) of 6 comparable homes.
Quality thruout, custom blt home feat 3200 sf. Home sits on 3.234 ac priv setting w/pond. 1st flr mstr br, 5 bths. Hdwd flrs, lg eat-in kit, brkfst rm area. Frml DR, 2 stone fps, Frml LR w/w-out to deck area, finished LL w/wet bar, fam rm, rec rm.
Public Records
Mar 26, 1997
Sold
$45,000
$14/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$11,693 (+7.7%)
$31,133 + $171,868
$203,001
2024
$10,855 (−0.5%)
$31,133 + $171,868
$203,001
2023
$10,910 (−6.8%)
$31,133 + $171,868
$203,001
2022
$11,706 (+2.1%)
$30,594 + $144,932
$175,526
2021
$11,470 (−0.9%)
$30,594 + $144,932
$175,526
2020
$11,577 (+10.1%)
$30,594 + $144,932
$175,526
2019
$10,516 (+11.5%)
$25,928 + $122,822
$148,750
2018
$9,432 (+5.5%)
$25,928 + $122,822
$148,750
2017
$8,942 (+16.6%)
$25,928 + $122,822
$148,750
2016
$7,669 (−1.0%)
$25,904 + $99,785
$125,689
2014
$7,750 (−0.2%)
$25,904 + $99,785
$125,689
2013
$7,764
$27,265 + $105,035
$132,300
Tax history for 9195 Brehm Rd
Year
Property tax
Land + Additions
Assessment*
2025
$11,693 (+7.7%)
$31,133 + $171,868
$203,001
2024
$10,855 (−0.5%)
$31,133 + $171,868
$203,001
2023
$10,910 (−6.8%)
$31,133 + $171,868
$203,001
2022
$11,706 (+2.1%)
$30,594 + $144,932
$175,526
2021
$11,470 (−0.9%)
$30,594 + $144,932
$175,526
2020
$11,577 (+10.1%)
$30,594 + $144,932
$175,526
2019
$10,516 (+11.5%)
$25,928 + $122,822
$148,750
2018
$9,432 (+5.5%)
$25,928 + $122,822
$148,750
2017
$8,942 (+16.6%)
$25,928 + $122,822
$148,750
2016
$7,669 (−1.0%)
$25,904 + $99,785
$125,689
2014
$7,750 (−0.2%)
$25,904 + $99,785
$125,689
2013
$7,764
$27,265 + $105,035
$132,300
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Property details
Interior
Basement Information
Basement Sq. Ft: 1,983
Basement Type: Full
Bathroom Information
# of Full Baths: 3
# of 1/2 Baths: 1
Heating & Cooling
Air Conditioning Type: Central
Heating Fuel Type: Electric/Oil
Room Information
# of Rooms: 8
Exterior
Exterior Information
Physical Condition: Average
Building Style Type: Conventional
Exterior Wall: Frame/Masonry
Property Information
Subdivision Name: OPEN RANGE ESTATES SUB
Living Sq. Ft: 3,181
Ground Floor Sq. Ft: 1,983
Building Sq. Ft: 5,777
# of Stories: 2
Legal Description: BREHM RD 20 X FT IRR LOT 16 L A FLEISCH BAUERNHOF OPEN RANGE ESTATES SUB
Parking & Garage Information
Parking Type: Frame Garage
Garage/Parking Sq. Ft: 613
Garage / Carport Type: Frame
Lot Information
# of Buildings: 1
Land Sq. Ft: 140,873
Legal Lot Number: 16
Municipality Name: COLERAIN TOWNSHIP
Acres: 3.234
Front Footage: 20
County Use Description: RESID-SINGLE FAMILY
State Use Description: SINGLE FAMILY
Utility Information
Electricity / Wiring Type: Connected
Sewer Type: Septic
Financial
Assessor Information
Assessment Year: 2025
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 3,181
Stories: 2.0
Lot Size: 3.23 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Hamilton County
APN: 5100240015100
Home facts updated by county records on Jul 20, 2026
Around this home
Schools
Colerain Elementary School
Public K-5 • Assigned • 0.7mi
6/10
Colerain Middle School
Public 6-8 • Assigned • 0.7mi
6/10
Colerain High School
Public 9-12 • Assigned • 1.4mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 103° expected this year, 18 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Cincinnati, OH • 45252
Average low and high temperatures (°F)
34
17
43
25
62
39
69
47
71
53
82
64
87
69
82
62
81
56
70
46
54
38
43
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.3 hours in
June and 3.2 hours in December, placing it below the
U.S. average for solar exposure.
9.3 hrs
3.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$726,000 – $879,000
Reach more buyers when you sell with Redfin. Save up to $7,640 in fees.3 minutes to get started.