OFF MARKET

Off market nov 2024 for $915K

$914,206

Est. refi paymentEst. refi $6,703/mo

•

2,389

sq ft

1900 Williams Rd, Hebron, KY 41048

About this home

Public Remarks: 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!

Single-familyProperty Type

2019Year Built

1.31 acresLot Size

$383Est. Price/Sq.Ft.

3 car garageParking

Listed by Michele Mamo • eXp Realty LLC

Bought with Michele Mamo • eXp Realty LLC

Redfin checked: 2 minutes ago

•Source:NKMLS #626207

Redfin Estimate

$914,206

$794 since sold in November 2024$8,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 98.8% higher than the average sale price ($460K) of 6 comparable homes.

SOLD SEP 18, 2026
$430,000
A
4 beds3 baths2,530 sq ft
1807 Bramble Ct, Hebron, KY 41048
SOLD SEP 25, 2026
$489,000
B
4 beds3.5 baths2,749 sq ft
2443 Wernz Dr, Hebron, KY 41048
SOLD OCT 2, 2026
$401,000
C
4 beds3 baths2,260 sq ft
2708 Perth Ct, Hebron, KY 41048
SOLD JUN 11, 2026
$472,000
D
4 beds3.5 baths— sq ft
1579 Battery Cir, Hebron, KY 41048
SOLD JUL 7, 2026
$452,694
E
4 beds3.5 baths2,552 sq ft
2366 Treetop Ln, Hebron, KY 41048
SOLD AUG 7, 2026
$515,000
F
4 beds3 baths3,001 sq ft
2457 Wernz Dr, Hebron, KY 41048

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$152,646

Est. take-home

List your home with Redfin and save $9,142

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,148/mo

Redfin rental estimate

List your home for rent

Market trends in 41048, KY

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.0%

0.2% MoM

Median sale price

$399K

$1K MoM

Avg. days on market

13d

2 days MoM

Recently sold homes

9 MoM

New listings for sale

NEW 10 HRS AGO
$899,900
3 beds3 baths2,370 sq ft
2341 Grandin Ct, Hebron, KY 41048
3D WALKTHROUGH
$401,000
3 beds2.5 baths2,248 sq ft
2115 Gray Ct, Hebron, KY 41048
$540,000
5 beds3.5 baths2,768 sq ft
2404 Lost Willow Ct, Hebron, KY 41048
$334,800
3 beds2.5 baths1,744 sq ft
2098 Canyon Ct, Hebron, KY 41048
$289,900
3 beds3 baths— sq ft
3700 Jonathan Dr, Hebron, KY 41048
3D WALKTHROUGH
$589,000
4 beds3.5 baths2,715 sq ft
2904 Northcross Dr, Hebron, KY 41048
OPEN SAT, 12PM TO 2PM
$550,000
6 beds4 baths3,328 sq ft
1413 Stoneyhollow Ct, Hebron, KY 41048
$450,000
4 beds2.5 baths2,084 sq ft
2414 Wernz Dr, Hebron, KY 41048
OPEN SAT, 2PM TO 4PM
$349,900
4 beds2.5 baths2,179 sq ft
3457 Patriot Ct, Hebron, KY 41048
$342,500
3 beds2.5 baths1,800 sq ft
1113 Riverwalk Ct, Hebron, KY 41048
See all

Provided by Redfin

Sale history for 1900 Williams Rd

Tax history for 1900 Williams Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

1.31 Acres

Year renovated

—

Sq. Ft.

2,389

Year built

2019

Style

Single Family Residential

County

Boone County

APN

035.00-07-708.00

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 30, 2026.

Property details

Parking

Parking Information
# of Parking Spaces: 3
Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Off Street

Garage Information
Has Attached Garage
Has Garage
# of Garage Spaces: 3

Interior

Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 1

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air

