It's in the top 10% of views. Tour it before it's gone!
Today:
About this home
This luxury home offers the convenience of city living, PLUS an amazing retreat with over 3,100 square feet of space! You will enjoy 3 levels of outdoor living, overlooking the water feature with downtown Cincinnati views. High-end design throughout the home with an elevator for a comfortable lifestyle. This custom modern home was built in 2023 and feels brand NEW. The floor plan is ideal for entertaining with large open rooms, 10 foot kitchen island, walk-in pantry, and an impressive floor to ceiling stone fireplace! With the built-in sound system, wet bar, and wine cellar every gathering will feel extra special! The Great Room opens up to a covered screened porch and grilling deck. First floor Primary Suite feels like the most luxurious hotel! Coffee/Wine Bar and covered balcony for cozy mornings or sunsets. The showstopping Bathroom is your tranquil wellness area complete with walk-in closet, speaker system, soaking tub, multi-head glass shower, and double vanity. Flexible space in the lower level for Home Theater Room, Fitness Room, Home Office, and private Guest Suite. Striking exterior includes custom stone, premium wood accents, epoxy garage floor, glass garage door. Amazing single family home (yard can also be fenced) in The Reserves of Bellevue community with walking trail and dog park. Just a few minutes to downtown, Fort Thomas, and the riverfront!
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
3,572 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Campbell County
APN
999-99-11-878.45
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 22, 2026.
Jul 24, 2023 • Final
New hvac for 1 or 2 family residential
HVAC
Jun 6, 2023 • Final
Construction of new 1 or 2 family residential
New construction
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Historical weather
Bellevue, KY • 41073
Average low and high temperatures (°F)
35
19
44
27
62
40
70
49
72
54
84
65
88
71
85
65
82
60
70
48
55
40
44
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
71/ 100
Good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
8.3 hrs
3.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 864 Belle Ridge Loop
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $320,000 and $875,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $320K to $875K.