5423 Stewart Avenue, Cincinnati, OH, 45227
Buyer BriefThe facts on this home and a current CMA, talked through with you by one of our agents. The brief is at no cost to you.
Get the Buyer BriefAbout this home
Opportunity awaits in Madisonville! This character-filled duplex offers two spacious one-bedroom, one-bathroom units, making it an excellent opportunity for investors or buyers looking to renovate and add value. One unit is currently occupied on a month-to-month basis, while the other is vacant, offering flexibility for future use. Features include original architectural details, a full basement, off-street parking, and a roof replaced in 2023. Conveniently located near Oakley, Hyde Park, and major highways, the property offers easy access to some of Cincinnati's most desirable neighborhoods. Being sold as-is- this property presents an opportunity for buyers ready to make improvements and unlock its potential. Bring your vision and explore the possibilities!
Facts & features
Interior
- Basement
- Full
- Levels
- Two
- Fireplace features
- None
Heating, cooling & utilities
- Heating
- Gas
- Cooling
- Window Unit
- Gas
- Natural
- Water
- Public
- Sewer
- Public Sewer
Parking
- Garage
- No garage
- Parking
- Concrete, Driveway
Exterior & lot
- Construction
- Wood Siding
- Roof
- Shingle
- Foundation
- Poured
- Windows
- Wood
- Exterior features
- Balcony
- Lot size
- 0.12 acres
- Lot dimensions
- 40 x 125
HOA & taxes
- HOA
- None
Property
- Type
- Multi Fam 2-4 units
- Year built
- Built in 1928
- Days on market
- 37
- County
- Hamilton
- High school district
- Cincinnati City SD (verify with the district)
- MLS #
- 1895587
See more of this home
Enter your email to see the rest of this home's photos and history.
You can request a tour, call, or contact an agent without doing this.
Sale history
- Nov 11, 2026Price changewas $229,900 · Source: CincyMLS$219,900
- Oct 2, 2026ListedSource: CincyMLS$239,900
- Jun 1, 2022TransferSource: Hamilton County Auditor—
Sold history: Hamilton County Auditor public records, retrieved Nov 14, 2026.
Listing dates and prices from CincyMLS.
Public-record transfers include non-sale deeds; a Transfer shows no price. Sold or Transfer follows each county's own sale-validity flag where it publishes one. Sale and deed dates are as recorded by each source; a price change is dated when our listing feed first showed it.
Location
Cincinnati, OH 45227
Drive time
Estimated drive without traffic. Check the drive at the time you'd travel. Kept on this device; we don't save the address. Routes: © OpenStreetMap contributors
Check it yourself
This home is in Hamilton County.
Opens FEMA's flood map and USDA's eligibility map. FEMA's map is a starting point — your lender's flood check is final. USDA's map covers the location only; income limits and the lender's review also apply.
Map shows the approximate property location.
About Cincinnati
What Cincinnati is like, what homes sell for there, and what is nearby. Neighborhood guide →Listed by Lainy D Chambliss · 419-618-5525. Listing courtesy of Keller Williams Advisors · 513-766-9200. Data via Cincinnati Multiple Listing Service.
The data relating to real estate appearing on this site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Properties marked with the Broker Reciprocity icon are provided courtesy of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed — independently verify all details. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Equal Housing Opportunity. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.
CincyMLS data last updated November 21, 2026 at 6:15 AM ET.


