4000 Colerain Avenue Northside, OH 45223
0.06
Acres
$1
MLS# 1846480
0
0.06 AC
Photos
Map
Photos
Map
Received 06/30/2025
More About 4000 Colerain Avenue
Located in the heart of Northside, 4000 Colerain Ave offers a unique opportunity to lease a recently renovated mixed-use property with a rich historical background. Once the iconic Farmers Hotel, this building has been thoughtfully restored. The ground floor features nearly 2,000 square feet of white-boxed space, ready for the incoming tenant's vision. This space is well-suited for a boutique, creative office space, photography studio, or fitness concept. Six newly updated apartments above create a built-in community and provide steady foot traffic. Ownership requesting $18-20/psf for space
Connect with a loan officer to get started!
Directions to this Listing
: From Blue Rock, L on Colerain
Information Refreshed: 6/30/2025 7:18 PM
Property Details
MLS#:
1846480Type:
RetailCounty:
HamiltonBasement:
PartialConstruction:
BrickCooling:
Central AirFlooring:
Not ApplicableGas:
NaturalHeat:
Gas, Central, ElectricParking:
Lot, On StreetSewer:
PublicSite:
Commercial Area, FreestandingWater:
PublicZone:
Commercial
Online Views:
0This listing courtesy of Rachel Thompson (513) 290-2511 , 3CRE Residential Advisors, LLC (513) 745-9333
Explore Northside & Surrounding Area
Monthly Cost
Mortgage Calculator
*The rates & payments shown are illustrative only.
Payment displayed does not include taxes and insurance. Rates last updated on 6/26/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.
Payment displayed does not include taxes and insurance. Rates last updated on 6/26/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.

Sell with Sibcy Cline
Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.
Must reads

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. Those listings held by brokerage firms other than Sibcy Cline, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Copyright© 2022 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.