$380,000
SOLD APR 11, 2025

10238 Hamlet Ct Union, KY 41091

4 Beds
3.5 Baths
2,768 Sq Ft
8,276 Sq Ft Lot

Recently Sold

$137 Per Sq Ft

1 Day on Market

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 2025

Beautiful 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

The Berens Team

Keller Williams Realty Service Listed on: 02/28/2025

Keller Williams Realty Service

Last Buyer's Agent

Lori Taylor

Coldwell Banker Realty FM License #211885

Coldwell Banker Realty FM

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 Only

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

Home Details

Home Type

Single Family

Year Built

Built in 2004

Lot Details

8,124 Sq Ft Lot

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.19
  • Year Built: 2004
  • Lot Size: irregular
  • Directions: US 42 to left on Frogtown to left on Hamlet - Or 75-West Richwood Rd- right on Frogtown Connector to left on Frogtown to -R on Hamlet
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Shirley Mann School
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Stratford
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: irregular
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.1865
  • General Property Description:Living Area: 2768.0
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-25-007.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 1
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Ceiling Fan(s), Multi Panel Doors, Recessed Lighting
  • Basement: Full Finished Bath, Full, Unfinished, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Flooring: Concrete
  • Property Type: Residential
  • Appliances: Electric Oven, Electric Range, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Ceramic, Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 2768.0
  • Window Features: Insulated Windows
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Basement:Unfinished2: Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Basement:Concrete Flooring: Yes
  • Basement:Full Finished Bath: Yes
  • Fireplace Features:Gas: Yes
  • Fireplace Features:Ceramic: Yes
  • Interior Features:Recessed Lighting: Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Cul-De-Sac
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Lot Features:Cul-De-Sac: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Shirley Mann School
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 8123.94
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

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
Boulanger Michael J and Boulanger Sarah
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
$406,071

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$26,071
Avg. Annual Appreciation
8.15%
Original Mortgage
$342,000
Outstanding Balance
$339,908
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$68,811

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
Source: Public Records
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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed $380,000 360 American Title
Warranty Deed $289,900 Springdale Title Llc
Warranty Deed $198,500 None Available
Quit Claim Deed $117,500 Advanced Land Title Agency
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $342,000 New Conventional
Previous Owner $284,684 FHA
Previous Owner $188,550 New Conventional
Previous Owner $210,000 Adjustable Rate Mortgage/ARM
Source: Public Records

Property History

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

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

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 630212

Northern Kentucky Multiple Listing Service

APN: 063.00-25-007.00

Your Personal Tour Guide

Ask me questions while you tour the home.