Seller's Agent in 2021
Bryan Hoelzer
Coldwell Banker Realty
(513) 839-5595
4 in this area
199 Total Sales
5224 Colorado River Trail Liberty Township, OH 45011
Estimated Value: $523,000 - $577,165
4
Beds
4
Baths
3,974
Sq Ft
$139/Sq Ft
Est. Value
Highlights
- Spa
- View of Trees or Woods
- Traditional Architecture
- Cherokee Elementary School Rated A-
- Deck
- Cathedral Ceiling
About This Home
As of June 2021The Chambrey Model in Aspen Trls, Built by Beazer Homes, Boast a 2-Story Transitional w/ a Cathedral Entry, HW Flrs, 1st Flr Study, Lg Kit Opn to the Great Rm, w/Granite, Tile Backsplash w/ Decorative Inlay, Double Wall Ovens and W/O to New Composite Deck. 2nd Flr Features a Loft, Laundry Rm, Master w/ Adjoining Ba w/ a Double Vanity & His/Her WIC. Finished LL w/ Theater Rm, Wet Bar, Built-In Island and 1/2 Ba. Backs up to an HOA Green Space & Walking Trls. Enjoy the Fully Stocked Fishing Ponds.
Last Agent to Sell the Property
Coldwell Banker Realty License #0000412001 Listed on: 05/21/2021
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $5,438
Year Built
- Built in 2005
Lot Details
- 0.26 Acre Lot
- Lot Dimensions are 80 x 140
HOA Fees
- $50 Monthly HOA Fees
Parking
- 2 Car Garage
- Driveway
- On-Street Parking
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 3,974 Sq Ft Home
- 2-Story Property
- Wet Bar
- Cathedral Ceiling
- Ceiling Fan
- Gas Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Bay Window
- French Doors
- Panel Doors
- Entrance Foyer
- Great Room with Fireplace
- Family Room
- Formal Dining Room
- Views of Woods
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Laminate
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
Laundry
- Dryer
- Washer
Outdoor Features
- Spa
- Deck
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- Association fees include association dues, walkingtrails
- Apen Trails HOA
- Aspen Trails Subdivision
Listing and Financial Details
- Court or third-party approval is required for the sale
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 26, 2016
Closed on
Nov 30, 2016
Sold by
Ratermann Craig F
Bought by
Ludwig Robert Brian and Ludwig Beth D
Seller's Agent
Denise Gifford
Keller Williams Advisors
Buyer's Agent
James Pitzer
Coldwell Banker Realty
List Price
$325,000
Sold Price
$322,500
Premium/Discount to List
-$2,500
-0.77%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$228,541
Avg. Annual Appreciation
6.17%
Original Mortgage
$306,375
Outstanding Balance
$247,010
Interest Rate
3.47%
Mortgage Type
New Conventional
Estimated Equity
$304,032
Purchase Details
Closed on
Feb 8, 2005
Sold by
Beazer Homes Investments Llc
Bought by
Bernecker Robert E and Bernecker Cassandra L
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,800
Interest Rate
4.75%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
May 19, 2004
Sold by
Aspen Trails Llc
Bought by
Crossman Communities Of Ohio Inc
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Ludwig Robert Brian | $322,500 | Stewart Title Company | |
| Bernecker Robert E | $282,250 | Paragon Title | |
| Crossman Communities Of Ohio Inc | $606,035 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Ludwig Robert Brian | $306,375 | |
| Previous Owner | Bernecker Robert E | $225,800 | |
| Closed | Bernecker Robert E | $56,450 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/30/2021 06/30/21 | Sold | $440,000 | +10.3% | $111 / Sq Ft | |
| 05/28/2021 05/28/21 | Pending | -- | -- | -- | |
| 05/26/2021 05/26/21 | For Sale | -- | -- | -- | |
| 05/21/2021 05/21/21 | For Sale | -- | -- | -- | |
| 05/21/2021 05/21/21 | For Sale | $399,000 | +23.7% | $100 / Sq Ft | |
| 03/06/2017 03/06/17 | Off Market | $322,500 | -- | -- | |
| 12/05/2016 12/05/16 | Sold | $322,500 | -0.8% | $81 / Sq Ft | View Prior Sale |
| 10/30/2016 10/30/16 | Pending | -- | -- | -- | |
| 10/26/2016 10/26/16 | For Sale | $325,000 | +1.2% | $82 / Sq Ft | |
| 07/15/2015 07/15/15 | Off Market | $321,000 | -- | -- | |
| 04/15/2015 04/15/15 | Sold | $321,000 | -1.2% | $81 / Sq Ft | View Prior Sale |
| 03/16/2015 03/16/15 | Pending | -- | -- | -- | |
| 02/28/2015 02/28/15 | For Sale | $324,900 | -- | $82 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $6,228 | $11,300 | $11,300 | -- |
| 2023 | $6,146 | $11,300 | $11,300 | -- |
| 2022 | $5,326 | $11,300 | $11,300 | $0 |
| 2021 | $5,298 | $11,300 | $11,300 | $0 |
| 2020 | $5,438 | $183,730 | $7,010 | $176,720 |
| 2019 | $9,178 | $95,280 | $11,300 | $83,980 |
| 2018 | $5,833 | $11,300 | $11,300 | $0 |
| 2017 | $5,929 | $11,300 | $11,300 | $0 |
| 2016 | $5,275 | $11,300 | $11,300 | $0 |
| 2015 | $5,197 | $11,300 | $11,300 | $0 |
| 2014 | $4,642 | $11,300 | $11,300 | $0 |
| 2013 | $4,642 | $11,300 | $11,300 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Bryan Hoelzer
-
Kathryn Hoelzer
Seller Co-Listing Agent in 2021
Kathryn Hoelzer
Coldwell Banker Realty
(513) 839-5003
3 in this area
132 Total Sales
-
Paige Platt
Buyer's Agent in 2021
Paige Platt
eXp Realty
(513) 600-2938
2 in this area
14 Total Sales
-
Denise Gifford
Seller's Agent in 2016
Denise Gifford
Keller Williams Advisors
(513) 290-1443
19 in this area
300 Total Sales
-
James Pitzer
Buyer's Agent in 2016
James Pitzer
Coldwell Banker Realty
(513) 225-3069
20 in this area
248 Total Sales
-
Linda Deters
L
Seller's Agent in 2015
Linda Deters
Huff Realty
38 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1701214
APN: D2020-261-000-075
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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.
Ten-X 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 2025, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 5259 Aspen Valley Dr
- 5200 Poets Way
- 5008 N Star Ct
- 5114 Princeton Glendale Rd
- 4360 Watoga Dr
- 4943 Silver Creek Ct
- 4957 Streamside Ct
- 5618 Rachels View
- 33 E Kelly St Unit 33
- 21 Kelly St Unit 21
- 5617 Creekside Meadows Dr
- 5406 Sugar Maple Run
- 5565 Eagle Ct
- 5609 Selu Dr
- 5567 Eagle Ct
- 4902 Harrier Ln
- 4897 Osprey Pointe Dr
- 5014 Rockdale Rd
- 5330 Hamilton Middletown Rd
- 5627 Eagle Dance Dr
- 5234 Colorado River Trail
- 5214 Colorado River Trail
- 5261 Alpine Ct
- 5228 Aspenwood Dr
- 5271 Alpine Ct
- 5231 Alpine Ct
- 5254 Colorado River Trail
- 5218 Aspenwood Dr
- 5281 Alpine Ct
- 5221 Alpine Ct
- 5255 Colorado River Trail
- 5184 Colorado River Trail
- 5264 Colorado River Trail
- 5260 Alpine Ct
- 5208 Aspenwood Dr
- 5280 Alpine Ct
- 5185 Colorado River Trail
- 5270 Alpine Ct
- 5211 Alpine Ct
- 5265 Colorado River Trail