$229,900
SOLD SEP 18, 2020

4200 Intrepid Dr Unit 23 Cincinnati, OH 45252

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

Recently Sold

$97 Per Sq Ft

1 Day on Market

Highlights

  • Deck
  • Ranch Style House
  • Formal Dining Room
  • Family Room with Fireplace
  • Wood Flooring
  • Eat-In Kitchen

About This Home

As of April 2025

Spotless End Unit Ranch Condo-Move In Ready!New Carpet & Laminate Flooring Thruout. 1st Flr Study, Eat In Kitchen, Living Rm w/WBFP & Walkout to Nice Composite Deck. Master Bdrm w/Adj Walk In Clst & Adj Full BA w/Granite Double Vanity! 1st Flr & Bsmnt Lndry Hookups. Finished Lower Level Family Rm w/WBFP, Wet Bar, Full Bath & Walkout to Patio!

Last Agent to Sell the Property

Kevin Hildebrand

eXp Realty License #0000409383 Listed on: 07/24/2020

eXp Realty

Co-Listed By

Michael Hildebrand

eXp Realty License #0000422053

Last Buyer's Agent

Nick Foltz

Pivot Realty Group, LLC License #2014004111

Pivot Realty Group, LLC

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,919

Year Built

  • Built in 1993

HOA Fees

  • $295 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Driveway

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
  • Insulated Windows
  • Panel Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • 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

  • Deck
  • Patio

Utilities

  • Central Air
  • Heat Pump System
  • Natural Gas Not Available
  • Electric Water Heater

Community Details

Overview

  • Association fees include snowremoval, association dues, clubhouse, landscapingunit, landscapingcommunity, pool
  • Innovative Property Association
  • The Yacht Club Subdivision

Pet Policy

  • Pets Allowed

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,919

Year Built

Built in 1993

Lot Details

0

HOA Fees

$295 per month

Parking

2

Listing Details

  • Suburb: Colerain Twp.West
  • Cross Street: Voyager Lane
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: Cable,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Basement Sq Ft: 1372
  • Census Tract Realist: 205.02
  • Cooling: Central Air
  • Heating: Electric, 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
  • Basement Features: Finished,Fireplace,Laminate Floor,Walkout
  • Level 1 Bathroom Type: Full,Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Condo Description: Townhouse
  • Dining Room Feat: WW Carpet,Other
  • Entry Area: 70
  • Entry Foyer: Wood Floor
  • Family Room Feat: Fireplace,Laminate Floor,Walkout,Wet Bar
  • 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: Fireplace,Walkout,WW Carpet
  • Mechanical Systems: Garage Door Opener,Water Softener,Other
  • 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
  • School 1 Type: District Phone
  • Architecture: Ranch
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: Colerain to Dry Ridge, L Voyager, L Intrepid
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2020-07-24
  • Property Subtype 1: Condominium
  • Suburb (SIC): The Yacht Club
  • Occupancy: Negotiable
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Interior Amenities: 9Ft + Ceiling, French Doors, Multi Panel Doors
  • Features: Pets Allowed
  • Bedroom 2: 18x13 Level: Lower
  • Bedroom 3: 13x10 Level: Lower
  • Dining Room: 17x10 Level: 1
  • Family Room: 30x15 Level: Lower
  • Living Room: 17x13 Level: 1
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-825-4600
  • Semi Annual Taxes: 1959.27
  • Kitchen: 14x13 Level: 1
  • Appliances: Dishwasher, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Eat-In,Wood Cabinets,Wood Floor
  • Bedroom 2 Area: 234
  • Basement: Full
  • Bedroom 3 Area: 130
  • Study Features: French Doors,WW Carpet
  • Entry: 14x5 Level: 1
  • Bathrooms: 3.00
  • Kitchen Area: 182
  • Kitchen Dim: 14 x 13
  • 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: 0x0 Level: 1
  • Laundryroom Dim: 0 x 0
  • 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: Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 208
  • PrimaryBedroomDim: 16 x 13
  • PrimaryBedroomLen: 16
  • Primary Bathrooms: Double Vanity,Marb/Gran/Slate,Shower
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet,WW Carpet
  • 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: Deck, Patio
  • Foundation: Poured
  • Listing Price: 229900.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Front,Garage Attached
  • Parking: Driveway

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 295.36
  • Fee Frequency: Monthly
  • HOA Management Co: Innovative Property
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Inc.In HOA/Condo Fee: SnowRemoval, AssociationDues, Clubhouse, LandscapingUnit, LandscapingCommunity, Other, Pool

Schools

  • District: Northwest Local SD

