Ty Boeppler
Comey & Shepherd
(513) 493-1749
75 Total Sales
1 in Colerain
$344,000 Price
5922 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $608,934
4
Beds
3
Baths
3,306
Sq Ft
$184/Sq Ft
Est. Value
Highlights
- Barn
- Deck
- Wooded Lot
- Views of Trees
- Family Room with Fireplace
- Cathedral Ceiling
About This Home
As of July 2023Stunning Custom, quality maint Ranch, w/1+ acre part wooded lot, w/LL walk out, w/patio. 1st flr walkout to deck. 1st lvl 3 season screen rm , 3 car garage, on Cul de sac, aprox over 4,000 sf home. Great gourmet kit. 2 gas FP. Spacious prim BDRM, Amazing fin. LL W/Rec Rm, wine cellar, Exercise rm Full kit, Office & BA. Close to I-275 & shopping, but very private. Landscape yard, very desirable street. You need to see this home, I cannot explain how fantastic it is. Open house on 5/7 from 12 to 2
Last Agent to Sell the Property
Coldwell Banker Realty License #0000256867 Listed on: 05/04/2023
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
- $8,198
Year Built
- Built in 1991
Lot Details
- 1.03 Acre Lot
- Lot Dimensions are 249 x 277
- Cul-De-Sac
- Aluminum or Metal Fence
- Wooded Lot
Parking
- 3 Car Garage
- Side Facing Garage
- Driveway
- On-Street Parking
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 3,306 Sq Ft Home
- Woodwork
- Crown Molding
- Cathedral Ceiling
- Brick Fireplace
- Gas Fireplace
- Bay Window
- Wood Frame Window
- Casement Windows
- Sliding Doors
- Entryway
- Family Room with Fireplace
- 2 Fireplaces
- Great Room with Fireplace
- Living Room with Fireplace
- Breakfast Room
- Dining Room
- Game Room
- Views of Trees
- Home Security System
Kitchen
- Eat-In Kitchen
- Double Oven
- Microwave
- Granite Countertops
- Disposal
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Laundry
- Laundry Room
- Dryer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump
- Fireplace in Basement
Outdoor Features
- Deck
- Enclosed Patio or Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
- Aerobic Septic System
- Septic Tank
Additional Features
- Air Purifier
- Barn
Community Details
- No Home Owners Association
- Squirrelsnest Subdivision
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, 2023
Closed on
Jul 17, 2023
Sold by
Bought by
Seller's Agent
Terry Elliott
Coldwell Banker Realty
Buyer's Agent
Sue Lewis
Sibcy Cline, Inc.
List Price
$499,000
Sold Price
$550,000
Premium/Discount to List
$51,000
10.22%
Views
47
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
$58,934
Avg. Annual Appreciation
3.39%
Purchase Details
Listed on
Sep 5, 2019
Closed on
Nov 1, 2019
Sold by
Bought by
Seller's Agent
Tim Chapman
Coldwell Banker Realty
Buyer's Agent
Dustin Walters
Coldwell Banker Realty
List Price
$355,000
Sold Price
$355,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.01%
Purchase Details
Closed on
Dec 16, 2011
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
$265,000
Interest Rate
3.99%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 1, 2007
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Ty Boeppler
-
Jillian Sprague
Jillian Sprague
Plum Tree Realty
(513) 666-5175
68 Total Sales
3 in Colerain
$181K - $228K Price Range
-
Alex Wagner
Alex Wagner
Coldwell Banker Realty
(513) 854-1091
244 Total Sales
8 in Colerain
$170K - $442K Price Range
-
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
311 Total Sales
1 in Colerain
$282,500 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 |
|---|---|---|---|
| -- | None Listed On Document | ||
| $355,000 | Absolute Title Agency Llc | ||
| $305,000 | Chicago Title Insurance Co | ||
| -- | 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 |
|---|---|---|---|
| Previous Owner | $288,000 | ||
| Previous Owner | $265,000 | ||
| Previous Owner | $60,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 | Prior Sale |
|---|---|---|---|---|---|
| 07/17/2023 07/17/23 | Sold | $550,000 | +10.2% | $166 / Sq Ft | |
| 05/06/2023 05/06/23 | Pending | -- | -- | -- | |
| 05/04/2023 05/04/23 | For Sale | $499,000 | +40.6% | $151 / Sq Ft | |
| 03/19/2020 03/19/20 | Off Market | $355,000 | -- | -- | |
| 12/19/2019 12/19/19 | Sold | $355,000 | 0.0% | $107 / Sq Ft | View Prior Sale |
| 10/03/2019 10/03/19 | Pending | -- | -- | -- | |
| 09/30/2019 09/30/19 | For Sale | $355,000 | 0.0% | $107 / Sq Ft | |
| 09/07/2019 09/07/19 | Pending | -- | -- | -- | |
| 09/05/2019 09/05/19 | For Sale | $355,000 | -- | $107 / 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 | $7,482 | $129,920 | $19,173 | $110,747 |
| 2024 | $6,936 | $129,920 | $19,173 | $110,747 |
| 2023 | $6,978 | $129,920 | $19,173 | $110,747 |
| 2022 | $8,176 | $124,251 | $18,855 | $105,396 |
| 2021 | $8,105 | $124,251 | $18,855 | $105,396 |
| 2020 | $8,191 | $124,251 | $18,855 | $105,396 |
| 2019 | $6,387 | $90,395 | $15,978 | $74,417 |
| 2018 | $5,729 | $90,395 | $15,978 | $74,417 |
| 2017 | $5,427 | $90,395 | $15,978 | $74,417 |
| 2016 | $6,489 | $106,751 | $15,978 | $90,773 |
| 2015 | $6,552 | $106,751 | $15,978 | $90,773 |
| 2014 | $6,563 | $106,751 | $15,978 | $90,773 |
| 2013 | $5,775 | $98,655 | $15,978 | $82,677 |
Source: Public Records
Agents Affiliated with this Home
-
Terry Elliott
Seller's Agent in 2023
Terry Elliott
Coldwell Banker Realty
(513) 543-3623
26 Total Sales
-
Sue Lewis
Buyer's Agent in 2023
Sue Lewis
Sibcy Cline
(513) 324-8095
280 Total Sales
-
Tim Chapman
Seller's Agent in 2019
Tim Chapman
Coldwell Banker Realty
(513) 509-1137
39 Total Sales
-
Dustin Walters
Buyer's Agent in 2019
Dustin Walters
Coldwell Banker Realty
(513) 716-8935
86 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1771183
APN: 510-0270-0194
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
- 5560 Birch Dr
- 4235 Hamilton Cleves Rd
- 4875 W Kemper Rd
- 6590 River Rd
- 6612 River Rd
- 2792 Laurie Ct
- 10811 Colerain Ave
- 2829 Wyatt Way
- 2795 Venice Crossing Dr
- 2795 Venice Crossing Dr
- 108 Fernald Dr
- 7006 Fort Scott Blvd
- 3978 Lukas Ln
- 5938 Squirrelsnest Ln
- 5931 Squirrelsnest Ln
- 5910 Squirrelsnest Ln
- 5921 Squirrelsnest Ln
- 5932 Squirrelsnest Ln
- 5911 Squirrelsnest Ln
- 5937 Squirrelsnest Ln
- 5934 Squirrelsnest Ln
- 5946 Squirrelsnest Ln
- 5889 Squirrelsnest Ln
- 5898 Squirrelsnest Ln
- 5947 Squirrelsnest Ln
- 5941 Squirrelsnest Ln
- 5950 Squirrelsnest Ln
- 5884 Squirrelsnest Ln
- 5871 Squirrelsnest Ln
- 5951 Squirrelsnest Ln
- 5945 Squirrelsnest Ln
- 5917 Squirrelsnest Ln
- 5943 Squirrelsnest Ln
Your Personal Tour Guide
Ask me questions while you tour the home.