Richard Morales
Coldwell Banker Realty
(513) 586-5101
65 Total Sales
2 in Colerain
$165K - $443K Price Range
4200 Intrepid Dr Unit 23 Cincinnati, OH 45252
Colerain AreaEstimated Value: $279,000 - $338,000
3
Beds
2.5
Baths
2,372
Sq Ft
1.15
Acre Lot
Highlights
- Family Room with Fireplace
- Wood Flooring
- Eat-In Kitchen
- Ranch Style House
- Balcony
- Bay Window
About This Home
As of April 2025Exceptional end-unit ranch style home offering modern updates and versatile living spaces. With 3 bedrooms, 2.5 baths, and the option for a 4th bedroom in the walkout lower level, this home is designed to adapt to your needs. Step into an inviting main level with hardwood floors, new carpet, and black stainless steel appliances that elevate the kitchen's style. The walkout lower level features LVP flooring, an additional living area, a second laundry hookup for convenience and wet bar. This home is perfect for entertaining or relaxing, with two cozy fireplaces, a composite deck, and a retractable awning for outdoor enjoyment. Additional features include a water softener, a 2-car garage, and ample storage space. Don't miss the chance to call this property home.
Last Agent to Sell the Property
Coldwell Banker Realty License #2003017346 Listed on: 02/24/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
Property Details
Home Type
- Condominium
Est. Annual Taxes
- $5,066
Year Built
- Built in 1993
Lot Details
- Sprinkler System
HOA Fees
- $366 Monthly HOA Fees
Parking
- 2 Car Garage
- Driveway
- Off-Street Parking
Home Design
- Ranch Style House
- Entry on the 1st floor
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2,372 Sq Ft Home
- Wet Bar
- Ceiling height of 9 feet or more
- Chandelier
- Wood Burning Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Double Hung Windows
- Bay Window
- Panel Doors
- Family Room with Fireplace
- 2 Fireplaces
- Living Room with Fireplace
Kitchen
- Eat-In Kitchen
- Oven or Range
- Solid Wood Cabinet
Flooring
- Wood
- Laminate
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
Outdoor Features
- Balcony
- Covered Deck
Utilities
- Forced Air Heating and Cooling System
- Heat Pump System
- Natural Gas Not Available
- Electric Water Heater
Community Details
- Association fees include association dues, pool, professionalmgt
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Richard Morales
-
Bill Lutts
Bill Lutts
Align Right Realty Infinity
(513) 993-4201
79 Total Sales
4 in Colerain
$120K - $295K Price Range
-
Cindy Johnston
Cindy Johnston
Lohmiller Real Estate
(513) 847-9386
80 Total Sales
1 in Colerain
$390,000 Price
-
Edward Lindenschmidt
Edward Lindenschmidt
Keller Williams Advisors
(513) 599-8883
189 Total Sales
7 in Colerain
$120K - $650K Price Range
-
Tracy Winkler
Tracy Winkler
Comey & Shepherd
(513) 808-9789
160 Total Sales
2 in Colerain
$178K - $475K Price Range
-
Haydee Wright
Haydee Wright
Howard Hanna Real Estate Serv
(937) 930-4213
79 Total Sales
1 in Colerain
$432,000 Price
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 |
|---|---|---|---|---|---|
| 04/29/2025 04/29/25 | Sold | $300,000 | -4.8% | $126 / Sq Ft | |
| 03/25/2025 03/25/25 | Pending | -- | -- | -- | |
| 03/12/2025 03/12/25 | Price Changed | $315,000 | -3.9% | $133 / Sq Ft | |
| 02/24/2025 02/24/25 | For Sale | $327,750 | +21.4% | $138 / Sq Ft | |
| 09/23/2022 09/23/22 | Sold | $270,000 | +1.9% | $114 / Sq Ft | View Prior Sale |
| 08/21/2022 08/21/22 | Pending | -- | -- | -- | |
| 08/20/2022 08/20/22 | For Sale | $265,000 | +15.3% | $112 / Sq Ft | |
| 12/20/2020 12/20/20 | Off Market | $229,900 | -- | -- | |
| 09/18/2020 09/18/20 | Sold | $229,900 | 0.0% | $97 / Sq Ft | View Prior Sale |
| 07/25/2020 07/25/20 | Pending | -- | -- | -- | |
| 07/24/2020 07/24/20 | For Sale | $229,900 | +19.4% | $97 / Sq Ft | |
| 09/11/2017 09/11/17 | Off Market | $192,500 | -- | -- | |
| 06/12/2017 06/12/17 | Sold | $192,500 | 0.0% | $81 / Sq Ft | View Prior Sale |
| 05/02/2017 05/02/17 | Pending | -- | -- | -- | |
| 04/30/2017 04/30/17 | For Sale | $192,500 | -- | $81 / 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 | $5,433 | $94,500 | $10,500 | $84,000 |
| 2024 | $5,036 | $94,500 | $10,500 | $84,000 |
| 2023 | $5,066 | $94,500 | $10,500 | $84,000 |
| 2022 | $4,429 | $67,375 | $8,750 | $58,625 |
| 2021 | $4,390 | $67,375 | $8,750 | $58,625 |
| 2020 | $4,437 | $67,375 | $8,750 | $58,625 |
| 2019 | $3,926 | $55,664 | $8,750 | $46,914 |
| 2018 | $3,521 | $55,664 | $8,750 | $46,914 |
| 2017 | $2,799 | $55,664 | $8,750 | $46,914 |
| 2016 | $3,127 | $60,568 | $8,050 | $52,518 |
| 2015 | $3,166 | $60,568 | $8,050 | $52,518 |
| 2014 | $3,172 | $60,568 | $8,050 | $52,518 |
| 2013 | $3,325 | $65,835 | $8,750 | $57,085 |
Source: Public Records
Agents Affiliated with this Home
-
Tom Deutsch
Seller's Agent in 2025
Tom Deutsch
Coldwell Banker Realty
(513) 460-5302
628 Total Sales
-
Brian Baverman
BB
Buyer Co-Listing Agent in 2025
Brian Baverman
Coldwell Banker Realty
(513) 675-6316
50 Total Sales
-
Sylvia Young
Seller's Agent in 2022
Sylvia Young
Sibcy Cline
(513) 604-4196
17 Total Sales
-
Kevin Hildebrand
Seller's Agent in 2020
Kevin Hildebrand
eXp Realty
(513) 509-5677
621 Total Sales
-
Michael Hildebrand
Seller Co-Listing Agent in 2020
Michael Hildebrand
eXp Realty
(513) 515-1170
327 Total Sales
-
Nick Foltz
Buyer's Agent in 2020
Nick Foltz
Pivot Realty Group, LLC
(513) 401-6462
256 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1831672
APN: 510-0183-0233
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
- 9940 Regatta Dr Unit 302
- 9940 Regatta Dr
- 9940 Regatta Dr
- 4327 Courageous Cir Unit 86
- 4240 Endeavor Dr
- 4281 Defender Dr
- 4220 Endeavor Dr
- 4220 Endeavor Dr Unit 101
- 9860 Regatta Dr
- 9858 Prechtel Rd
- 9800 Regatta Dr
- 10263 Colerain Ave
- 9952 Capstan Dr
- 5160 Pebblevalley Dr
- 9970 Hollis Dr
- 3775 Susanna Dr
- 3540 Alamosa Dr
- 4498 Day Rd
- 3407 Redskin Dr
- 8545 Noelle Dr
- 4198 Intrepid Dr Unit 24
- 4194 Intrepid Dr Unit 26
- 4192 Intrepid Dr
- 4190 Intrepid Dr Unit 28
- 4196 Intrepid Dr
- 4186 Intrepid Dr
- 4193 Intrepid Dr
- 4193 Intrepid Dr Unit 41
- 4185 Intrepid Dr Unit 37
- 4195 Intrepid Dr
- 4191 Intrepid Dr
- 4189 Intrepid Dr
- 4195 Intrepid Dr Unit 42
- 4184 Intrepid Dr Unit 30
- 4216 Intrepid Dr
- 4214 Intrepid Dr Unit 22
- 4220 Intrepid Dr
- 4218 Intrepid Dr
- 4180 Intrepid Dr
- 4182 Intrepid Dr
Your Personal Tour Guide
Ask me questions while you tour the home.