Investor special! Once upon a time in North Avondale, this mansion was the pride of a riverboat captain. Converted to a 3 FAM, it has unfortunately fallen on hard times but with vision and investment holds great potential! One can see how unique this property was at one time and with the right investor, could be something special again with great renting potential.
Details
MLS #
1871630
Listing Type
For Sale
Sub-Type
Resale
Status
Active
Year
1892
Days On Site
211
Listing Provided By
Sibcy Cline, Inc. | Elizabeth Soloria
Features
SQ Feet
4,546
Basement
Y
Story(s)
3
Units
3
Building(s)
1
Acreage
0.45
Interior
Rooms Total
0
Heating
Gas
Cooling
None
Window Features
Vinyl, Wood
Fireplace Features
Wood
Fireplaces Total
2
Exterior
Roof
Slate
Construction Materials
Brick
Foundation Details
Stone
Parking
Parking Features
Off Street, Driveway
Open Parking Spaces
0
Utilities
Sewer
Public Sewer
Gas
Natural
Area Information
State
OH
County
Hamilton
City
Cincinnati
Zip Code
45229
Area
Hamilton E01
Subarea
Hamilton E01
Community Name
Avondale
School District
Cincinnati City SD
High School
Cincinnati City SD
Listing VS Median (in Avondale)
Price: $199,000
low | high
Med: $309,498
5.526381909548% of Average
sqft: 4,546
low | high
Med: 2,923
85.701715794105% of Average
$ / sqft: $44
low | high
Med: $107
94.673946499147% of Average
On site: 211
low | high
Med: 92.5
100% of Average
Sourced by Back At You
Market Activity 45229
Date
Sales
Avg $ Per SqFt
Min Sale Price
Max Sale Price
Med Sale Price
Date: Sep 2026
Sales: 1
Avg $ Per SqFt: $158.31
Min Sale Price: $385,000
Max Sale Price: $385,000
Med Sale Price: $385,000
Date: Aug 2026
Sales: 2
Avg $ Per SqFt: $217.65
Min Sale Price: $370,000
Max Sale Price: $390,000
Med Sale Price: $380,000
Date: Jul 2026
Sales: 7
Avg $ Per SqFt: $157.43
Min Sale Price: $47,500
Max Sale Price: $725,000
Med Sale Price: $372,000
Date: Jun 2026
Sales: 8
Avg $ Per SqFt: $108.27
Min Sale Price: $75,000
Max Sale Price: $725,000
Med Sale Price: $180,500
Date: May 2026
Sales: 2
Avg $ Per SqFt: $170.84
Min Sale Price: $375,000
Max Sale Price: $525,000
Med Sale Price: $450,000
Date: Apr 2026
Sales: 11
Avg $ Per SqFt: $158.67
Min Sale Price: $32,000
Max Sale Price: $990,000
Med Sale Price: $549,900
Date: Mar 2026
Sales: 11
Avg $ Per SqFt: $159.28
Min Sale Price: $165,000
Max Sale Price: $1,150,000
Med Sale Price: $450,000
Date: Feb 2026
Sales: 10
Avg $ Per SqFt: $141.62
Min Sale Price: $25,000
Max Sale Price: $1,185,000
Med Sale Price: $240,000
Date: Jan 2026
Sales: 3
Avg $ Per SqFt: $160.4
Min Sale Price: $290,000
Max Sale Price: $350,000
Med Sale Price: $335,000
Date: Dec 2025
Sales: 4
Avg $ Per SqFt: $122.42
Min Sale Price: $73,500
Max Sale Price: $950,000
Med Sale Price: $309,500
Date: Nov 2025
Sales: 6
Avg $ Per SqFt: $125.61
Min Sale Price: $90,000
Max Sale Price: $792,000
Med Sale Price: $281,300
Date: Oct 2025
Sales: 11
Avg $ Per SqFt: $133.73
Min Sale Price: $73,000
Max Sale Price: $780,000
Med Sale Price: $330,000
Sourced by Back At You
Sep 2026
Sales:
1
Avg $ Per SqFt:
$158.31
Min Sale Price:
$385,000
Max Sale Price:
$385,000
Med Sale Price:
$385,000
Aug 2026
Sales:
2
Avg $ Per SqFt:
$217.65
Min Sale Price:
$370,000
Max Sale Price:
$390,000
Med Sale Price:
$380,000
Jul 2026
Sales:
7
Avg $ Per SqFt:
$157.43
Min Sale Price:
$47,500
Max Sale Price:
$725,000
Med Sale Price:
$372,000
Jun 2026
Sales:
8
Avg $ Per SqFt:
$108.27
Min Sale Price:
$75,000
Max Sale Price:
$725,000
Med Sale Price:
$180,500
May 2026
Sales:
2
Avg $ Per SqFt:
$170.84
Min Sale Price:
$375,000
Max Sale Price:
$525,000
Med Sale Price:
$450,000
Apr 2026
Sales:
11
Avg $ Per SqFt:
$158.67
Min Sale Price:
$32,000
Max Sale Price:
$990,000
Med Sale Price:
$549,900
Mar 2026
Sales:
11
Avg $ Per SqFt:
$159.28
Min Sale Price:
$165,000
Max Sale Price:
$1,150,000
Med Sale Price:
$450,000
Feb 2026
Sales:
10
Avg $ Per SqFt:
$141.62
Min Sale Price:
$25,000
Max Sale Price:
$1,185,000
Med Sale Price:
$240,000
Jan 2026
Sales:
3
Avg $ Per SqFt:
$160.4
Min Sale Price:
$290,000
Max Sale Price:
$350,000
Med Sale Price:
$335,000
Dec 2025
Sales:
4
Avg $ Per SqFt:
$122.42
Min Sale Price:
$73,500
Max Sale Price:
$950,000
Med Sale Price:
$309,500
Nov 2025
Sales:
6
Avg $ Per SqFt:
$125.61
Min Sale Price:
$90,000
Max Sale Price:
$792,000
Med Sale Price:
$281,300
Oct 2025
Sales:
11
Avg $ Per SqFt:
$133.73
Min Sale Price:
$73,000
Max Sale Price:
$780,000
Med Sale Price:
$330,000
MLS Number: 1871630
Elizabeth Soloria – esoloria@sibcycline.com
Sibcy Cline, Inc. – (513) 793-2121
Request a showing
Request a showing
The information is being provided by CincyMLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 CincyMLS. All Rights Reserved.
