Loading...

Cincinnati, OH, 45248 • 45248 • Hamilton County
$165/sqft
Down payment assistance available
5Beds
4Baths
5,080Sqft
0.5 acLot
2001Built
Scenic Views
Golf Course · Other
Traditional Style
Built 2001 · 25 years of history
4 Fireplaces
Marble · Stone · Gas · Living Room
Private Pool
Gunite · In Ground
2-Car Garage
Garage - Attached
3d on Market
Listed Apr 6, 2026
Demand and pricing signals for this listing
120 views
People checking out this listing
5 saves
Buyers have saved this home
3 days on market
Just listed — act fast
$165/sqft
Price per square foot
Single Family · Built 2001
Truly magnificent 5 bd, 4 ba home featuring granite, limestone, imported tiles, detailed woodwork, pillars, arches, niches, built-ins, sound system, custom cabinetry, master suite with barrel vault ceilings, 3 fireplaces and much more. This is a private retreat on a golf course, just under an acre of land and features a covered trex deck off the master suite. Finished LL with kitchen and bar. Extensive landscaping surrounds the mineral springs, salt water, in-ground gunite pool. Sprinklers, security system, large closets, fenced yard and high ceilings add to the retreat that awaits your family!
Based on current rates
Est. 6.24% rate · 30yr fixed · $671,200 loan
Full calculator →Key facts and listing details
11 categories of property features
16 rooms detailed
Master Bedroom
SecondBedroom2
SecondBedroom3
SecondBedroom4
SecondBedroom5
SecondMaster Bathroom
Market data and value estimates
3 schools rated nearby
Cincinnati, OH, 45248
21 events
24 years of records
Local context around this listing
Cincinnati, OH • Hamilton County
Nearby cities
Nearby zip codes
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Zillow, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Zillow, Inc. does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
No obligation · Same-day response