Lot Info

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

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

  • 2256 Clough Ridge Dr Unit 2256, Cincinnati, OH 45230

    $259,900

    • 3 Beds
    • 2.5 Baths
    • 1,957 Sq Ft
    • 2256 Clough Ridge Dr
    • Unit 2256
    • Cincinnati, OH

    Industrial Edge Meets Refined LivingNow at a New Price Welcome to 2256 Clough Ridge, where timeless character meets modern luxury. This 3-bedroom, 2.5-bath condo blends sleek, industrial design with warm, elevated finishes. The standout kitchen features high-end appliances, minimalist cabinetry, and bold, repurposed elementsincluding built-ins from the original Walnut Hills High School chemistry

    Brian Jackson Keller Williams Seven Hills Re

    Section Image
  • 4045 Resolute Cir Unit 503, Cincinnati, OH 45252

    $260,000

    • 2 Beds
    • 4 Baths
    • 2,059 Sq Ft
    • 4045 Resolute Cir
    • Unit 503
    • Cincinnati, OH

    There is so much to love about this gorgeous townhouse with over 2,000 sq ft of livable space! Open floor plan that flows perfectly! 3 levels of fun so you still have plenty of room to spread out and have some privacy! 2 bedrooms upstairs each with their own full bathroom!The primary suite is a great size & has vaulted ceilings Beautiful LVP flooring throughout the first floor and lots of natural

    Desirae Phillips ERA REAL Solutions Realty. LLC

    Section Image
  • 9850 Regatta Dr, Cincinnati, OH 45252

    $179,000

    • 2 Beds
    • 2 Baths
    • 1,109 Sq Ft
    • 9850 Regatta Dr
    • Cincinnati, OH

    Welcome to easy living at the Yacht Club! Spacious open floor plan with vaulted ceilings. Tons of updates including flooring, light fixtures, paint, stainless steel appliances, custom shades, hot water heater, and more. Large primary offering new carpet, full bathroom, and walk in closet. Covered balcony. Wood burning fireplace. Detached garage. All appliances stay.

    Timothy Settles Plum Tree Realty

    Section Image
  • 5563 Old Blue Rock Rd, Cincinnati, OH 45247

    $169,900

    • 3 Beds
    • 1.5 Baths
    • 1,134 Sq Ft
    • 5563 Old Blue Rock Rd
    • Cincinnati, OH

    Welcome to this spacious 3 Bd, 2 bath townhome with added family room. A total of 1701 square feet of living space. Sought after corner unit with back patio and privacy fence. First floor features refinished hardwood flooring and luxury vinyl tile in kitchen. Kitchen has top of the line cabinetry with added storage. New appliances and new sliding back door to private patio, Upstairs has 3

    Micah Strong Hallmark Realty, LLC

    Section Image
  • 1 Belknap Place, Cincinnati, OH 45218

    $189,900

    • 3 Beds
    • 1.5 Baths
    • 1,296 Sq Ft
    • 1 Belknap Place
    • Cincinnati, OH

    Welcome to this beautifully updated townhome in the desirable Greenhill neighborhoodno HOA fees! Step inside to find brand-new luxury vinyl plank flooring throughout the main level and a modernized kitchen featuring stainless steel appliances. Freshly painted from top to bottom, this home offers a clean, move-in-ready feel. Upstairs, you'll find new carpet and generously sized bedrooms, perfect

    Meghan Dwyer Irongate Inc.

    Section Image
  • 119 Burley Cir, Cincinnati, OH 45218

    $185,000

    • 3 Beds
    • 1.5 Baths
    • 1,296 Sq Ft
    • 119 Burley Cir
    • Cincinnati, OH

    Charming 3-Bedroom Home with Over 1,600 Sqft in Historic Greenhills - No HOA! Nestled on a quiet, one-way street, this beautifully updated 3-bedroom, 1.5-bath home is one of the few in the area with central AC. Enjoy a finished basement, leathered granite countertops, stainless steel appliances, new carpet, and refinished original hardwood floors. Fresh interior paint, updated vanities, and

    Alexandria Piercy Howard Hanna Real Estate Svcs

    Section Image
  • 5617 Regimental Place, Cincinnati, OH 45239

    $214,499

    • 2 Beds
    • 2 Baths
    • 1,153 Sq Ft
    • 5617 Regimental Place
    • Cincinnati, OH

    Welcome to Kiplington Landominiums! Move right in to this updated very well cared for Landominium-Direct access to garage from unit-Equipped Kitchen with backsplash and wood floors-Formal dining room with walkout to private patio overlooking wooded area- HVAC 2020-First floor bedroom has vaulted ceilings - 2story entry with skylight Opens to Living room with wood burning fireplace-Attached garage

    Mark Schupp Sibcy Cline, Inc.

    Section Image
  • 5567 Regimental Place, Cincinnati, OH 45239

    $239,900

    • 2 Beds
    • 2.5 Baths
    • 1,932 Sq Ft
    • 5567 Regimental Place
    • Cincinnati, OH

    Welcome to 5567 Regimental Place! Spacious 2 bed, 2.5 bath townhouse featuring a finished basement, soaring ceilings in the living room, and an open-concept layout. Enjoy abundant natural light from large rear-facing windows, a walk-out deck on the main level, and a lower-level patio ideal for relaxing or entertaining. The generous eat-in kitchen boasts stainless steel appliances. The primary

    Ron Hill JoAnn Jones & Assoc. Realty

    Section Image
  • 9413 Stoneybrooke, Cincinnati, OH 45231

    $258,000

    • 2 Beds
    • 2.5 Baths
    • 1,748 Sq Ft
    • 9413 Stoneybrooke
    • Cincinnati, OH

    Move-in ready ranch style condo with a finished, walk-out basement! Effortless living in this beautifully maintained condo. Step right into your home from the convenience of the attached direct-entry garage. The spacious owner's suite offers a walk-in closet and a private full bathroom for your comfort. Multiple outdoor areas including a screen in porch along with a screened in covered patio from

    Jamie Hurtubise Keller Williams Advisors

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

MLS of Greater Cincinnati (CincyMLS)

APN: 510-0183-0233