5595 Colerain, Cincinnati, OH 45239 - Photo 1

Save This Listing

1/16

View All Photos

$255,000

For Sale
Active
Duplex
1,992 Sq. Ft.
0.207 Acres
2 Car Garage

See This Home

Save This Listing

1/16

Property Description

Back on market after buyer's financing fell through. Solid brick duplex in the heart of Mount Airy offering a prime opportunity for both owner-occupants and investors. Located in a strong rental market, this property features separate furnaces and individually metered gas and electric, helping keep owner expenses low and operations simple. One unit is currently occupied (Month to month), providing immediate income, while the second unit is vacant, perfect for an owner-occupant or ready to be leased at market rates. Rental comps suggest strong upside potential with rents exceeding $1,200/month per unit. Oversized attached garage provides an additional income stream ** Property is available for individual purchase or can be packaged with the neighboring duplex at 5603 Colerain Ave for added scale and investment potential. Rent roll/Notes attached

Full Property Details

Full Property Details for 5595 Colerain

General

Price: $255,000
Status: Active
Type: Duplex
Source: Cincinnati
MLS ID: 1876308
Updated: 5/12/2026
Added to Site: 34 day(s) ago

Parking

Garage: Yes
Garage Spaces: 2
Total Spaces: 4
Parking: Asphalt, Driveway
Garage Description: Attached, Oversized, Rear

Location

Area: Mt. Airy
County: Hamilton
Township: Cincinnati City
Driving Directions: Right off Colerain Ave

School Information

School District: Cincinnati City SD
High School District: Cincinnati City SD

Heating & Cooling

Central air: Yes
Cooling Type: Central Air Conditioning
Separate Air Cond.: Yes
Heating Type: Forced Air
Heating Fuel: Natural
Separate Furnace: Yes

Utilities

Separate Gas/Elect: Yes
Sewer: Public Sewer
Water: Public

Structural Information

# Buildings: 1
Architectural Style: Two Story
Exterior Const.: Brick
Basement: Yes
Basement Desc.: Full
Foundation: Block
Roof: Shingle
Windows: Vinyl
Stories/Levels: Two
Square Feet: 1,992
Year Built: 1941

Unit Information

2 Bedroom Units: 2
2 Bedroom Sq. Ft.: 1,020

Unit 1

Bedrooms: 2

Unit 2

Bedrooms: 2

Lot Features

Lot Size (Acres): 0.207
Lot Size (Sq. Ft.): 9,017

Financial Considerations

Semi-Annual Taxes: $1471
Tenant Expense: Heat
Pays Heat: Tenant
Pays Water: Owner

Disclosures and Reports

APN: 231-0004-0051-00

Listed by Plum Tree Realty (513) 443-5060, Noah Gibby

Quickly Find Out More

* Indicates a required field

Comment optional

Full Name *

Email Address *

Mobile Phone Number *

See this property in person

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 5595 Colerain —

Noah Gibby

Plum Tree Realty

513-443-5060

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 5595 Colerain

School District:Cincinnati City School District

Name	Grades	Distance
Mt. Airy Elementary School 5730 Colerain Avenue, Cincinnati, OH 45239	PK-6	0.3 mi
Aiken New Tech High School 5641 Belmont Avenue, Cincinnati, OH 45224	7-12	1.3 mi
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237	7-12	5.9 mi
James N. Gamble Montessori High School 3036 Werk Road, Cincinnati, OH 45211	7-12	3.9 mi
Western Hills University High School 2144 Ferguson Road, Cincinnati, OH 45238	7-12	5 mi
Gilbert A. Dater High School 2146 Ferguson Road, Cincinnati, OH 45238	7-12	5 mi
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207	7-12	6.3 mi
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208	7-12	7.5 mi
Riverview East Academy 3555 Kellogg Avenue, Cincinnati, OH 45226	9-12	9 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 5595 Colerain Get Price Alerts and Save Property

Date

Details

Price

Change

Source

4/23/2026

Listed

$255,000

114.29%

MLS

5/20/2004

Sold

$119,000

—

Public Record

Get Price Alerts and Save Property

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History

Tax History for 5595 Colerain

Year

Property Taxes

Change

Tax Assessment

Change

2025

$2,947

—

$46,235

—

2024

$2,943

—

$46,235

—

2023

$2,948

94%

$46,235

113%

2021

$1,520

-2%

$21,701

—

2022

$1,548

$21,701

—

2020

$1,520

$21,701

16%

2019

$1,440

$18,708

—

2018

$1,427

$18,708

—

2017

$1,375

-28%

$18,708

-27%

2016

$1,923

12%

$25,526

—

2015

$1,719

-1%

$25,526

—

2014

$1,728

-2%

$25,526

—

2013

$1,758

—

$25,526

—

View All

Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost

Estimate the Cost for 5595 Colerain

5595 Colerain, Cincinnati, OH 45239 (MLS# 1876308) is a Duplex property with 0 bedrooms and 0 full bathrooms. 5595 Colerain is currently listed for $255,000 and was received on April 23, 2026. Want to learn more about 5595 Colerain? Do you have questions about finding other Duplex real estate for sale in Mount Airy? You can browse all Mount Airy real estate or contact a Coldwell Banker agent to request more information.

Tour this property

5595 Colerain Cincinnati, OH 45239