Interior Features
Laundry Features: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Sound System, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Built-in Features, Ceiling Fan(s), High Ceilings, Recessed Lighting, Wired for Sound
Fireplace Features: Electric, Insert
Appliances: Stainless Steel Appliance(s), Gas Cooktop, Dishwasher, Disposal, Double Oven, Ice Cooler, Microwave, Refrigerator
Has Fireplace
Flooring: Carpet, Vinyl

Room Information
Basement: Full

Room Information 1
Room Type: Office
Room Dimensions: 13 x 13
Room Length: 13.00
Room Width: 13.00

Room Information 2
Room Dimensions: 9 x 9
Room Length: 9.00
Room Width: 9.00

Room Information 3
Room Type: Living Room
Room Dimensions: 23 x 14
Room Length: 23.00
Room Width: 14.00

Room Information 4
Room Type: Breakfast Room
Room Dimensions: 11 x 10
Room Length: 11.00
Room Width: 10.00

Room Information 5
Room Type: Primary Bedroom
Room Dimensions: 19 x 15
Room Length: 19.00
Room Width: 15.00

Room Information 6
Room Type: Media Room
Room Dimensions: 14 x 17
Room Length: 14.00
Room Width: 17.00

Room Information 7
Room Dimensions: 28 x 29
Room Length: 28.00
Room Width: 29.00

Room Information 8
Room Type: Bedroom 2
Room Dimensions: 12 x 13
Room Length: 12.00
Room Width: 13.00

Room Information 9
Room Type: Bedroom 3
Room Dimensions: 12 x 13
Room Length: 12.00
Room Width: 13.00

Room Information 10
Room Type: Bedroom 4
Room Dimensions: 12 x 10
Room Length: 12.00
Room Width: 10.00

Exterior

Pool Information
Pool Features: In Ground

Building Information
Levels: One
Structure Type: House
Construction Materials: Brick Veneer, Stone, Wood Siding
Building Area Total: 3500.0

Exterior Features
Patio And Porch Features: Covered, Deck
Security Features: Security System, Smoke Detector(s)
Year Built: 2019
Double Hung, Vinyl Clad Window(s), Vinyl Frames
Outdoor Kitchen, Private Yard, Fire Pit, Balcony, Hot Tub, Lighting, Outdoor Grill
Aluminum, Full, Perimeter
Shingle

Property Type
Single Family Residence

Property Features
Has View

Property Information
Property Type: Residential

Land Information
Foundation Details: Poured Concrete
Road Surface Type: Paved
Road Frontage Type: County Road
Other Structures: Gazebo

Lot Information
Lot Size Units: Acres
Lot Size Sq. Ft.: 57,064
Lot Size Dimensions: 170 x 334 x 170 x 336
Lot Size Area: 1.31
Lot Size Acres: 1.31
Lot Features: Cleared, Sloped Down

Utilities

Utility Information
Water Source: Public
Sewer: At Street
Utilities: Natural Gas Available, Sewer Available, Water Available

Location

HOA Information
Association Amenities: Playground, Pool, Tennis Court(s), Clubhouse, Trail(s)
Association Fee: $500
Association Fee Frequency: Annually
Has Association

School Information
Middle Or Junior School: Conner Middle School
Elementary School: Thornwilde
High School District: Boone Co Public
High School: Conner Senior High

Location Information
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.

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 2,389
Stories: 1.0
Lot Size: 1.31 acres
Style: Single Family Residential
Year Built: 2019
Year Renovated: —
County: Boone County
APN: 035.00-07-708.00

Home facts updated by county records on Jul 30, 2026

Around this home

Schools

Thornwilde Elementary School

Public PreK-5 • Assigned • 0.3mi

8/10

Conner Middle School

Public 6-8 • Assigned • 3.4mi

9/10

Conner High School

Public 9-12 • Assigned • 3.5mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 101° expected this year, 19 days in 30 years

2/10 Wind Factor

