Shawn Bosse
Coldwell Banker Realty, Anders
(513) 586-5923
114 Total Sales
2 in Columbia Tusculum
$200K - $455K Price Range
504 1/2 Delta Ave Cincinnati, OH 45226
Columbia Tusculum Neighborhood
4
Beds
3.5
Baths
3,460
Sq Ft
3,267
Sq Ft Lot
Highlights
- Eat-In Gourmet Kitchen
- Heated Floor in Bathroom
- Marble Flooring
- Walnut Hills High School Rated A+
- Contemporary Architecture
- Solid Surface Countertops
About This Home
As of July 2026Modern luxury meets prime location at 504 1/2 Delta Ave! Built in 2022 with tax abatement through 2031, this 3,460 SF home offers 4 bedrooms, 3.5 baths, and a 2-car oversized attached garage. Sleek fiber cement exterior, covered front porch with statement chandelier, and spacious covered balcony perfect for entertaining. Thoughtful design with laminate wood floors throughout. Chef's kitchen features 36 gas cooktop, double convection ovens, coffee bar, and wine refrigerator. Tankless water heater. Finished lower level with garage walkout includes rec room with wet bar, beverage fridge, and guest suite. Walk to the Ohio River, Mt. Lookout, and Alms Park. Surrounded by top dining, nightlife, shopping, and fitness.
Last Agent to Sell the Property
Plum Tree Realty License #2005005137 Listed on: 03/26/2026
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $1,000
Year Built
- Built in 2022
Lot Details
- 3,267 Sq Ft Lot
- Lot Dimensions are 25x135
Parking
- 2 Car Garage
- Oversized Parking
- Rear-Facing Garage
- Driveway
- On-Street Parking
Home Design
- Contemporary Architecture
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 3,460 Sq Ft Home
- 2-Story Property
- Bookcases
- Chandelier
- Gas Fireplace
- Vinyl Clad Windows
- Window Treatments
- Entrance Foyer
- Great Room with Fireplace
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Double Convection Oven
- Kitchen Island
- Solid Surface Countertops
- Solid Wood Cabinet
Flooring
- Laminate
- Marble
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Heated Floor in Bathroom
- Dual Vanity Sinks in Primary Bathroom
- Bathtub
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Balcony
- Covered Deck
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Tankless Water Heater
- Gas Water Heater
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Nov 3, 2022
Sold by
Bmf99 Llc
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$740,000
Outstanding Balance
$687,516
Interest Rate
3.75%
Mortgage Type
New Conventional
Estimated Equity
$135,115
Purchase Details
Closed on
Oct 28, 2022
Sold by
Bmf99 Llc
Bought by
Smith Kayla J
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$740,000
Outstanding Balance
$687,516
Interest Rate
3.75%
Mortgage Type
New Conventional
Estimated Equity
$135,115
Purchase Details
Closed on
Feb 20, 2019
Sold by
Clutsam Henry
Bought by
Bmf99 Llc
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Columbia Tusculum, OH
-
Shawn Bosse
-
Patrick Lach
Patrick Lach
Responds QuicklySibcy Cline, Inc.
(513) 952-8835
108 Total Sales
1 in Columbia Tusculum
$330,000 Price
-
Hillary Justice
Hillary Justice
Coldwell Banker Realty
(513) 647-6201
180 Total Sales
5 in Columbia Tusculum
$225K - $499K Price Range
-
Helena Cameron
Helena Cameron
Sibcy Cline, Inc.
(513) 952-8574
317 Total Sales
1 in Columbia Tusculum
$375,000 Price
-
Steven Booth
Steven Booth
Sibcy Cline, Inc.
(947) 210-5365
91 Total Sales
1 in Columbia Tusculum
$302,500 Price
-
Andrew Maloney
Andrew Maloney
eXp Realty
(513) 586-4439
70 Total Sales
1 in Columbia Tusculum
$343,300 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $740,000 | -- | |
| Warranty Deed | $740,000 | None Listed On Document | |
| Warranty Deed | $85,000 | Parkway Title Llc |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $740,000 | New Conventional | |
| Previous Owner | $400,000 | New Conventional | |
| Previous Owner | $100,000 | Construction |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 07/08/2026 07/08/26 | Sold | $738,000 | -4.8% | $213 / Sq Ft |
| 06/18/2026 06/18/26 | Pending | -- | -- | -- |
| 06/08/2026 06/08/26 | Price Changed | $775,000 | -2.5% | $224 / Sq Ft |
| 05/26/2026 05/26/26 | For Sale | $795,000 | 0.0% | $230 / Sq Ft |
| 05/11/2026 05/11/26 | Pending | -- | -- | -- |
| 05/04/2026 05/04/26 | Price Changed | $795,000 | -6.5% | $230 / Sq Ft |
| 04/14/2026 04/14/26 | Price Changed | $850,000 | -8.1% | $246 / Sq Ft |
| 03/26/2026 03/26/26 | For Sale | $925,000 | -- | $267 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $10,015 | $259,000 | $17,850 | $241,150 |
| 2024 | $9,711 | $259,000 | $17,850 | $241,150 |
| 2023 | $9,930 | $259,000 | $17,850 | $241,150 |
| 2022 | $9,112 | $129,297 | $29,750 | $99,547 |
| 2021 | $2,069 | $29,750 | $29,750 | $0 |
| 2020 | $2,075 | $29,750 | $29,750 | $0 |
| 2019 | $878 | $0 | $0 | $0 |
| 2018 | $0 | $0 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Sheryl Buechly
Seller's Agent in 2026
Sheryl Buechly
Plum Tree Realty
(513) 310-1952
2 in this area
107 Total Sales
-
Gabrielle Hodge
GH
Buyer's Agent in 2026
Gabrielle Hodge
Ken Perry Realty, Inc.
(513) 417-3709
2 in this area
100 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1872706
APN: 026-0001-0238
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 502 Delta Ave
- 3446 Golden Ave
- 3435 Golden Ave
- 3435 Golden Ave
- 455 Flinn Ave
- 459 Flinn Ave
- 467 Flinn Ave
- 560 Delta Ave
- 609 Athens Ave
- 3415 Golden Ave Unit 5
- 608 Rushton Rd
- 1/2 Handman Ave
- 3304 Columbia Pkwy
- 520 Missouri Ave
- 3248 Columbia Pkwy
- 329 Stanley Ave
- 650 Rushton Rd
- 3614 Columbia Pkwy
- 658 Rushton Rd
- 434 Stanley Ave
Your Personal Tour Guide
Ask me questions while you tour the home.