Last Sold Price
4 beds2,389 sqft$383/sqft
1900 Williams Road, Hebron, KY 41048

Description

When you're searching for that elusive unicorn of a home, this Drees-built masterpiece checks all the boxes. Set on a spacious, private lot, this stunning residence boasts a first-floor primary suite, a beautifully finished basement, and an outdoor oasis that will take your breath away—featuring a pool, outdoor kitchen, hot tub, and space for unforgettable entertainment. Wow. Perfect for discerning buyers who crave a ''like-new'' home with the ideal balance of size, privacy, and luxury amenities....When you're searching for that elusive unicorn of a home, this Drees-built masterpiece checks all the boxes. Set on a spacious, private lot, this stunning residence boasts a first-floor primary suite, a beautifully finished basement, and an outdoor oasis that will take your breath away—featuring a pool, outdoor kitchen, hot tub, and space for unforgettable entertainment. Wow. Perfect for discerning buyers who crave a ''like-new'' home with the ideal balance of size, privacy, and luxury amenities. Nestled in a quiet enclave, yet with access to coveted HOA amenities, this property is truly a 10. Custom craftsmanship shines throughout the home, including a private office and a fully finished basement with a theater room, bar, walkout, and recreation space. Plus, enjoy the convenience of a 3-car garage and a fully fenced lot. This home is your rare chance to experience luxury living at its finest!
LISTING CLOSED: 11/18/2024 12:00 AM

  1. Listed by Michele Mamo • Brokerage DRE #287166 • eXp Realty LLC
    P: (859) 512-7772 C: (859) 512-7772 michelemamo@gmail.com

Property Details for 1900 Williams Road

Status
MLS #
626207
Days on Market
47
Taxes
-
HOA Fees
$42 / month
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
2019
Lot Size
1.31 AC / 57,063 SF
Has View
Yes
Architectural Style
Transitional
View
Trees/Woods, Neighborhood
Zoning Description
Residential

Recent comparable sales

Median sold price

$419,900

Avg days on market

35

Sale-to-list ratio

97.3%

Hebron, KY

9 comparable properties found

$419,900 | 2392 Oakview Court, Hebron, KY 41048
1/33
1

$419,900

Sold 12/09/24

4
Bedrooms
2,380
Square Feet
0.22
Acres
$410,000 | 2529 Broadleaf Court, Hebron, KY 41048
1/43
2

$410,000

Sold 10/15/24

4
Bedrooms
2,400
Square Feet
0.23
Acres
$440,000 | 2626 Alyssum Drive, Hebron, KY 41048
1/40
3

$440,000

Sold 01/06/26

4
Bedrooms
2,640
Square Feet
0.23
Acres
$399,900 | 1143 Rivermeade Drive, Hebron, KY 41048
1/50
4

$399,900

Sold 12/20/24

4
Bedrooms
2,580
Square Feet
0.25
Acres
$405,000 | 1731 Elmburn Lane, Hebron, KY 41048
1/51
5

$405,000

Sold 01/17/25

4
Bedrooms
2,082
Square Feet
0.25
Acres
$484,900 | 1545 Backwood Court, Hebron, KY 41048
1/46
6

$484,900

Sold 04/01/26

4
Bedrooms
2,467
Square Feet
0.36
Acres
$480,000 | 1225 Thistledown Court, Hebron, KY 41048
1/51
7

$480,000

Sold 12/20/24

4
Bedrooms
2,393
Square Feet
0.54
Acres
$685,000 | 2259 Britt Drive, Hebron, KY 41048
1/50
8

$685,000

Sold 10/31/25

4
Bedrooms
2,630
Square Feet
1.6
Acres
$360,000 | 1617 Woodfield Court, Hebron, KY 41048
1/47
9

$360,000

Sold 09/10/25

4
Bedrooms
2,206
Square Feet
0.22
Acres

Location

Listing Courtesy of eXp Realty LLC

Sold By eXp Realty LLC

Add your commute

Building Information for 1900 Williams Road

Stories-Year Built2019Building Size-Lot Size1.31 AC / 57,063 SF

Payment Calculator

$5,506 per month

30 year fixed, 6.55% Interest

Principal and Interest

$4,651

Property Taxes

$813

HOA Dues

$42

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 1900 Williams Road

Summary
Location and General Information
  • Longitude: -84.745167
  • Latitude: 39.094505
  • Directions: Exit HWY 275 on to Graves Rd. Then turn left on Worldwide Blvd then another left on to Williams Rd. Continue on Williams Rd and the property will be on the right hand side.
  • MLSArea Major: K10 - Burlgt/Hebrn/BeBo/Peters/NB
  • MLSArea Minor: K10 - Burlgt/Hebrn/BeBo/Peters/NB
  • Year Built Known: Yes
  • Property Condition Disclosure: Yes
  • SIC: HE - Hebron-Boone Cty
