Start of property details

share this property:

MY ACCOUNT

Dashboard

Viewed Properties Saved Properties

Recent Searches New Listing Alerts Saved Searches

Contact Agent Start A New Search

Existing Members Log in Here

Create Your Account

Log Out

SAVE SAVED SHARE PRINT

NEW SEARCH

See all 29 Photos

1 / 30

Show Map Show Gallery

Request a Showing

4000 Colerain Avenue

Cincinnati, OH 45223

FOR

SALE

$1

Active

0.06

Acres

MLS# 1846480

Cumulative Days on Market: 55 (since June 30th, 2025) Data provided by the MLS.

Request a Showing Request Info Contact Agent

Property Description

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

Get Directions

Print Flyer

Ask a Local Expert

Comments and Questions

*Your Name

Submit Question

Property Highlights

Price

$1

Property Type

Commercial Sale

Property Sub Type

Retail

Living Area

0.00

Acres

0.06

Location

Area

Hamilton-W05

County

Hamilton

Property Details

Price

$1

Property Sub Type

Retail

Property Type

Commercial Sale

Building

Levels

One

Interior Features

Rooms and Basement

Basement Features

Partial

Interior Features

Flooring

Not Applicable

Heating and Cooling

Heating Features

Central, Electric, Gas

Building Details

Construction

Foundations

Stone

Materials

Construction Materials

Brick

Roof

Slate

Heating, Cooling & Utilities

Cooling Features

Central Air

Utilities

Sewer

Public Sewer

Water Source

Public

Lot

Acres

6

Lot Size Area Sq Ft

2,701

Parking

Parking Features

Lot, On Street

Listed by Rachel L Thompson, 3cre Residential Advisors, LLC.

Listing Data last updated 08/15/2025 10:40 am

Get a Link to this Property: Copy To Clipboard

Save Property

View Census Data

View Schools

Phone:

Connect with:

Request a Showing

Contact Agent

Payment Calculator

per month. fixed. % interest.

Home Price Loan Type Rate

$

10 year 15 year 20 year 25 year 30 year 40 year

%

Down Payment

$

%

Principal & Interest

+ Home Insurance

+ Property Tax

+ HOA Fees

Total interest paid over s will be:

All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 15-Aug-2025 and are subject to change without notice. All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified. See assumptions and disclosures

Assumptions and Disclosures

×

• Interest rates and APRs presented are based on current market rates, are for informational purposes only, are subject to change without notice and may be subject to pricing add-ons related to property type, loan amount, loan-to-value, credit score and other variables - call for details.
• This is not a credit decision or a commitment to lend.
• Depending on loan guidelines, mortgage insurance may be required
• If mortgage insurance is required, the mortgage insurance premium could increase the APR and the monthly mortgage payment. Additional loan programs may be available.
• APR (annual percentage rate) reflects the effective cost of your loan on a yearly basis, taking into account such items as interest, most closing costs, discount points (also referred to as "points"), and loan-origination fees. One point is 1% of the mortgage amount (e.g., $1,000 on a $100,000 loan).
• Your monthly payment is not based on APR, but instead on the interest rate on your Note.
• Adjustable Rate Mortgage (ARM) rates assume no increase in the financial index after the initial fixed period. ARM rates and monthly payments are subject to increase after the fixed period.
• These special rates presented here are only available when you pre-qualify and are not guaranteed until lock-in.
• Amounts may be rounded up. Additional fees and closing costs apply. If the down payment is less than 20%, mortgage insurance may be needed, which could increase the monthly payment and APR.
• Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
• Please contact a loan specialist to get specific payment examples and information regarding your particular needs.

Get Walk Score Content

Property History

35 days ago

Property information last updated

45 days ago

Status Active. This is the date the listing was placed on market.

82406 days ago

Date Sold

Cumulative Days on Market: 55 (since June 30th, 2025) Data provided by the MLS.

Similar Properties

The content relating to real estate in this web site comes in part from the Internet Data eXchange (IDX) program of Cincinnati MLS . This information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Display of MLS data and information is usually deemed reliable but is not guaranteed accurate by the MLS. Supplied Open House Information is subject to change without notice. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Broker/Agent may have been included in the MLS data. The Broker/Agent operating this web site believes the data here to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. All information is subject to change and should be independently verified.
© 2025 Cincinnati MLS .

DMCA Notice

Privacy Policy

Listing Data last updated: 08/15/2025 10:40 am

Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2025 Buying Buddy. All rights reserved.

Save Property Saved!

Share

Email to a friend Share on Facebook Copy Link for Instagram Share on Twitter Share on Pinterest! Copy Direct Link

Actions For Property

Request a Tour Request Info Notes Property Alerts Send to Friend My Account

