1504 Aster Pl, Cincinnati, OH 45224
Property image
Property image
NEW
COMING SOON 8/22

1504 Aster Pl
Cincinnati, OH 45224

College Hill
  • 3 Beds
  • 2 Baths

$199,000

Est. Mortgage $1,331/mo*

$199,000

Est. Mortgage $1,331/mo*
3 Beds
2 Baths

Home Highlights

Parking
Garage
Outdoor
Porch, Deck
Climate Control
Forced Air, Gas & Central Air
HOA
None
Listed
2 days ago

Local Information

  • Map ViewExplore the area around 1504 Aster Pl.
  • Schools2 Preschool Schools3 Elementary Schools11 Middle Schools12 High Schools
  • Shop & Eat
-- mins to
Commute Destination

About this House

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.
Contact this Building
Last check for updates: about 10 hours ago
Listing courtesy of Ryan C Naish, (513) 535-6480
Plum Tree Realty, (513) 443-5060
Originating MLS: Cincinnati Area Multiple Listing Service
Source: Cincy MLS, MLS#1890736
Also Listed on Cincy MLS.
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 Zillow, 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. 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. Zillow, Inc. 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

Home Details for 1504 Aster Pl

Interior Features

Interior Details
Basement: Full,Partially Finished,Walk-Out AccessNumber of Rooms: 9Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Master Bathroom, Bathroom 1, Bathroom 2, Dining Room, Family Room, Kitchen, Living Room, Office
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 2Number of Bathrooms (full): 2
Appliances & Utilities
Appliances: Gas Water Heater
Heating & Cooling
Heating: Forced Air,GasHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Fireplace: Family Room
Gas & Electric
Gas: Natural
Windows, Doors, Floors & Walls
Window: Storm Window(s), Wood Frames
Levels, Entrance, & Accessibility
Stories: 2Levels: TwoAccessibility: No Accessibility Features
View
No View

Exterior Features

Exterior Home Features
Roof: ShinglePatio / Porch: Deck, PorchFoundation: StoneNo Private Pool
Parking & Garage
Number of Garage Spaces: 3Number of Covered Spaces: 3No CarportHas a GarageNo Attached GarageParking Spaces: 3Parking: Garage
Water & Sewer
Sewer: Public Sewer

Days on Market

Days on Market: 2

Property Information

Year Built
Year Built: 1915
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Traditional
Building
Construction Materials: BrickNot a New Construction

Price & Status

Price
List Price: $199,000Price Range: $0 - $199,000
Status Change & Dates
Possession Timing: Close Of Escrow

Active Status

MLS Status: Coming Soon

Location

Direction & Address
City: Cincinnati
School Information
High School District: Cincinnati City SD

Agent Information

Listing Agent
Listing ID: 1890736

HOA

Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOAHOA Fee: No HOA Fee

Documents

Disclaimer: Information has not been verified, is not guaranteed and subject to change.<BR>Copyright</A> &copy;2026 <A name="trans">MLS of Greater Cincinnati, Inc. All rights reserved.</A><BR>

Offer

Listing Terms: No Special Financing

Miscellaneous

BasementMls Number: 1890736Listing Url

Neighborhood Overview

Neighborhood stats provided by third party data sources.

What Locals Say about College Hill

At least 99 Trulia users voted on each feature.
  • 95 % Say there are sidewalks

  • 89 % Say it's dog friendly

  • 84 % Say yards are well-kept

  • 81 % Say parking is easy

  • 75 % Say car is needed

  • 69 % Say kids play outside

  • 65 % Say it's walkable to restaurants

  • 62 % Say neighbors are friendly

  • 58 % Say there's holiday spirit

  • 58 % Say streets are well-lit

  • 52 % Say it's quiet

  • 52 % Say they plan to stay for at least 5 years

  • 47 % Say people would walk alone at night

  • 47 % Say there's wildlife

  • 33 % Say there are community events

  • 31 % Say it's walkable to grocery stores

Sourced by Trulia users. Learn more about our methodology.
  • natalieclaire19
    "It’s easy to get downtown and to major highways - 74/75/Ronald Reagan, plus easy to get to 471 or the lateral to get to the east side "
  • carla matthews
    "Depending on the time of day can get frustrated with traffic. I don’t ride the bus but I noticed they run on a regular schedule "
  • carla matthews
    "People walk their dogs all the time on a leash they might like the fact that they should pick up their animals. Waste"
  • Trulia User
    "I work downtown and it takes me 15 minutes to get there by car. A lot of buses come through here as well"
  • Trulia User
    "They would like that it's very quiet and friendly. People are open minded and will speak to you. they always have there dogs on a leash."
  • Trulia User
    "People don't clean up after their,dogs all the time. Some people let dogs walk without a leash. Some dogs are very aggressive, which is scary if not paying attention. Too much traffic in this neighborhood, for small dogs. There is a very popular dog grooming spot near, which gets busy. "
  • Renee N.
    "we have a drive in movie theater and fresh market with local farmers. walkin distance to several outdoor restaurants"
  • Kaela_dennis
    "I was born and raised in college hill. I know a little bit of everyone and mostly all the store owners."
  • Murrydion
    "College hill is a beautiful neighborhood to live A very Pister picturesque neighborhood indeed. From the neighborhood boutiques to the restaurants in its business district It has A main street old town feel to it."
  • Sroemele
    "Great community with flourishing walkable business district and great neighbors. Lots have good setbacks sidewalks everywhere."
  • Sroemele
    "Friendly neighbors, porch crawls and progressive dinners are great. Walkable to businesses and restaurants."
  • Giovani3336
    "I'm not sure. I'm visiting relatives. It's always been a nice neighborhood. People are kind and crime is low. "
  • Elena L.
    "I moved in 6 months ago. I know my neighbors and say hello and chat with them when I'm out walking my dog. I feel safe because I know my neighbors."
  • Kimsolly
    "Older homes if cared for are beautiful unique with tree lined streets well cared for lawns and flowers"
  • Stephanie
    "I really like the diversity of my community and the neighborhood watch. There are some nice mom and pop businesses in the neighborhood. "
  • Slayerofheart3
    "ive lived here a year. ive seen fights on the street heard gunfire. but most people are polite. stores are starting to straighten up. and the sidewalks are pretty messy. the police station has moved closer to dollar store"
  • Bambi e.
    "it s a working class neighborhood nice house for couple starting out."

