333 Stanley Avenue Columbia/Tusculum, OH 45226
0.09
Acres
$495,000
MLS# 1871082
0
0.09 AC
Photos
Map
Photos
Map
More About 333 Stanley Avenue
Great mixed-use investment opportunity in the historic Columbia Tusculum neighborhood of Cincinnati! 333 Stanley Ave features a versatile commercial storefront with two residential rental units above, offering immediate income and long-term upside. The main level is currently operating as a tire shop but provides flexible commercial potentialideal for a tire or mechanic shop, small gym, retail space, workshop, and more. The second and third floors each feature 1-bedroom, 1-bath apartments. Unit 2 currently rents for $1,200/month and Unit 3 rents for $750/month, both on month-to-month leases, offering flexibility for investors or owner-occupants. Additional storage space is located in the rear of the building along with convenient off-street parking. Excellent opportunity for investors seeking mixed-use cash flow or entrepreneurs looking to operate a business while generating rental income above.
Connect with a loan officer to get started!
Directions to this Listing
: From rt 50 turn right onto Stanley Ave. The property is the 3rd house on the right.
Information Refreshed: 7/10/2026 8:00 AM
Property Details
MLS#:
1871082Type:
Multi FamilyCounty:
HamiltonAge:
89Construction:
BrickCooling:
Central AirGarage:
Garage AttachedHeating:
Gas, RadiantSchool District:
Cincinnati Public Schools
This listing courtesy of Daniel Morales (513) 503-7777, James Hurtubise (513) 766-0656, Keller Williams Advisors (513) 766-9200
Explore Columbia-Tusculum & Surrounding Area
Monthly Cost
Mortgage Calculator
Enter your details for an estimated monthly payment. See how much house you can afford
%
LEGAL DISCLAIMERS▼

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© 2026 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.




