Clay Horan
Horan Rosenhagen Real Estate
(513) 866-2497
61 Total Sales
1 in Union
$240,000 Price
Estimated Value: $429,105
Wow! Pride of ownership shows in this spacious 5 bedroom 3.5 bath home located in the desirable Hempsteade community. The seller has meticulously maintained and put thought into every addition! HVAC 2025. ROOF 2022. French drain system installed in backyard. Extended concrete patio 3 yrs old! NEW Waterproof, LVP flooring on the main level. 2nd floor carpet is only 4yrs old with an extra thick, hypo-allergenic padding underneath. FRESHLY FINISHED BASEMENT offering 2 bedrooms, full bathroom, family room and built in counter bar complete w/walk out access to enjoy the backyard patio and deck entertaining spaces. Formal dining room off the open foyer which leads you into the living room boasting high ceilings. Kitchen has plenty of space for eating-in, planning area, ample cabinet storage, pantry, butcher block kitchen island, wood cabinets, & walk out access to the newly resurfaced 16x14 deck. Enjoy the ease of laundry being on the 1st floor w/built in cabinets for extra storage. Keep your closets organized with the built in complete closet systems and better yet a few offer the lighting features! 3 minute walk to front community pool, pickleball/tennis/bball courts & fishing pond!
Last Agent to Sell the Property
Simple Fee Realty License #223305 Listed on: 08/19/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Clay Horan
Horan Rosenhagen Real Estate
(513) 866-2497
61 Total Sales
1 in Union
$240,000 Price
Heather Townsend
Huff Realty - Florence
(859) 739-3465
54 Total Sales
5 in Union
$170K - $725K Price Range
David Schneider
Blue Chicken Realty
(513) 586-5839
94 Total Sales
1 in Union
$398,250 Price
Kimberly Nachazel
eXp Realty, LLC
(513) 802-9458
132 Total Sales
2 in Union
$377K - $570K Price Range
JC
Jody Connett
Huff Realty - CC
(513) 586-6213
115 Total Sales
4 in Union
$310K - $661K Price Range
Chris Kennedy
Sibcy Cline, REALTORS-Florence
(513) 586-6325
104 Total Sales
7 in Union
$255K - $3.9M Price Range
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 |
|---|---|---|---|
| $436,000 | None Listed On Document | ||
| $206,000 | Metro Title Llc | ||
| $206,000 | Homestead Land Title Agency | ||
| $191,000 | In Title Agency Inc | ||
| $133,000 | None Available | ||
| $224,000 | Homestead Title Agency Ltd | ||
| $194,535 | -- |
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 | $436,000 | ||
| Previous Owner | $9,507 | ||
| Previous Owner | $9,006 | ||
| Previous Owner | $264,550 | ||
| Previous Owner | $188,292 | ||
| Previous Owner | $202,268 | ||
| Previous Owner | $181,450 | ||
| Previous Owner | $212,800 |
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/04/2025 09/04/25 | Sold | $436,000 | -6.2% | $155 / Sq Ft |
| 08/26/2025 08/26/25 | Pending | -- | -- | -- |
| 08/25/2025 08/25/25 | Price Changed | $464,999 | -3.1% | $166 / Sq Ft |
| 08/23/2025 08/23/25 | Price Changed | $479,999 | -2.0% | $171 / Sq Ft |
| 08/23/2025 08/23/25 | Price Changed | $489,999 | -2.0% | $175 / Sq Ft |
| 08/19/2025 08/19/25 | For Sale | $499,999 | -- | $178 / Sq Ft |
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 | $2,869 | $250,000 | $35,000 | $215,000 |
| 2024 | $2,821 | $250,000 | $35,000 | $215,000 |
| 2023 | $2,845 | $250,000 | $35,000 | $215,000 |
| 2022 | $2,551 | $227,200 | $35,000 | $192,200 |
| 2021 | $2,631 | $227,200 | $35,000 | $192,200 |
| 2020 | $2,461 | $215,000 | $30,000 | $185,000 |
| 2019 | $2,490 | $215,000 | $30,000 | $185,000 |
| 2018 | $2,528 | $215,000 | $30,000 | $185,000 |
| 2017 | $2,453 | $215,000 | $30,000 | $185,000 |
| 2015 | $2,425 | $215,180 | $35,000 | $180,180 |
| 2013 | -- | $224,000 | $30,000 | $194,000 |
Seller's Agent in 2025
Blaire Hancock
Simple Fee Realty
(859) 221-5050
178 Total Sales
Seller Co-Listing Agent in 2025
Jim Murray
Simple Fee Realty
(859) 802-3733
163 Total Sales
Buyer's Agent in 2025
K2 Home Team
ERA Real Solutions Realty
(859) 802-5651
17 Total Sales
Source: Northern Kentucky Multiple Listing Service
MLS Number: 635476
APN: 063.00-12-477.00
Ask me questions while you tour the home.