OFF MARKET

Off market mar 2025 for $1.2M

$1,360,667

Est. refi paymentEst. refi $8,311/mo

•

4,226

sq ft

4040 Roundup Rdg, Hebron, KY 41048

About this home

Public Remarks: Experience luxury living at 4040 Roundup Ridge, a stunning 4-bedroom ranch featured in the 2019 Cavalcade of Homes, located in the prestigious Reserve at Rivers Pointe Estates. Nestled on a 1.8-acre lot with breathtaking panoramic Ohio River views, this home combines authentic character with modern luxury. The open floor plan offers over 4,200 sqft of living space, highlighted by a gourmet kitchen with a quartz island, Subzero and Wolf appliances, and designer finishes. Enjoy two levels of covered outdoor living spaces, including a screened-in area, perfect for taking in the serene views. The primary suite features a spa-like ensuite with a freestanding tub, picture window, and a custom walk-in closet. The lower level is designed for entertaining with a wet bar and ample space for gatherings. Smart features like motorized blinds and a whole-house water purification system add convenience. Located in a thriving master-planned community, access is available to the RIVERWORKS pool and clubhouse, equestrian trails, and more. Schedule your showing today!

Single-familyProperty Type

2019Year Built

1.84 acresLot Size

$322Est. Price/Sq.Ft.

3 car garageParking

Listed by Eric Sztanyo • Keller Williams Advisors

Bought with Michele Mamo • eXp Realty LLC

Redfin checked: a minute ago

•Source:NKMLS #629096

Redfin Estimate

$1,360,667

$111K since sold in March 2025$5,000 since October

Recently sold homes
Estimate history
Homes for sale

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

SOLD SEP 18, 2026
$476,500
A
4 beds3.5 baths2,984 sq ft
2071 Madison Dr, Hebron, KY 41048
SOLD AUG 20, 2026
$999,900
B
3 beds3.5 baths3,846 sq ft
1514 Crystal Rim Ct, Hebron, KY 41048
SOLD MAR 30, 2026
$786,390
C
4 beds4 baths3,570 sq ft
1852 Coachtrail Dr, Hebron, KY 41048
SOLD JAN 9, 2026
$840,000
D
4 beds3.5 baths4,539 sq ft
2400 Copper Ridge Ct, Hebron, KY 41048
SOLD DEC 18, 2025
$1,364,365
E
4 beds3.5 baths4,514 sq ft
1705 Ledgestone Way, Hebron, KY 41048
SOLD AUG 17, 2026
$375,000
F
4 beds3.5 baths1,782 sq ft
2016 Falling Water Ln, Hebron, KY 41048

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

Earn from this home

Sell

$309,480

Est. take-home

List your home with Redfin and save $13,607

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,253/mo

Redfin rental estimate

List your home for rent

Market trends in 41048, KY

Last updated October 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

FOR SALE BY OWNER
$345,000
4 beds3 baths1,690 sq ft
1672 Jeffrey Ln, Hebron, KY 41048
$469,900
4 beds3 baths2,394 sq ft
1963 Montpelier Dr, Hebron, KY 41048
$349,900
3 beds2.5 baths1,624 sq ft
1023 Meadowbrook Ct, Hebron, KY 41048
$475,000
4 beds3.5 baths2,380 sq ft
2392 Oakview Ct, Hebron, KY 41048
3D WALKTHROUGH
$1,274,888
4 beds4.5 baths6,031 sq ft
610 Rivershore Dr, Hebron, KY 41048
$320,000
3 beds3 baths1,234 sq ft
3030 Republic Way, Hebron, KY 41048
See all

Provided by Redfin

Sale history for 4040 Roundup Rdg

Date

Event

Price

NKMLS #629096

Mar 27, 2025

Sold

$1,250,000

$296/sq ft

Feb 21, 2025

Pending

—

Jan 9, 2025

Listed

$1,399,900

$331/sq ft

NKMLS #607337

Oct 5, 2022

Sold

$1,160,000

$274/sq ft

Aug 30, 2022

Pending

—

Aug 25, 2022

Listed

$1,195,000

$283/sq ft

+43

Public Remarks

