1504 Aster Pl
Cincinnati, OH 45224
College Hill
3 Beds
2 Baths
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
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: 1 day 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 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 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: 2 |
|
|---|
Year Built Year Built: 1915 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Traditional |
Building Construction Materials: BrickNot a New Construction |
|
|---|
Price List Price: $199,000Price Range: $0 - $199,000 |
Status Change & Dates Possession Timing: Close Of Escrow |
|
|---|
MLS Status: Coming Soon |
|
|---|
Direction & Address City: Cincinnati |
School Information High School District: Cincinnati City SD |
|
|---|
Listing Agent Listing ID: 1890736 |
|
|---|
Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOAHOA Fee: No HOA Fee |
|
|---|
Disclaimer: Information has not been verified, is not guaranteed and subject to change.<BR>Copyright</A> ©2026 <A name="trans">MLS of Greater Cincinnati, Inc. All rights reserved.</A><BR> |
|
|---|
Listing Terms: No Special Financing |
|
|---|
Around this home
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.
Market trends in Cincinnati
Last updated July 2026
Avg. sale price
$258K
$4.33KMoM
Sale-to-List Price
100.0%
Price per sq ft
$174
$3MoM
Available listings
1537
20MoM
Home Value
Trulia Estimate
$168KSince last month
Increased$5K (+3%)Since last year
Increased$6K (+3.7%)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 +99% in the last 10 years
| Month | Estimated value |
|---|---|
2026 | |
| August 2026 | $176K |
| 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
| Date | Event | Price |
|---|---|---|
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 |
| Year | Property tax | Tax assessment |
|---|---|---|
| 2024 | $3,152 | $141,820 |
Home facts updated by county records
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Similar Homes You May Like
NEW - 1 DAY AGOCentury 21 Premiere Properties
Keller Williams Pinnacle Group
0.27 ACRESRE/MAX United Associates
1.15 ACRESKeller Williams Seven Hills Re
OPEN SUN, 1-2:30PMColdwell Banker Realty
OPEN THU, 6-7:30PMComey & Shepherd
See more homes for sale inCincinnati
New Listings near 1504 Aster Pl
NEWOPEN SUN, 12-2PMCOMING SOONLynn Schwarber, Comey & Shepherd REALTORS
NEW - 2 DAYS AGOFOR SALE BY OWNER0.28 ACRES
OPEN SUN, 12-2PMAlign Right Realty Infinity- See more homes for sale inCincinnati
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,355 (about $1,040 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.