Stunning custom built brick house nestled in the expansive waterfront community, The Enclave at Riverview. This home is the only one on the market with a full unfinished basement for storage or to finish for an in-law suite with it's own entrance! Come in to this elegant open floor plan home with a 2 story living room in the center of the house. The front door opens to a grand staircase on one side and en elegant formal dining room on the other side of the foyer. The chef's dream kitchen boasts granite counter tops, a large 5 burner gas cooktop on the island and instant hot water at the sink. The downstairs also has a cozy keeping room off the kitchen and the master suite with an office/ potential nursery across the hall. Bose speakers throughout the downstairs ensure you will always have soothing music to enjoy. Following the stairs up, you will find 3 guest rooms, 2 full baths and a media room for your enjoyment. At the end of the hall is the 3rd bedroom/ large bonus room with a potential media room hiding behind one of the doors. The windowless room off the bonus room is surrounded by a walk through attic space where you can add wiring for your perfect movie space. Still need more space? There is a full unfinished basement that can add an extra 2,500 square feet to the home and can easily be built out for an in law or teen space. The unfinished basement walks out to the beautiful flat fenced in backyard with sprinklers throughout. There is even a greenhouse space in the basement for your plants and a 4th garage into the basement. In the front yard enjoy plum trees and new LED lighting along with sprinklers throughout the yard. On the side of the house there is plenty of parking with a wide driveway and 3 garage doors. Come see this spectacular house today! Agent is related to seller, Seller is Agen't's Aunt.
Single-familyProperty Type
2005Year Built
0.4 acresLot Size
$315Est. Price/Sq.Ft.
3 car garageParking
Bought with Dustin Spillers• RE/MAX Renaissance Realtors
*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
—
Stories
2
Lot width
106 ft.
Lot depth
150 ft.
Lot size
1 Acre
Year renovated
—
Sq. Ft.
3,245
Year built
2004
Style
Single Family Residential
County
Hamilton County
APN
118N A 015
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 16, 2026.
RN-1-6
Residential Neighborhood Zone
The RN-1-6 Residential Neighborhood Zone is intended to accommodate a neighborhood environment predominantly characterized by single-unit homes on lots of 6,000 square feet or greater.
Permitted uses
Include but are not limited to:
Community / recreation center
Religious facility
Housing-Group
Housing-Single unit
Infrastructure
Bed & breakfast
Educational/school
Fire house
Police station
Park & open space
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Basement, Garage Door Opener, Kitchen Level, Attached, Garage