CondominiumResidential
400 Pike St
CINCINNATI, OH 45202
1905
Year BuiltThe year the home was originally built, according to county records.
1
StoriesHow many floors the home has above ground.
1
ParkingThe number of parking spaces on the property, including the garage.
Built 19059 floors114 units945–4,184 ft²
$67M
All units combinedThe sum of our current value estimates for every unit in the building — roughly what the whole building's homes are worth together.
$555K
Median unit valueThe middle unit value in this building by our estimate: half the units are worth more, half less.
$328
Median $/ft²The middle price per square foot across the building's units, by our current estimates. Useful for comparing units of different sizes.
+12.4%vs the Cincinnati ZIP median sale $/ft² ($292)
Sales Performance
$458K
Median sale (12 mo)The middle sale price among this building's units that sold in the last 12 months, from recorded deeds.
-14.6%
1-yr changeHow the building's median sale price over the last 12 months compares with the 12 months before that.
6
Sales (12 mo)Units in this building that sold in the last 12 months, from recorded arms-length deeds.
5.3%
Turnover (12 mo)The share of units that changed hands in the last 12 months. Around 4–6% a year is typical; much higher can signal investor churn or a wave of exits.
This building's own appreciationThe building's own appreciation: for every unit that sold twice (held over a year), we compute its yearly price change between the two sales and take the middle value. This is the cleanest read on how this specific building performs, because it compares each unit to itself.
+1.9%per yeartypical hold 6.0 yrsfrom 143 same-unit resales
Median sale price (yearly, all time)Every recorded arms-length sale in the building since records begin, grouped by year: the bars count sales and the line tracks the median price paid.MedianSales
20052008201120142017202020232026
Sale price per ft² (yearly, all time)The middle price per square foot across the building's units, by our current estimates. Useful for comparing units of different sizes.$/ft²
20052008201120142017202020232026
264 arms-length sales on record for this building.
Unit Mix & Floor PlansThe building's recurring floor plans, found by grouping units with identical beds, baths and square footage in county records. Larger groups are the building's standard layouts; leftover units have one-off sizes.
Every unit: size vs estimated valueEvery unit in the building as one dot: across is its size, up is our current value estimate, and color is its bedroom count. Vertical columns of dots are recurring floor plans; the height spread within a column shows how much floor, view and condition move prices for the same layout.
1 bd2 bd3 bd4+ bd
1 bed
11 units$319K · $338/ft²
2 bed
84 units$530K · $327/ft²
3 bed
18 units$870K · $327/ft²
4 bed
1 unit$1.6M · $474/ft²
Recurring floor plansThe building's recurring floor plans, found by grouping units with identical beds, baths and square footage in county records. Larger groups are the building's standard layouts; leftover units have one-off sizes.
2 bd · 2 ba · 1,623 ft²
10 units$582K · $358/ft²
2 bd · 2 ba · 1,668 ft²
10 units$567K · $340/ft²
1 bd · 1 ba · 945 ft²
7 units$301K · $319/ft²
2 bd · 1 ba · 945 ft²
7 units$306K · $323/ft²
2 bd · 2 ba · 1,734 ft²
5 units$569K · $328/ft²
2 bd · 1 ba · 984 ft²
3 units$324K · $329/ft²
2 bd · 1 ba · 1,008 ft²
3 units$333K · $330/ft²
2 bd · 2 ba · 1,520 ft²
3 units$589K · $387/ft²
2 bd · 2 ba · 1,562 ft²
3 units$523K · $335/ft²
3 bd · 3 ba · 3,251 ft²
3 units$771K · $237/ft²
1 bd · 1 ba · 1,008 ft²
2 units$306K · $304/ft²
2 bd · 2 ba · 1,636 ft²
2 units$524K · $320/ft²
3 bd · 2 ba · 1,668 ft²
2 units$641K · $384/ft²
2 bd · 2 ba · 1,731 ft²
2 units$644K · $372/ft²
One-off layouts
52 units
Value DistributionHow the building's units spread across value ranges by our current estimates. A wide spread usually means big differences in size, floor or view.
$252K–$407K
28 units
$427K–$578K
42 units
$588K–$722K
24 units
$754K–$885K
9 units
$923K–$1.1M
6 units
$1.1M–$1.1M
1 unit
$1.3M–$1.3M
1 unit
$1.5M–$1.6M
3 units
Value by Floor & LineAverage estimated price per square foot by floor range, using unit numbers to infer floors. Higher floors usually price higher — the gap shows how much the view is worth here.
Floors 5–6
$314/ft²40 units · -4%
Floors 7–8
$329/ft²39 units · +0%
Floor 9
$334/ft²19 units · +2%
Unit lines by $/ft²Condo units stacked vertically share a unit line — the last digits of the unit number (like 05 in 1205, 1305, 1405). Lines share a layout and exposure, so comparing estimated $/ft² by line shows which position in the building commands a premium.
Line ·08
$380/ft²5 units · +16%
Line ·05
$375/ft²5 units · +14%
Line ·06
$359/ft²5 units · +9%
Line ·09
$342/ft²5 units · +4%
Line ·07
$339/ft²5 units · +3%
Line ·15
$335/ft²4 units · +2%
Line ·04
$332/ft²5 units · +1%
Line ·16
$323/ft²5 units · -1%
Line ·17
$321/ft²5 units · -2%
Line ·11
$320/ft²5 units · -2%
Line ·02
$319/ft²4 units · -3%
Line ·03
$318/ft²5 units · -3%
Ownership & Financing
Owner-occupiedThe share of units where the owner lives in the unit, per county records. The rest are second homes or rentals.84%
Company-ownedUnits owned through an LLC, trust, or other company — a rough proxy for investor ownership.19%
Typical owner tenureThe middle number of years since each unit last changed hands — how long the current owners have been in place.8.6 yrs
Cash purchases (5 yrs)The share of purchases in the last 5 years with no mortgage recorded. High cash share is common in second-home and investor buildings.53%
Avg. loan-to-valueAverage current loan balance against unit value across the building. Low numbers mean owners hold lots of equity — a sign of financial stability.40%
Median owner equityThe middle dollar amount of equity (value minus loans) unit owners hold in this building.$568,962
Median tax billThe middle annual property tax bill among the building's units.$11,238
Pre-foreclosure noticesUnits with an active pre-foreclosure or foreclosure notice on file.1
Recent SalesThe latest recorded arms-length sales in the building, newest first.
Unit 612Sep 29, 2026$565,000$324/ft²Unit 716Jul 13, 2026$315,000$333/ft²Unit 903Jun 29, 2026$350,000$347/ft²Unit 816Apr 16, 2026$325,000$344/ft²Unit P19Mar 20, 2026$1,300,000$400/ft²Unit 821Nov 21, 2025$585,000$337/ft²Unit 921Aug 1, 2025$536,000$309/ft²Unit 518May 2, 2025$275,000$291/ft²Unit 607Mar 28, 2025$580,000$348/ft²Unit P6Mar 19, 2025$640,000$394/ft²
Values are TopHap estimates, not appraisals. Sales, ownership and tax figures come from recorded county documents via ATTOM and can lag by several weeks.
Property Facts
Property TypeThe broad category the county puts this property in, such as residential or commercial.Condominium
StyleThe architectural style of the home, such as ranch or colonial.Conventional
CountyHamilton
HeatingThe type of heating system in the home.Yes
CoolingThe type of cooling or air conditioning in the home.Central
GarageWhether the property has a garage, and details like whether it is attached to the home.Garage, Basement
Assigned SchoolsThe public schools this address is zoned for. Boundaries change, so confirm with the district before you count on it.
ME
Robert A. Taft Information Technology High SchoolD-
Middle · Grades 7–12 · 1.1 mi
Hays-Porter Elementary SchoolC-
Elementary · Grades PK–6 · 1.2 mi
District: Cincinnati City School District
Neighborhood · ZIP 45202These are comparison scores, not percentages. 100 equals the national average, so 150 means about 50% above average.
CrimeLocal crime compared with the rest of the country, where 100 is average. It reflects things like population density, income, and how crime gets reported.167
Air pollutionOverall air pollution compared with the rest of the country, where 100 is average. Lower is cleaner.211
EarthquakeEarthquake risk and likely building damage compared with the rest of the country, where 100 is average. Scores can run far above 100.39
Index scale: 100 = US average (tick). Lower is better.
Homes occupiedThe share of homes here that someone lives in. The rest sit empty, including vacation and for-sale homes.84%
Bachelor's or higherThe share of adults 25 and older whose highest degree is a bachelor's degree.37%
Poverty rateThe share of people whose household income falls below the federal poverty line, which varies by family size.16%
UnemploymentThe share of men 16 and older who are out of work and actively looking. Only men are counted in this figure.1.6%
PopulationHow many people live in this area.18,424
DensityPeople per square mile. Higher numbers mean a more crowded, urban area.5,968 / mi²
Median incomeThe middle household income here — half of households earn more, half earn less.$78,373
Average incomeThe average household income. It runs higher than the median when a few high earners pull it up.$117,362
Average tempThe average temperature here across a full year.54°F
Annual precipHow much rain and melted snow falls here in a typical year.42 in
SunshineThe share of daylight hours that get direct sun in a typical year, counting cloud cover.51%
All UnitsEvery property record the county has at this street address, such as the units in a condo building. Prices shown are our estimates, not asking prices.
400 Pike St # P1
3 bd · 3.5 ba · 3,132 ft²
400 Pike St # P4
3 bd · 3.5 ba · 4,184 ft²
400 Pike St # P5
2 bd · 2 ba · 1,520 ft²
400 Pike St Unit P6
2 bd · 2 ba · 1,623 ft²
400 Pike St # P7
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit P8
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit P9
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit P10
2 bd · 3 ba · 2,295 ft²
400 Pike St Unit P11
4 bd · 5 ba · 3,350 ft²
400 Pike St Unit P14
2 bd · 3 ba · 2,484 ft²
400 Pike St Unit P15
2 bd · 2 ba · 2,016 ft²
400 Pike St # P17
1 bd · 1 ba · 980 ft²
400 Pike St # P18
1 bd · 1 ba · 945 ft²
400 Pike St # P19
3 bd · 2.5 ba · 3,251 ft²
400 Pike St Unit P20
2 bd · 3 ba · 1,616 ft²
400 Pike St Unit P21
2 bd · 3 ba · 1,768 ft²
400 Pike St Unit 501
2 bd · 3 ba · 2,122 ft²
400 Pike St Unit 502
2 bd · 1 ba · 984 ft²
400 Pike St Unit 503
1 bd · 1 ba · 1,008 ft²
400 Pike St Unit 504
3 bd · 3 ba · 3,121 ft²
400 Pike St Unit 505
2 bd · 2 ba · 1,520 ft²
400 Pike St Unit 506
2 bd · 2 ba · 1,623 ft²
400 Pike St # 507
2 bd · 2 ba · 1,668 ft²
400 Pike St # 508
2 bd · 2 ba · 1,668 ft²
400 Pike St # 509
2 bd · 2 ba · 1,623 ft²
400 Pike St # 510
2 bd · 2 ba · 1,714 ft²
400 Pike St Unit 511
3 bd · 2 ba · 2,243 ft²
400 Pike St Unit 512
2 bd · 2 ba · 1,745 ft²
400 Pike St Unit 514
2 bd · 2 ba · 1,967 ft²
400 Pike St Unit 515
2 bd · 2 ba · 1,562 ft²
400 Pike St # 516
2 bd · 1 ba · 945 ft²
400 Pike St Unit 517
1 bd · 1 ba · 945 ft²
400 Pike St Unit 518
1 bd · 1 ba · 945 ft²
400 Pike St Unit 519
3 bd · 3 ba · 3,251 ft²
400 Pike St # 520
2 bd · 2 ba · 1,608 ft²
400 Pike St Unit 521
2 bd · 2 ba · 1,734 ft²
400 Pike St Unit 601
2 bd · 3 ba · 2,122 ft²
400 Pike St # 602
1 bd · 1 ba · 984 ft²
400 Pike St Unit 603
2 bd · 1 ba · 1,008 ft²
400 Pike St # 604
3 bd · 3 ba · 3,170 ft²
400 Pike St Unit 605
2 bd · 2 ba · 1,588 ft²
400 Pike St Unit 606
2 bd · 2 ba · 1,623 ft²
400 Pike St # 607
3 bd · 2 ba · 1,668 ft²
400 Pike St Unit 608
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 609
2 bd · 3 ba · 1,623 ft²
400 Pike St Unit 610
2 bd · 2 ba · 1,765 ft²
400 Pike St Unit 611
2 bd · 2 ba · 2,243 ft²
400 Pike St # 612
2 bd · 2 ba · 1,745 ft²
400 Pike St # 614
2 bd · 2 ba · 1,916 ft²
400 Pike St # 615
2 bd · 2 ba · 1,540 ft²
400 Pike St # 616
2 bd · 1 ba · 945 ft²
400 Pike St Unit 617
2 bd · 1 ba · 945 ft²
400 Pike St # 618
1 bd · 1 ba · 945 ft²
400 Pike St # 619
3 bd · 2.5 ba · 3,251 ft²
400 Pike St Unit 620
2 bd · 2 ba · 1,629 ft²
400 Pike St Unit 621
2 bd · 2 ba · 1,734 ft²
400 Pike St Unit 701
3 bd · 4 ba · 3,108 ft²
400 Pike St Unit 703
2 bd · 1 ba · 1,008 ft²
400 Pike St Unit 704
3 bd · 3 ba · 3,165 ft²
400 Pike St Unit 705
2 bd · 2 ba · 1,500 ft²
400 Pike St Unit 706
2 bd · 2 ba · 1,584 ft²
400 Pike St # 707
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 708
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 709
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit 710
2 bd · 2 ba · 1,731 ft²
400 Pike St # 711
2 bd · 2 ba · 2,271 ft²
400 Pike St Unit 712
2 bd · 2 ba · 1,648 ft²
400 Pike St Unit 714
2 bd · 2 ba · 2,051 ft²
400 Pike St Unit 715
2 bd · 2 ba · 1,562 ft²
400 Pike St # 716
2 bd · 1 ba · 945 ft²
400 Pike St Unit 717
1 bd · 1 ba · 945 ft²
400 Pike St # 718
2 bd · 1 ba · 945 ft²
400 Pike St Unit 719
3 bd · 3 ba · 3,209 ft²
400 Pike St Unit 720
2 bd · 2 ba · 1,636 ft²
400 Pike St Unit 721
2 bd · 2 ba · 1,734 ft²
400 Pike St # 801
3 bd · 2.5 ba · 2,122 ft²
400 Pike St Unit 802
2 bd · 1 ba · 984 ft²
400 Pike St Unit 803
2 bd · 1 ba · 1,008 ft²
400 Pike St Unit 804
3 bd · 3 ba · 3,079 ft²
400 Pike St # 805
2 bd · 2 ba · 1,531 ft²
400 Pike St # 806
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit 807
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 808
3 bd · 2 ba · 1,668 ft²
400 Pike St Unit 809
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit 810
2 bd · 2 ba · 1,697 ft²
400 Pike St Unit 811
2 bd · 2 ba · 2,306 ft²
400 Pike St # 812
2 bd · 3 ba · 1,745 ft²
400 Pike St Unit 814
2 bd · 2 ba · 2,016 ft²
400 Pike St Unit 815
2 bd · 2 ba · 1,562 ft²
400 Pike St # 816
2 bd · 1 ba · 945 ft²
400 Pike St Unit 817
2 bd · 1 ba · 945 ft²
400 Pike St Unit 818
2 bd · 1 ba · 972 ft²
400 Pike St # 819
2 bd · 2.5 ba · 3,251 ft²
400 Pike St Unit 820
2 bd · 2 ba · 1,636 ft²
400 Pike St # 821
2 bd · 2 ba · 1,734 ft²
400 Pike St Unit 901
3 bd · 3 ba · 2,122 ft²
400 Pike St # 902
2 bd · 1 ba · 984 ft²
400 Pike St # 903
1 bd · 1 ba · 1,008 ft²
400 Pike St Unit 904
3 bd · 3 ba · 3,173 ft²
400 Pike St # 905
2 bd · 2 ba · 1,520 ft²
400 Pike St # 906
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit 907
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 908
2 bd · 2 ba · 1,668 ft²
400 Pike St Unit 909
2 bd · 2 ba · 1,623 ft²
400 Pike St Unit 910
2 bd · 2 ba · 1,731 ft²
400 Pike St Unit 911
2 bd · 3 ba · 2,306 ft²
400 Pike St Unit 912
2 bd · 2 ba · 1,709 ft²
400 Pike St Unit 914
2 bd · 3 ba · 2,730 ft²
400 Pike St Unit 916
2 bd · 2 ba · 1,707 ft²
400 Pike St Unit 917
1 bd · 1 ba · 945 ft²
400 Pike St Unit 918
1 bd · 1 ba · 945 ft²
400 Pike St Unit 919
3 bd · 3 ba · 3,251 ft²
400 Pike St Unit 920
2 bd · 2 ba · 1,670 ft²
400 Pike St Unit 921
2 bd · 2 ba · 1,734 ft²
Data by ATTOM. Valuations are automated estimates, not appraisals. Photos from Google Street View and may not depict the current property state.
About 400 Pike St
How many units are in 400 Pike St, Cincinnati, OH?
400 Pike St, Cincinnati, OH has 114 residential units across 9 floors, built in 1905, according to county assessor records.
What is a unit at 400 Pike St, Cincinnati, OH worth?
The median TopHap Estimate across the 114 units at 400 Pike St, Cincinnati, OH is $554,639. That works out to $328 per square foot. Units run from 945 to 4,184 square feet. Estimates are modelled from recorded sales and assessments, not appraisals.
Is 400 Pike St, Cincinnati, OH expensive for Cincinnati?
Units at 400 Pike St, Cincinnati, OH carry a median of $328 per square foot, 12% above the Cincinnati median of $292 per square foot.
How often do units sell at 400 Pike St, Cincinnati, OH?
6 units at 400 Pike St, Cincinnati, OH sold in the last 12 months, out of 264 recorded arms-length sales all time. That is a turnover rate of 5.3% of the building per year. The median sale over that period was $458K.
Have units at 400 Pike St, Cincinnati, OH appreciated?
Across 143 repeat sales of the same unit, 400 Pike St, Cincinnati, OH returned a median 1.9% per year. Because each pair is the same unit bought and sold, the figure is not distorted by which units traded. The median owner held for 6.0 years.
What floor plans does 400 Pike St, Cincinnati, OH have?
The most common plan at 400 Pike St, Cincinnati, OH is a 2-bedroom of 1,623 square feet, repeated 10 times, with a median estimate of $581,826. TopHap identifies 14 recurring plans in the building.
More homes on Pike St Unit 820
- 400 Pike St # 612$564K2 bd · 2 ba · 1,745 ft² · Sold $565K · Sep 2026
- 400 Pike St # 716$314K2 bd · 1 ba · 945 ft² · Sold $315K · Jul 2026
- 400 Pike St # 903$348K1 bd · 1 ba · 1,008 ft² · Sold $350K · Jun 2026
- 400 Pike St # 816$323K2 bd · 1 ba · 945 ft² · Sold $325K · Apr 2026
- 400 Pike St # P19$1.3M3 bd · 2.5 ba · 3,251 ft² · Sold $1.3M · Mar 2026
- 400 Pike St # 821$578K2 bd · 2 ba · 1,734 ft² · Sold $585K · Nov 2025
- 400 Pike St # 608$660K2 bd · 2 ba · 1,668 ft² · Sold Sep 2025
- 400 Pike St # 921$528K2 bd · 2 ba · 1,734 ft² · Sold $536K · Aug 2025
- 400 Pike St # P11$1.6M4 bd · 5 ba · 3,350 ft² · Sold Jul 2025
- 400 Pike St # 518$270K1 bd · 1 ba · 945 ft² · Sold $275K · May 2025
- 400 Pike St # P6$628K2 bd · 2 ba · 1,623 ft² · Sold $640K · Mar 2025
- 400 Pike St # 818$298K2 bd · 1 ba · 972 ft² · Sold $304K · Jan 2025
Closest homes
- 400 Pike St Unit 818$298K0 ft · 2 bd · 1 ba · 972 ft² · Sold $304K · Jan 2025
- 400 Pike St Unit 518$270K0 ft · 1 bd · 1 ba · 945 ft² · Sold $275K · May 2025
- 400 Pike St Unit P20$505K0 ft · 2 bd · 3 ba · 1,616 ft² · Sold $385K · Sep 2019
- 400 Pike St Unit 501$694K0 ft · 2 bd · 3 ba · 2,122 ft² · Sold $610K · May 2019
- 400 Pike St Unit 706$577K0 ft · 2 bd · 2 ba · 1,584 ft² · Sold $575K · May 2022
- 400 Pike St Unit P6$628K0 ft · 2 bd · 2 ba · 1,623 ft² · Sold $640K · Mar 2025
- 400 Pike St$1.3M0 ft · 3 bd · 2.5 ba · 3,251 ft² · Sold $1.3M · Mar 2026
- 400 Pike St Unit P10$757K0 ft · 2 bd · 3 ba · 2,295 ft² · Sold $638K · Jul 2009
More homes in Cincinnati 45202
- 399 Oregon St3 bd · 3 ba · 2,562 ft² · Sold Sep 2026
- 548 Liberty Hl$1.2M3 bd · 3.5 ba · 4,906 ft² · Sold $1.2M · Sep 2026
- 399 Oregon St3,498 ft² · Sold Sep 2026
- 988 Paradrome St$905K4 bd · 3.5 ba · 2,727 ft² · Sold $900K · Sep 2026
- 154 E Mcmicken Ave$477K2.5 ba · 2,237 ft² · Sold $475K · Sep 2026
- 1351 Broadway St4 bd · 4.5 ba · 3,986 ft² · Sold Sep 2026
- 1613 Walnut St3,504 ft² · Sold $130K · Sep 2026
- 1209 Wareham Dr3 bd · 2 ba · 2,314 ft² · Sold $378K · Sep 2026
- 1412 Republic St$230K1 bd · 1 ba · 855 ft² · Sold $230K · Sep 2026
- 1328 Republic St$350K2 ba · 1,100 ft² · Sold $330K · Sep 2026
- 15 W 4th St$458K2 bd · 2 ba · 1,673 ft² · Sold $459K · Sep 2026
- 1432 Race St$190K1 ba · 464 ft² · Sold $170K · Sep 2026
Assigned schools
Explore the area
See this home in context
Open 400 Pike St Unit 820 on TopHap’s interactive map to compare it against every sale nearby, overlay school zones and flood risk, and run a CMA.
Open in map