$239,900
PENDING $5K PRICE DROP

Estimated payment $1,670/month

Total Views 3,301
-- Beds
-- Baths
1,850 Sq Ft
$130 Price per Sq Ft

Highlights

  • View of Trees or Woods
  • No HOA
  • 2 Car Attached Garage
  • Walnut Hills High School Rated A+
  • Porch
  • Oversized Parking

About This Home

Duplex with exceptional house-hacking potential. Live in style while your tenant helps offset the mortgage. This beautifully updated property offers two spacious 2-bed, 1-bath units. One unit is vacant and move-in ready; the other is currently leased at $1,200/mo. Ideally on Colerain Ave with quick access to city amenities, shopping, and transit. A rare blend of comfort, income, and investment appeal.

Listing Agent

Ran Day

Sparen Realty License #2019006810 Listed on: 09/02/2025

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $3,664

Year Built

  • Built in 1951

Parking

  • 2 Car Attached Garage
  • 2 Open Parking Spaces
  • Oversized Parking
  • Rear-Facing Garage
  • Tandem Garage
  • Driveway

Home Design

  • Brick Exterior Construction
  • Block Foundation
  • Shingle Roof

Interior Spaces

  • 1,850 Sq Ft Home
  • 2-Story Property
  • Vinyl Clad Windows
  • Double Hung Windows
  • Storage
  • Views of Woods
  • Basement Fills Entire Space Under The House

Utilities

  • Baseboard Heating
  • Private Sewer

Additional Features

  • Porch
  • 10,629 Sq Ft Lot

Community Details

  • No Home Owners Association

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$3,664

Year Built

Built in 1951

Lot Details

10,629 Sq Ft Lot

Parking

2

Listing Details

  • Suburb: Mt. Airy
  • Broker Approved: Yes
  • Census Tract Realist: 85.01
  • Cooling: None
  • Heating: Baseboard, Electric
  • Lot Area Realist: 10629.00
  • Suburb S I C: Mt. Airy
  • Zoning: Multi Family
  • Year Built: 1951
  • Directions: Colerain ave
  • Lot Measurement: Acres
  • MLS Status: Pending
  • Total Units: 2
  • On Market Date: 2025-09-02
  • Property Subtype 1: Multi Fam 2-4 units
  • Standard Status: Pending
  • Occupancy: At Closing
  • Second Floor Area: 925
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: MultiFamily

Interior Features

  • Interior Amenities: Storage Area
  • Property Type: Residential Income
  • Reciprocal Listing: No
  • Semi Annual Taxes: $1832
  • Basement: Full
  • Levels: Two
  • Zero Selling Price: No
  • Fireplace: None
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1850.00
  • Windows: Vinyl, Double Hung
  • Two Bedroom Units: 2

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Porch
  • Foundation: Block
  • Listing Price: 239900.00
  • Acres: 0.2440
  • New Construction: No

Garage/Parking

  • Garage: Attached, Oversized, Built in, Rear, Tandem
  • Garage Spaces: 2.00
  • Parking Spaces: 2
  • Parking: Driveway

Utilities

  • Gas: Natural
  • Sewer: Private Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Fee Information

  • Taxes: 3665

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Size Sq Ft: 10629.00

Rental Info

  • Sub Lease: No

Multi Family

  • Total Buildings: 1

Map

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

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 $3,716 $59,465 $9,709 $49,756
2024 $3,649 $59,465 $9,709 $49,756
2023 $3,699 $59,465 $9,709 $49,756
2022 $1,468 $21,137 $8,012 $13,125
2021 $1,474 $21,137 $8,012 $13,125
2020 $1,478 $21,137 $8,012 $13,125
2019 $1,401 $18,222 $6,906 $11,316
2018 $1,402 $18,222 $6,906 $11,316
2017 $1,350 $18,222 $6,906 $11,316
2016 $650 $8,488 $7,816 $672
2015 $582 $8,488 $7,816 $672
2014 $585 $8,488 $7,816 $672
2013 $2,661 $38,511 $8,208 $30,303
Source: Public Records

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
09/15/2026 09/15/26 Pending -- -- --
09/01/2026 09/01/26 Price Changed $239,900 0.0% $130 / Sq Ft
09/01/2026 09/01/26 For Sale $239,900 -2.0% $130 / Sq Ft
01/20/2026 01/20/26 Off Market $244,900 -- --
10/29/2025 10/29/25 Pending -- -- --
10/09/2025 10/09/25 For Sale $244,900 +44.1% $132 / Sq Ft
04/29/2021 04/29/21 Off Market $169,900 -- --
01/25/2021 01/25/21 Sold $169,900 0.0% $92 / Sq Ft View Prior Sale
11/12/2020 11/12/20 Pending -- -- --
11/10/2020 11/10/20 For Sale $169,900 +600.6% $92 / Sq Ft
04/02/2014 04/02/14 Off Market $24,250 -- --
12/26/2013 12/26/13 Sold $24,250 -49.3% $13 / Sq Ft View Prior Sale
11/13/2013 11/13/13 Pending -- -- --
08/17/2013 08/17/13 For Sale $47,790 -- $26 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase 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 Type Sale Price Title Company
Warranty Deed $169,900 American Homeland Title
Warranty Deed -- None Available
Warranty Deed -- None Available
Warranty Deed -- Attorney
Warranty Deed -- Attorney
Deed $24,250 Attorney
Warranty Deed -- None Available
Sheriffs Deed $38,000 None Available
Warranty Deed $98,800 Classic Title Agency Llc
Survivorship Deed $122,000 --
Warranty Deed $86,000 --
Source: Public Records

Mortgage 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 Status Loan Amount Loan Type
Open $166,822 FHA
Previous Owner $82,500 New Conventional
Previous Owner $81,000 Future Advance Clause Open End Mortgage
Previous Owner $49,000 Unknown
Previous Owner $114,918 FHA
Previous Owner $100,776 Unknown
Previous Owner $109,800 No Value Available
Previous Owner $15,609 Unknown
Source: Public Records

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1857714

MLS of Greater Cincinnati (CincyMLS)

APN: 227-0001-0043-00

Your Personal Tour Guide

Ask me questions while you tour the home.