NOT LISTED FOR SALE

4200 Intrepid Dr Unit 23 Cincinnati, OH 45252

Estimated Value: $273,000 - $333,000

3 Beds
2.5 Baths
2,372 Sq Ft
$366/mo HOA Fee

Last Sold April 29, 2025

Last sale price $300,000 $126 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $2,391/month

29 Days on Market

Highlights

  • Family Room with Fireplace
  • Wood Flooring
  • Eat-In Kitchen
  • Ranch Style House
  • Balcony
  • Bay Window

About This Home

As of April 2025

Exceptional 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

Tom Deutsch

Coldwell Banker Realty License #2003017346 Listed on: 02/24/2025

Coldwell Banker Realty

Last Buyer's Agent

Tom Deutsch

Coldwell Banker Realty License #2003017346 Listed on: 02/24/2025

Coldwell Banker Realty

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

Property Details

Home Type

Condominium

Est. Annual Taxes

$5,066

Year Built

Built in 1993

Lot Details

0

HOA Fees

$366 per month

Parking

2

Listing Details

  • Suburb: Colerain Twp.West
  • Topography: Level
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Cable,Ceiling Fan,Smoke Alarm,Tech Wiring
  • Census Tract Realist: 205.02
  • Cooling: Central Air
  • Heating: Electric, Forced Air, Heat Pump
  • Lot Area Realist: 50229.00
  • Suburb S I C: Colerain Twp.West
  • Zoning: Residential
  • Basement Features: Finished,Fireplace,Walkout,Laminate Floor
  • Level 1 Bathroom Type: Full,Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Condo Description: Other
  • Dining Room Feat: Chandelier
  • Entry Foyer: Wood Floor
  • Family Room Feat: Walkout,Fireplace,Wet Bar,Laminate Floor
  • Living Great Rm Dim: 17 x 13
  • Living Room Feat: Walkout,Wall-to-Wall Carpet,Fireplace
  • Study Lib Den: 14x11 Level: 1
  • Study Lib Den Dim: 14 x 11
  • Unit Entry Level: 1
  • Water Heating: Electric
  • Year Built: 1993
  • Architecture: Ranch
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: Colerain to Dryridge, left on Voyager, L on Intrepid
  • Lot Measurement: Acres
  • Status: Sold
  • Property Subtype 1: Condominium
  • Occupancy: At Closing
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Condos

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Multi Panel Doors
  • Bedroom 2: 18x13 Level: 1
  • Bedroom 3: 13x10 Level: Lower
  • Dining Room: 17x10 Level: 1
  • Living Room: 17x13 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $2533
  • Appliances: Oven/Range, Refrigerator
  • Kitchen Features: Pantry,Eat-In,Wood Cabinets,Wood Floor
  • Basement: Full
  • Study Features: Wall-to-Wall Carpet
  • Entry: 14x15 Level: 1
  • Bathrooms: 3.00
  • Kitchen Dim: 14 x 11
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: Lower
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 8x8 Level: 1
  • Laundryroom Dim: 8 x 8
  • Recreation Room Dim: 0 x 0
  • Fireplace: Ceramic, Wood
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2372.00
  • Windows: Bay/Bow, Double Hung, Vinyl, Insulated
  • First Floor Family Room: 30x15 Level: Lower
  • PrimaryBedroomDim: 16 x 13
  • Primary Bathrooms: Shower,Double Vanity,Marb/Gran/Slate
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet
  • P R I M A R Y B E D R O O M: 16x13 Level: 1

Exterior Features

  • Roof: Shingle
  • Construction: Brick, Vinyl Siding
  • Outside Features: Balcony, Covered Deck/Patio, Sprinklers
  • Foundation: Poured
  • Listing Price: 315000.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Built in
  • Parking: Off Street, Driveway

Utilities

  • Gas: None
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 365.85
  • Fee Frequency: Monthly
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Inc.In HOA/Condo Fee: AssociationDues, Pool, ProfessionalMgt

Schools

  • District: Northwest Local SD

Lot Info

  • Lot Dimensions: Condo
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 24, 2025
Closed on
Apr 28, 2025
Sold by
Moore Pattiann M
Bought by
Boyle Thomas R and Boyle Peggy
Seller's Agent
Tom Deutsch
Coldwell Banker Realty
Buyer's Agent
Tom Deutsch
Coldwell Banker Realty
List Price
$327,750
Sold Price
$300,000
Premium/Discount to List
-$27,750
-8.47%
Views
191
Current Estimated Value
$307,212

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$7,212
Avg. Annual Appreciation
3.66%
Original Mortgage
$270,000
Outstanding Balance
$269,048
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$38,164

Purchase Details

Listed on
Aug 18, 2022
Closed on
Sep 23, 2022
Sold by
Perrucci Christine
Bought by
Moore Robert Bruce and Moore Pattiann M
Seller's Agent
Sylvia Young
Sibcy Cline, Inc.
Buyer's Agent
Tom Deutsch
Coldwell Banker Realty
List Price
$265,000
Sold Price
$270,000
Premium/Discount to List
$5,000
1.89%
Views
34

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.14%
Original Mortgage
$203,000
Interest Rate
5.55%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jul 24, 2020
Closed on
Sep 18, 2020
Sold by
Widmer Gary W and Widmer Kimberly S
Bought by
Perrucci Christine
Seller's Agent
Kevin Hildebrand
eXp Realty
Buyer's Agent
Nick Foltz
Pivot Realty Group, LLC
List Price
$229,900
Sold Price
$229,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.33%

Purchase Details

Listed on
Apr 30, 2017
Closed on
Jun 12, 2017
Sold by
Durnell Bertha L and Bertha L Durnell Family Trust
Bought by
Widmer Gary W and Widmer Kimberly S
Seller's Agent
Dianna Shelton
Coldwell Banker Realty, Anders
Buyer's Agent
Kevin Hildebrand
eXp Realty
List Price
$192,500
Sold Price
$192,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.58%
Original Mortgage
$182,875
Interest Rate
3.94%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 9, 2007
Sold by
Durnell Bertha L
Bought by
Durnell Bertha L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$172,000
Interest Rate
6.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jun 8, 2007
Sold by
Stehlin Roseanne and Pietch Sally
Bought by
Durnell Bertha L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$172,000
Interest Rate
6.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Aug 17, 1995
Sold by
Wingate Jack R and Wingate Janis S
Bought by
Stehlin Roseanne
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Boyle Thomas R $300,000 Northwest Title
Boyle Thomas R $300,000 Northwest Title
Moore Robert Bruce -- --
Perrucci Christine -- Stewart Title
Widmer Gary W $192,500 Mattingly Ford Title Svcs
Durnell Bertha L -- Attorney
Durnell Bertha L $215,000 Attorney
Stehlin Roseanne -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Boyle Thomas R $270,000
Closed Boyle Thomas R $270,000
Previous Owner Moore Robert Bruce $203,000
Previous Owner Widmer Gary W $182,875
Previous Owner Durnell Bertha L $172,000
Source: Public Records

Property History

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 Compared to Growth

Source: Public Records

Tax History

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
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

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1831672

MLS of Greater Cincinnati (CincyMLS)

APN: 510-0183-0233