$300,000
SOLD APR 29, 2025

4200 Intrepid Dr Unit 23 Cincinnati, OH 45252

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

Recently Sold

$126 Per Sq Ft

8% Below List Price

29 Days on Market

Highlights

  • Family Room with Fireplace
  • Wood Flooring
  • Eat-In Kitchen
  • Ranch Style House
  • Balcony
  • Wet Bar

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

HOA Fees

  • $366 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,372 Sq Ft Home
  • Wet Bar
  • Ceiling height of 9 feet or more
  • Wood Burning Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Double Hung Windows
  • 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

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
  • Basement Sq Ft: 1372
  • Census Tract Realist: 205.02
  • Cooling: Central Air
  • Heating: Electric, Forced Air, Heat Pump
  • Lot Area Realist: 50229.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Colerain Twp.West
  • Taxes Annual: 5066
  • 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 Area: 210
  • Entry Foyer: Wood Floor
  • Family Room Feat: Walkout,Fireplace,Wet Bar,Laminate Floor
  • Living Great Rm Area: 221
  • Living Great Rm Dim: 17 x 13
  • Living Great Rm Len: 17
  • Living Great Rm Wid: 13
  • Living Room Feat: Walkout,Wall-to-Wall Carpet,Fireplace
  • Study Lib Den: 14x11 Level: 1
  • Study Lib Den Area: 154
  • Study Lib Den Dim: 14 x 11
  • Study Lib Den Len: 14
  • 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
  • Bedroom 2 Area: 234
  • Basement: Full
  • Bedroom 3 Area: 130
  • Study Features: Wall-to-Wall Carpet
  • Entry: 14x15 Level: 1
  • Bathrooms: 3.00
  • Kitchen Area: 154
  • Kitchen Dim: 14 x 11
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: Lower
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Diningroom Area: 170
  • Family Room Area: 450
  • Laundry Room: 8x8 Level: 1
  • Laundry Room Area: 64
  • 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
  • Total Rooms: 8
  • Windows: Bay/Bow, Double Hung, Vinyl, Insulated
  • First Floor Family Room: 30x15 Level: Lower
  • PrimaryBedroomArea: 208
  • PrimaryBedroomDim: 16 x 13
  • PrimaryBedroomLen: 16
  • 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
$304,371

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$4,371
Avg. Annual Appreciation
18.23%
Original Mortgage
$270,000
Outstanding Balance
$269,764
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$43,064

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
$21,500
Interest Rate
6.2%
Mortgage Type
Unknown

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
$21,500
Interest Rate
6.2%
Mortgage Type
Unknown

Purchase Details

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

