$550,000

( )

$3,659 est/mo Sourced by Back At You

333 Stanley Avenue,Cincinnati, OH 45226

Cincinnati, OH 45226

Images Map

Description

Mixed-use investment opportunity in Columbia Tusculum! Commercial storefront currently operating as a tire shop with two residential rental units above. Unit 2 rents for $1200/mo and Unit 3 for $750/month. Rear storage and off-street parking. Zoned CC-M. Value-add potential in a prime Cincinnati location.

Details

MLS #	1893403
Listing Type	For Sale
Style	Retail
Sub-Type	Resale
Status	Active
Year	1927
Days On Site	21
Listing Provided By	Comey & Shepherd \| Laura M. Zembrodt

Features

Story(s)	2
Building(s)	1
Zoning	Commercial,See Remarks
Acreage	0.09

Interior

Rooms Total	0
Heating	Gas
Cooling	Central Air
Fireplaces Total	0

Exterior

Roof	Shingle
Construction Materials	Brick
Foundation Details	Slab

Parking

Parking Features	Lot, Onsite

Utilities

Sewer	Public Sewer
Gas	Natural

Taxes

Property	2323

Area Information

State	OH
County	Hamilton
City	Cincinnati
Zip Code	45226
Area	Hamilton E04
Subarea	Hamilton E04
Community Name	Columbia/Tusculum
Listing VS Median (in Columbia/Tusculum)
Price: $550,000 low \| high Med: $429,000 72% of Average On site: 21 low \| high Med: 43.5 48.275862068966% of Average

Sourced by Back At You

Market Activity 45226

Date	Sales	Avg $ Per SqFt	Min Sale Price	Max Sale Price	Med Sale Price
Date: Aug 2026	Sales: 4	Avg $ Per SqFt: $293.84	Min Sale Price: $263,000	Max Sale Price: $985,000	Med Sale Price: $661,265
Date: Jul 2026	Sales: 8	Avg $ Per SqFt: $286.03	Min Sale Price: $197,000	Max Sale Price: $835,000	Med Sale Price: $490,000
Date: Jun 2026	Sales: 9	Avg $ Per SqFt: $257.75	Min Sale Price: $234,000	Max Sale Price: $902,000	Med Sale Price: $485,000
Date: May 2026	Sales: 10	Avg $ Per SqFt: $305.56	Min Sale Price: $20,000	Max Sale Price: $1,800,000	Med Sale Price: $623,000
Date: Apr 2026	Sales: 16	Avg $ Per SqFt: $276.44	Min Sale Price: $225,300	Max Sale Price: $1,050,000	Med Sale Price: $597,500
Date: Mar 2026	Sales: 10	Avg $ Per SqFt: $232.15	Min Sale Price: $250,000	Max Sale Price: $1,200,000	Med Sale Price: $392,500
Date: Feb 2026	Sales: 8	Avg $ Per SqFt: $283.23	Min Sale Price: $250,000	Max Sale Price: $950,000	Med Sale Price: $607,450
Date: Jan 2026	Sales: 7	Avg $ Per SqFt: $257.37	Min Sale Price: $395,000	Max Sale Price: $775,000	Med Sale Price: $470,000
Date: Dec 2025	Sales: 5	Avg $ Per SqFt: $219.1	Min Sale Price: $255,000	Max Sale Price: $398,000	Med Sale Price: $347,000
Date: Nov 2025	Sales: 12	Avg $ Per SqFt: $179.53	Min Sale Price: $6,000	Max Sale Price: $800,000	Med Sale Price: $292,000
Date: Oct 2025	Sales: 8	Avg $ Per SqFt: $250.14	Min Sale Price: $40,000	Max Sale Price: $1,320,000	Med Sale Price: $485,450

Sourced by Back At You

