For Lease
  • For Sale
  • For Lease
  • Recently Sold
  • Property Lookup
  • Brokers
Back to Search
The Largest CRE Database in the US with Over 1 Million Listings

4000 Colerain Ave Cincinnati, OH 45223

View on Map
Loading data...
Loading data...
Loading data...
For Lease
Contact for pricing

Historic building with retail and apartments in vibrant Northside.

Type:Retail
Property size:
7,515 SF
Added:
Nov 21, 2025
Days on Market:
133
Last Refresh:
Apr 1 at 8:04 pm

Property Features for 4000 Colerain Ave

General Information

Standard status
Active
Size
7,515 SF
Property subtype
Retail

Building Details

Year Built
1910

Spaces For Lease

at 4000 Colerain Ave Contact us

We can help!

Listing Contact
Gabriela Costantini
Gabriela Costantini

Listing agent Gabriela Costantini License #OH #218754

Listing office 3CRE Advisors, LLC - corporate

Listing date Nov 21, 2025

Source 3cre

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


Overview

Historic Mixed-Use Building in Northside

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.
Property Profile Insight Report Location Intelligence

Current Use by Public Records

Retail space

Suggested Use

Real Estate Agency Restaurant Law Firm Spa & Massage Center Dental Office Hair Salon Nail Salon Building Supply Auto Repair Shop Gym & Fitness Center

Zoning and permitted uses should be independently verified with local authorities.

Location Insight

  • Map
  • Local Demand
City
Cincinnati
County
Clermont
State
Ohio
Longitude
-84.5445
Latitude
39.1589

FAQs

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 Ave 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