Recently Viewed Properties
See This Home
Save This Listing
Close

$738,000

  • Sold
  • Closed
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 3,460 Sq. Ft.
  • 0.075 Acres
  • 2 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
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 for 504 Delta Ave

General

  • Sold For: $738,000
  • Status: Closed
  • Type: Single Family
  • Source: Cincinnati
  • MLS ID: 1872706
  • Added to Site: 109 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, 286 Sq. Ft.
  • 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
  • Exterior Const.: 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
  • Lower: 1,300 Sq. Ft.
  • 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

  • Sub Lease Exp.: 1800-01-01T00:00:00-05:00
  • Semi-Annual Taxes: $500

Disclosures and Reports

  • APN: 026-0001-0238-00
  • Property ID: 026-0001-0238-00

Listed by Plum Tree Realty (513) 443-5060, Sheryl Buechly
Sold by Ken Perry Realty, Inc. (859) 442-6800, Gabrielle Hodge

Listing agent

— 504 Delta Ave —

  • Sheryl Buechly

    Plum Tree Realty

    513-443-5060

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 504 Delta Ave

School District:Cincinnati City School District
NameGradesDistance
Riverview East Academy
3555 Kellogg Avenue, Cincinnati, OH 45226
9-120.4 mi
Withrow University High School
2488 Madison Road, Cincinnati, OH 45208
7-121.7 mi
Walnut Hills High School
3250 Victory Parkway, Cincinnati, OH 45207
7-122.7 mi
Clark Montessori High School
3030 Erie Avenue, Cincinnati, OH 45208
7-121.5 mi
Robert A. Taft Information Technology High School
420 Ezzard Charles Drive, Cincinnati, OH 45214
7-124.6 mi
Hughes STEM High School
2515 Clifton Avenue, Cincinnati, OH 45219
7-124.6 mi
Mt. Washington Elementary School, Cincinnati, OH
1730 Mears Avenue, Cincinnati, OH 45230
PK-83.6 mi
Shroder Paideia High School
5030 Duck Creek Road, Cincinnati, OH 45227
7-123.6 mi
Woodward Career Technical High School
7005 Reading Road, Cincinnati, OH 45237
7-125 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

Date
Details
Price
Change
Source
7/08/2026
Sold
$738,000
-4.77%
MLS
6/08/2026
Price Reduced
$775,000
-2.52%
MLS
5/04/2026
Price Reduced
$795,000
-6.47%
MLS
4/14/2026
Price Reduced
$850,000
-8.11%
MLS
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.

Listed by Plum Tree Realty (513) 443-5060, Sheryl Buechly
Sold by Ken Perry Realty, Inc. (859) 442-6800, Gabrielle Hodge

Similar Properties near 504 Delta Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

860 Belle Ridge Loop, Bellevue, KY 41073 - Photo 1 Price Reduced
-$30,000 (-3.87%)
$745,000

860 Belle Ridge Loop  Bellevue, KY 41073

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,000
    Sq. Ft.
Co-Listed by Tristate Partners
1326 Knowlton St, Cincinnati, OH 45223 - Photo 1
$750,000

1326 Knowlton St  Cincinnati, OH 45223

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,028
    Sq. Ft.
1025 Jackson Rd, Covington, KY 41011 - Photo 1 Just Listed
$719,000

1025 Jackson Rd  Covington, KY 41011

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,806
    Sq. Ft.
8552 Deerway Dr, Sycamore Township, OH 45236 - Photo 1
$729,900

8552 Deerway Dr  Sycamore Township, OH 45236

  • Single Family
  • Active
  • Updated 11 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,064
    Sq. Ft.

Just Listed near 504 Delta Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

18 W 8th St, Newport, KY 41071 - Photo 1 Just Listed
$499,900

18 W 8th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,660
    Sq. Ft.
911 Park Ave, Newport, KY 41071 - Photo 1 Just Listed
$249,900

911 Park Ave  Newport, KY 41071

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,636
    Sq. Ft.
900 Ovation Wy, Newport, KY 41071 - Photo 1 Just Listed
$1,090,000

900 Ovation Wy  #318  Newport, KY 41071

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
1111 Park Ave, Newport, KY 41071 - Photo 1 Just Listed
$239,000

1111 Park Ave  Newport, KY 41071

  • Multi-Family
  • Active
  • Updated 3 days ago
  • 3
    Total Beds

Price Reduced near 504 Delta Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

25 W 12th St, Newport, KY 41071 - Photo 1 Price Reduced
-$30,000 (-11.77%)
$224,900

25 W 12th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 1
    Bed
  • 1
    Total Bath
  • 730
    Sq. Ft.
Listed by Sam Valz (859) 443-9373
835 Monroe St, Newport, KY 41071 - Photo 1 Price Reduced
-$14,900 (-2.29%)
$635,000

835 Monroe St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,091
    Sq. Ft.
1 W 13th St, Newport, KY 41071 - Photo 1 Price Reduced
-$14,900 (-5.14%)
$275,000

1 W 13th St  Newport, KY 41071

  • Multi-Family
  • Active
  • Updated 6 days ago
734 E 10th St, Newport, KY 41071 - Photo 1 Price Reduced
-$10,000 (-2.44%)
$399,900

734 E 10th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 2,062
    Sq. Ft.

Recent Sales near 504 Delta Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

557 Hoge St, Cincinnati, OH 45226 - Photo 1 Sold
$721,000

557 Hoge St  Cincinnati, OH 45226

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,095
    Sq. Ft.
Sold by Melissa Attewell and Julia Packer-Wesselkamper
3435 Golden Ave, Cincinnati, OH 45226 - Photo 1 Sold
$678,500

3435 Golden Ave  #1402  Cincinnati, OH 45226

  • Condo
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,425
    Sq. Ft.
Listed by Hinckley Group
3435 Golden Ave, Cincinnati, OH 45226 - Photo 1 Sold
$655,000

3435 Golden Ave  #1001  Cincinnati, OH 45226

  • Condo
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,076
    Sq. Ft.
Sold by The Sheppard Team
633 Athens Ave, Cincinnati, OH 45226 - Photo 1 Sold
$639,900

633 Athens Ave  Cincinnati, OH 45226

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 2,339
    Sq. Ft.
Sold by Oyler Hines

50412 Delta Avenue, Cincinnati, OH 45226 (MLS# 1872706) is a Single Family property that was sold at $738,000 on July 08, 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.