Here is your chance to own a show home featured in the 2019 Cavalcade of homes in the prestigious and -SOLD OUT- Reserve at Rivers Pointe . A one of a kind 4 bedroom ranch that offers a remarkable blend of authentic character and luxury amenities at every turn. The breathtaking panoramic river views will wow anyone who enters. Other exciting features include: Open floor plan with over 4200 sqft of living space on a 1.8 acre lot*9' ceiling heights on main & lower level*Gourmet kitchen w/ huge island bathed in quarts*Subzero and Wolf kitchen appliances*Two levels of covered outdoor living space(screened & open)*Luxurious master bedroom retreat*Opulent master bathroom with freestanding tub and picture view window of the Ohio River*Massive walk-in closet with custom shelving & shoe racks galore* Motorized blinds*Whole house water purification system*Wet bar entertainment center in lower level and so much more. Own or like to ride horses? You can walk to River Pointe Stables just a few hundred yards from the house or as the community grows you can have access to pools, 8 miles of equestrian trails and hiking. TAKE THE 3D TOUR

NKMLS #607335

Aug 25, 2022

Price Changed

$1,195,000

$283/sq ft

Aug 25, 2022

Listed

$1,950,000

$461/sq ft

Aug 25, 2022

Listing Removed

—

NKMLS #602526

Aug 25, 2022

Listing Removed

—

Jun 28, 2022

Price Changed

$1,249,000

$296/sq ft

May 6, 2022

Price Changed

$1,270,000

$301/sq ft

Mar 30, 2022

Listed

$1,349,900

$319/sq ft

NKMLS #528412

Nov 5, 2019

Sold

$980,048

$232/sq ft

Aug 1, 2019

Listing Removed

—

Jun 26, 2019

Listed

$876,000

$207/sq ft

NKMLS #520841

Jun 26, 2019

Listing Removed

—

Oct 10, 2018

Listed

$876,000

$207/sq ft

Year

Property tax

Land + Additions

Assessment*

2026

$13,144 (+6.5%)

$150,000 + $1,100,000

$1,250,000

2025

$12,342 (+1.8%)

$150,000 + $1,010,000

$1,160,000

2024

$12,122 (−2.2%)

$150,000 + $1,010,000

$1,160,000

2023

$12,389 (+17.8%)

$150,000 + $1,010,000

$1,160,000

2022

$10,512 (+0.2%)

$150,000 + $1,010,000

$1,160,000

2021

$10,496 (−1.8%)

$150,000 + $830,000

$980,000

2020

$10,690 (+548.3%)

$150,000 + $830,000

$980,000

2019

$1,649 (+1.6%)

$150,000 + $830,000

$980,000

2018

$1,623 (−0.7%)

$150,000

2017

$1,635

$150,000

Tax history for 4040 Roundup Rdg

Year

Property tax

Land + Additions

Assessment*

2026

$13,144 (+6.5%)

$150,000 + $1,100,000

$1,250,000

2025

$12,342 (+1.8%)

$150,000 + $1,010,000

$1,160,000

2024

$12,122 (−2.2%)

$150,000 + $1,010,000

$1,160,000

2023

$12,389 (+17.8%)

$150,000 + $1,010,000

$1,160,000

2022

$10,512 (+0.2%)

$150,000 + $1,010,000

$1,160,000

2021

$10,496 (−1.8%)

$150,000 + $830,000

$980,000

2020

$10,690 (+548.3%)

$150,000 + $830,000

$980,000

2019

$1,649 (+1.6%)

$150,000 + $830,000

$980,000

2018

$1,623 (−0.7%)

$150,000

2017

$1,635

$150,000

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

Public record

Public record
Zoning

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

1.84 Acres

Year renovated

—

Sq. Ft.

2,520

Year built

2019

Style

Single Family Residential

County

Boone County

APN

034.00-08-002.00

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 30, 2026.

A-2

Agricultural Estate District

The purpose of the Agricultural Estate district is to provide for low density residential development and on a limited basis agricultural uses or agricultural related uses in the context of a rural environment.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
General retail
Housing-Single unit
Housing-Senior
Cemetery

Property details

Parking