Market trends in Cincinnati

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$258K
$4.33K
MoM
Sale-to-List Price
100.0%
Price per sq ft
$174
$3
MoM
Available listings
1537
20
MoM

Home Value

Trulia Estimate
$168K
Since last month
Decreased$3K (-1.9%)
Since last year
Decreased$2K (-1.2%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +90% in the last 10 years
MonthEstimated value
2026
August 2026$168K
July 2026$171K
June 2026$182K
May 2026$186K
April 2026$175K
March 2026$178K
February 2026$171K
January 2026$165K
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.16
Single-Family Home
$199,500
11/05/25
3
1.5
1,356
0.09
Single-Family Home
$245,000
05/04/26
4
2
2,698
0.22
Single-Family Home
$50,000
03/11/26
3
2
-
0.26
Single-Family Home
$312,500
05/29/26
3
2
2,226
0.14
Single-Family Home
$299,000
06/22/26
2
1.5
1,419
0.35
Single-Family Home
$223,000
10/30/25
3
2
1,053
0.15
Single-Family Home
$250,000
10/27/25
2
2
1,562
0.37
Single-Family Home
$195,000
03/02/26
2
1.5
1,067
0.50
Single-Family Home
$220,000
12/16/25
3
2
1,670

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
0.04
$185,700
2
1
1,141
Off Market
0.09
$353,400
4
4
760
Off Market
0.09
$245,000
4
2
2,698
Recently Sold
0.10
$464,800
5
4
2,948
Off Market
0.10
$218,500
3
1
1,600
Off Market
0.12
$219,400
3
1.5
1,292
Off Market
0.15
$250,000
2
2
1,562
Recently Sold
0.14
$299,000
2
1.5
1,419
Recently Sold
0.16
$405,800
4
3.5
2,806
Off Market
0.16
$199,500
3
1.5
1,356
Recently Sold
0.18
$196,000
3
1
1,455
Off Market

Price and Tax history

DateEventPrice
Mar 24, 2021
Source: N/A
ListingRemoved
May 1, 2019
Source: N/A
ListingRemoved
$950
Apr 26, 2019
Source: N/A
Listed For Rent
$950

LGBTQ Local Legal Protections

Ryan C Naish, Plum Tree Realty, (513) 443-5060
Agent Phone: (513) 535-6480

Similar Homes You May Like

Skip to last item
Skip to first item

New Listings near 1504 Aster Pl

Skip to last item
Skip to first item

Frequently asked questions about 1504 Aster Pl

  • What is the estimated monthly payment for 1504 Aster Pl?
    Based on a $199,000 list price with 20% down at today's rates, the estimated monthly payment for 1504 Aster Pl in Cincinnati, OH is approximately $1,356 (about $1,041 principal & interest, $240 property taxes, and $75 homeowner's insurance). This is an estimate. Actual payment depends on your loan terms.
  • How does the list price for 1504 Aster Pl compare to homes in Cincinnati?
    1504 Aster Pl in Cincinnati, OH is listed at $199,000, about 23% below the $258K median sale price in Cincinnati.
  • What do residents say about the College Hill neighborhood?
    Residents describe the College Hill neighborhood in Cincinnati, OH as pedestrian-friendly, dog-friendly, and well-kept. See homes for sale in College Hill, Cincinnati.
  • What are the closest schools to 1504 Aster Pl?
    The closest schools to 1504 Aster Pl in Cincinnati, OH are Aiken New Tech High School (Middle, rated 4/10), Clark Montessori High School (Middle, rated 6/10), Gilbert A. Dater High School (Elementary/Middle, rated 3/10).
  • Does 1504 Aster Pl have air conditioning?
    Yes, 1504 Aster Pl in Cincinnati, OH has air conditioning.
  • Does 1504 Aster Pl have a garage?
    Yes, 1504 Aster Pl in Cincinnati, OH has a garage.
1504 Aster Pl, Cincinnati, OH 45224 is a 3 bedroom, 2 bathroom single-family home built in 1915. 1504 Aster Pl is located in College Hill, Cincinnati. This property is currently available for sale and was listed by Cincy MLS on Aug 17, 2026. The MLS # for this home is MLS# 1890736.