This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$490,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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!
Full Property Details
Full Property Details for 5123 Stewart Ave
General
- Sold For: $490,000
- Status: Closed
- Type: Single Family
- Source: Cincinnati
- MLS ID: 1864018
- Added to Site: 99 day(s) ago
Interior
- Number of Rooms: 10
- Rooms/Areas: Loft, Other
- Interior Features: High Ceiling (9 Feet or More), Multi-Panel Doors, Natural Woodwork, Other
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Ceramic, Gas, Inoperable
- Appliances: Dishwasher, Garbage Disposal, Gas Cooktop, Oven/Range, Refrigerator, Other
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 2
- Half Bathrooms: 1
- Primary Bathroom: Shower, Tile Floor, Double Vanity, Marb/Gran/Slate
- Bathroom 1: Full, Level 2
- Bathroom 2: Full, Level 2
- Bathroom 3: Partial, Level 1
Bedrooms
- Total Bedrooms: 5
- Primary Bedroom: Adjoining Bathroom, Walk-In Closet, Wood Floor, 18 x 15, Level 2, 270 Sq. Ft.
- Bedroom 2: 14 x 12, Level 2, 168 Sq. Ft.
- Bedroom 3: 12 x 10, Level 2, 120 Sq. Ft.
- Bedroom 4: 15 x 13, Level 3, 195 Sq. Ft.
- Bedroom 5: 15 x 12, Level 3, 180 Sq. Ft.
Other Rooms
- Foyer/Entry: Closet, Open Foyer, Wood Floor, Level 1, 99 Sq. Ft.
- Living Room: Bookcases, Walk-Out, Fireplace, Wood Floor, Other, 17 x 14, Level 1, 238 Sq. Ft.
- Kitchen: Pantry, Quartz Counters, Counter Bar, Eat-In, Walk-Out, Gourmet, Island, Wood Cabinets, Wood Floor, Other, 15 x 13, 15x13, 195 Sq. Ft.
- Dining Room: Chandelier, Wood Floor, Other, 18 x 14, Level 1, 252 Sq. Ft.
- Breakfast Room: 8 x 5, Level 1, 40 Sq. Ft.
- Office/Den/Study: 12 x 10, Level 3, 120 Sq. Ft.
- Office: Wall-to-Wall Carpet
Additional Information
- Other Features: 220 Volts, Attic Storage, Bus Line Nearby
Exterior
- Exterior Features: Deck, Fire Pit, Porch, Other
Parking
- Parking: Off-Street Parking, Driveway
- Garage Description: None
Location
- Area: Madisonville
- County: Hamilton
- Township: Cincinnati City
- Suburb: Madisonville
- Cross Streets: Madison Rd
- Driving Directions: 71 S on Red Bank Rd, E on Madison Rd, N on Stewart Ave
School Information
- School District: Cincinnati City SD
- High School District: Cincinnati City SD
Community
- Home Owners Assn.: False
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Forced Air, Gas, Zoned, Other
- Heating Fuel: Natural
- Water Heater: Gas
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Architectural Style: Three Story Traditional, Victorian
- Exterior Const.: Brick, Wood Siding, Other
- Basement: Yes
- Basement Desc.: Full, Concrete Floor, Unfinished, Glass Block Windows, Other
- Foundation: Stone
- Roof: Shingle
- Windows: Vinyl, Wood, Other, Insulated
- Stories/Levels: Three
- Square Feet: 2,470
- Lower: 996 Sq. Ft.
- Year Built: 1910
Lot Features
- Lot Size (Acres): 0.169
- Lot Dimensions: 50 x 150
- Frontage: City Street
- Zoning: Residential
- Lot Description: Less than .5 Acre
- Fencing (Description): Metal, Privacy, Wood, Other
Financial Considerations
- Sub Lease Exp.: 1800-01-01T00:00:00-05:00
- Semi-Annual Taxes: $2623
Disclosures and Reports
- APN: 035-0001-0030-00
- Property ID: 035-0001-0030-00
Get Pre-Approved Today
Schools
Schools serving 5123 Stewart Ave
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
John P Parker Elementary School 5051 Anderson Place, Cincinnati, OH 45227 | PK-6 | 0.1 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 0.7 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 3.3 mi |
Clark Montessori High School 3030 Erie Avenue, Cincinnati, OH 45208 | 7-12 | 2.3 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 7.1 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 7.7 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 4.1 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 4.7 mi |
Aiken New Tech High School 5641 Belmont Avenue, Cincinnati, OH 45224 | 7-12 | 8.5 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 5123 Stewart Ave
Date
Details
Price
Change
Source
3/20/2026
Sold
$490,000
-1.01%
MLS
12/15/2025
Listed
$495,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
5123 Stewart Avenue, Cincinnati, OH 45227 (MLS# 1864018) is a Single Family property that was sold at $490,000 on March 20, 2026. This property was listed by Meg Perez from our Hyde Park Office.Want to learn more about 5123 Stewart Avenue? Do you have questions about finding other Single Family real estate for sale in Madisonville? You can browse all Madisonville real estate or contact a Coldwell Banker agent to request more information.