1% chance of strong winds in next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Hebron, KY • 41048

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.2 hours in June and 3.2 hours in December, placing it below the U.S. average for solar exposure.

9.2 hrs

3.2 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$869,000 – $1.05M

Reach more buyers when you sell with Redfin. Save up to $9,142 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

NEW 10 HRS AGO

$899,900

3 beds3 baths2,370 sq ft

2341 Grandin Ct, Hebron, KY 41048

3D WALKTHROUGH

$359,900

3 beds3.5 baths2,016 sq ft

6626 Home City Ave, Cincinnati, OH 45233

$345,000

4 beds3 baths1,642 sq ft

966 Surfridge Dr, Hebron, KY 41048

$324,900

3 beds3.5 baths2,268 sq ft

188 Monitor Ave, Cincinnati, OH 45233

$287,900

4 beds3 baths2,144 sq ft

1837 Asbury Way, Hebron, KY 41048

$342,500

3 beds2.5 baths1,800 sq ft

1113 Riverwalk Ct, Hebron, KY 41048

New listings for sale in 41048

NEW 10 HRS AGO

$899,900

3 beds3 baths2,370 sq ft

2341 Grandin Ct, Hebron, KY 41048

3D WALKTHROUGH

$401,000

3 beds2.5 baths2,248 sq ft

2115 Gray Ct, Hebron, KY 41048

$540,000

5 beds3.5 baths2,768 sq ft

2404 Lost Willow Ct, Hebron, KY 41048

$334,800

3 beds2.5 baths1,744 sq ft

2098 Canyon Ct, Hebron, KY 41048

$289,900

3 beds3 baths— sq ft

3700 Jonathan Dr, Hebron, KY 41048

3D WALKTHROUGH

$589,000

4 beds3.5 baths2,715 sq ft

2904 Northcross Dr, Hebron, KY 41048

OPEN SAT, 12PM TO 2PM

$550,000

6 beds4 baths3,328 sq ft

1413 Stoneyhollow Ct, Hebron, KY 41048

$450,000

4 beds2.5 baths2,084 sq ft

2414 Wernz Dr, Hebron, KY 41048

OPEN SAT, 2PM TO 4PM

$349,900

4 beds2.5 baths2,179 sq ft

3457 Patriot Ct, Hebron, KY 41048

Home values near 1900 Williams Rd

Data from public records.

Address	Redfin Estimate
1880 Williams Rd, Hebron, KY 5 Beds \| 4 Baths \| 2728 Sq. Ft.	$669,872
1870 Williams Rd, Hebron, KY 4 Beds \| 2.5 Baths \| 3000 Sq. Ft.	$753,297

Address	Redfin Estimate
1910 Williams Rd, Hebron, KY 3 Beds \| 3 Baths \| 1659 Sq. Ft.	$642,063
1860 Williams Rd, Hebron, KY 5 Beds \| 3 Baths \| 4223 Sq. Ft.	$813,293

Address	Redfin Estimate
1890 Williams Rd, Hebron, KY 4 Beds \| 3.5 Baths \| 3572 Sq. Ft.	$780,820
1637 Southcross Dr, Hebron, KY 4 Beds \| 3.5 Baths \| - Sq. Ft.	$549,865

Property information provided by NKMLS when last listed in 2024. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for sale near me	Louisville, KY homes for sale	Frankfort, KY homes for sale
Land for sale near me	Lexington, KY homes for sale	Richmond, KY homes for sale
Open Houses near me	Bowling Green, KY homes for sale	Francisville Property Records
Condos for sale near me	Covington, KY homes for sale	KY New Listings
Agents near me	Georgetown, KY homes for sale	Francisville Housing Market

45052 homes for sale
45233 homes for sale
41048 homes for sale

West Chester homes for sale
Cincinnati homes for sale
Covington homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 41048, KY

Sale history for 1900 Williams Rd

Tax history for 1900 Williams Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 41048

Home values near 1900 Williams Rd

More real estate resources