Brandy Mccaster
Keller Williams Seven Hills Re
(513) 993-4223
116 Total Sales
2 in Mount Airy
$300K - $305K Price Range
5700 Colerain Ave Cincinnati, OH 45239
Mount Airy NeighborhoodEstimated Value: $314,000 - $355,000
3
Beds
2.5
Baths
2,787
Sq Ft
$122/Sq Ft
Est. Value
Highlights
- 0.6 Acre Lot
- Craftsman Architecture
- No HOA
- Walnut Hills High School Rated A+
- Radiant Floor
- Formal Dining Room
About This Home
As of May 2016Elegant, old world charm w/updated amenities. 15 minutes to town. Craftsmanship throughout, woodwork & hdwdd flrs along w/archways showcase this home. Brick & stone construction & architectural details are throughout. Enclosed solarium. Updated mechanicals. Pride of ownership is apparent. You will appreciate the condition & character of this home
Last Agent to Sell the Property
Coldwell Banker Realty License #0000342857 Listed on: 03/14/2016
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $3,269
Year Built
- Built in 1931
Lot Details
- 0.6
Parking
- 2 Car Garage
- Driveway
- Assigned Parking
Home Design
- Craftsman Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 2,787 Sq Ft Home
- 2-Story Property
- Bookcases
- Wood Burning Fireplace
- Gas Fireplace
- Insulated Windows
- Family Room
- Living Room with Fireplace
- Formal Dining Room
- Partially Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Radiant Floor
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
Utilities
- Central Air
- Hot Water Heating System
- Heating System Uses Gas
Additional Features
- Patio
- 26,310 Sq Ft Lot
Community Details
- No Home Owners Association
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 14, 2016
Closed on
May 31, 2016
Sold by
Harmeyer Dennis M and Harmeyer Mary Kay
Bought by
Seller's Agent
Rakesh Ram
Coldwell Banker Realty
Buyer's Agent
Andy Childs
Coldwell Banker Realty
List Price
$239,800
Sold Price
$239,800
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
$100,134
Avg. Annual Appreciation
3.45%
Original Mortgage
$191,840
Interest Rate
3.57%
Mortgage Type
New Conventional
Purchase Details
Closed on
Sep 29, 1993
Sold by
Harmeyer Dennis M
Bought by
Harmeyer Dennis M
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Mount Airy, OH
-
Brandy Mccaster
-
Cory Allen
Cory Allen
Streetlight Realty LLC
(513) 987-2109
255 Total Sales
1 in Mount Airy
$230,000 Price
-
Brandon Willis
Brandon Willis
Keller Williams Seven Hills Re
(513) 586-3521
213 Total Sales
2 in Mount Airy
$195K - $220K Price Range
-
Courtney Ram
Courtney Ram
Real of Ohio
(513) 854-7720
96 Total Sales
1 in Mount Airy
$350,500 Price
-
Helen Papazyan
Helen Papazyan
Fortune Vine Realty
(424) 363-8052
72 Total Sales
1 in Mount Airy
$139,900 Price
-
Jennifer Pope
Jennifer Pope
Keller Williams Seven Hills Re
(513) 895-9605
55 Total Sales
1 in Mount Airy
$196,809 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $239,300 | -- | ||
| Harmeyer Dennis M | -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $228,000 | ||
| Closed | Dahlberg Arthur D | $191,840 | |
| Previous Owner | Harmeyer Dennis M | $139,217 | |
| Previous Owner | Harmeyer Dennis M | $37,400 | |
| Previous Owner | Harmeyer Dennis M | $130,000 | |
| Previous Owner | Harmeyer Dennis M | $125,905 | |
| Previous Owner | Harmeyer Dennis M | $125,905 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 09/07/2016 09/07/16 | Off Market | $239,800 | -- | -- |
| 05/31/2016 05/31/16 | Sold | $239,800 | 0.0% | $86 / Sq Ft |
| 03/29/2016 03/29/16 | Pending | -- | -- | -- |
| 03/14/2016 03/14/16 | For Sale | $239,800 | -- | $86 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2025 | $6,797 | $109,865 | $9,940 | $99,925 |
| 2023 | $6,740 | $109,865 | $9,940 | $99,925 |
| 2022 | $6,658 | $97,360 | $8,243 | $89,117 |
| 2021 | $6,400 | $97,360 | $8,243 | $89,117 |
| 2020 | $6,587 | $97,360 | $8,243 | $89,117 |
| 2019 | $6,194 | $83,930 | $7,105 | $76,825 |
| 2018 | $6,204 | $83,930 | $7,105 | $76,825 |
| 2017 | $5,893 | $83,930 | $7,105 | $76,825 |
| 2016 | $3,624 | $47,730 | $7,728 | $40,002 |
| 2015 | $3,241 | $47,730 | $7,728 | $40,002 |
| 2014 | $3,258 | $47,730 | $7,728 | $40,002 |
| 2013 | $3,599 | $51,881 | $8,400 | $43,481 |
Source: Public Records
Agents Affiliated with this Home
-
Rakesh Ram
Seller's Agent in 2016
Rakesh Ram
Coldwell Banker Realty
(513) 247-1802
1 in this area
508 Total Sales
-
Mitchell Ram
Seller Co-Listing Agent in 2016
Mitchell Ram
Coldwell Banker Realty
(513) 703-7774
189 Total Sales
-
Andy Childs
Buyer's Agent in 2016
Andy Childs
Coldwell Banker Realty
(513) 818-5959
93 Total Sales
-
JB
Buyer Co-Listing Agent in 2016
Jim Basquette
Huff Referral Company
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1485232
APN: 231-0002-0043
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 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 5682 Colerain Ave
- 5743 Colerain Ave
- 5645 Colerain Ave
- 5612 Colerain Ave
- 5558 Foxrun Ct
- 2810 Robers Ave
- 2888 Mount Airy Ave
- 2612 Kathleen Ct
- 2505 Rack Ct
- 5594 Sunnywoods Ln
- 5970 Colerain Ave
- 5592 Regimental Place
- 2505 Flanigan Ct
- 5574 Regimental Place
- 5406 Bluebird Ln
- 2661 Hummingbird Ct
- 2218 Sweetbriar Ln
- 2936 N Bend Rd
- 2944 N Bend Rd
- 2717 W North Bend Rd
- 5688 Colerain Ave
- 5691 Colerain Ave
- 5693 Colerain Ave
- 5687 Colerain Ave
- 5678 Colerain Ave
- 5683 Colerain Ave
- 5705 Colerain Ave
- 2600 Allaire Ave
- 2611 Jessup Rd
- 5672 Colerain Ave
- 2614 Allaire Ave
- 2617 Jessup Rd
- 5711 Colerain Ave
- 5717 Colerain Ave
- 5663 Buttercup Ln
- 2621 Jessup Rd
- 2622 Allaire Ave
- 2624 Jessup Rd
- 5667 Buttercup Ln
- 5664 Colerain Ave
Your Personal Tour Guide
Ask me questions while you tour the home.