Recently Viewed Properties
See This Home
Save This Listing
Close

$469,000

  • Sold
  • Closed
  • Single Family
  • 4 Beds
  • 2 Full Baths
  • 2 Partial Baths
  • 0.37 Acres
  • 3 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Welcome to the Welborne by Drees!Tucked away on a peaceful cul-de-sac this great one-owner home features every available builder extension, 4 lg.bedrooms, 2 full/2 half baths and a true 3-car garage this home offers room to live, relax,and entertain.Step inside to 9-ft ceilings on the first floor with an open-concept main level. Expansive family room w/fireplace, a welcoming kitchen w/wood cabinetry, granite,large pantry,and the double wall oven setup make it perfect for everyday meals or entertaining. Walk out from the breakfast area to a private backyard with a large patio and custom pergola-ideal for evening gatherings or morning coffee.Upstairs, retreat to your oversized primary suite with vaulted ceilings, an updated bath featuring a soaking tub, separate tiled shower, and a massive walk-in closet. Each secondary bedroom has its own walk-in closet and easy access to the double-vanity hall bath and convenient second-floor laundry.The finished basement offers more finished living space with a full wet bar and half bath.Set on a premium homesite with a private backyard this home truly has it all-location and layout.Minutes from top-rated schools,shopping,and everyday essentials

Full Property Details for 10154 Hamlet Ct

General

  • Sold For: $469,000
  • Status: Closed
  • Type: Single Family
  • Source: Northern_Kentucky
  • MLS ID: 632725
  • Added to Site: 272 day(s) ago

Interior

  • Number of Rooms: 16
  • Interior Features: Wet Bar, Walk-In Closet(s), Soaking Tub, Smart Thermostat, Pantry, Eat-in Kitchen, Double Vanity, Ceiling Fan(s), High Ceilings, Multi-Panel Doors, Recessed Lighting, Vaulted Ceiling(s)
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Blower Fan, Gas
  • Appliances: Gas Cooktop, Dishwasher, Disposal, Double Oven, Microwave

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 2
  • Half Bathrooms: 2

Bedrooms

  • Total Bedrooms: 4

Other Rooms

  • Laundry: Upper Level

Additional Information

  • Security/Safety: Smoke Detector(s)
  • Equipment: Sump Pump

Exterior

  • Exterior Features: Private Yard, Outdoor Grill
  • Porch/Patio/Deck: Patio, Porch

Parking

  • Garage: Yes
  • Garage Spaces: 3
  • Parking Features: Driveway, Garage, Garage Door Opener, Garage Faces Side

Location

  • County: Boone
  • Cross Streets: Frogtown
  • Driving Directions: US 42 South, L on Frogtown Rd, L on Hamlet Court, home is on the right.

School Information

  • Elementary School: Shirley Mann School
  • Middle School: Gray Middle School
  • High School: Ryle High

Community

  • Community Name: K11 - Richwd/Un/Wal/Ver/SB

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Natural Gas, Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Cable Available: Yes
  • Utility Description: Cable Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available

Structural Information

  • Architectural Style: Traditional
  • Construction: Brick, Vinyl Siding
  • Basement Desc.: Full Bath Roughed In, Full, Finished, Storage Space
  • Roof: Shingle
  • Windows: Insulated Windows, Vinyl Frames
  • Year Built: 2007
  • Property Condition: Existing Structure

Additional Structures

  • Other Structures: Pergola

Lot Features

  • Lot Size (Acres): 0.37
  • Lot Size (Sq. Ft.): 16,306
  • Lot Size: .37
  • Lot Size Source: Realist
  • Lot Dimensions: irreg.
  • Frontage: County Road, Paved
  • Lot Features: Cul-De-Sac, Level
  • Zoning: Residential

Disclosures and Reports

  • Property ID: 063.00-25-027.00

Listed by eXp Realty, LLC, Patrina Hensley
Sold by Keller Williams Realty Services, Joshua Tungate

Listing agent

