Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
534 Total Sales
6 in Colerain
$97K - $440K Price Range
5744 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $503,361 - $630,000
4
Beds
5
Baths
3,070
Sq Ft
$183/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Deck
- Transitional Architecture
- View of Trees or Woods
- Wooded Lot
- Wood Flooring
About This Home
As of June 2015WOW! Prestigious 3000 sqft plus above grade living space updated & upgraded 2 story transitional located on 1 acre plus wooded lot! Cathedral ceilings! 1st flr mstr bdrm! New granite countertops! Finished lwr lvl w/walkout! 2nd flr loft area 15x13!
Last Agent to Sell the Property
Larry Hoover
Star One Real Estate, LLC License #0000254116 Listed on: 03/23/2015
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
- $5,718
Year Built
- Built in 1989
Lot Details
- 1.01 Acre Lot
- Lot Dimensions are 165x265
- Cul-De-Sac
- Wooded Lot
Parking
- 2 Car Garage
- Driveway
- On-Street Parking
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Wood Siding
Interior Spaces
- 3,070 Sq Ft Home
- 2-Story Property
- Chair Railings
- Skylights
- Chandelier
- Wood Burning Fireplace
- Stone Fireplace
- Insulated Windows
- Double Hung Windows
- Wood Frame Window
- Double Door Entry
- Family Room with Fireplace
- Living Room with Fireplace
- Formal Dining Room
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Concrete
Bedrooms and Bathrooms
- 4 Bedrooms
- Main Floor Bedroom
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Deck
- Patio
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Aerobic Septic System
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
Mar 23, 2015
Closed on
Jun 3, 2015
Sold by
Bought by
Seller's Agent
Larry Hoover
Star One Real Estate, LLC
Buyer's Agent
Ron Bisher
Coldwell Banker Realty
List Price
$314,875
Sold Price
$293,000
Premium/Discount to List
-$21,875
-6.95%
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
$268,340
Avg. Annual Appreciation
5.99%
Original Mortgage
$168,000
Outstanding Balance
$125,762
Interest Rate
3.63%
Mortgage Type
Unknown
Estimated Equity
$435,578
Purchase Details
Closed on
Mar 29, 2002
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
$240,000
Interest Rate
4.99%
Purchase Details
Closed on
Jun 3, 1997
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Cindy Shetterly
-
Wendi Sheets
Wendi Sheets
eXp Realty
(513) 813-1446
212 Total Sales
1 in Colerain
$282,000 Price
-
Mark Schwab
Mark Schwab
OwnerLand Realty, Inc.
(513) 586-5203
41 Total Sales
2 in Colerain
$336K - $459K Price Range
-
Andrea White
Andrea White
White's Farm Est. 1922 DBA White's Realty
(513) 993-6674
127 Total Sales
1 in Colerain
$650,000 Price
-
Wendy Goldfinger
Wendy Goldfinger
Responds QuicklyHoward Hanna Real Estate Serv
(513) 854-8841
119 Total Sales
1 in Colerain
$165,000 Price
-
Judith Maiden
Judith Maiden
Comey & Shepherd
(513) 866-8614
67 Total Sales
1 in Colerain
$119,900 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 |
|---|---|---|---|
| $293,000 | Stewart Title Company | ||
| $300,000 | -- | ||
| $239,900 | -- |
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 | $168,000 | ||
| Previous Owner | $235,000 | ||
| Previous Owner | $210,000 | ||
| Previous Owner | $240,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 |
|---|---|---|---|---|
| 09/02/2015 09/02/15 | Off Market | $293,000 | -- | -- |
| 06/03/2015 06/03/15 | Sold | $293,000 | -6.9% | $95 / Sq Ft |
| 05/14/2015 05/14/15 | Pending | -- | -- | -- |
| 03/23/2015 03/23/15 | For Sale | $314,875 | -- | $103 / 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,249 | $125,958 | $19,033 | $106,925 |
| 2023 | $6,760 | $125,958 | $19,033 | $106,925 |
| 2022 | $7,957 | $121,009 | $18,718 | $102,291 |
| 2021 | $7,888 | $121,009 | $18,718 | $102,291 |
| 2020 | $7,971 | $121,009 | $18,718 | $102,291 |
| 2019 | $7,236 | $102,550 | $15,862 | $86,688 |
| 2018 | $6,489 | $102,550 | $15,862 | $86,688 |
| 2017 | $6,147 | $102,550 | $15,862 | $86,688 |
| 2016 | $5,670 | $93,328 | $15,862 | $77,466 |
| 2015 | $5,725 | $93,328 | $15,862 | $77,466 |
| 2014 | $5,735 | $93,328 | $15,862 | $77,466 |
| 2013 | $5,458 | $93,328 | $15,862 | $77,466 |
Source: Public Records
Agents Affiliated with this Home
-
L
Seller's Agent in 2015
Larry Hoover
Star One Real Estate, LLC
-
Ron Bisher
Buyer's Agent in 2015
Ron Bisher
Coldwell Banker Realty
(513) 708-7968
511 Total Sales
-
Anna Bisher
Buyer Co-Listing Agent in 2015
Anna Bisher
Coldwell Banker Realty
(513) 300-7348
292 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1441441
APN: 510-0270-0177
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
- 5739 Squirrelsnest Ln
- 5790 Squirrelsnest Ln
- 11930 Stone Mill Rd
- 10952 Gosling Rd
- 5250 Yeatman Rd
- 10960 Gosling Rd
- 4875 W Kemper Rd
- 2117 Cardinal Ave
- 5560 Birch Dr
- 10811 Colerain Ave
- 4235 Hamilton Cleves Rd
- 2792 Laurie Ct
- 6590 River Rd
- 6612 River Rd
- 2829 Wyatt Way
- 3978 Lukas Ln
- 2795 Venice Crossing Dr
- 2795 Venice Crossing Dr
- 325 Gregorian Dr
- 4043 Jennifer Dr
- 5730 Squirrelsnest Ln
- 5750 Squirrelsnest Ln
- 5758 Squirrelsnest Ln
- 5752 Squirrelsnest Ln
- 5712 Squirrelsnest Ln
- 5708 Squirrelsnest Ln
- 5770 Squirrelsnest Ln
- 5763 Squirrelsnest Ln
- 5704 Squirrelsnest Ln
- 5698 Dunlap Rd
- 5780 Squirrelsnest Ln
- 5775 Squirrelsnest Ln
- 5702 Dunlap Rd
- 11733 Colerain Ave
- 5757 Squirrelsnest Ln
- 11731 Colerain Ave
- 5708 Dunlap Rd
- 5705 Dunlap Rd
- 11735 Colerain Ave
- 5686 Dunlap Rd
Your Personal Tour Guide
Ask me questions while you tour the home.