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!
Sold for $1,250,000
$1,250,000
4040 Roundup Rdg, Hebron, KY 41048
4beds
4,226sqft
Single Family Residence, Residential
Built in 2019
1.84 Acres Lot
$1,294,300 Zestimate®
$296/sqft
$4,537 Estimated rent
Home value
$1,294,300
$1.20M - $1.40M
$4,537/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$4,537/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$4,537/mo
Rent Zestimate®
Refinance and save
$9,897/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$9,897/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: April 26, 2025 at 10:16pm
Listed by:
Eric Sztanyo 513-813-6293,
Keller Williams Advisors
Bought with:
Michele Mamo, 216745
eXp Realty LLC
Source: NKMLS,MLS#: 629096
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Carpet Flooring, Window Treatments, Walk-In Closet(s), Bath Adjoins, Dressing Area
- Level: First
- Area: 289
- Dimensions: 17 x 17
Bedroom 2
- Features: Carpet Flooring, Window Treatments, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
- Level: First
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Features: Carpet Flooring, Window Treatments, Walk-In Closet(s), Ceiling Fan(s)
- Level: First
- Area: 195
- Dimensions: 15 x 13
Bedroom 4
- Features: Carpet Flooring, Window Treatments, Ceiling Fan(s)
- Level: First
- Area: 195
- Dimensions: 15 x 13
Bathroom 2
- Level: First
- Area: 35
- Dimensions: 5 x 7
Bathroom 4
- Features: Tile Flooring
- Level: First
- Area: 35
- Dimensions: 5 x 7
Bonus room
- Features: Closet(s)
- Level: First
- Area: 48
- Dimensions: 8 x 6
Den
- Description: Lower level study/den
- Level: Lower
- Area: 195
- Dimensions: 13 x 15
Dining room
- Features: Walk-Out Access, Wood Flooring, Chandelier
- Level: First
- Area: 176
- Dimensions: 16 x 11
Entry
- Features: Wood Flooring, Closet(s), Entrance Foyer
- Level: First
- Area: 66
- Dimensions: 6 x 11
Exercise room
- Description: Gym/ hobby room
- Level: Lower
- Area: 225
- Dimensions: 15 x 15
Family room
- Features: Carpet Flooring, Wet Bar, Storage
- Level: Lower
- Area: 324
- Dimensions: 18 x 18
Game room
- Features: Luxury Vinyl Flooring
- Level: Lower
- Area: 169
- Dimensions: 13 x 13
Game room
- Features: Luxury Vinyl Flooring
- Level: Lower
- Area: 529
- Dimensions: 23 x 23
Kitchen
- Description: Custom Cabinetry and organization shelves
- Features: Wood Flooring, Kitchen Island, Gourmet Kitchen, Eat-in Kitchen, Pantry, Wood Cabinets, Recessed Lighting
- Level: First
- Area: 150
- Dimensions: 15 x 10
Laundry
- Features: Built-in Features, Plank Flooring
- Level: First
- Area: 56
- Dimensions: 8 x 7
Library
- Features: Carpet Flooring
- Level: First
- Area: 80
- Dimensions: 10 x 8
Living room
- Features: Fireplace(s), Wood Flooring, Window Treatments, Recessed Lighting
- Level: First
- Area: 340
- Dimensions: 20 x 17
Primary bath
- Features: Double Vanity, Shower With Bench, Soaking Tub, Tile Flooring
- Level: First
- Area: 204
- Dimensions: 17 x 12
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Oven, Dishwasher, Microwave, Refrigerator
- Laundry: Laundry Room, Main Level
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, Recess Ceiling(s), Recessed Lighting, Wired for Data, Wired for Sound
- Doors: Multi Panel Doors
- Windows: Aluminum Clad Window(s), Casement, Double Hung, Picture Window(s), Slider Window(s)
- Has basement: Yes
- Number of fireplaces: 2
- Fireplace features: Gas
Interior area
- Total structure area: 4,226
- Total interior livable area: 4,226 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Off Street, Oversized
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck, Enclosed
- Has view: Yes
- View description: River, Trees/Woods, Valley
- Has water view: Yes
- Water view: River
Lot
- Size: 1.84 Acres
- Features: Cleared, Wooded
Details
- Parcel number: 034.0008002.00
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence, Residential
Materials
- HardiPlank Type, Stone
- Foundation: Poured Concrete
- Roof: Composition,Shingle
Condition
- Existing Structure
- New construction: No
- Year built: 2019
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & neighborhood
Location
- Region: Hebron
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $3,758 annually
- Services included: Maintenance Grounds, Snow Removal
Price history
| Date | Event | Price |
|---|---|---|
| 3/27/2025 | Sold | $1,250,000-10.7%$296/sqft |
Source:  NKMLS #629096 Report a problem | ||
| 2/21/2025 | Pending sale | $1,399,900$331/sqft |
Source: NKMLS #629096 Report a problem | ||
| 1/9/2025 | Listed for sale | $1,399,900+20.7%$331/sqft |
Source: NKMLS #629096 Report a problem | ||
| 10/21/2022 | Sold | $1,160,000-2.9%$274/sqft |
Source: Public Record Report a problem | ||
| 8/31/2022 | Pending sale | $1,195,000$283/sqft |
Source: NKMLS #607337 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2023 | $12,464 +18.6% | $1,160,000 +18.4% |
| 2022 | $10,512 +0.2% | $980,000 |
| 2021 | $10,496 -2.5% | $980,000 |
Find assessor info on the county website
Neighborhood: 41048
Nearby schools
GreatSchools rating
- 9/10North Pointe Elementary SchoolGrades: PK-5Distance: 1.1 mi
- 9/10Conner Middle SchoolGrades: 6-8Distance: 4 mi
- 9/10Conner High SchoolGrades: 9-12Distance: 3.9 mi
Schools provided by the listing agent
- Elementary: North Pointe Elementary
- Middle: Conner Middle School
- High: Conner Senior High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,294,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,294,300
- Kentucky
- Boone County
- Hebron
- 41048
- 4040 Roundup Rdg