3174 Portsmouth Avenue, Cincinnati, OH 45208

Cincinnati
Local realty services provided by:ERA Real Solutions Realty
3174 Portsmouth Avenue,Cincinnati, OH 45208
$1,795,000
Virtual Tour
  • 4 Beds
  • 5 Baths
  • 4,646 sq. ft.
  • Single family
  • Active
Listed by: lisa williams, valerie woodham
Office: sibcy cline, inc.513-321-9922
MLS#:1885312
Source:OH_CINCY

Price summary

  • Price:$1,795,000
  • Price per sq. ft.:$386.35

About this home

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.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2016
  • Listing ID #:1885312
  • Added:1 day(s) ago
  • Updated:July 07, 2026 at 09:40 PM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:5
  • Full bathrooms:3
  • Half bathrooms:2
  • Rooms Total:11
  • Dining Description:Chandelier, Walkout, Wood Floor
  • Kitchen Description:Convection Oven, Counter Bar, Dishwasher, Double Oven, Gas Cooktop, Island, Kitchen Outdoor, Oven/Range, Pantry, Quartz Counters, Refrigerator, Tile Floor, Walkout, Wine Cooler
  • Bedroom Description:Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet, Window Treatment
  • Basement Description:Finished, Full, Vinyl Floor, Walkout, Wall-to-Wall Carpet
  • Living area:4,646 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air, Gas

Structure and exterior

  • Roof:Membrane
  • Year built:2016
  • Building area:4,646 sq. ft.
  • Lot area:0.22 Acres
  • Architectural Style:Contemporary/Modern
  • Construction Materials:Cedar, Stucco
  • Exterior Features:BBQ Grill, Covered Deck/Patio, Kitchen Outdoor, Patio, Sprinklers, Yard Lights
  • Foundation Description:Poured
  • Levels:2 Story

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$1,795,000
  • Price per sq. ft.:$386.35

Features and amenities

  • Appliances:Convection Oven, Dishwasher, Double Oven, Dryer, Gas Cooktop, Oven/Range, Refrigerator, Washer, Wine Cooler
  • Laundry features:Dryer, Washer
  • Amenities:9Ft + Ceiling

Parking

  • Parking description:Driveway, On Street
  • Garage:Yes
  • Garage spaces:2
MLS LogoInformation deemed reliable but not guaranteed. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than ERA Real Solutions Realty are marked with the Broker Reciprocity&#8482 logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. 2026, MLS of Greater Cincinnati, Inc. All rights reserved. OH_CINCY Member Broker: Jeremy Raby

New listings near 3174 Portsmouth Avenue