1504 Aster Place College Hill, OH 45224

3
Bed
2
Bath
1,696
Sq. Ft
$199,000
MLS# 1890736
3 BR
2 BA
1,696 Sq. Ft
1/56
  • New Listing
2/56
3/56

On Market 08/22/2026

More About 1504 Aster Place

Welcome to this spacious brick home tucked away on a quiet street in College Hill, offering the perfect combination of character, space, and convenient access to nearby Northside. With 3 bedrooms, 2 full baths, and three garage spaces, this home offers plenty of room for comfortable living. Inside, you'll find an extra-large dining room that provides an inviting space for gatherings and entertaining, along with a cozy rear sunroom that makes a great spot to relax, enjoy your morning coffee, or unwind at the end of the day. The front room offers flexibility and could function as a third bedroom, office, or additional living space depending on your needs. The home also features a welcoming front porch, two full bathrooms, and generous living spaces throughout. Recent updates provide peace of mind, including a roof approximately 6 years old, furnace approximately 3 years old, water heater approximately 3 years old, A/C approximately 8 years old, and deck approximately 7 years old.

Connect with a loan officer to get started!

Directions to this Listing

: Hamilton Ave in College Hill to Aster Place

Information Refreshed: 8/23/2026 7:58 PM

Ask a Question

Contact our Customer Care team or
513-985-4010
CallText

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Call us now at 513-985-4010

Property Details

  • MLS#:

    1890736

  • Type:

    Single Family

  • Sq. Ft:

    1,696

  • County:

    Hamilton

  • Age:

    111

  • Architecture:

    Traditional

  • Basement:

    Part Finished, Walkout

  • Basement Type:

    Full

  • Construction:

    Brick

  • Cooling:

    Central Air

  • Garage:

    Garage Detached, Oversized

  • Garage Spaces:

    3

  • Gas:

    Natural

  • Heating:

    Gas, Forced Air

  • Kitchen:

    Pantry

  • Primary Bedroom:

    Bath Adjoins

  • S/A Taxes:

    1600

  • School District:

    Cincinnati Public Schools

  • Sewer:

    Public Sewer

  • Water:

    Public

Rooms

  • Bath 1:

    F (Level: 2)

  • Bath 2:

    F (Level: B)

  • Bedroom 1:

    12x12 (Level: 2)

  • Bedroom 2:

    15x11 (Level: 1)

  • Bedroom 3:

    12x10 (Level: 2)

  • Dining Room:

    15x13 (Level: 1)

  • Entry:

    10x9 (Level: 1)

  • Family Room:

    18x12 (Level: 1)

  • Kitchen:

    14x10 (Level: 1)
This listing courtesy of Ryan Naish (513) 535-6480 , Plum Tree Realty (513) 443-5060

Explore College Hill & Surrounding Area

College Hill OH

College Hill

This historical neighborhood sits high on a ridge, with rolling wooded terrain. In some areas, the elegant old homes, surrounded by ancient trees, give the familiar Cincinnati impression of great strength and variety. Other sections have smaller homes, ...

View Community
Mt Airy OH

Mt. Airy

Neat, smaller homes in quiet neighborhoods border a tremendous forest that offers more than a recreational facility. The 2,000 acres of dense, lush woodland provide a natural environment for those who enjoy the beauty and wonders of nature. Although the...

View Community
Northside OH

Northside

Originally viewed as a place where Cincinnatians could retreat from the busy city, Northside is now a neighborhood rich with culture, community and entertainment within minutes of downtown. With a mix of classic homes and a vibrant business district, No...

View Community
Finneytown

Finneytown

Homes of almost every design can be found here from ranches to cape cods and two stories. Easy access to shopping and parks makes Finneytown an ideal neighborhood with access to Interstates 275 and 75.

View Community
North College Hill OH

North College Hill

The North College Hill business district generates a feeling of stability and well-being. Through the years, it has retained its distinctive personality. For the most part, the houses are small and attractive. Proud owners are dedicated to the upkeep of...

View Community
White Oak OH

White Oak

Newcomers of all ages appreciate the excellent home values. Some houses are so large and so elegantly designed that they lend prestige to the area. The majority, however, are attractively planned to serve a variety of today's needs and lifestyles. Throu...

View Community
OH•45224•Hamilton County•College Hill•1504 Aster Place

Ask a Question

Contact our Customer Care team or
513-985-4010
CallText

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Call us now at 513-985-4010

Monthly Cost

Mortgage Calculator

Enter your details for an estimated monthly payment. See how much house you can afford

%
LEGAL DISCLAIMERS▼

Your estimated payment

$1,022
per month
PRINCIPAL & INTEREST
$1,022
CHAT WITH A LOAN OFFICER

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.