Visit our professional directory to find an agent in your area that can help with your home search.

Contact Agent

variant

zpid

mlsCode

onlyPreapprovalContact

showNameField

showPhoneField

suppressAccountCreation

submitId

showPhoneMandatoryField

leaderboardZuids

isSelectListingAgent

zuid

ccListingAgent

palZuids

pixelId

message

name

phone

email

REMARKABLE RIVER FRONT HOME! 2 Stunning Primary Suites w/Beautifully Customized Porcelain walk in showers! 3 secondary bedrooms,comfortable study/lounging rm walk out to a covered deck with a fabulous Water View! Joe Zang's infamous attention to detail brings this finish level to unmatched heights! Selections made are Rich and Tasteful offering a clean yet warm elegance to this home. The Views are nothing short of spectacular w/o any effort from all three levels! Easy Access to all three levels by elevator or stairs! This Home is Truly a Gem in a Riverview Community w/ commercial boat ramp,seasonal dock, walking trail and community fire pit along the River bank, neighborhood Park w/play yard and ball fields, Easy access to Cincinnati's renown bike trails. Completion by 12/31/25. There is still time to make personal selections regarding the second/prep kitchen/content and finishes and closet personalizations . This home is a  Showstopper!Unlimited Platinum 15 yr abatement.

California

By pressing Contact agent, you agree that Zillow Group and its affiliates, and real estate professionals may call/text you about your inquiry, which may involve use of automated means and prerecorded/artificial voices. You don’t need to consent as a condition of buying any property, goods or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you’re looking for in a home.

Contact agent

apple-mobile-web-app-capable

apple-mobile-web-app-status-bar-style

format-detection

google-signin-clientid

google-signin-cookiepolicy

google-signin-scope

691f1bfccade71b5-c065751219a379dd-g64cedb67f5ea020a-a

google-translate-customization

msapplication-config

msapplication-TileColor

https://www.zillowstatic.com/static/images/logos/zillow-logo-win8-tile.png

msapplication-TileImage

referrer

width=device-width, height=device-height, user-scalable=yes, initial-scale=1.0, minimum-scale=1.0

viewport


        if (typeof Object.assign === 'function') {
            window.appInfo = Object.assign(
                typeof window.appInfo === 'object' ? window.appInfo : {},
                {"@zillow/page-frame-content":"cd33d518"}
            );
        }
    


        window.CLIENT_PROFILER_CONFIG = window.CLIENT_PROFILER_CONFIG || {
            staticDimensions: {
                ABDecisionToken: "2BqAWv_1756453035",
            },
        };
    


        var customDimension1 = 'dfd37a3146ac449cb3f767477c2db7d5';
        ua('set', 'dimension1', customDimension1);
        ga('set', 'dimension1', customDimension1);
        ua('identify', null);
        ua('set', {"dimension179":"AB_DASHBOARD_AA_TEST.ON","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.CONTROL","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension58":"FSBO_MEDIASOLUTIONS_RTM.CONTROL","dimension185":"FSHDP_OPTIMIZATION.ON","dimension65":"FoyerPhase2.TREATMENT","dimension39":"HDP_SHARE_TO_ZIM.CONTROL","dimension164":"HDP_SHOP_WITH_BUDGET_WEB.CONTROL","dimension50":"HDP_TOURING_AGREEMENT.CONTROL","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.CONTROL","dimension187":"HOPS_MWEB_UPSELL_ORDER.CONTROL","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.ON","dimension177":"MST_SRP_WEB_2NDAD13AND17.SLOT13","dimension178":"NBA_MHDP.CONTROL","dimension171":"NC_HDP_HOLLYWOOD_BUILDERWEBSITE.CONTROL","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension174":"RC_CONTACT_STATUS.TEST","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.BUTTON","dimension57":"RDP_SIGNATURE_MEDIA_V2.CONTROL","dimension173":"SAT_DYNAMIC_RANKING.CONTROL","dimension59":"SXP_DESKTOP_MO_MAP_PILLS.CONTROL","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension188":"ZEXP_DECISION_TOKEN_HOLD.2BqAWv_1756453035","dimension176":"ZE_FRSRP_WEB_3RDAD.ON","dimension169":"ZE_HDP_WEB_VIDEO.CONTROL"});
        ga('set', {"dimension179":"AB_DASHBOARD_AA_TEST.ON","dimension47":"CIAM_AUTH_OTP_CONTACT_AGENT_FORM.CONTROL","dimension43":"CIAM_AUTH_OTP_TOUR_FORM.CONTROL","dimension58":"FSBO_MEDIASOLUTIONS_RTM.CONTROL","dimension185":"FSHDP_OPTIMIZATION.ON","dimension65":"FoyerPhase2.TREATMENT","dimension39":"HDP_SHARE_TO_ZIM.CONTROL","dimension164":"HDP_SHOP_WITH_BUDGET_WEB.CONTROL","dimension50":"HDP_TOURING_AGREEMENT.CONTROL","dimension184":"HDP_WEB_OFFER_INSIGHTS_V2.CONTROL","dimension187":"HOPS_MWEB_UPSELL_ORDER.CONTROL","dimension56":"IOS_SATELLITE_RACHEL_VIEWATTACHMENTS.ON","dimension177":"MST_SRP_WEB_2NDAD13AND17.SLOT13","dimension178":"NBA_MHDP.CONTROL","dimension171":"NC_HDP_HOLLYWOOD_BUILDERWEBSITE.CONTROL","dimension180":"ONSITE_MESSAGE_VALVE.OMP_ON","dimension174":"RC_CONTACT_STATUS.TEST","dimension41":"RC_RP_RENTALS_BUYABILITY_UPSELL.BUTTON","dimension57":"RDP_SIGNATURE_MEDIA_V2.CONTROL","dimension173":"SAT_DYNAMIC_RANKING.CONTROL","dimension59":"SXP_DESKTOP_MO_MAP_PILLS.CONTROL","dimension37":"SXP_MWEB_MO_MAP_PILLS.CONTROL","dimension188":"ZEXP_DECISION_TOKEN_HOLD.2BqAWv_1756453035","dimension176":"ZE_FRSRP_WEB_3RDAD.ON","dimension169":"ZE_HDP_WEB_VIDEO.CONTROL"});
    

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
        (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
        m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
        })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

window.__USER_SESSION_INITIAL_STATE__ = { user: { loggedIn: false } };

5751 Sanctuary Pl, Cincinnati, OH 45230

What's special