Kerry Schrand-Rawe
Huff Realty - Florence
(859) 600-0975
51 Total Sales
6 in Union
$342K - $535K Price Range
10238 Hamlet Ct Union, KY 41091
Union AreaEstimated Value: $409,980
4
Beds
3.5
Baths
2,768
Sq Ft
$148/Sq Ft
Est. Value
Highlights
- Deck
- Traditional Architecture
- Covered Patio or Porch
- Shirley Mann Elementary School Rated A
- No HOA
- Formal Dining Room
About This Home
As of April 2025Beautiful 4-bedroom 4-bathroom home offering ample space for all! Located in the desirable Ryle school district in a no HOA neighborhood. Step into the heart of the home where an open concept living room seamlessly flows into the kitchen and eat-in area, creating the ideal space for entertaining or gatherings. Prepare delicious meals in the kitchen, complete with modern appliances, large island & plenty of storage. Walkout from your breakfast room to a large deck with a wooded view! Expansive primary suite with sitting area, a large bathroom, separate shower and soaking tub. Spacious family room, fireplace. Don't miss the opportunity to make this your forever home!
Last Agent to Sell the Property
Keller Williams Realty Service Listed on: 02/28/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
Year Built
- Built in 2004
Lot Details
- 8,124 Sq Ft Lot
- Cul-De-Sac
Parking
- 2 Car Garage
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2,768 Sq Ft Home
- 2-Story Property
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Gas Fireplace
- Insulated Windows
- Panel Doors
- Entrance Foyer
- Family Room
- Living Room
- Formal Dining Room
- Laundry Room
Kitchen
- Eat-In Kitchen
- Electric Oven
- Electric Range
- Microwave
- Dishwasher
- Kitchen Island
Flooring
- Carpet
- Concrete
Bedrooms and Bathrooms
- 4 Bedrooms
- Double Vanity
- Soaking Tub
- Shower
Unfinished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
Outdoor Features
- Deck
- Covered Patio or Porch
Schools
- Shirley Mann Elementary School
- Gray Middle School
- Ryle High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Cable TV Available
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 063.00-25-007.00
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
Feb 28, 2025
Closed on
Apr 9, 2025
Sold by
Schulkers Logan T and Schulkers Payton M
Bought by
Seller's Agent
The Berens Team
Keller Williams Realty Service
Buyer's Agent
Lori Taylor
Coldwell Banker Realty FM
List Price
$380,000
Sold Price
$380,000
Views
50
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
$29,980
Avg. Annual Appreciation
5.45%
Original Mortgage
$342,000
Outstanding Balance
$337,414
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$72,566
Purchase Details
Closed on
Sep 5, 2019
Sold by
Luzak James T and Luzak Amber N
Bought by
Schulkers Logan T and Schulkers Payton M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$284,684
Interest Rate
3.7%
Mortgage Type
FHA
Purchase Details
Closed on
Jan 20, 2014
Sold by
Salyers Nathan
Bought by
Luzak James T and Luzak Amber N
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$188,550
Interest Rate
4.44%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 6, 2008
Sold by
Crouch Holly N
Bought by
Salyers Nathan
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$210,000
Interest Rate
7.53%
Mortgage Type
Adjustable Rate Mortgage/ARM
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Union, KY
-
Kerry Schrand-Rawe
-
Ken Warden
Ken Warden
Warden & Associates
(859) 600-0843
26 Total Sales
2 in Union
$340,000 Price Range
-
Andrew Lohmiller
Andrew Lohmiller
Lohmiller Real Estate
(812) 577-9616
53 Total Sales
1 in Union
$580,000 Price
-
Jessica Reeves
Jessica Reeves
Responds QuicklySibcy Cline, REALTORS-Florence
(859) 600-0257
62 Total Sales
2 in Union
$158K - $863K Price Range
-
Linda Mildon
Linda Mildon
Responds QuicklyRE/MAX Victory + Affiliates
(859) 600-1626
136 Total Sales
26 in Union
$55K - $870K Price Range
-
Missy Bricking
Missy Bricking
Keller Williams Realty Service
(859) 600-6767
284 Total Sales
49 in Union
$195K - $690K 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 |
|---|---|---|---|
| $380,000 | 360 American Title | ||
| Schulkers Logan T | $289,900 | Springdale Title Llc | |
| Luzak James T | $198,500 | None Available | |
| Salyers Nathan | $117,500 | Advanced Land Title Agency |
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 | $342,000 | ||
| Previous Owner | Schulkers Logant | $286,300 | |
| Previous Owner | Schulkers Logan T | $284,684 | |
| Previous Owner | Luzak James T | $198,921 | |
| Previous Owner | Luzak James T | $188,550 | |
| Previous Owner | Salyers Nathan | $210,000 | |
| Previous Owner | Salyers Nathan | $23,500 | |
| Previous Owner | Salyers Nathan | $211,500 |
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 |
|---|---|---|---|---|
| 04/11/2025 04/11/25 | Sold | $380,000 | 0.0% | $137 / Sq Ft |
| 03/01/2025 03/01/25 | Pending | -- | -- | -- |
| 02/28/2025 02/28/25 | For Sale | $380,000 | -- | $137 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
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 | $3,426 | $299,900 | $42,000 | $257,900 |
| 2024 | $3,369 | $299,900 | $42,000 | $257,900 |
| 2023 | $3,299 | $289,900 | $36,500 | $253,400 |
| 2022 | $3,255 | $289,900 | $36,500 | $253,400 |
| 2021 | $3,336 | $289,900 | $36,500 | $253,400 |
| 2020 | $3,319 | $289,900 | $36,500 | $253,400 |
| 2019 | $2,722 | $235,000 | $36,500 | $198,500 |
| 2018 | $2,756 | $235,000 | $36,500 | $198,500 |
| 2017 | $2,681 | $235,000 | $36,500 | $198,500 |
| 2015 | $2,648 | $235,000 | $36,500 | $198,500 |
| 2013 | -- | $235,000 | $36,500 | $198,500 |
Source: Public Records
Agents Affiliated with this Home
-
The Berens Team
TB
Seller's Agent in 2025
The Berens Team
Keller Williams Realty Service
(859) 663-8464
307 Total Sales
-
Lori Taylor
Buyer's Agent in 2025
Lori Taylor
Coldwell Banker Realty FM
(859) 486-8239
109 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 630212
APN: 063.00-25-007.00
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 web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 10859 Pleasant Colony Dr
- 10862 Pleasant Colony Dr
- 10605 Pimlico Park
- 10569 Pimlico Park
- 1040 Belmont Park Dr
- 705 Oakridge Dr
- 10008 Wild Cherry Dr
- 10015 Bent Tree Cir
- 11512 Gregson Ct
- 10652 Chenery Cove
- 10789 Saint Andrews Dr
- 1227 Farmcrest Dr
- 10258 Cardigan Dr
- 10796 Saint Andrews Dr
- 10530 Cheshire Ridge Dr
- 1276 Frogtown Rd
- 10082 Cedarwood Dr
- 10900 Triple Crown Blvd
- 1311 Scottish Ln
- 10819 Sawgrass Ct
- 10250 Hamlet Ct
- 896 Frogtown Rd
- 908 Frogtown Rd
- 10246 Hamlet Ct
- 10258 Hamlet Ct
- 10253 Hamlet Ct
- 10242 Hamlet Ct
- 872 Frogtown Rd
- 10257 Hamlet Ct
- 10262 Hamlet Ct
- 1101 Avon Ct
- 1105 Avon Ct
- 10234 Hamlet Ct
- 787 Oakridge Dr
- 1109 Avon Ct
- 790 Oakridge Dr
- 960 Frogtown Rd
- 117 Avon Ct
- 783 Oakridge Dr
- 10230 Hamlet Ct
Your Personal Tour Guide
Ask me questions while you tour the home.