Taxes and HOA
  • Association: Yes
  • Association Fee Frequency: Annually
  • Parcel Number: 035.00-07-708.00
  • Association Fee: $500
  • Total Yearly Fees: $500.00
  • Tax Rate: 10.68
Distance To
  • Distance To Bus Comments: No Transportation
School Information
  • High School District: Boone Co Public
  • Elementary School: Thornwilde
  • Middle Or Junior School: Conner Middle School
  • High School: Conner Senior High
Parking
  • Parking Features: Attached, Driveway, Off Street, Garage Faces Side, Garage Faces Front, Garage Door Opener, Garage
  • Attached Garage: Yes
  • Garage: Yes
  • Parking Total: 3.0
  • Garage Spaces: 3.0
Property
Lot Information
  • Road Frontage Type: County Road
  • Lot Size Units: Acres
  • Lot Size Square Feet: 57064.0
  • Lot Features: Cleared, Sloped Down
  • Lot Size Acres: 1.31
  • Lot Size Source: Realist
  • Lot Size Dimensions: 170 x 334 x 170 x 336
  • Lot Size Area: 1.31
  • Road Surface Type: Paved
  • Lot Features: Cleared, Sloped Down
Property and Assessments
  • New Construction: No
  • Year Built: 2019
  • Building Area Total: 3500.0
  • Living Area: 2389.0
  • Living Area Units: Square Feet
  • Land Lease: Yes
  • Living Area Source: Public Records
  • Property Attached: No
  • Land Description: 1 to 4.9 Acres
Building Features
  • Levels: One
  • Structure Type: House
  • Other Structures: Gazebo
  • Foundation Details: Poured Concrete
  • Construction Materials: Stone, Wood Siding, Brick Veneer
Utilities
  • Utilities: Natural Gas Available, Water Available, Sewer Available
  • Sewer: At Street
  • Water Source: Public
  • Gas Company: Duke Energy
  • Electric Company: Owen Electric
  • Water Company: Northern Kentucky Water
  • Sanitation Company: SD1
Interior and Exterior Features
Interior Features
  • Bathrooms: 3
  • Appliances: Disposal, Double Oven, Dishwasher, Ice Cooler, Microwave, Refrigerator, Wine Cooler, Stainless Steel Appliance(s), Gas Cooktop
  • Bathrooms Half: 1
  • Cooling: Central Air
  • Fireplaces Total: 1
  • Security Features: Smoke Detector(s), Security System
  • Fireplace: Yes
  • Window Features: Insulated Windows, Vinyl Frames, Double Hung, Vinyl Clad Window(s)
  • Has Heating: Yes
  • Has Cooling: Yes
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished
  • Interior Features: Built-in Features, Ceiling Fan(s), Recessed Lighting, Wired for Sound, High Ceilings, Double Vanity, Eat-in Kitchen, Entrance Foyer, Granite Counters, Kitchen Island, Open Floorplan, Pantry, Sound System, Walk-In Closet(s), Wet Bar
  • Rooms Total: 10
  • Laundry Features: Electric Dryer Hookup, Main Level, Washer Hookup, Laundry Room
  • Heating: Forced Air
  • Fireplace Features: Electric, Insert
  • Laundry Room Features: Built-in Features, Luxury Vinyl Flooring
  • Living Room Features: High Ceiling(s), Recessed Lighting, Luxury Vinyl Flooring
  • Primary Bedroom Features: Walk-Out Access, Walk-In Closet(s), Ceiling Fan(s), Luxury Vinyl Flooring, Recessed Lighting
  • Office Features: Luxury Vinyl Flooring
  • Recreation Room Features: Walk-Out Access, Carpet Flooring
Exterior Features
  • Exterior Features: Balcony, Lighting, Hot Tub, Outdoor Grill, Fire Pit, Outdoor Kitchen, Private Yard
  • Patio And Porch Features: Deck, Covered
  • Pool Features: In Ground
  • Association Amenities: Pool, Clubhouse, Tennis Court(s), Playground, Trail(s)
  • Fencing: Full, Perimeter, Aluminum, Fenced
  • Roof: Shingle
Room Information
Room 1
  • Room Features: Recessed Lighting, Luxury Vinyl Flooring
  • Room Type: Office
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 13 x 13
Room 2
  • Room Features: Built-in Features, Luxury Vinyl Flooring
  • Room Type: Laundry
  • Room Length: 9.0
  • Room Level: First
  • Room Width: 9.0
  • Room Dimensions: 9 x 9
Room 3
  • Room Features: High Ceilings, Recessed Lighting, Luxury Vinyl Flooring
  • Room Type: Living Room
  • Room Length: 23.0
  • Room Level: First
  • Room Width: 14.0
  • Room Dimensions: 23 x 14
