Public Remarks: ENTERTAINER'S DREAM! Remarkable 6+ BDRM, 6 Bath, 3 Car Garage Residence Boasting Luxurious Living! Perfectly Appointed on a 1.73 ACRE Homesite Boasting PANORAMIC RIVER VIEWS, Incredible In-Ground Pool, & Suspended, Oversized Patio! Custom Built by Krumpelman Builders Who are Known for Elaborate Moldings, Upscale Appointments, & Outstanding Fit & Finish/5,832 FINISHED SQ FT on 3 LEVELS/Close to Greater NKY/Cincinnati Airport & Downtown Cincinnati/Enjoy a Wonderful LIFESTYLE w/One of the Best Views in the Northern KY Area in Most Desirable Rivershore Farms/Residential ELEVATOR Offering 1 Story Living in a 2 Story Home/Wide Hallways/Accessible Baths/Remarkable LVR RM, DNR RM, & Hearth RM/Gourmet Kitchen has 42 Inch Cabinetry, Solid Surface Countertops, (12 x 9 Pantry w/Additional Sink & Desk Area), Black Appliances, Double Oven, & Island w/Seating/Hard to Find, 1ST FL Primary Suite w/Fabulous River View, Walk-In Closet, & Adjoining Full Bath w/Walk-In Shower & Soaking Tub/1st Floor Laundry RM + Mudroom w/Cubbies/Plushly FIN LL w/Nice Bedroom, Full Bath, Spectacular Recreation RM, Storage Rooms, Kitchen/Bar Area, Lots of Windows, & French Patio Door Walkout/9 FT Ceilings/+ MUCH MORE!
Single-familyProperty Type
2006Year Built
1.73 acresLot Size
$186Est. Price/Sq.Ft.
3 car garageParking
Listed by Jane Ashcraft-West• RE/MAX Victory + Affiliates
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
6
Baths
5
Stories
2
Lot width
—
Lot depth
—
Lot size
1.73 Acres
Year renovated
—
Sq. Ft.
4,032
Year built
2006
Style
Single Family Residential
County
Boone County
APN
034.00-02-093.00
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 30, 2026.
Property details
Parking
Parking Information
Parking Features: Driveway, Garage, Garage Faces Side, Off Street, On Street, Oversized
Garage Information
Has Garage
# of Garage Spaces: 3
Interior
Bathroom Information
# of Full Bathrooms: 4
# of Half Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air
Interior Features
Laundry Features: Laundry Room, Main Level
Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Soaking Tub, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Bookcases, Breakfast Bar, Built-in Features, Butler's Pantry, Ceiling Fan(s), Elevator, French Doors, High Ceilings, Multi Panel Doors, Recessed Lighting
Fireplace Features: Ceramic, Gas
Accessibility Features: Accessible Approach with Ramp, Accessible Doors, Accessible Elevator Installed, Accessible Full Bath, Accessible Kitchen, Enhanced Accessible
Appliances: Electric Cooktop, Electric Oven, Dishwasher, Double Oven, Microwave, Refrigerator
Has Fireplace
Flooring: Carpet
Room Information
Basement: Full
Room Information 1
Room Type: Entry
Room Description: Gorgeous Entry/Custom, Arched Door w/Sidelights/Beautiful Staircase with Landing/Lots of Guest Closet Space
Room Dimensions: 12 x 9
Room Length: 12.00
Room Width: 9.00
Room Information 2
Room Type: Great Room
Room Description: Columned Accents/Handcrafted Built-In Bookcases & Cabinetry with Crown Molding/5 Windows/Window Treatments/Open to Dining Room
Room Dimensions: 18 x 12
Room Length: 18.00
Room Width: 12.00
Room Information 3
Room Type: Dining Room
Room Description: Bay Window with Incredible River View/Columned Accents/Adjacent to Great Room & Hearth Room
Room Dimensions: 16 x 10
Room Length: 16.00
Room Width: 10.00
Room Information 4
Room Type: Kitchen
Room Description: Spectacular Kitchen with One of a Kind (12x9) Pantry/Black Appliances/Double Oven/Island with Counter Bar/Upscale 42 Inch Cabinetry with Crown Molding
Room Dimensions: 18 x 15
Room Length: 18.00
Room Width: 15.00
Room Information 5
Room Type: Other Room
Room Description: Unbelievable, Walk-In Pantry with Custom Built-In Shelving, Sink, Place for Coffee Station, Window, Desk Area with Cabinetry & Crown Molding
Room Dimensions: 12 x 9
Room Length: 12.00
Room Width: 9.00
Room Information 6
Room Type: Other Room
Room Description: Hearth Room/Single French Patio Door Walkout/Ceramic, Gas Fireplace/Open to Dining Room & Kitchen
Room Dimensions: 13 x 10
Room Length: 13.00
Room Width: 10.00
Room Information 7
Room Description: White Cabinetry/Double Utility Sink/Folding Counter/Window/Fluorescent Lighting
Room Dimensions: 10 x 9
Room Length: 10.00
Room Width: 9.00
Room Information 8
Room Type: Other Room
Room Description: Fabulous Mudroom/6 Cubbies w/ Crown Molding, Shelving, & Hooks for Hanging/Entry to 1/2 Bath/Single French Patio Door Walkout to Rear Suspended Patio
Room Dimensions: 10 x 6
Room Length: 10.00
Room Width: 6.00
Room Information 9
Room Type: Primary Bedroom
Room Description: Luxurious, Primary Suite with Crown Molding, Bookcases & Desk Area, Dressing Area, Large Walk-In Closet, Adjoining Full Bath, & Magnificent River View
Room Dimensions: 16 x 15
Room Length: 16.00
Room Width: 15.00
Room Information 10
Room Type: Primary Bath
Room Description: Double Bowl Sinks/Arched, Triple View Window/Walk-In Shower/Ceramic Surrounding Tub & Shower Area/Mount for TV
Room Dimensions: 14 x 10
Room Length: 14.00
Room Width: 10.00
Room Information 11
Room Type: Bedroom 2
Room Description: Huge Room with Private, Adjoining Full Bath/Lots of Closet Space/River View
Room Dimensions: 23 x 12
Room Length: 23.00
Room Width: 12.00
Room Information 12
Room Type: Bathroom 2
Room Description: Ensuite Bathroom/Upgraded Vanity with Designer Vanity Top
Room Description: Remarkable, Finished LL/2ND KIT w/Refrigerator, Microwave, & 2 Burner Electric Cooktop/Custom Cabinetry with Decorative Cabinets & Crown Molding
Room Dimensions: 46 x 28
Room Length: 46.00
Room Width: 28.00
Room Information 20
Room Type: Bathroom 3
Room Description: Hall Full Bath/Upgraded Vanity
Room Dimensions: 9 x 5
Room Length: 9.00
Room Width: 5
Exterior
Pool Information
Pool Features: In Ground
Building Information
Levels: Two
Structure Type: House
Construction Materials: Brick
Building Area Total: 6534.0
Exterior Features
Patio And Porch Features: Covered, Patio, Porch
Year Built: 2006
Bay Window(s), Insulated Window(s)
Fenced, Private Yard, Balcony
Aluminum, Partial
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
Road Surface Type: Paved
Lot Information
Lot Size Units: Acres
Lot Size Sq. Ft.: 75,432.85
Lot Size Dimensions: 1.7317 Acres
Lot Size Area: 1.73
Lot Size Acres: 1.73
Lot Features: Wooded
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Utilities: Underground Utilities
Location
HOA Information
Association Amenities: Lake Year Round
Association Fee: $500
Association Fee Frequency: Annually
Association Fee Includes: Association Fees
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 to Hebron Exit. Approximately 2 mi to Rivershore Farms Subdivision on Right. Continue on Coachtrail Drive until it ends, turn R to 598 Rivershore Drive
Public facts
Beds: 6
Baths: 5.0
Sq. Ft.: 4,032
Stories: 2.0
Lot Size: 1.73 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Boone County
APN: 034.00-02-093.00
Home facts updated by county records on Jul 30, 2026
Around this home
Schools
North Pointe Elementary School
Public PreK-5 • Assigned • 0.9mi
8/10
Conner Middle School
Public 6-8 • Assigned • 4.8mi
9/10
Conner High School
Public 9-12 • Assigned • 4.8mi
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 103° 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)
34
19
44
27
62
40
69
49
72
54
83
65
87
69
83
64
82
58
70
48
54
39
44
30
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.03M – $1.25M
Reach more buyers when you sell with Redfin. Save up to $10,850 in fees.3 minutes to get started.