Crystal Gibson
Pivot Realty Group
(513) 440-3822
109 Total Sales
3 in Hebron
$545K - $638K Price Range
4040 Roundup Ridge Hebron, KY 41048
Hebron AreaEstimated Value: $844,000 - $1,364,627
4
Beds
3.5
Baths
4,226
Sq Ft
$278/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- River View
- Open Floorplan
- North Pointe Elementary School Rated A
- 1.84 Acre Lot
- Deck
About This Home
As of March 2025Experience 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!
Last Agent to Sell the Property
Keller Williams Advisors License #241335 Listed on: 01/09/2025
Last Buyer's Agent
Michele Mamo
eXp Realty, LLC License #216745
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Year Built
- Built in 2019
Lot Details
- 1.84 Acre Lot
- Cleared Lot
- Wooded Lot
HOA Fees
- $313 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Front Facing Garage
- Side Facing Garage
- Garage Door Opener
- Driveway
- Off-Street Parking
Property Views
- River
- Woods
- Valley
Home Design
- Ranch Style House
- Poured Concrete
- Shingle Roof
- Composition Roof
- HardiePlank Type
- Stone
Interior Spaces
- 4,226 Sq Ft Home
- Open Floorplan
- Wet Bar
- Sound System
- Wired For Data
- Built-In Features
- Crown Molding
- Beamed Ceilings
- Coffered Ceiling
- Tray Ceiling
- High Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Gas Fireplace
- Double Hung Windows
- Picture Window
- Sliding Windows
- Casement Windows
- Aluminum Window Frames
- Panel Doors
- Entrance Foyer
- Family Room
- Living Room with Fireplace
- 2 Fireplaces
- Dining Room
- Den
- Library
- Bonus Room
- Game Room Downstairs
- Storage Room
- Home Gym
- Smart Home
Kitchen
- Eat-In Gourmet Kitchen
- Butlers Pantry
- Gas Oven
- Microwave
- Dishwasher
- Kitchen Island
- Granite Countertops
- Solid Wood Cabinet
Flooring
- Wood
- Carpet
- Tile
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Primary Bedroom
- En-Suite Bathroom
- Walk-In Closet
- Dressing Area
- Dual Vanity Sinks in Primary Bathroom
- Soaking Tub in Primary Bathroom
- Soaking Tub
- Primary Bathroom includes a Walk-In Shower
- Built-In Shower Bench
Laundry
- Laundry Room
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Kitchen in Basement
- Finished Basement Bathroom
- Stubbed For A Bathroom
Outdoor Features
- Deck
- Enclosed Patio or Porch
Schools
- North Pointe Elementary School
- Conner Middle School
- Conner Senior High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Septic Tank
- High Speed Internet
Listing and Financial Details
- Assessor Parcel Number 034.00-08-002.00
Community Details
Overview
- Association fees include ground maintenance, snow removal
- Stonegate Property Mortgage Association, Phone Number (859) 534-0900
- On-Site Maintenance
Recreation
- Snow Removal
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 9, 2025
Closed on
Mar 25, 2025
Sold by
Moore John J and Evans-Moore Teresa M
Bought by
Seller's Agent
Eric Sztanyo
Keller Williams Advisors
Buyer's Agent
Michele Mamo
eXp Realty, LLC
List Price
$1,399,900
Sold Price
$1,250,000
Premium/Discount to List
-$149,900
-10.71%
Views
90
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$73,138
Avg. Annual Appreciation
-4.25%
Purchase Details
Listed on
Aug 25, 2022
Closed on
Oct 3, 2022
Sold by
Sink Daniel R and Sink Rita A
Bought by
Moore John J and Evans-Moore Teresa M
Seller's Agent
Jason Asch
Keller Williams Realty Service
Buyer's Agent
Eric Sztanyo
Keller Williams Advisors
List Price
$1,195,000
Sold Price
$1,160,000
Premium/Discount to List
-$35,000
-2.93%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.06%
Original Mortgage
$1,160,000
Interest Rate
5.89%
Mortgage Type
VA
Purchase Details
Closed on
Nov 5, 2019
Sold by
Rivers Pointe Development Llc
Bought by
Sink Daniel R and Sink Rita A
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Hebron, KY
-
Crystal Gibson
-
Cara Chitwood
Cara Chitwood
Responds QuicklyKeller Williams Realty Service
(513) 854-6469
114 Total Sales
6 in Hebron
$290K - $484K Price Range
-
Kathy Crawford
Kathy Crawford
ERA Real Solutions Realty
(859) 600-0770
40 Total Sales
2 in Hebron
$330K - $439K Price Range
-
Brandon Stamper
Brandon Stamper
Plum Tree Realty
(859) 888-1472
129 Total Sales
2 in Hebron
$273K - $310K Price Range
-
Ben Walling
Ben Walling
Cahill Real Estate Services
(513) 586-6760
92 Total Sales
1 in Hebron
$210,000 Price
-
Cherish Jessup
Cherish Jessup
Responds QuicklyeXp Realty
(859) 279-4286
74 Total Sales
2 in Hebron
$252K - $307K Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,250,000 | 360 American Title | ||
| Moore John J | $1,160,000 | Sojourners Title | |
| Sink Daniel R | $980,048 | 360 American Title Services |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $1,160,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 03/27/2025 03/27/25 | Sold | $1,250,000 | -10.7% | $296 / Sq Ft | |
| 02/21/2025 02/21/25 | Pending | -- | -- | -- | |
| 01/09/2025 01/09/25 | For Sale | $1,399,900 | +20.7% | $331 / Sq Ft | |
| 10/05/2022 10/05/22 | Sold | $1,160,000 | -2.9% | $274 / Sq Ft | View Prior Sale |
| 08/30/2022 08/30/22 | Pending | -- | -- | -- | |
| 08/25/2022 08/25/22 | For Sale | $1,195,000 | -- | $283 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $12,342 | $1,160,000 | $150,000 | $1,010,000 |
| 2024 | $12,122 | $1,160,000 | $150,000 | $1,010,000 |
| 2023 | $12,389 | $1,160,000 | $150,000 | $1,010,000 |
| 2022 | $10,512 | $980,000 | $150,000 | $830,000 |
| 2021 | $10,571 | $980,000 | $150,000 | $830,000 |
| 2020 | $10,690 | $980,000 | $150,000 | $830,000 |
| 2019 | $1,649 | $150,000 | $150,000 | $0 |
| 2018 | $1,623 | $150,000 | $150,000 | $0 |
| 2017 | $1,635 | $150,000 | $150,000 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Eric Sztanyo
Seller's Agent in 2025
Eric Sztanyo
Keller Williams Advisors
(513) 813-6293
288 Total Sales
-
MM
Buyer's Agent in 2025
Michele Mamo
eXp Realty, LLC
-
JA
Seller's Agent in 2022
Jason Asch
Keller Williams Realty Service
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 629096
APN: 034.00-08-002.00
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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.
Nearby Homes
- 1450 Topaz Trace Ct
- 1631 Stone Crest Dr
- 1465 Topaz Trace Ct
- 2309 Bentwood Ct
- 1709 Ledgestone Way
- 1500 Crystal Rim Ct
- 2011 Falling Water Ln
- 720 Broomtail Ln
- 1517 Crystal Rim Ct
- 1745 Ledgestone Way
- 1078 Glenhurst Ct
- 7126 River Rd
- 7160 River Rd
- 1 Rivers Pointe Dr
- 7222 Catalpa Rd
- 2432 Rivers Pointe Dr
- 1490 Brenden Ct
- 2444 Rivers Pointe Dr
- 1510 Brenden Ct
- 1530 Brenden Ct
- 4040 Roundup Ridge Unit Lot 2
- 4020 Roundup Ridge
- 4020 Roundup Ridge Unit Lot 3
- 600 Back Country Dr
- 4060 Roundup
- 4000 Roundup Ridge
- 4000 Roundup Ridge Unit Lot 4
- 4021 Roundup Ridge
- 1 Roundup
- 4051 Roundup Ridge
- 7150 River Rd
- 4089 Roundup
- 4089 Roundup Unit Lot 7
- 4090 Roundup Ridge
- 7413 River Rd
- 7089 River Rd
- 3174 Bentgrass Way
- 3178 Bentgrass Way
- 3170 Bentgrass Way
- 3158 Bentgrass Way
Your Personal Tour Guide
Ask me questions while you tour the home.