Room 4
  • Room Features: Luxury Vinyl Flooring
  • Room Type: Breakfast Room
  • Room Length: 11.0
  • Room Level: First
  • Room Width: 10.0
  • Room Dimensions: 11 x 10
Room 5
  • Room Features: Walk-Out Access, Walk-In Closet(s), Ceiling Fan(s), Recessed Lighting, Luxury Vinyl Flooring
  • Room Type: Primary Bedroom
  • Room Length: 19.0
  • Room Level: First
  • Room Width: 15.0
  • Room Dimensions: 19 x 15
Room 6
  • Room Type: Media Room
  • Room Length: 14.0
  • Room Level: Lower
  • Room Width: 17.0
  • Room Dimensions: 14 x 17
Room 7
  • Room Features: Walk-Out Access, Carpet Flooring
  • Room Type: Recreation Room
  • Room Length: 28.0
  • Room Level: Lower
  • Room Width: 29.0
  • Room Dimensions: 28 x 29
Room 8
  • Room Type: Bedroom 2
  • Room Length: 12.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 12 x 13
Room 9
  • Room Type: Bedroom 3
  • Room Length: 12.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 12 x 13
Room 10
  • Room Type: Bedroom 4
  • Room Length: 12.0
  • Room Level: Lower
  • Room Width: 10.0
  • Room Dimensions: 12 x 10

Property History for 1900 Williams Road

DateEvent & SourcePriceAppreciation
Nov 18, 2024

Sold

Northern Kentucky Multiple Listing Service #626207

$915,000
Oct 23, 2024

Contract Signed

Northern Kentucky Multiple Listing Service #626207

Sep 5, 2024

Listed (Active)

Northern Kentucky Multiple Listing Service #626207

$950,000
DateEvent & SourcePrice
11/18/2024

Sold

Northern Kentucky Multiple Listing Service #626207

$915,000
10/23/2024

Contract Signed

Northern Kentucky Multiple Listing Service #626207

09/05/2024

Listed (Active)

Northern Kentucky Multiple Listing Service #626207

$950,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 1900 Williams Road

Taxable ValueLand$50,000Additions$865,000Total$915,000
Tax Record2025$9,751 ($813 / month)
Home Facts
Beds4Baths3Total Finished SqFt2,389 SqFtAbove Grade Finished SqFt2,389 SqFtStories1Lot Size57,064 SqFtStyleSingle Family ResidenceYear Built2019CountyBOONEAPN035.00-07-708.00

Schools near 1900 Williams Road

This home is within Boone County.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Public - 6 to 12
Rating
School
Distance
Thornwilde Elementary School
PublicPK to 5

Conner Middle School
Public6 to 8

Conner High School
Public9 to 12

ACCEL Academy
Public6 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 41048

$300,000 | 1078 Glenhurst Court, Hebron, KY 41048
1/26

$300,000

3
Bedrooms
1,567
Square Feet
0.25
Acres
$574,900 | 3186 Bentgrass Way, Hebron, KY 41048
1/26
New Construction

$574,900

4
Bedrooms
2,746
Square Feet
0.3
Acres
$534,900 | 3108 Bentgrass Way, Hebron, KY 41048
1/43
Open: 8/22 11:00AM - 01:00PM

$534,900

4
Bedrooms
3,376
Square Feet
0.45
Acres
$510,000 | 2617 Timberside Drive, Hebron, KY 41048
1/5
New Construction

$510,000

3
Bedrooms
2,941
Square Feet
0.29
Acres
$342,500 | 2644 Timberside Drive, Hebron, KY 41048
1/25
New Construction

$342,500

2
Bedrooms
Unavailable
Square Feet
$415,000 | 2059 Madison Drive, Hebron, KY 41048
1/28

$415,000

3
Bedrooms
1,618
Square Feet
0.28
Acres
$925,000 | 1631 Stone Crest Drive, Hebron, KY 41048
1/51
New Construction

$925,000

5
Bedrooms
3,733
Square Feet
0.26
Acres
$543,000 | 1530 Autumn Rdg Drive, Hebron, KY 41048
1/6
New Construction

$543,000

4
Bedrooms
2,753
Square Feet
0.33
Acres
$220,000 | 1972 Tanners Cove Road, Hebron, KY 41048
1/20

$220,000

2
Bedrooms
1,203
Square Feet

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 1900 Williams Road, Hebron, KY 41048
$915,000
4
2,389
57,063
$622,598
3
3
1,659
66,211
$515,150
5
4
2,728
55,757
$408,488
4
3,377
$385,000
4
3,081
13,939
$381,900
4
3,452
12,196

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of eXp Realty LLC

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 Compass and its related brokerages 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.