Date
Details
Price
Change
Source
3/26/2026
Listed
$925,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
$925,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/39
Property Description
Modern 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.
Full Property Details
Full Property Details for 504 Delta Ave
General
- Price: $925,000
- Status: Active
- Type: Single Family
- Source: Cincinnati
- MLS ID: 1872706
- Updated: 3/28/2026
- Added to Site: 6 day(s) ago
Interior
- Number of Rooms: 10
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Ceramic, Gas
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
- Primary Bathroom: Shower, Tile Floor, Double Vanity, Tub, Heated Floors, Window Treatment, Marb/Gran/Slate
- Bathroom 1: Full, Level 2
- Bathroom 2: Full, Level 2
- Bathroom 3: Full, Lower
- Bathroom 4: Partial, Level 1
Bedrooms
- Total Bedrooms: 4
- Primary Bedroom: Adjoining Bathroom, Window Treatment, Other, 20 x 18, Level 2, 360 Sq. Ft.
- Bedroom 2: 15 x 12, Level 2, 180 Sq. Ft.
- Bedroom 3: 14 x 13, Level 2, 182 Sq. Ft.
- Bedroom 4: 13 x 11, Lower, 143 Sq. Ft.
Other Rooms
- Foyer/Entry: Closet, Open Foyer, Transom/Sidelit, Laminate Floor, Level 1
- Great Room: Walkout, Window Treatment, Fireplace, Laminate Floor, 20 x 15, Level 1
- Kitchen: Counter Bar, Solid-Surface Counter, Eat-In, Gourmet, Window Treatment, Island, Wood Cabinets, Laminate Floor, 20 x 17, 20x17, 340 Sq. Ft.
- Dining Room: Laminate Floor, Chandelier, Window Treatment, 20 x 10, Level 1, 200 Sq. Ft.
- Office/Den/Study: 11 x 13, Level 1, 143 Sq. Ft.
- Office: Bookcases, Window Treatment, Laminate Floor
- Rec Room: 20 x 13, Lower
Exterior
- Exterior Features: Balcony, Covered Deck/Patio
Parking
- Garage: Yes
- Garage Spaces: 2
- Parking: On-Street Parking, Driveway
- Garage Description: Built-In, Oversized, Rear
Location
- Area: Columbia/Tusculum
- County: Hamilton
- Township: Cincinnati City
- Suburb: Columbia/Tusculum
- Cross Streets: Columbia Pkwy
- Driving Directions: Columbia to N on Delta or Linwood to S on Delta
School Information
- School District: Cincinnati City SD
- High School District: Cincinnati City SD
Community
- Home Owners Assn.: False
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Forced Air, Gas
- Heating Fuel: Natural
- Water Heater: Gas, Tankless
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Architectural Style: Two Story Contemporary/Modern
- Description/Design: Single Family
- Exterior Const.: Stone, Vinyl Siding, Fiber Cement
- Basement: Yes
- Basement Desc.: Full, Finished, Walk-Out
- Foundation: Poured
- Roof: Shingle
- Windows: Vinyl
- Stories/Levels: Two
- Square Feet: 3,460
- Year Built: 2022
Lot Features
- Lot Size (Acres): 0.075
- Lot Dimensions: 25 x 135
- Frontage: City Street
- Zoning: Residential
- Lot Description: Less than .5 Acre
Financial Considerations
- Semi-Annual Taxes: $500
Disclosures and Reports
- APN: 026-0001-0238-00
Listed by Plum Tree Realty (513) 443-5060, Sheryl Buechly
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 504 Delta Ave —
Sheryl Buechly
Plum Tree Realty
513-443-5060
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 504 Delta Ave
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
Riverview East Academy 3555 Kellogg Avenue, Cincinnati, OH 45226 | 9-12 | 0.4 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 1.7 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 2.7 mi |
Clark Montessori High School 3030 Erie Avenue, Cincinnati, OH 45208 | 7-12 | 1.5 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 4.6 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 4.6 mi |
Mt. Washington Elementary School, Cincinnati, OH 1730 Mears Avenue, Cincinnati, OH 45230 | PK-8 | 3.6 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 3.6 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 5 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 504 Delta Ave
Estimate the Cost
Estimate the Cost for 504 Delta Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 4 hours ago
- 3Beds
- 2Total Baths
- 1,570Sq. Ft.
Listed by Todd Blersch (513) 604-3138
- Single Family
- Active
- Updated 6 days ago
- 4Beds
- 1Total Bath
- 1,326Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 2Total Baths
- 1,763Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 4Beds
- 4Total Baths
- 2,365Sq. Ft.
Listed and Sold by Hinckley Group
- Single Family
- Closed
- 3Beds
- 4Total Baths
- 5,778Sq. Ft.
Sold by Hinckley Group
- Single Family
- Closed
- Updated 8 days ago
- 3Beds
- 4Total Baths
- 2,165Sq. Ft.
Listed by Doug Spitz
50412 Delta Avenue, Cincinnati, OH 45226 (MLS# 1872706) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 50412 Delta Avenue is currently listed for $925,000 and was received on March 26, 2026. Want to learn more about 50412 Delta Avenue? Do you have questions about finding other Single Family real estate for sale in Columbia/Tusculum? You can browse all Columbia/Tusculum real estate or contact a Coldwell Banker agent to request more information.