Cindy Johnston
Lohmiller Real Estate
(513) 847-9386
80 Total Sales
1 in Colerain
$390,000 Price
5576 Sheits Rd Cincinnati, OH 45252
Colerain AreaEstimated Value: $236,000 - $284,549
3
Beds
1
Bath
1,606
Sq Ft
$157/Sq Ft
Est. Value
Highlights
- 1.87 Acre Lot
- Ranch Style House
- Eat-In Kitchen
- Wooded Lot
- No HOA
- Shed
About This Home
As of October 2025Rare opportunity to own a spacious ranch on a private wooded 1.86 acre lot, 5 minutes to 275, 20 minutes to downtown. This fixer upper, low maintenance, brick home features 3 bedrooms, 1 bath, a large eat in kitchen with a huge family room. Has a 2 car attached garage and a detached oversized one car garage with a room above it. This property has great bones'' and is being sold AS IS. Concrete drive, beautiful retaining wall, lots of parking and storage.
Last Agent to Sell the Property
Sibcy Cline, Inc. License #2001007297 Listed on: 05/30/2025
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,744
Year Built
- Built in 1957
Lot Details
- 1.87 Acre Lot
- Lot Dimensions are 203x419
- Wooded Lot
Parking
- 2 Car Garage
- Driveway
Home Design
- Ranch Style House
- Brick Exterior Construction
- Block Foundation
- Shingle Roof
Interior Spaces
- 1,606 Sq Ft Home
- Ceiling Fan
- Wood Burning Fireplace
- Brick Fireplace
- Vinyl Clad Windows
- Double Hung Windows
- Family Room with Fireplace
Kitchen
- Eat-In Kitchen
- Oven or Range
Flooring
- Concrete
- Vinyl
Bedrooms and Bathrooms
- 3 Bedrooms
- 1 Full Bathroom
- Bathtub and Shower Combination in Primary Bathroom
Laundry
- Dryer
- Washer
Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump with Backup
Outdoor Features
- Shed
Utilities
- Forced Air Heating and Cooling System
- Baseboard Heating
- Heating System Uses Gas
- 220 Volts
- Propane
- Cistern
- Electric Water Heater
- Septic Tank
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
May 30, 2025
Closed on
Oct 15, 2025
Sold by
Stoeckle Mildred S and Stoeckle Robert A
Bought by
Seller's Agent
Jeffrey Schupp
Sibcy Cline, Inc.
Buyer's Agent
Jeffrey Schupp
Sibcy Cline, Inc.
List Price
$299,900
Sold Price
$218,000
Premium/Discount to List
-$81,900
-27.31%
Views
118
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
$34,387
Avg. Annual Appreciation
17.89%
Original Mortgage
$239,329
Outstanding Balance
$236,768
Interest Rate
6.57%
Mortgage Type
FHA
Estimated Equity
$15,619
Purchase Details
Closed on
Jan 20, 2012
Sold by
Stoeckle Mildred S and Egbert Carol S
Bought by
Schroder Lanora C
Purchase Details
Closed on
Jul 30, 2010
Sold by
Schroder Lanora C
Bought by
Stoeckle Mildred S and Egbert Carol S
Purchase Details
Closed on
Jul 31, 2000
Sold by
Estate Of Earl E Schroder
Bought by
Schroder Lanora C
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Cindy Johnston
-
Edward Lindenschmidt
Edward Lindenschmidt
Keller Williams Advisors
(513) 599-8883
190 Total Sales
7 in Colerain
$120K - $650K Price Range
-
Tracy Winkler
Tracy Winkler
Comey & Shepherd
(513) 808-9789
161 Total Sales
2 in Colerain
$178K - $475K Price Range
-
Haydee Wright
Haydee Wright
Howard Hanna Real Estate Serv
(937) 930-4213
81 Total Sales
1 in Colerain
$432,000 Price
-
Vernon Duett
Vernon Duett
Hand In Hand Realty, LLC
(513) 572-7877
91 Total Sales
1 in Colerain
$190,000 Price
-
Ty Boeppler
Ty Boeppler
Comey & Shepherd
(513) 493-1749
77 Total Sales
1 in Colerain
$344,000 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 |
|---|---|---|---|
| $218,000 | 360 American Title | ||
| Schroder Lanora C | -- | None Available | |
| Stoeckle Mildred S | -- | None Available | |
| Schroder Lanora C | -- | -- |
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 | $239,329 | ||
| Previous Owner | Schroder Lanora C | $48,200 | |
| Previous Owner | Schroder La Nora C | $50,000 | |
| Previous Owner | Schroder Lanora C | $20,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 |
|---|---|---|---|---|
| 10/15/2025 10/15/25 | Sold | $218,000 | -11.2% | $136 / Sq Ft |
| 08/06/2025 08/06/25 | Pending | -- | -- | -- |
| 07/09/2025 07/09/25 | Price Changed | $245,500 | -7.5% | $153 / Sq Ft |
| 06/18/2025 06/18/25 | Price Changed | $265,500 | -11.5% | $165 / Sq Ft |
| 05/30/2025 05/30/25 | For Sale | $299,900 | -- | $187 / 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 | $4,015 | $79,457 | $24,283 | $55,174 |
| 2024 | $3,745 | $79,457 | $24,283 | $55,174 |
| 2023 | $3,800 | $79,457 | $24,283 | $55,174 |
| 2022 | $3,436 | $60,575 | $23,877 | $36,698 |
| 2021 | $3,401 | $60,575 | $23,877 | $36,698 |
| 2020 | $3,439 | $60,575 | $23,877 | $36,698 |
| 2019 | $3,030 | $51,335 | $20,234 | $31,101 |
| 2018 | $2,720 | $51,335 | $20,234 | $31,101 |
| 2017 | $2,576 | $51,335 | $20,234 | $31,101 |
| 2016 | $2,448 | $48,654 | $20,227 | $28,427 |
| 2015 | $2,473 | $48,654 | $20,227 | $28,427 |
| 2014 | $2,478 | $48,654 | $20,227 | $28,427 |
| 2013 | $2,509 | $51,213 | $21,291 | $29,922 |
Source: Public Records
Agents Affiliated with this Home
-
Jeffrey Schupp
JS
Seller's Agent in 2025
Jeffrey Schupp
Sibcy Cline, Inc.
(513) 207-7518
77 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1842672
APN: 510-0240-0090
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
- 10016 Skyridge Dr
- 9860 Regatta Dr
- 9901 Regatta Dr
- 4327 Courageous Cir Unit 86
- 4281 Defender Dr
- 4220 Endeavor Dr
- 4220 Endeavor Dr Unit 101
- 5585 Springdale Rd
- 9940 Regatta Dr Unit 302
- 9940 Regatta Dr
- 4240 Endeavor Dr
- 5638 Springdale Rd
- 5778 Blue Rock Hill Rd
- 4194 Intrepid Dr Unit 26
- 5847 Blue Rock Hill Rd
- 4068 Springrock Dr
- 9661 Weik Rd
- 9460 Maple Knoll Dr
- 5609 Old Blue Rock Rd Unit 25
- 10263 Colerain Ave
- 5526 Sheits Rd
- 5575 Sheits Rd
- 5448 Sheits Rd
- 5626 Sheits Rd
- 9800 Skyridge Dr
- 9434 Brehm Rd
- 9810 Skyridge Dr
- 9801 Skyridge Dr
- 5595 Sheits Rd
- 9432 Brehm Rd
- 9807 Skyridge Dr
- 9436 Brehm Rd
- 9813 Skyridge Dr
- 9846 Skyridge Dr
- 9819 Skyridge Dr
- 9835 Skyridge Dr
- 9860 Skyridge Dr
- 5430 Sheits Rd
- 9857 Skyridge Dr
- 9438 Brehm Rd
Your Personal Tour Guide
Ask me questions while you tour the home.