Public Remarks: Step into this Stunning Custom Home with 3237 Sq Ft, Alluded with Masterful attention to Detail! Lavishly painted throughout, and Uniquely Lit Ambiance~6 Fireplaces~Custom Wet Bar and Wine Cellar~Every Room Creates an Impression of Perfection! Enjoy the Custom Built Outside Bar, featuring pond and waterfall!
*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
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
0.46 Acres
Year renovated
—
Sq. Ft.
3,237
Year built
2002
Style
Single Family Residential
County
Hamilton County
APN
5500252042600
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 20, 2026.
A-2
Residential District
The purpose of the A-2 Districts established, is to protect and support the development of single-family housing in conjunction with appropriate accessory uses and public and institutional uses. The standards of these districts are intended to maintain a suitable environment for family living at various densities and in various types on housing, including single-family detached and clustered housing under specified conditions which provides flexibility in the organization of site elements and building location.
Property details
Parking
Parking Information
# of Garage Spaces: 3
Garage/Carport: Oversized, Rear
Parking Features: Driveway
Interior
Accessibility Information
Bedroom Level 1: Yes
Bathroom Level 1: Yes
Bathroom Level 1 Type: Full
Bathroom Information
# of Bathrooms (Full): 3
Bath 1: Full
Bath 1 Level: 1
Bath 2: Full
Bath 2 Level: 1
Bath 3: Full
Bath 3 Level: Lower
Primary Bathroom: Shower, Other
Bedroom Information
# of Bedrooms Total: 3
Primary Bedroom Features: Fireplace
Primary Bedroom: 13x25 Level: 1
Primary Bedroom Area: 325
Primary Bedroom Dimensions: 13 x 25
Primary Bedroom Length: 13
Primary Bedroom Width: 25
Bedroom 2: 13x9 Level: 1
Bedroom 2 Area: 117
Bedroom 2 Dimensions: 13 x 9
Bedroom 2 Length: 13
Bedroom 2 Width: 9
Bedroom 3: 12x13 Level: Lower
Bedroom 3 Area: 156
Bedroom 3 Dimensions: 12 x 13
Bedroom 3 Length: 12
Bedroom 3 Width: 13
Den/Recreation Room Information
Study (Lib/Den): 10x11 Level: 1
Study Features: Bookcases, Fireplace, French Doors, Wood Floor