4000 Colerain Avenue - MLS#1846480 - $1

Listed by 3cre Residential Advisors, LLC

{"property_id":"oh417_1846480","AboveGradeFinishedArea":"0","AccessibilityFeatures":"","Appliances":"","ArchitecturalStyle":"","AssociationAmenities":"","AssociationFee":"0.00","AssociationFeeFrequency":"","AssociationFeeIncludes":"","AssociationYN":"0","AttributionContact":"","Basement":"Partial","BasementYN":"","BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"0","BuilderModel":"","BuilderName":"","BuyerAgentFullName":"","BuyerAgentEmail":"","BuyerAgentDirectPhone":"","BuyerOfficeName":"","CapRate":"0.00","CityRegion":"","CommunityFeatures":"","ComplexName":"","ConstructionMaterials":"Brick","Contingency":"","Cooling":"Central Air","CountyOrParish":"Hamilton","CoveredSpaces":"0","DevelopmentName":"","DevelopmentStatus":"","DirectionFaces":"","DoorFeatures":"","Electric":"","ElementarySchool":"","Exclusions":"","ExteriorFeatures":"","Fencing":"","FireplaceFeatures":"","FireplaceYN":"","FireplacesTotal":"0","Flooring":"Not Applicable","FoundationDetails":"Stone","GarageSpaces":"0.00","GreenBuildingVerificationType":"","GreenEnergyEfficient":"","GreenEnergyGeneration":"","GreenIndoorAirQuality":"","GreenLocation":"","GreenSustainability":"","GreenWaterConservation":"","Heating":"Central, Electric, Gas","HighSchool":"","HorseAmenities":"","HorseYN":"","Inclusions":"","IndoorFeatures":"","InteriorFeatures":"","InternetAddressDisplayYN":"","LaundryFeatures":"","Levels":"One","ListingTerms":"","ListAgentFullName":"Rachel L Thompson","LivingArea":"0.00","LotFeatures":"","LotSizeArea":"0.00","LotSizeSquareFeet":"2701.00","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"","Model":"","NewConstructionYN":"0","NumberOfUnitsTotal":"0","OtherParking":"","Ownership":"","ParkingFeatures":"Lot, On Street","ParkingTotal":"0","PatioAndPorchFeatures":"","PoolFeatures":"","PoolYN":"","PoolPrivateYN":"","PropertyCondition":"","public_remarks":"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","Roof":"Slate","RoomsTotal":"0","SchoolDistrict":"","SecurityFeatures":"","SeniorCommunityYN":"","Sewer":"Public Sewer","SpaFeatures":"","SpaYN":"","SpecialListingConditions":"","StandardStatus":"","StateRegion":"","StoriesTotal":"0","StructureType":"","SuburbSIC":"Northside","TaxAnnualAmount":"0.00","Utilities":"","View":"","ViewYN":"","VirtualTourURLUnbranded":"","WalkScore":"0","WaterBodyName":"","WaterSource":"Public","WaterfrontFeatures":"","WaterfrontYN":"","WindowFeatures":"","YearBuilt":"0","Zoning":"","ZoningDescription":"","headline_txt":"","description_txt":"","property_uid":"1275758","listing_status":"active","mls_status":"Active","mls_id":"oh417","listing_num":"1846480","acreage":"","acres":"0.06","address":"","address_direction":"","address_flg":"1","address_num":"4000","agent_id":"2021007394","area":"Hamilton-W05","baths_total":"0.00","bedrooms_total":"0","car_spaces":"0","city":"Cincinnati","coseller_id":"","coagent_id":"","days_on_market":"17","finished_sqft_total":"0","geocode_address":"4000 Colerain Avenue","geocode_status":"","lat":"0","lon":"0","map_flg":"true","office_id":"TCRE02","office_name":"3CRE Residential Advisors,  LLC","orig_price":"1","photo_count":"29","photo_count_lac":"29","previous_price":"0","price":"1","prop_img":"\/listing\/photos\/oh417\/1846480-1.jpeg","property_type":"Commercial Sale","property_subtype":"Retail","sqft_total":"0","state":"OH","street_type":"Avenue","street_name":"Colerain","sub_area":"","unit":"","zip_code":"45223","listing_dt":"2025-06-24","undercontract_dt":"0000-00-00","openhouse_dt":null,"price_change_dt":"0000-00-00","seller_id":"","seller_office_id":"","sold_dt":"1800-01-01","sold_price":"0","webapi_update_dt":"2025-07-07 16:55:27","update_dt":"2025-07-11 06:09:23","create_dt":"2025-06-30 23:39:09","marketing_headline_txt":null,"use_marketing_description_txt":null,"banner_flg":null,"banner_headline":null,"banner_location":null,"banner_description":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}