Alex Wagner
Coldwell Banker Realty
(513) 854-1091
244 Total Sales
8 in Colerain
$170K - $442K Price Range
5859 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $688,394
4
Beds
5
Baths
3,500
Sq Ft
$197/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- 1.17 Acre Lot
- Vaulted Ceiling
- View of Trees or Woods
- Fireplace in Kitchen
- Traditional Architecture
About This Home
As of October 2020Stunning Custom 4Bd Home w/5,000 Fin SqFt on Prvt Wooded 1.17 Acre Lot,GATED/SECURED Private Section,Gourmet Kitch w/Island,Custom Cabinets,Hearth Rm w/FP/Brkfst Nook, Formal DinRm & LivRm, Vaulted FamRm w/Gas FP- Walks Out to Encl Porch, 1st Flr Master w/Lux Bath and WalkIn Shwr, Amazing Fin LL w/Rec Rm,Exer Rm,WetBar/Full Kitchen/Bath + MORE
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
- $9,020
Year Built
- Built in 1992
Lot Details
- 1.17 Acre Lot
- Lot Dimensions are 297 x 182
- Aluminum or Metal Fence
HOA Fees
- $25 Monthly HOA Fees
Parking
- 2 Car Garage
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 3,500 Sq Ft Home
- 2-Story Property
- Central Vacuum
- Woodwork
- Crown Molding
- Vaulted Ceiling
- Skylights
- Chandelier
- Gas Fireplace
- Insulated Windows
- French Doors
- Panel Doors
- Family Room with Fireplace
- 2 Fireplaces
- Formal Dining Room
- Sun or Florida Room
- Wood Flooring
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Butlers Pantry
- Oven or Range
- Gas Cooktop
- Warming Drawer
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
- Fireplace in Kitchen
Bedrooms and Bathrooms
- 4 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
Outdoor Features
- Enclosed Patio or Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
- Aerobic Septic System
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
May 4, 2020
Closed on
Sep 22, 2020
Sold by
Bought by
Seller's Agent
Tyler Minges
Huff Realty
Buyer's Agent
Linda Kunkel
Coldwell Banker Realty
List Price
$549,000
Sold Price
$500,000
Premium/Discount to List
-$49,000
-8.93%
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
$188,394
Avg. Annual Appreciation
5.67%
Original Mortgage
$300,000
Outstanding Balance
$260,729
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$427,665
Purchase Details
Closed on
Sep 17, 2008
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$440,000
Interest Rate
6.48%
Mortgage Type
Unknown
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Alex Wagner
-
Teri Herrmann
Teri Herrmann
Keller Williams Seven Hills Re
(513) 586-4538
91 Total Sales
2 in Colerain
$221K - $392K Price Range
-
Adam Minehart
Adam Minehart
NavX Realty, LLC
(937) 717-3860
100 Total Sales
1 in Colerain
$313,500 Price
-
Helena Cameron
Helena Cameron
Sibcy Cline, Inc.
(513) 952-8574
310 Total Sales
1 in Colerain
$282,500 Price
-
Brandi Howell
Brandi Howell
Keller Williams Community Part
(513) 224-5293
291 Total Sales
2 in Colerain
$253,000 Price Range
-
Brandy Mccaster
Brandy Mccaster
Keller Williams Seven Hills Re
(513) 993-4223
115 Total Sales
4 in Colerain
$120K - $425K Price Range
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 |
|---|---|---|---|
| $500,000 | None Available | ||
| -- | None Available |
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 | $300,000 | ||
| Previous Owner | $417,000 | ||
| Previous Owner | $60,000 | ||
| Previous Owner | $78,000 | ||
| Previous Owner | $417,000 | ||
| Previous Owner | $440,000 | ||
| Previous Owner | $80,000 | ||
| Previous Owner | $40,000 | ||
| Previous Owner | $240,000 | ||
| Previous Owner | $215,000 |
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 |
|---|---|---|---|---|
| 01/18/2021 01/18/21 | Off Market | $500,000 | -- | -- |
| 10/15/2020 10/15/20 | Sold | $500,000 | 0.0% | $143 / Sq Ft |
| 08/20/2020 08/20/20 | Pending | -- | -- | -- |
| 08/17/2020 08/17/20 | Price Changed | $499,900 | -2.9% | $143 / Sq Ft |
| 07/09/2020 07/09/20 | Price Changed | $514,900 | -1.9% | $147 / Sq Ft |
| 06/30/2020 06/30/20 | Price Changed | $524,900 | -0.9% | $150 / Sq Ft |
| 06/10/2020 06/10/20 | Price Changed | $529,900 | -1.9% | $151 / Sq Ft |
| 05/28/2020 05/28/20 | Price Changed | $539,900 | -1.8% | $154 / Sq Ft |
| 05/04/2020 05/04/20 | Price Changed | $549,900 | +0.2% | $157 / Sq Ft |
| 05/04/2020 05/04/20 | For Sale | $549,000 | -- | $157 / 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 | $9,825 | $175,000 | $20,545 | $154,455 |
| 2023 | $9,395 | $175,000 | $20,545 | $154,455 |
| 2022 | $9,932 | $150,973 | $20,206 | $130,767 |
| 2021 | $9,862 | $150,973 | $20,206 | $130,767 |
| 2020 | $9,958 | $150,973 | $20,206 | $130,767 |
| 2019 | $9,043 | $127,943 | $17,122 | $110,821 |
| 2018 | $8,111 | $127,943 | $17,122 | $110,821 |
| 2017 | $7,688 | $127,943 | $17,122 | $110,821 |
| 2016 | $8,478 | $139,283 | $17,129 | $122,154 |
| 2015 | $8,556 | $139,283 | $17,129 | $122,154 |
| 2014 | $8,572 | $139,283 | $17,129 | $122,154 |
| 2013 | $8,158 | $139,283 | $17,129 | $122,154 |
Source: Public Records
Agents Affiliated with this Home
-
Tyler Minges
Seller's Agent in 2020
Tyler Minges
Huff Realty
(513) 460-0102
444 Total Sales
-
Linda Kunkel
Buyer's Agent in 2020
Linda Kunkel
Coldwell Banker Realty
(513) 404-7115
82 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1660032
APN: 510-0270-0213
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
- 5790 Squirrelsnest Ln
- 5739 Squirrelsnest Ln
- 10952 Gosling Rd
- 10960 Gosling Rd
- 2117 Cardinal Ave
- 11930 Stone Mill Rd
- 5250 Yeatman Rd
- 4875 W Kemper Rd
- 5560 Birch Dr
- 4235 Hamilton Cleves Rd
- 10811 Colerain Ave
- 6590 River Rd
- 2792 Laurie Ct
- 6612 River Rd
- 2829 Wyatt Way
- 2795 Venice Crossing Dr
- 2795 Venice Crossing Dr
- 3978 Lukas Ln
- 7006 Fort Scott Blvd
- 4043 Jennifer Dr
- 5865 Squirrelsnest Ln
- 5843 Squirrelsnest Ln
- 5833 Squirrelsnest Ln
- 5856 Squirrelsnest Ln
- 5844 Squirrelsnest Ln
- 5871 Squirrelsnest Ln
- 5870 Squirrelsnest Ln
- 5821 Squirrelsnest Ln
- 5819 Squirrelsnest Ln
- 5841 Squirrelsnest Ln
- 5830 Squirrelsnest Ln
- 5817 Squirrelsnest Ln
- 55 Squirrelsnest Ln Unit 55
- 5884 Squirrelsnest Ln
- 5820 Squirrelsnest Ln
- 5889 Squirrelsnest Ln
- 5809 Squirrelsnest Ln
- 4288 Miamitrail Ln
- 4289 Miamitrail Ln
- 5815 Squirrelsnest Ln
Your Personal Tour Guide
Ask me questions while you tour the home.