Wendy Goldfinger
Responds Quickly
Howard Hanna Real Estate Serv
(513) 854-8841
117 Total Sales
1 in Colerain
$165,000 Price
9160 Brehm Rd Cincinnati, OH 45252
Colerain AreaEstimated Value: $441,000 - $519,000
5
Beds
4
Baths
2,226
Sq Ft
$217/Sq Ft
Est. Value
Highlights
- Gourmet Kitchen
- Ranch Style House
- Wood Flooring
- Family Room with Fireplace
- Cathedral Ceiling
- No HOA
About This Home
As of June 2025Spacious Brick Ranch with Exceptional Features: Welcome to this impressive nearly 4100 sq ft ranch offering five bedrooms and four bathrooms. Designed for comfortable living and entertaining, this home boasts a great room with a cathedral ceiling and wood - burning fireplace. The breakfast room opens to a sprawling 22'x14' covered deck, perfect for outdoor relaxation. The finished walk-out lower level offers a 27' family room with another wood - burning fireplace, a wet bar for entertaining, a 31' recreation room, and two additional bedrooms. You will love the country setting and the convenient location.
Last Agent to Sell the Property
RE/MAX Victory + Affiliates License #0000426400 Listed on: 04/14/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,688
Year Built
- Built in 1993
Lot Details
- 43,429 Sq Ft Lot
- Lot Dimensions are 183x273
Parking
- 2 Car Attached Garage
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 2,226 Sq Ft Home
- Woodwork
- Cathedral Ceiling
- Ceiling Fan
- Recessed Lighting
- Wood Burning Fireplace
- Brick Fireplace
- Double Hung Windows
- French Doors
- Panel Doors
- Family Room with Fireplace
- 2 Fireplaces
- Living Room with Fireplace
- Wood Flooring
- Fire and Smoke Detector
Kitchen
- Gourmet Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Solid Wood Cabinet
Bedrooms and Bathrooms
- 5 Bedrooms
- 4 Full Bathrooms
- Bathtub and Shower Combination in Primary Bathroom
Finished Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
Outdoor Features
- Covered Deck
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- 220 Volts
- Propane
- Electric Water Heater
- Aerobic Septic System
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 14, 2025
Closed on
Jun 2, 2025
Sold by
Smith Jeremy and Smith Diana
Bought by
Seller's Agent
David Davidson
RE/MAX Victory + Affiliates
Buyer's Agent
Courtne Brass
Coldwell Banker Realty
List Price
$479,000
Sold Price
$465,000
Premium/Discount to List
-$14,000
-2.92%
Views
33
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$18,095
Avg. Annual Appreciation
3.08%
Original Mortgage
$441,750
Outstanding Balance
$436,694
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$46,401
Purchase Details
Listed on
Jul 24, 2019
Closed on
Sep 26, 2019
Sold by
Yeaw Glenn and Bernert Silke A
Bought by
Smith Jeremy and Smith Diana
Seller's Agent
June Newman
Coldwell Banker Realty
Buyer's Agent
David Davidson
RE/MAX Victory + Affiliates
List Price
$319,000
Sold Price
$317,000
Premium/Discount to List
-$2,000
-0.63%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.99%
Original Mortgage
$311,258
Interest Rate
3.12%
Mortgage Type
FHA
Purchase Details
Listed on
Apr 11, 2017
Closed on
May 16, 2017
Sold by
Williams Jeannette W and Williams Joseph R
Bought by
Yeaw Glenn and Bernert Silke A
Seller's Agent
Edward Detzel
E.G. Detzel, REALTORS
Buyer's Agent
June Newman
Coldwell Banker Realty
List Price
$269,900
Sold Price
$270,000
Premium/Discount to List
$100
0.04%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.98%
Original Mortgage
$278,910
Interest Rate
4.08%
Mortgage Type
VA
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Wendy Goldfinger
-
Judith Maiden
Judith Maiden
Comey & Shepherd
(513) 866-8614
66 Total Sales
1 in Colerain
$119,900 Price
-
Anthony Auciello
Anthony Auciello
Responds QuicklyRE/MAX Preferred Group
(513) 802-9715
67 Total Sales
4 in Colerain
$128K - $540K Price Range
-
Quintin Suggs
Quintin Suggs
Pivot Realty Group, LLC
(513) 572-3260
93 Total Sales
2 in Colerain
$150K - $153K Price Range
-
Gina Dubell-Smith
Gina Dubell-Smith
eXp Realty
(513) 854-9142
263 Total Sales
2 in Colerain
$105K - $385K Price Range
-
Craig Steele
Craig Steele
Plum Tree Realty
(513) 666-5497
41 Total Sales
1 in Colerain
$160,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $465,000 | None Listed On Document | ||
| Smith Jeremy | $317,000 | None Available | |
| Yeaw Glenn | $270,000 | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $441,750 | ||
| Previous Owner | Smith Jeremy | $311,258 | |
| Previous Owner | Yeaw Glenn | $278,910 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/02/2025 06/02/25 | Sold | $465,000 | -2.9% | $209 / Sq Ft | |
| 04/17/2025 04/17/25 | Off Market | $479,000 | -- | -- | |
| 04/15/2025 04/15/25 | Pending | -- | -- | -- | |
| 04/15/2025 04/15/25 | Off Market | $479,000 | -- | -- | |
| 04/14/2025 04/14/25 | For Sale | $479,000 | +51.1% | $215 / Sq Ft | |
| 01/02/2020 01/02/20 | Off Market | $317,000 | -- | -- | |
| 10/03/2019 10/03/19 | Sold | $317,000 | -0.6% | $142 / Sq Ft | View Prior Sale |
| 09/05/2019 09/05/19 | Pending | -- | -- | -- | |
| 08/30/2019 08/30/19 | For Sale | $319,000 | +0.6% | $143 / Sq Ft | |
| 08/16/2019 08/16/19 | Off Market | $317,000 | -- | -- | |
| 08/06/2019 08/06/19 | Pending | -- | -- | -- | |
| 07/31/2019 07/31/19 | For Sale | $319,000 | 0.0% | $143 / Sq Ft | |
| 07/24/2019 07/24/19 | Pending | -- | -- | -- | |
| 07/24/2019 07/24/19 | For Sale | $319,000 | +18.1% | $143 / Sq Ft | |
| 08/17/2017 08/17/17 | Off Market | $270,000 | -- | -- | |
| 05/19/2017 05/19/17 | Sold | $270,000 | 0.0% | $121 / Sq Ft | View Prior Sale |
| 04/15/2017 04/15/17 | Pending | -- | -- | -- | |
| 04/11/2017 04/11/17 | For Sale | $269,900 | -- | $121 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $7,020 | $121,989 | $14,280 | $107,709 |
| 2024 | $6,507 | $121,989 | $14,280 | $107,709 |
| 2023 | $6,547 | $121,989 | $14,280 | $107,709 |
| 2022 | $6,217 | $94,500 | $11,900 | $82,600 |
| 2021 | $6,414 | $94,500 | $11,900 | $82,600 |
| 2020 | $6,229 | $94,500 | $11,900 | $82,600 |
| 2019 | $6,669 | $94,500 | $11,900 | $82,600 |
| 2018 | $5,981 | $94,500 | $11,900 | $82,600 |
| 2017 | $5,665 | $94,500 | $11,900 | $82,600 |
| 2016 | $4,714 | $77,560 | $11,970 | $65,590 |
| 2015 | $4,760 | $77,560 | $11,970 | $65,590 |
| 2014 | $4,768 | $77,560 | $11,970 | $65,590 |
| 2013 | $4,776 | $81,641 | $12,600 | $69,041 |
Source: Public Records
Agents Affiliated with this Home
-
David Davidson
Seller's Agent in 2025
David Davidson
RE/MAX
(513) 839-0281
38 Total Sales
-
Courtne Brass
Buyer's Agent in 2025
Courtne Brass
Coldwell Banker Realty
(513) 314-9447
242 Total Sales
-
June Newman
Seller's Agent in 2019
June Newman
Coldwell Banker Realty
(513) 205-0614
62 Total Sales
-
ED
Seller's Agent in 2017
Edward Detzel
E.G. Detzel, REALTORS
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1836995
APN: 510-0240-0169
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 5585 Springdale Rd
- 5638 Springdale Rd
- 5778 Blue Rock Hill Rd
- 5847 Blue Rock Hill Rd
- 5609 Old Blue Rock Rd Unit 25
- 4068 Springrock Dr
- 8407 Lakevalley Dr
- 5526 Deervalley Ct
- 8255 Lakevalley Dr
- 9873 Kittywood Dr
- 9858 Prechtel Rd
- 3775 Susanna Dr
- 9800 Regatta Dr
- 9860 Regatta Dr
- 10016 Skyridge Dr
- 9460 Maple Knoll Dr
- 4220 Endeavor Dr
- 4220 Endeavor Dr Unit 101
- 4281 Defender Dr
- 5160 Pebblevalley Dr
Your Personal Tour Guide
Ask me questions while you tour the home.