Public Remarks: Making its debut on the MLS this sensational home, long treasured by the same family, is truly one of a kind! Beautiful stone & wood construction, 3bed/3 full bath ranch, exceptionalized by skylights, solariums, sauna, jacuzzi tubs, 4-walkouts, +outdoor living on almost 0.5acres! Upon entry you're greeted w/grand floor-to-ceiling windows, hrdwd floors & 2 marble fireplaces. Expansive open kitchen and living room w/custom tile, island w/gas cooktop, counterbar, & new carpets. Stunning solarium w/curved glass windows, automated blinds + wet bar/fridge. Custom-designed curved staircase leading to spacious finished LL w/full bar. This entertainer's dream continues as you step into impeccably landscaped, outdoor oasis. Stone pathways wind past bright flower beds & trees, 2 decks, koi pond, outdoor pool house w/bar&electric, &shed. Centering the spectacular SS pool complete with slide & diving board! Full of exceptional warmth, character,& impressive unique design, this is one for the books!
Single-familyProperty Type
1955Year Built
0.5 acresLot Size
$131Est. Price/Sq.Ft.
2 garage spacesParking
Listed by Erika Bussard• Keller Williams Advisors
•513-319-3317 (agent)
•erika@erikabussardrealtor.com (agent)
•513-766-9200 (broker)
•BROKER@WEAREADVISORS.COM (broker)
Bought with Nick Mitchell• Coldwell Banker Realty, Anders
*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
21,780
Year renovated
1985
Sq. Ft.
3,583
Year built
1955
Style
Single Family Residential
County
Hamilton County
APN
5500101002200
Parking Spaces
4
Basement
Yes
Accessible
Yes
HOA Dues
—
Garage
Yes
Features
Pool
Last updated by owner on Apr 13, 2026.
A
Residential District
The purpose of the A District 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.
Permitted uses
Include but are not limited to:
Equestrian facility
Greenhouse / nursery
Livestock production
Housing-Single unit
Kennel
Veterinary clinic
Property details
Parking
Parking Information
# of Garage Spaces: 2
Garage/Carport: Built in, Oversized, Front, Garage Attached