— 10154 Hamlet Ct —

  • Patrina Hensley

    eXp Realty, LLC

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 10154 Hamlet Ct

School District:Boone County School District
NameGradesDistance
Shirley Mann Elementary School
10435 U.S. 42, Union, KY 41091
K-51.5 mi
Gray Middle School
10400 U.S. 42, Union, KY 41091
6-81.7 mi
Larry A. Ryle High School
10379 U.S. 42, Union, KY 41091
9-121.6 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 10154 Hamlet Ct

Date
Details
Price
Change
Source
6/30/2025
Sold
$469,000
1.96%
MLS
5/23/2025
Listed
$460,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Listed by eXp Realty, LLC, Patrina Hensley
Sold by Keller Williams Realty Services, Joshua Tungate

Similar Properties near 10154 Hamlet Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

4657 Donegal Ave, Union, KY 41091 - Photo 1
$467,500

4657 Donegal Ave  Union, KY 41091

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
4649 Donegal Ave, Union, KY 41091 - Photo 1
$475,000

4649 Donegal Ave  Union, KY 41091

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,369
    Sq. Ft.
6248 Browning Trail, Burlington, KY 41005 - Photo 1
$475,000

6248 Browning Trail  Burlington, KY 41005

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,820
    Sq. Ft.
6637 Gordon Blvd, Union, KY 41091 - Photo 1
$459,999

6637 Gordon Blvd  Union, KY 41091

  • Single Family
  • Active
  • Updated 8 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,305
    Sq. Ft.

Just Listed near 10154 Hamlet Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2225 Forest Lawn Dr, Florence, KY 41042 - Photo 1 Just Listed
$369,900

2225 Forest Lawn Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,824
    Sq. Ft.
Listed by Stephanie Simpson (859) 468-4227
612 Friars Ln, Florence, KY 41042 - Photo 1 Just Listed
$163,500

612 Friars Ln  #8  Florence, KY 41042

  • Condo
  • Active
  • Updated 18 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,010
    Sq. Ft.
348 Cornwall Dr, Florence, KY 41042 - Photo 1 Just Listed
$297,400

348 Cornwall Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
9241 Tranquility Dr, Florence, KY 41042 - Photo 1 Just Listed
$520,000
Open House

9241 Tranquility Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 5
    Beds
  • 4
    Total Baths
  • 2,928
    Sq. Ft.

Price Reduced near 10154 Hamlet Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

7796 Walnut Creek Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$5,000 (-1.92%)
$254,900

7796 Walnut Creek Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 14 hours ago
  • 3
    Beds
  • 1
    Total Bath
  • 936
    Sq. Ft.
110 Hillside Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$7,000 (-2.73%)
$249,000

110 Hillside Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,368
    Sq. Ft.
367 Cornwall Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$2,500 (-0.89%)
$277,400
Open House

367 Cornwall Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
821 Amesbury Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$5,000 (-1.13%)
$437,400

821 Amesbury Dr  Florence, KY 41042

  • Townhouse
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 3
    Total Baths

Recent Sales near 10154 Hamlet Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

10214 Hamlet Ct, Union, KY 41091 - Photo 1 Sold
$426,000

10214 Hamlet Ct  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 2,859
    Sq. Ft.
10254 Hamlet Ct, Union, KY 41091 - Photo 1 Sold
$415,000

10254 Hamlet Ct  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,610
    Sq. Ft.
10125 Ash Creek Dr, Union, KY 41091 - Photo 1 Sold
$470,000

10125 Ash Creek Dr  Union, KY 41091

  • Single Family
  • Closed
  • 3
    Beds
  • 4
    Total Baths
  • 2,276
    Sq. Ft.
10015 Bent Tree Cir, Union, KY 41091 - Photo 1 Sold
$435,000

10015 Bent Tree Cir  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,424
    Sq. Ft.

10154 Hamlet Court, Union, KY 41091 (MLS# 632725) is a Single Family property that was sold at $469,000 on June 30, 2025. Want to learn more about 10154 Hamlet Court? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.