5123 Stewart Avenue, Cincinnati, OH 45227 (MLS # 1864018)
Twitter
Facebook
Email
|
Charm meets modern finishes. Beautifully redone, unique Home w/ captivating finishes + must-have features & amenities. You just might fall in Love w/ this one! 4-5 Bedrooms/3 Baths, Office & Loft w/ endless space & Privacy. New Master Suite, spacious updated Kitchen w/ new SS Appliances & new Hardwood Flrs (2025). Also new - Lighting fixtures, refinished, orig HW Flrs (2025), Newer Elec (2025), Dual Zoned HVAC (1 of 2 new in 2025). Other big ticket items: Roof (2022), Downspouts (2025), Windows (2017), & restored Leaded Glass Entry & Stained Glass Doors (2025). You will absolutely love the grand Living Room w/ Built-ins & a Rookwood Fireplace + tons of natural light on all 3 finished floors. In all, 2500+ sf & plentiful storage. Plus Home is newly painted inside & out. Resurfaced Driveway & New Fence for added privacy (2025) + Pet Proof Fencing in Backyard. Walkable in all directions to all the Great Dining & shops Madisonville offers + 2 mins to Red Dog's 3 Acre Dog Park. Must See!
| DAYS ON MARKET | 1 | LAST UPDATED | 12/15/2025 |
|---|---|---|---|
| YEAR BUILT | 1910 | COMMUNITY | Hamilton-E04 |
| COUNTY | Hamilton | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, disposal, Gas Cooktop, Gas Water Heater, Other, Oven, Range, Refrigerator |
| AREA | Hamilton-E04 |
| BASEMENT | Full, Unfinished, Yes |
| CONSTRUCTION | Brick, Other, Wood Siding |
| EXTERIOR | Fire Pit, Other |
| FIREPLACE | Yes |
| HEAT | Forced Air, Natural Gas, Other, Zoned |
| INTERIOR | Eat-in Kitchen, Kitchen Island, Natural Woodwork, Other, Pantry, Walk-In Closet(s) |
| LOT | 7362 sq ft |
| LOT DIMENSIONS | 50 X 150 |
| PARKING | Off Street, Driveway |
| SEWER | Public Sewer |
| STORIES | 3+ |
| STYLE | Traditional, Victorian |
| UTILITIES | Natural Gas Available |
| WATER | Public |
| ZONING | Residential |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Wendi
Sheets to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Coldwell Banker Realty, phone# 513-321-9944, Meg Perez, phone# 513-658-7478
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati and the Dayton Area Board of Realtors® MLS IDX Database.
Information is provided 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. Information Deemed Reliable but Not Guaranteed.
Copyright© 2025 MLS of Greater Cincinnati, Inc. and Dayton Area Board of Realtors® All rights reserved.
Data last updated: 12/15/25 8:24 PM PST
This IDX solution is (c) Diverse Solutions 2025.