These panoramic river and city views are the best in town! 2567 sqft of quality & custom amenities throughout. Almost completely renovated in 2022! Enjoy the views from the stunning kitchen, which includes high end appliances, copper hood with brick veneer wall, huge island, new hard wood floors & walk-in pantry. The primary suite, which has also been completely renovated, includes a beautiful primary bath, walk-in closet, it's own personal laundry, custom remote blinds, sitting area and private laundry room. This home is located at the end of a private dead-end street. Enjoy your own private elevator, 2 covered porches with brand new custom railings, and new HVAC system. Come and see for yourself these breathtaking views up and down the river, NKY, and straight into downtown! Very low HOA fee, only 4 units in total.
Sold for $620,000 on 10/30/25
$620,000
542 Davenport Ave APT D, Cincinnati, OH 45204
2beds
2,576sqft
Condominium
Built in 2002
-- sqft lot
$620,100 Zestimate®
$241/sqft
$2,838 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 31, 2025 at 10:28am
Listed by:
Stacie A Schoeplein 513-237-9623,
Sibcy Cline, Inc. 513-321-9922
Bought with:
Lisa McCarthy, 2005016661
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1848351
Originating MLS: Cincinnati Area Multiple Listing Service

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Window Treatment, Sitting Room, Wood Floor
- Level: Third
- Area: 378
- Dimensions: 27 x 14
Bedroom 2
- Level: Third
- Area: 182
- Dimensions: 14 x 13
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Built-In Shower Seat, Tile Floor, Double Vanity
Bathroom 1
- Features: Full
- Level: Third
Bathroom 2
- Features: Full
- Level: Third
Bathroom 3
- Features: Partial
- Level: Second
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: Chandelier, Walkout, Wood Floor
- Level: Second
- Area: 208
- Dimensions: 16 x 13
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Butler's Pantry, Pantry, Quartz Counters, Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor
- Area: 304
- Dimensions: 16 x 19
Living room
- Features: Walkout, Fireplace
- Area: 304
- Dimensions: 16 x 19
Office
- Features: Wet/Dry Bar, French Doors, Wood Floor
- Level: Second
- Area: 165
- Dimensions: 15 x 11
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator, Gas Water Heater
Features
- Elevator, Ceiling Fan(s), Recessed Lighting
- Doors: French Doors, Multi Panel Doors
- Windows: Double Hung, Vinyl
- Basement: None
- Number of fireplaces: 1
- Fireplace features: Electric, Living Room
Interior area
- Total structure area: 2,576
- Total interior livable area: 2,576 sqft
Property
Parking
- Total spaces: 2
- Parking features: On Street
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Stories: 3
- Patio & porch: Covered Deck/Patio, Deck
- Exterior features: Balcony, Other
- Has view: Yes
- View description: City, River
- Has water view: Yes
- Water view: River
- Waterfront features: River
Lot
- Features: Cul-De-Sac, Less than .5 Acre
Details
- Parcel number: 1510001017300
- Zoning description: Residential
Construction
Type & style
- Home type: Condo
- Architectural style: Transitional
- Property subtype: Condominium
Materials
- Brick, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2002
Utilities & green energy
- Electric: 220 Volts
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Smoke Alarm
Location
- Region: Cincinnati
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 monthly
- Services included: Insurance, Water, Community Landscaping
Other
Other facts
- Listing terms: No Special Financing,Other
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$620,100