This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$1,795,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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.
Full Property Details
Full Property Details for 3174 Portsmouth Ave
General
- Sold For: $1,795,000
- Status: Closed
- Type: Single Family
- Source: Cincinnati
- MLS ID: 1885312
- Added to Site: 97 day(s) ago
Interior
- Number of Rooms: 11
- Rooms/Areas: Exercise Room, Wine Cellar
- Interior Features: High Ceiling (9 Feet or More)
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Gas
- Appliances: Convection Oven, Dishwasher, Double Oven, Dryer, Gas Cooktop, Oven/Range, Refrigerator, Washer, Wine Cooler
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 3
- Half Bathrooms: 2
- Primary Bathroom: Shower, Double Shower, Tile Floor, Double Vanity, Window Treatment
- Bathroom 1: Full, Level 2
- Bathroom 2: Full, Level 2
- Bathroom 3: Full, Level 2
- Bathroom 4: Partial, Level 1
Bedrooms
- Total Bedrooms: 4
- Primary Bedroom: Adjoining Bathroom, Walk-In Closet, Wall-to-Wall Carpet, Window Treatment, 19 x 14, Level 2, 266 Sq. Ft.
- Bedroom 2: 13 x 13, Level 2, 169 Sq. Ft.
- Bedroom 3: 16 x 12, Level 2, 192 Sq. Ft.
- Bedroom 4: 16 x 12, Level 2, 192 Sq. Ft.
Other Rooms
- Foyer/Entry: Closet, Open Foyer, Tile Floor, Level 1, 108 Sq. Ft.
- Living Room: Walk-Out, Fireplace, Wood Floor, 23 x 15, Level 1, 345 Sq. Ft.
- Kitchen: Pantry, Quartz Counters, Counter Bar, Tile Floor, Walk-Out, Island, 23 x 18, 23x18, 414 Sq. Ft.
- Dining Room: Chandelier, Walk-Out, Wood Floor, 15 x 13, Level 1, 195 Sq. Ft.
- Rec Room: 37 x 22, Lower
- Laundry: 11 x 5, Level 2, 55 Sq. Ft.
Additional Information
- Other Features: Ceiling Fan, Recessed Lights
Exterior
- Exterior Features: Barbecue Grill, Covered Deck/Patio, Kitchen – Outdoor, Patio, Sprinklers, Yard Lights
Parking
- Garage: Yes
- Garage Spaces: 2
- Parking: On-Street Parking, Driveway
- Garage Description: Built-In, Oversized, Front
Location
- Area: Hyde Park
- County: Hamilton
- Township: Cincinnati City
- Suburb: Hyde Park
- Driving Directions: Paxton to Portsmouth
School Information
- School District: Cincinnati City SD
- High School District: Cincinnati City SD
Community
- Home Owners Assn.: False
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Forced Air, Gas
- Heating Fuel: Natural
- Water Heater: Gas
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Architectural Style: Two Story Contemporary/Modern
- Exterior Const.: Cedar, Stucco
- Basement: Yes
- Basement Desc.: Full, Finished, Vinyl Floor, Walk-Out, Wall-to-Wall Carpet
- Foundation: Poured
- Roof: Membrane
- Windows: Picture, Casement, Double Pane, Vinyl/Alum Clad
- Stories/Levels: Two
- Square Feet: 4,646
- Lower: 1,436 Sq. Ft.
- Year Built: 2016
Lot Features
- Lot Size (Acres): 0.217
- Lot Dimensions: 60 x 157
- Frontage: City Street
- Zoning: Residential
- Lot Description: Less than .5 Acre
- Fencing (Description): Invisible, Privacy, Wood
Financial Considerations
- Sub Lease Exp.: 1800-01-01T00:00:00-05:00
- Semi-Annual Taxes: $10874
Disclosures and Reports
- APN: 0390A06018200
- Property ID: 0390A06018200
Get Pre-Approved Today
Schools
Schools serving 3174 Portsmouth Ave
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
Kilgour Elementary School 1339 Herschel Avenue, Cincinnati, OH 45208 | K-6 | 0.7 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 1.4 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 1.8 mi |
Clark Montessori High School 3030 Erie Avenue, Cincinnati, OH 45208 | 7-12 | 0.3 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 5.2 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 5.7 mi |
Riverview East Academy 3555 Kellogg Avenue, Cincinnati, OH 45226 | 9-12 | 2.2 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 2.9 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 3.8 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 3174 Portsmouth Ave
Date
Details
Price
Change
Source
8/28/2026
Sold
$1,795,000
—
MLS
7/07/2026
Listed
$1,795,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
3174 Portsmouth Avenue, Cincinnati, OH 45208 (MLS# 1885312) is a Single Family property that was sold at $1,795,000 on August 28, 2026. This property was sold by Julia Packer-Wesselkamper from our Central Regional Office.Want to learn more about 3174 Portsmouth Avenue? Do you have questions about finding other Single Family real estate for sale in Hyde Park? You can browse all Hyde Park real estate or contact a Coldwell Banker agent to request more information.