Parking Information
Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Off Street, Oversized

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: Laundry Room, Main Level
Interior Features: Kitchen Island, Tray Ceiling(s), Sound System, Soaking Tub, Smart Home, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Coffered Ceiling(s), Built-in Features, Beamed Ceilings, Butler's Pantry, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recess Ceiling(s), Recessed Lighting, Wired for Data, Wired for Sound
Fireplace Features: Gas
Appliances: Gas Oven, Dishwasher, Microwave, Refrigerator
Has Fireplace

Room Information 1
Room Type: Primary Bedroom
Room Dimensions: 17 x 17
Room Length: 17.00
Room Width: 17.00

Room Information 2
Room Type: Bedroom 2
Room Dimensions: 12 x 11
Room Length: 12.00
Room Width: 11.00

Room Information 3
Room Type: Bedroom 3
Room Dimensions: 15 x 13
Room Length: 15.00
Room Width: 13.00

Room Information 4
Room Type: Bedroom 4
Room Dimensions: 15 x 13
Room Length: 15.00
Room Width: 13.00

Room Information 5
Room Type: Primary Bath
Room Dimensions: 17 x 12
Room Length: 17.00
Room Width: 12.00

Room Information 6
Room Type: Family Room
Room Dimensions: 18 x 18
Room Length: 18.00
Room Width: 18.00

Room Information 7
Room Type: Living Room
Room Dimensions: 20 x 17
Room Length: 20.00
Room Width: 17.00

Room Information 8
Room Type: Kitchen
Room Description: Custom Cabinetry and organization shelves
Room Dimensions: 15 x 10
Room Length: 15.00
Room Width: 10.00

Room Information 9
Room Type: Library
Room Dimensions: 10 x 8
Room Length: 10.00
Room Width: 8.00

Room Information 10
Room Type: Entry
Room Dimensions: 6 x 11
Room Length: 6.00
Room Width: 11.00

Room Information 11
Room Dimensions: 8 x 7
Room Length: 8.00
Room Width: 7.00

Room Information 12
Room Type: Dining Room
Room Dimensions: 16 x 11
Room Length: 16.00
Room Width: 11.00

Room Information 13
Room Type: Exercise Room
Room Description: Gym/ hobby room
Room Dimensions: 15 x 15
Room Length: 15.00
Room Width: 15.00

Room Information 14
Room Type: Den
Room Description: Lower level study/den
Room Dimensions: 13 x 15
Room Length: 13.00
Room Width: 15.00

Room Information 15
Room Type: Game Room
Room Dimensions: 13 x 13
Room Length: 13.00
Room Width: 13.00

Room Information 16
Room Type: Bathroom 4
Room Dimensions: 5 x 7
Room Length: 5.00
Room Width: 7.00

Room Information 17
Room Type: Game Room
Room Dimensions: 23 x 23
Room Length: 23.00
Room Width: 23.00

Room Information 18
Room Type: Bonus Room
Room Dimensions: 8 x 6
Room Length: 8.00
Room Width: 6.00

Room Information 19
Room Type: Bathroom 2
Room Dimensions: 5 x 7
Room Length: 5.00
Room Width: 7.00

Exterior

Building Information
Levels: One
Structure Type: House
Construction Materials: HardiPlank Type, Stone
Building Area Total: 4226.0

Exterior Features
Patio And Porch Features: Covered, Deck, Enclosed
Year Built: 2019
Aluminum Clad Window(s), Casement, Double Hung, Picture Window(s), Slider Window(s)
Composition, Shingle

Property Type
Single Family Residence

Property Features
Property Condition: Existing Structure
Has View

Property Information
Property Type: Residential

Land Information
Foundation Details: Poured Concrete

Lot Information
Lot Size Units: Acres
Lot Size Sq. Ft.: 80,061
Lot Size Dimensions: Irregular dimensions
Lot Size Area: 1.84
Lot Size Acres: 1.84
Lot Features: Cleared, Wooded

Utilities

Utility Information
Water Source: Public
Sewer: Septic Tank

Location

HOA Information
Association Fee: $3,758
Association Fee Frequency: Annually
Association Fee Includes: Maintenance Grounds, Snow Removal
Has Association

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

Location Information
Directions: I-275 West to Exit 6A (237 North). Continue one half mile, R on Tanner Road. Go 1 mile to River Road (Rt. 8). L at River Road, then proceed 1 mile to the Reserve. Turn L on Back Country Dr Right to Roundup Ridge

