Sign in
Home
    • Browse
    • Browse A-Z
    • Coming Soon
    • New Listings
    • Price Changes
    • Open Houses
    • New Construction
    • Premier Builders
    • National Search
    • View All Properties
    • Premier Collection
    • Luxury Homes
    • Find a Builder
    • Explore Developments
    • Get Help
    • Get Pre-Approved
    • Buyer’s Guide
    • Find an Agent
    • Find a Loan Officer
    • Sell your Home
    • Seller’s Guide
    • Find an Agent
    • Home Services
    • School Links
    • Community Guide
    • Buyer’s Guide
    • Seller’s Guide
    • Regional Guide
    • What's Your Home Worth?
    • Utility Connection
    • Blog
    • Overview
    • Mortgage
    • Insurance
    • Title
    • Relocation
    • U.S. Military on the Move
    • Home Services
    • Home Warranty
    • Earnest Money Payment
    • Offices
    • Find an Agent
    • Find a Loan Officer
    • Becoming an Agent
Sign in

3174 Portsmouth Avenue Hyde Park, OH 45208

4
Bed
3/2
Bath
4,646
Sq. Ft
0.22
Acres
$1,795,000
MLS# 1885312
4 BR
3/2 BA
4,646 Sq. Ft
0.22 AC
1/67
  • New Listing
  • Open House
2/67
3/67
Photos
Map
Photos
Map
Virtual Tour

Received 07/07/2026

  • Open: Sun, Jul 12, 3pm - 4:30pm

More About 3174 Portsmouth Avenue

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.

Seller open to concessions based on the terms of the offer!

Directions to this Listing

: Paxton to Portsmouth

Information Refreshed: 7/10/2026 9:04 AM

Headshot of Lisa Williams

Lisa Williams

REALTOR®

513-807-5430
CallText
Headshot of Valerie Woodham

Valerie Woodham

Sales Vice President

513-307-7603
CallText
Contact us to learn more or 

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Property Details

  • MLS#:

    1885312
  • Type:

    Single Family
  • Sq. Ft:

    4,646
  • County:

    Hamilton
  • Age:

    10
  • Appliances:

    Oven/Range, Dishwasher, Refrigerator, Washer, Dryer, Convection Oven, Double Oven, Gas Cooktop, Wine Cooler
  • Architecture:

    Contemporary/Modern
  • Basement:

    Finished, Walkout, WW Carpet, Vinyl Floor
  • Basement Type:

    Full
  • Construction:

    Cedar, Stucco
  • Cooling:

    Central Air
  • Fence:

    Wood, Invisible, Privacy
  • Fireplace:

    Gas
  • Flex Room:

    Exercise Room, Wine Cellar
  • Garage:

    Built in, Front, Oversized
  • Garage Spaces:

    2
  • Gas:

    Natural
  • Heating:

    Gas, Forced Air
  • Inside Features:

    9Ft + Ceiling
  • Kitchen:

    Pantry, Tile Floor, Walkout, Island, Counter Bar, Quartz Counters
  • Lot Description:

    60X157
  • Mechanical Systems:

    Garage Door Opener, Sump Pump w/Backup
  • Misc:

    Ceiling Fan, Recessed Lights
  • Parking:

    On Street, Driveway
  • Primary Bedroom:

    Wall-to-Wall Carpet, Bath Adjoins, Walk-in Closet, Window Treatment
  • S/A Taxes:

    10874
  • School District:

    Cincinnati Public Schools
  • Sewer:

    Public Sewer
  • Water:

    Public

Rooms

  • Bath 1:

    F (Level: 2)
  • Bath 2:

    F (Level: 2)
  • Bath 3:

    F (Level: 2)
  • Bath 4:

    P (Level: 1)
  • Bedroom 1:

    19x14 (Level: 2)
  • Bedroom 2:

    13x13 (Level: 2)
  • Bedroom 3:

    16x12 (Level: 2)
  • Bedroom 4:

    16x12 (Level: 2)
  • Dining Room:

    15x13 (Level: 1)
  • Entry:

    12x9 (Level: 1)
  • Kitchen:

    23x18 (Level: 1)
  • Laundry Room:

    11x5 (Level: 2)
  • Living Room:

    23x15 (Level: 1)
  • Recreation Room:

    37x22 (Level: Lower)
This listing courtesy of Lisa Williams (513) 807-5430, Valerie Woodham (513) 307-7603, Hyde Park Office (513) 321-9922

Explore Hyde Park - Mt. Lookout & Surrounding Area

Hyde Park

Hyde Park - Mt. Lookout

Hyde Park and Mt. Lookout are adjacent urban communities where people of all ages enjoy the convenience of being centrally located and only minutes from downtown. Throughout this community, older homes are lovingly care for in an urban setting with a su...

View Community
Oakley_OH

Oakley

Oakley is seen as a more-affordable neighborhood with ever increasing property values as compared to nearby Hyde Park and Mt. Lookout. The many oak-lined streets and shopping within walking distance offer much to the people who live in Oakley. Convenien...

View Community
Pleasant Ridge OH

Pleasant Ridge

Today’s Pleasant Ridge, however, is a community of block parties, neighborhood clubs, and citizens involved in various activities. Home buyers can find an assortment of Tudors to choose from. Many of the wide, winding streets have spacious old frame hou...

View Community
Columbia Tusculum

Columbia-Tusculum

The restoration in Columbia-Tusculum is preserving the distinctive historical character of the area. There's an abundance of old frame homes with high ceilings, wood floors, and many decorative elements like gingerbread and steam boat gothic. Stately Vi...

View Community
OH•45208•Hamilton County•Hyde Park•3174 Portsmouth Avenue
Headshot of Lisa Williams

Lisa Williams

REALTOR®

513-807-5430
CallText
Headshot of Valerie Woodham

Valerie Woodham

Sales Vice President

513-307-7603
CallText
Contact us to learn more or 

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Monthly Cost

Mortgage Calculator

Enter your details for an estimated monthly payment. See how much house you can afford

%
LEGAL DISCLAIMERS▼

Your estimated payment

$9,067
per month
PRINCIPAL & INTEREST
$9,067
CHAT WITH A LOAN OFFICER

Properties Similar to 3174 Portsmouth Avenue

    $1,795,000Sale Pending3 Cloister CourtHyde Park, OH 45208
    • 4 br
    • 5/1 ba
    • 0.46 ac

    Sell with Sibcy Cline

    Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.

    Must reads

    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 Sibcy Cline, 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. Copyright© 2026 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.