Skip main navigation
Pending
    • $1,795,000

    3174 Portsmouth Ave, Cincinnati, OH 45208

    4beds
    4,646sqft
    : 
    $12,511/mo
    Get pre-qualified
    Single Family Residence
    Built in 2016
    9,452 Square Feet Lot
    $-- Zestimate®
    $386/sqft
    $-- HOA

    What's special

    Striking architectureOpen-concept main levelBuilt-in grillCustom climate-controlled wine cellarStunning two-story foyerDedicated fitness areaPremium finishes
    Sophisticated Asian-inspired contemporary by Justin Doyle, offering nearly 4,700 SF on one of Hyde Park's most coveted streets. Striking architecture & premium finishes incl knotless cedar siding, red rock accents & Brazilian pecan hardwood floors. Enter the home via a stunning two-story foyer w 10' glass pivot door. The open-concept main level was designed for effortless entertaining w expansive living & dining spaces, dedicated bar area, & walls of sliding glass opening to front & rear outdoor living spaces. Enjoy a covered front patio overlooking the professionally landscaped Asian rock garden & a rear terrace with full outdoor kitchen incl built-in grill, refrigerator, & wet bar. The primary suite has an expansive bedroom, walk in closet & spa-like bathroom. The walk-out lower level provides an exceptional extension of the home's entertaining spaces, featuring a custom climate-controlled wine cellar, media room w 113'' projection screen & projector, & a dedicated fitness area.
    32 days
    |
    1,895
    |
    86
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Lisa K. Williams 513-807-5430,

    Sibcy Cline, Inc. 513-321-9922,

    Valerie Woodham 513-307-7603,

    Sibcy Cline, Inc.

    Source: Cincy MLS,MLS#: 1885312MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 3
      • 1/2 bathrooms: 2
      Primary bedroom
      • Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet, Window Treatment
      • Level: Second
      • Area: 266
      • Dimensions: 19 x 14
      Bedroom 2
      • Level: Second
      • Area: 169
      • Dimensions: 13 x 13
      Bedroom 3
      • Level: Second
      • Area: 192
      • Dimensions: 16 x 12
      Bedroom 4
      • Level: Second
      • Area: 192
      • Dimensions: 16 x 12
      Bedroom 5
      • Area: 0
      • Dimensions: 0 x 0
      Primary bathroom
      • Features: Shower, Double Shower, Tile Floor, Double Vanity, Window Treatment
      Bathroom 1
      • Features: Full
      • Level: Second
      Bathroom 2
      • Features: Full
      • Level: Second
      Bathroom 3
      • Features: Full
      • Level: Second
      Bathroom 4
      • Features: Partial
      • Level: First
      Dining room
      • Features: Chandelier, Walkout, Wood Floor
      • Level: First
      • Area: 195
      • Dimensions: 15 x 13
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Features: Pantry, Quartz Counters, Counter Bar, Tile Floor, Walkout, Kitchen Island
      • Area: 414
      • Dimensions: 23 x 18
      Living room
      • Features: Walkout, Fireplace, Wood Floor
      • Area: 345
      • Dimensions: 23 x 15
      Office
      • Area: 0
      • Dimensions: 0 x 0
      Heating
      • Forced Air, Gas
      Cooling
      • Central Air
      Appliances
      • Included: Convection Oven, Dishwasher, Double Oven, Dryer, Gas Cooktop, Oven/Range, Refrigerator, Washer, Wine Cooler, Gas Water Heater
      Features
      • High Ceilings, Ceiling Fan(s), Recessed Lighting
      • Windows: Picture, Casement, Double Pane Windows
      • Basement: Full,Finished,Vinyl Floor,Walk-Out Access,WW Carpet
      • Number of fireplaces: 1
      • Fireplace features: Gas, Living Room
      Interior area
      • Total structure area: 4,646
      • Total interior livable area: 4,646 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: On Street, Driveway, Garage Door Opener
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Covered Deck/Patio, Patio
      • Exterior features: Barbecue, Outdoor Kitchen, Yard Lights
      • Fencing: Invisible,Privacy,Wood
      Lot
      • Size: 9,452 Square Feet
      • Dimensions: 60 x 157
      • Features: Sprinklers, Less than .5 Acre
      Details
      • Parcel number: 0390A06018200
      • Zoning description: Residential
      • Other equipment: Sump Pump w/Backup

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary/Modern
      • Property subtype: Single Family Residence
      Materials
      • Cedar, Stucco
      • Foundation: Concrete Perimeter
      • Roof: Membrane
      Condition
      • New construction: No
      • Year built: 2016

      Utilities & green energy

      • Gas: Natural
      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Cincinnati

      Financial & listing details

      • Price per square foot: $386/sqft
      • Annual tax amount: $21,748
      • Date on market: 7/7/2026
      • Listing terms: No Special Financing

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/20/2026Pending sale$1,795,000$386/sqft
        Source: Cincy MLS #1885312 Report a problem
        7/7/2026Listed for sale$1,795,000+286.1%$386/sqft
        Source: Cincy MLS #1885312 Report a problem
        2/29/2008Listing removed$464,900$100/sqft
        Source: Real Living #1107606 Report a problem
        2/27/2008Price change$464,900-2.1%$100/sqft
        Source: Real Living #1107606 Report a problem
        2/19/2008Listed for sale$474,900+7.8%$102/sqft
        Source: Real Living #1107606 Report a problem
        10/14/2005Sold$440,500+111.5%$95/sqft
        Source: Cincy MLS #957059 Report a problem
        4/4/1996Sold$208,300$45/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$21,079 -2.2%$449,785
        2023$21,555 +4.2%$449,785 +12.3%
        2022$20,677 +0.7%$400,446
        2021$20,538 $400,446
        2020$20,538 -19.5%$400,446 +16%
        2019$25,501 +0.2%$345,212
        2018$25,441 +5%$345,212
        2017$24,227 +125%$345,212 +138.6%
        2016$10,766 +15.5%$144,697
        2015$9,323 -0.7%$144,697
        2014$9,386 +7.1%$144,697 +9%
        2013$8,765 +1.8%$132,748
        2012$8,611 +3.1%$132,748
        2011$8,350 -14.5%$132,748 -19.5%
        2010$9,770 +3.8%$164,966
        2009$9,415 +1.9%$164,966
        2008$9,242 +22.4%$164,966 +7%
        2007$7,549 +1.1%$154,175
        2006$7,466 -0.5%$154,175
        2005$7,500 +14.7%$154,175 +25%
        2003$6,540 +6.7%$123,375
        2002$6,130 +19.5%$123,375 +27.2%
        2001$5,132 +3.4%$96,985
        2000$4,963 $96,985
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Hyde Park

        Getting around

        73 / 100
        Very Walkable
        41 / 100
        Some Transit
        47 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Cincinnati Topics

              Search
              Updates
              Favorites
              Plan
              Inbox