Aug 2026
Sales:	4
Avg $ Per SqFt:	$293.84
Min Sale Price:	$263,000
Max Sale Price:	$985,000
Med Sale Price:	$661,265
Jul 2026
Sales:	8
Avg $ Per SqFt:	$286.03
Min Sale Price:	$197,000
Max Sale Price:	$835,000
Med Sale Price:	$490,000
Jun 2026
Sales:	9
Avg $ Per SqFt:	$257.75
Min Sale Price:	$234,000
Max Sale Price:	$902,000
Med Sale Price:	$485,000
May 2026
Sales:	10
Avg $ Per SqFt:	$305.56
Min Sale Price:	$20,000
Max Sale Price:	$1,800,000
Med Sale Price:	$623,000
Apr 2026
Sales:	16
Avg $ Per SqFt:	$276.44
Min Sale Price:	$225,300
Max Sale Price:	$1,050,000
Med Sale Price:	$597,500
Mar 2026
Sales:	10
Avg $ Per SqFt:	$232.15
Min Sale Price:	$250,000
Max Sale Price:	$1,200,000
Med Sale Price:	$392,500
Feb 2026
Sales:	8
Avg $ Per SqFt:	$283.23
Min Sale Price:	$250,000
Max Sale Price:	$950,000
Med Sale Price:	$607,450
Jan 2026
Sales:	7
Avg $ Per SqFt:	$257.37
Min Sale Price:	$395,000
Max Sale Price:	$775,000
Med Sale Price:	$470,000
Dec 2025
Sales:	5
Avg $ Per SqFt:	$219.1
Min Sale Price:	$255,000
Max Sale Price:	$398,000
Med Sale Price:	$347,000
Nov 2025
Sales:	12
Avg $ Per SqFt:	$179.53
Min Sale Price:	$6,000
Max Sale Price:	$800,000
Med Sale Price:	$292,000
Oct 2025
Sales:	8
Avg $ Per SqFt:	$250.14
Min Sale Price:	$40,000
Max Sale Price:	$1,320,000
Med Sale Price:	$485,450

Request a showing

Contact

Learn More About This Property

Carter Dominy

e-Merge Real Estate Champions

(419) 565-9629 carter.dominy@e-merge.com

State	OH
County	Hamilton
City	Cincinnati
Zip Code	45226
Area	Hamilton E04
Subarea	Hamilton E04
Community Name	Columbia/Tusculum
Listing VS Median (in Columbia/Tusculum)
Price: $550,000 low \| high Med: $429,000 72% of Average On site: 21 low \| high Med: 43.5 48.275862068966% of Average

Sourced by Back At You

Nearby Listings (Within 1/10 mile)

Price: $412K - $687K

sqft: 0 - 0

Nearby Listings Property Image	Nearby Listings Details
	$495,000 3610 Columbia Parkway Cincinnati, OH 45226

Listing Updated: September 28, 2026 at 5:42:46 PM PDT

333 Stanley Avenue,Cincinnati, OH 45226

Cincinnati, OH 45226

Description

Details

Features

Interior

Exterior

Parking

Utilities

Taxes

Area Information

Market Activity 45226

Request a showing

Request a showing

Contact

Additional Information

Showing Information

Submit Form

Contact

Learn More About This Property

Carter Dominy

e-Merge Real Estate Champions

Contact

Additional Information

Submit Form

Attachments

Loading

$495,000

Carter Dominy - e-Merge Real Estate Champions Mansfield - e-Merge Real Estate

333 Stanley Avenue,Cincinnati, OH 45226

Cincinnati, OH 45226

Share:

Description

Details

Features

Interior

Exterior

Parking

Utilities

Taxes

Area Information

Market Activity 45226

Request a showing

Request a showing

Contact

Additional Information

Showing Information

Submit Form

Contact

Learn More About This Property

Carter Dominy

e-Merge Real Estate Champions

Contact

Additional Information

Submit Form

Attachments

Loading

$495,000

Carter Dominy - e-Merge Real Estate Champions Mansfield - e-Merge Real Estate