For Lease
    • For Sale
    • For Lease
    • 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
    Claim this Listing
    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:
    160
    Last Refresh:
    Apr 5 at 8:09 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