Similar Homes in Cincinnati, OH

  • 143 Goethe St, Cincinnati, OH 45202

    $310,000

    • 2 Beds
    • 1 Bath
    • 1,050 Sq Ft
    • 143 Goethe St
    • Cincinnati, OH

    Experience elevated city living in this fully furnished, updated 2-bedroom condo located in coveted Prospect Hill in Mt. Auburn. Enjoy a luxurious custom bath with dual shower heads and a built-in bench connected to the primary suite. A dramatic 46-inch skylight fills the spacious dining area with natural light, perfect for meals or entertaining. The unit also features in-unit laundry, a private

    Kristine Green Coldwell Banker Realty

    Section Image
  • 1124 Race St, Cincinnati, OH 45202

    $239,900

    • 1 Bed
    • 1 Bath
    • 749 Sq Ft
    • 1124 Race St
    • Cincinnati, OH

    Studio condo situated in the heart of OTR and just steps away from Washington Park. This 749 sqft studio comes with onsite gated parking and private entrance to unit. Brick wall accents, high ceilings, custom cabinetry & built-in Murphy bed & private patio in rear all add to the charm and easy living in downtown Cincinnati.

    Patrick Lach Sibcy Cline, Inc.

    Section Image
  • 2380 Madison Rd, Cincinnati, OH 45208

    $275,000

    • 2 Beds
    • 2 Baths
    • 1,282 Sq Ft
    • 2380 Madison Rd
    • Cincinnati, OH

    This stunning Grasmoor House condominium offers the perfect blend of elegance and convenience in the heart of Hyde Park. With soaring high ceiling and original large parquet floor. Updated kitchen with quartzite counter, sub zero refrigerator. New windows. Corner unit with balcony allows for abundant natural light. Garage parking. Beautifully landscaped grounds a short walk to O'Bryonville or

    Maria Walley Comey & Shepherd

    Section Image
  • 804 Woodlyn Dr S, Cincinnati, OH 45230

    $239,900

    • 3 Beds
    • 3.5 Baths
    • 1,460 Sq Ft
    • 804 Woodlyn Dr S
    • Cincinnati, OH

    End unit town-house style condo. 3 bedroom, 3 full baths and 1 half. First floor walk-out to deck, Lower-level walkout to patio. Car port #158 and one assigned space, guest parking also. HOA covers water, trash, exterior maintenance, landscaping, snow removal and pool. Some updates include windows 2020, exterior doors 2023 with transferable warranties, Roof 2020, New siding coming 2026 and

    Susan Kuehnle Coldwell Banker Realty, Anders

    Section Image
  • 4309 Value Springs, Cincinnati, OH 45245

    $239,900

    • 2 Beds
    • 2 Baths
    • 1,092 Sq Ft
    • 4309 Value Springs
    • Cincinnati, OH

    2022 Newer Construction condo by Fischer Homes in Twelve Oaks community. Second floor condo is the Kimbell floor plan, 1,111 sq. ft. 2 bed/2 bath vaulted ceilings, bright and airy floor plan, kitchen w/ peninsula island & abundant cabinet space. Sizeable great room and dining area, laundry room, primary suite with walk in closet and adjoining bath. Second bedroom with closet can dual as a study.

    Lori Williams Lohmiller Real Estate

    Section Image
  • 3834 Enterprise Cir, Cincinnati, OH 45252

    $329,900

    • 2 Beds
    • 2.5 Baths
    • 1,988 Sq Ft
    • 3834 Enterprise Cir
    • Cincinnati, OH

    Spectacular, 1988 sqft condo with covered front porch! 2-3 bedrooms, 2.5 baths. No-step living on 1st floor. Eat-in kitchen, formal dining room & 1st-floor laundry. Primary suite w/walk-in closet & adjoining full bath w/double vanity. Turned staircase. Deck overlooks peaceful, grassy area. LL family room w/large wet bar, wood-burning fireplace & walkout to concrete patio. 1-2 additional bedrooms

    Edmund Ferrall Comey & Shepherd

    Section Image
  • 3856 Enterprise Cir Unit 573, Cincinnati, OH 45252

    $227,000

    • 2 Beds
    • 2.5 Baths
    • 1,350 Sq Ft
    • 3856 Enterprise Cir
    • Unit 573
    • Cincinnati, OH

    Excellent Opportunity! Welcome to this beautifully updated 2 bedroom, 2.5 bath condo with a 1-car attached garage. The kitchen has been carefully renovated with fresh, modern finishes, including granite countertops, new appliances and lighting throughout. This move-in ready gem is in a desirable location close to highways, stores, restaurants and more. You do not want to miss this home.

    Arnez Gray Sibcy Cline, Inc.

    Section Image
  • 6112 Blue Lake Dr Unit 9, Cincinnati, OH 45247

    $229,900

    • 2 Beds
    • 1 Bath
    • 835 Sq Ft
    • 6112 Blue Lake Dr
    • Unit 9
    • Cincinnati, OH

    Complete renovation! Resort-style living, close to everything! Single-family, free-standing lakefront condo with all the extras. Remodeled kitchen & bath, new cabinets, quartz counter & appliances. 1st-floor primary suite & 2nd-floor loft bedroom. Family room with wood-burning stove flue & walkout to massive wood deck & tranquil lakeview - abundant wildlife to enjoy! New HVAC, HWH, breaker panel,

    Edmund Ferrall Comey & Shepherd

    Section Image
  • 4951 N Arbor Woods Ct, Cincinnati, OH 45248

    $229,000

    • 2 Beds
    • 2 Baths
    • 1,407 Sq Ft
    • 4951 N Arbor Woods Ct
    • Cincinnati, OH

    Gorgeous top floor ranch style, NO STEP condo- access floor from elevator! Two bed/two bath all updated! Beautifully maintained. Front unit with view of pool! Fireplace! Vaulted ceiling! Bonus room- study with built-in bookcases and French doors. Newer flooring. Newer mechanics! Detached garage close to unit. Such a lovely home with a deck to enjoy the quiet community. No one above and no one

    Mary Droder Sibcy Cline, Inc.

    Section Image

Range of Values:

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 Type Sale Price Title Company
Warranty Deed $300,000 Northwest Title
Warranty Deed $300,000 Northwest Title
Warranty Deed -- --
Warranty Deed -- Stewart Title
Warranty Deed $192,500 Mattingly Ford Title Svcs
Interfamily Deed Transfer -- Attorney
Warranty Deed $215,000 Attorney
Warranty Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $270,000 New Conventional
Closed $270,000 New Conventional
Previous Owner $106,500 Construction
Previous Owner $203,000 New Conventional
Previous Owner $182,875 New Conventional
Previous Owner $128,000 Credit Line Revolving
Previous Owner $152,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $21,500 Unknown
Previous Owner $172,000 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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
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
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
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