Public facts

Beds: 3
Baths: 3.5
Sq. Ft.: 2,520
Stories: 1.0
Lot Size: 1.84 acres
Style: Single Family Residential
Year Built: 2019
Year Renovated: —
County: Boone County
APN: 034.00-08-002.00

Home facts updated by county records on Oct 30, 2026

Around this home

Schools

North Pointe Elementary School

Public PreK-5 • Assigned • 1.1mi

8/10

Conner Middle School

Public 6-8 • Assigned • 3.9mi

9/10

Conner High School

Public 9-12 • Assigned • 3.9mi

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 102° 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

$1.29M – $1.57M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

NEW CONSTRUCTION

$474,000

4 beds3 baths2,646 sq ft

1113 Camden Ct, Hebron, KY 41048

Open-concept layout • Staggered cabinetry • Granite countertops

$535,000

5 beds3.5 baths2,768 sq ft

2404 Lost Willow Ct, Hebron, KY 41048

Gorgeous newer deck • Granite countertops • Large island

$549,000

5 beds4 baths3,851 sq ft

2324 Summerwoods Dr, Hebron, KY 41048

New roof • White wood cabinetry • Granite countertops

OPEN NOV 8, 12PM TO 2PM

$798,500

5 beds3.5 baths5,178 sq ft

1880 Whetherstone Rdg, Hebron, KY 41048

1 acre lot • Custom built home • Open concept kitchen

NEW CONSTRUCTION

$1,099,900

4 beds4.5 baths6,619 sq ft

1517 Crystal Rim Ct, Hebron, KY 41048

Open floor plan • Morning room • Beamed ceiling

$224,900

3 beds1 bath1,496 sq ft

7472 Gracely Dr, Cincinnati, OH 45233

One-level living • Updated kitchen • Granite counters

New listings for sale in 41048

FOR SALE BY OWNER

$345,000

4 beds3 baths1,690 sq ft

1672 Jeffrey Ln, Hebron, KY 41048

Fenced backyard • Quiet street • Recent upgrades

$469,900

4 beds3 baths2,394 sq ft

1963 Montpelier Dr, Hebron, KY 41048

Spacious kitchen • Fenced backyard • Hardwood flooring

$349,900

3 beds2.5 baths1,624 sq ft

1023 Meadowbrook Ct, Hebron, KY 41048

Move-in ready • Renovated baths • Finished lower level

$475,000

4 beds3.5 baths2,380 sq ft

2392 Oakview Ct, Hebron, KY 41048

Open floor plan • Finished basement • Walkout patio

3D WALKTHROUGH

$1,274,888

4 beds4.5 baths6,031 sq ft

610 Rivershore Dr, Hebron, KY 41048

Circular drive • Travertine flooring • Granite surfaces

$320,000

3 beds3 baths1,234 sq ft

3030 Republic Way, Hebron, KY 41048

Open floor plan • Huge back yard • 0.35 acre lot

Home values near 4040 Roundup Rdg

Data from public records.

Address	Redfin Estimate
4090 Roundup Rdg, Hebron, KY 4 Beds \| 4.5 Baths \| 4553 Sq. Ft.	$1,573,561
4021 Roundup Rdg, Hebron, KY 4 Beds \| 3.5 Baths \| - Sq. Ft.	$1,733,408

Address	Redfin Estimate
4020 Roundup Rdg, Hebron, KY 4 Beds \| 3.5 Baths \| 3039 Sq. Ft.	$1,392,896
4051 Roundup Rdg, Hebron, KY 4 Beds \| 4 Baths \| 5000 Sq. Ft.	$1,724,523

Address	Redfin Estimate
4000 Roundup Rdg, Hebron, KY 6 Beds \| 5 Baths \| 4233 Sq. Ft.	$1,760,539
4089 Roundup Rdg, Hebron, KY 4 Beds \| 4 Baths \| 4954 Sq. Ft.	$1,893,146

Property information provided by NKMLS when last listed in 2025. 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	Newport, 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 4040 Roundup Rdg

Tax history for 4040 Roundup Rdg

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 4040 Roundup Rdg

More real estate resources