Search
Historic Mixed-Use Building in Northside
For Lease
Contact for pricing

4000 Colerain Avenue, Cincinnati, OH 45223

Historic building with retail and apartments in vibrant Northside.

Space Size2,440 SF
Property Size7,515 SF
Days on Market261

Property Features for 4000 Colerain Avenue

General Information

Standard status Active
Size 2,440 SF
Property subtype Retail

Building Details

Building Size 7,515 SF
Year Built 1910

Spaces For Lease

at 4000 Colerain Avenue Contact us

First Floor Corner Retail

Size
2,440 SF
Term
Negotiable
Rate
Contact for pricing
Contact us
Listing Agency: 3CRE Advisors, LLC - corporate
Listed By: Gabriela Costantini · License #OH #218754
Source: 3cre
Added: Nov 21, 2025 Changed: Aug 8 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

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

Current Use

Retail space

Suggested Use

Top Pick Law Firm Real Estate Agency Dental Office Spa & Massage Center Nail Salon Skin Care Clinic

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

NNN (Triple Net)
Lease Type

Location Intelligence

Trade Area within ½ mile

101
Businesses Nearby

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

Market

Lease Benchmarks for Cincinnati, OH

$21.37 /SF/Yr
Avg Asking Price
$2.39–$35 /SF/Yr
Price Range
10,717 SF
Avg Space Size

Vacancy Rate% for Multifamily in Midwest region

6.5% 2022
7.5% 2023
7.8% 2024
8% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

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).
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message