Robert Smith
Coldwell Banker Realty
(513) 599-1654
328 Total Sales
4 in Colerain
$333K - $487K Price Range
Estimated Value: $208,694 - $229,000
Move-In Ready Condo in Desirable Cincinnati Location! Welcome to 4187 Intrepid Dr, a beautifully updated 2-bed, 1.5-bath condo in The Yacht Club! This home features granite countertops, fresh paint, new carpet, upgraded primary bath and updated light fixtures throughout. The luxury bathroom includes a double-sink vanity for added style and convenience. Enjoy a finished basement with laundry hookups, perfect for additional living, workspace, or storage. A one-car garage provides secure parking and extra storage. Bright, inviting, and thoughtfully updated, this condo blends modern finishes with everyday functionality in a convenient location close to shopping, dining, and major routes. Don't miss this one!
Last Agent to Sell the Property
Keller Williams Seven Hills Re License #2026002391 Listed on: 02/27/2026
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Robert Smith
Coldwell Banker Realty
(513) 599-1654
328 Total Sales
4 in Colerain
$333K - $487K Price Range
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
524 Total Sales
6 in Colerain
$97K - $440K Price Range
Wendi Sheets
eXp Realty
(513) 813-1446
214 Total Sales
1 in Colerain
$282,000 Price
Mark Schwab
OwnerLand Realty, Inc.
(513) 586-5203
41 Total Sales
2 in Colerain
$336K - $459K Price Range
Andrea White
White's Farm Est. 1922 DBA White's Realty
(513) 993-6674
124 Total Sales
1 in Colerain
$650,000 Price
Wendy Goldfinger
Howard Hanna Real Estate Serv
(513) 854-8841
117 Total Sales
1 in Colerain
$165,000 Price
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 |
|---|---|---|---|
| $215,000 | None Listed On Document | ||
| Hwo Real Estate Llc | $141,000 | None Listed On Document | |
| Hanon Doreen L | $104,500 | -- | |
| Lakamp Daniel Charles | -- | -- |
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 | $163,000 | ||
| Previous Owner | Hwo Real Estate Llc | $141,000 | |
| Previous Owner | Hanon Doreen L | $90,000 | |
| Previous Owner | Hanon Doreen L | $74,700 | |
| Previous Owner | Hanon Doreen L | $37,000 | |
| Previous Owner | Hanon Doreen L | $68,500 | |
| Previous Owner | Hanon Doreen L | $60,000 |
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 |
|---|---|---|---|---|
| 04/24/2026 04/24/26 | Sold | $215,000 | 0.0% | $169 / Sq Ft |
| 03/20/2026 03/20/26 | Pending | -- | -- | -- |
| 02/27/2026 02/27/26 | For Sale | $215,000 | -- | $169 / Sq Ft |
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 | $3,308 | $56,116 | $10,500 | $45,616 |
| 2024 | $3,149 | $56,116 | $10,500 | $45,616 |
| 2023 | $3,113 | $56,116 | $10,500 | $45,616 |
| 2022 | $2,705 | $39,883 | $8,750 | $31,133 |
| 2021 | $2,731 | $39,883 | $8,750 | $31,133 |
| 2020 | $2,699 | $39,883 | $8,750 | $31,133 |
| 2019 | $2,549 | $34,969 | $8,750 | $26,219 |
| 2018 | $2,293 | $34,969 | $8,750 | $26,219 |
| 2017 | $2,203 | $34,969 | $8,750 | $26,219 |
| 2016 | $2,172 | $33,649 | $8,050 | $25,599 |
| 2015 | $2,162 | $33,649 | $8,050 | $25,599 |
| 2014 | $2,168 | $33,649 | $8,050 | $25,599 |
| 2013 | $2,246 | $36,575 | $8,750 | $27,825 |
Seller's Agent in 2026
Margaret Killough
Keller Williams Seven Hills Re
(513) 492-2998
179 Total Sales
AP
Buyer's Agent in 2026
Anthony Phillips
Sibcy Cline, Inc.
(502) 994-2932
9 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1869968
APN: 510-0183-0306
Ask me questions while you tour the home.