Historic Mixed-Use Building in
4000 Colerain Avenue, Cincinnati, OH 45223
For Lease
Contact for pricing
Historic building with retail and apartments in vibrant Northside.
Space Size2,440 SF
Property Size7,515 SF
Days on Market354
Property Features for 4000 Colerain Avenue
General Information
Standard status
Size
Property subtype
Site & Location
Neighborhood
Building Details
Building Size
Year Built
Spaces For Lease
at 4000 Colerain Avenue
First Floor Corner Retail
Size
2,440 SF
Term
Negotiable
Rate
Contact for pricing
Listing Agency:
3CRE Advisors, LLC - corporate
Listed By:
Gabriela Costantini · License OH #218754
(513) 600-6168
Source:
3cre
Added: Nov 21, 2025
Changed: Aug 9
Last Checked: May 19 at 9:22PM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of 3CRE Advisors, LLC - corporate
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.
Investment Insights
Based on property information with market context.
This historic mixed-use property, formerly the Farmer's Hotel, is located in the Northside neighborhood. The building features approximately 2,000 square feet of street-level retail space and six modernized apartments above. The property combines new construction with historic elements. Built in 1859, it is the oldest standing commercial building in Northside and the only remaining former hotel that housed farmers and their livestock during the 19th-century heyday of Porkopolis. The commercial space offers opportunities for various businesses, including retail stores, cocktail bars, and restaurants. The Hamilton County Landbank saved the structure from demolition and stabilized it for future redevelopment in 2014, following the City Historic Landmark designation. Northside Cincinnati is a diverse and vibrant neighborhood known for its artistic community, historic architecture, and unique local businesses. The neighborhood features numerous art galleries, live music venues, and theaters. The area boasts a variety of locally-owned businesses, including eclectic shops, restaurants, and bars. Northside has several parks and green spaces, including Hoffner Park, which hosts community events and gatherings. The neighborhood has good access to public transportation, with bus routes connecting it to downtown Cincinnati and other parts of the city. Northside is actively attracting multifamily residences, retailers, and various other developments to revitalize its urban landscape and promote economic growth. The property is located at the corner of Colerain and Hoffner.
Key Highlights
- Mixed‑use property with street‑level retail space and six fully modernized apartments.
- Located in the vibrant and up‑and‑coming Northside neighborhood.
- Historic building, the oldest standing commercial building in Northside (built in 1859).
Property Analytics
Who owns this building?
See the owner, sales and loan history
Open Analytics
Current Use
Lease Details
NNN (Triple Net)
Lease Type
Location Intelligence
Trade Area within ½ mile
828
Businesses Nearby
Explore this area
Business Placement
Demographics for 45223, OH
13,174
Population
6,765
Households
1.9
Avg Household Size
33
Median Age
43%
College-Educated
91%
High-School Grad
4.6 sq mi
ZIP Area
2,864
Density / Sq Mi
$46,930
Median Household Income
$41,482
Median Earnings
$914
Median Rent
$203,800
Median Home Value
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Lease Benchmarks for Cincinnati, OH
$19.65 /SF/Yr
Avg Asking Price
$4.29–$35 /SF/Yr
Price Range
7,665 SF
Avg Space Size
Average Price Trend$/SF/Yr for Retail space in Cincinnati, OH
Properties on Market for Retail space in Cincinnati
Vacancy Rate% for Multifamily in Midwest region
Frequently Asked Questions
What type of property is this?
Retail space - Historic building with retail and apartments in vibrant Northside.
Where is this retail space located?
The property is located at 4000 Colerain Avenue Cincinnati, OH.
What are key features of this property?
This property features: Mixed‑use property with street‑level retail space and six fully modernized apartments.; Located in the vibrant and up‑and‑coming Northside neighborhood.; Historic building, the oldest standing commercial building in Northside (built in 1859).
