List price was just lowered by $10K. Tour it before it's gone!
Today:
About this home
Welcome to this charming 3-bedroom, 1 bath brick home in Newport! The main level features a spacious living room, dining room, kitchen, bedroom, bathroom, updated LVP flooring and fresh paint throughout. The second level features two additional bedrooms. The kitchen features updated cabinetry and white appliances. An attached 1 car garage and unfinished basement offer valuable parking and storage. Conveniently located near near shopping, dining, and major highways. Sqft is reported per PVA/public record and has not been independently verified by listing agent or seller. Buyer and buyer's agent to independently verify Sqft, room dimensions, finished living area, and all information deemed important to buyer.
Single-familyProperty Type
1952Year Built
5,881 sq ftLot Size
$152Price/Sq.Ft.
1 car garageParking
Listed by EveryState Inc. Kittle• Real Estate Go To
Cliffview, located between York Street and the Ohio River, is a residential and hillside Newport neighborhood with steep streets and river-view overlooks. The neighborhood’s character concentrates around the York Street corridor near the Purple People Bridge approach, where corner taverns, small eateries, and riverfront foot traffic set the tone. Community pillars include the Purple People Bridge, Newport on the Levee, and the Newport Aquarium. Brick walk-ups and compact single-family homes step down the slope, with stairways and retaining walls shaping daily routes. Riverfront paths and pocket greenspaces frame a walk-and-bike rhythm tied to the bridges. The setting reads urban and tucked-in, with Cincinnati’s skyline as a constant backdrop.
Provided by Walk Score and Local Logic
Market insights
357 Riddle Pl · $189,900
DAYS ON MARKET
41 days
The average home goes pending in 9 days.
SALE-TO-LIST
98.6%
Most homes are selling 1% below list price.
LIST PRICE
$199,900
Median list price in this area is $318,703. (59% higher than this home)
PRICE DROP
2 price drops
27% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Interior features
Walkout unfinished basement
Six total rooms (seven total rooms listed)
Four closets
Bedrooms
Three bedrooms total — one on the first floor and two on the second floor
Bathrooms
One full bathroom on the first floor
Kitchen
Kitchen on the first floor
Dining room on the first floor
Laundry & utility
No first-floor laundry
Heating & cooling
Forced air heating (natural gas)
Central air conditioning
One HVAC unit
Exterior features
Located on a cul-de-sac
Lot approximately 0.13 acre
Home design
Single-family residence, Cape Cod style
Two stories
Built in 1952
Parking
Attached garage and driveway (1 garage space)
Construction
Brick construction
Shingle roof
Poured concrete foundation
Utilities
Electricity connected
HOA & community
No association fee
Other
Directions: From 471 to Alexandria Pike toward Newport, right on New Linden Rd, right on Joyce Ave, left on Riddle Pl; home is toward the end of the street on the left.
Electricity and solar
View estimated energy costs and solar savings for this home
3 Bedroom Cape Cod. Home Being Sold As Is. Preview Addendums must be signed at time of acceptance. Offer is subject to SR management approval, mortgage ins. &/or investor approval.
Year
Property tax
Land + Additions
Assessment*
2025
$504 (−3.6%)
$20,000 + $99,900
$119,900
2024
$522 (+38.0%)
$20,000 + $99,900
$119,900
2023
$379 (−2.0%)
$20,000 + $99,900
$119,900
2022
$386 (−2.4%)
$9,800 + $69,900
$79,700
2021
$396 (−1.7%)
$9,800 + $69,900
$79,700
2020
$402 (+6.7%)
$9,800 + $69,900
$79,700
2019
$377 (+1.3%)
$9,800 + $69,900
$79,700
2018
$372 (−0.4%)
$9,800 + $63,200
$73,000
2017
$374 (+8.4%)
$9,800 + $63,200
$73,000
2016
$345 (+19.0%)
$9,800 + $63,200
$73,000
2015
$290 (+2.1%)
$9,800 + $63,200
$73,000
2014
$284
$9,800 + $49,900
$59,700
Public record
Public record
Zoning
Beds
3
Baths
1
Stories
1.5
Lot width
—
Lot depth
—
Lot size
5,881 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
1,248
Unfinished Sq. Ft.
—
Total Sq. Ft.
1,248
Year built
1952
Style
Single Family Residential
County
Campbell County
APN
999-99-04-440.00
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 19, 2026.
R-1
Residential One Zone
The R-1 Zone is intended to be limited to dwellings and public or semi public uses which are normally associated with residential neighborhoods. The only uses permitted in this district are those, which would not detract from the residential character of the neighborhood. Conversion of existing structures should be discouraged. Densities in this area should generally be below 10 unit per acre. New residential developments under this zone should however, be discouraged at densities above 7 unit per acre. The purpose of this district is to create an attractive, stable and orderly single family residential environment
Permitted uses
Include but are not limited to:
Housing-Single unit
Planned unit development (pud)
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 103° expected this year, 19 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Newport, KY • 41071
Average low and high temperatures (°F)
35
19
45
27
63
40
70
49
73
55
84
66
88
70
84
65
83
59
71
49
55
40
44
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
69/ 100
Moderate sunlight
Sunscore
This home receives average direct sun exposure in Newport. There appears to be some shading by surrounding buildings, terrain, and vegetation.
5.8 hrs
5.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 357 Riddle Pl
$196,340
$6,440 over list price of $190K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $159K to $233K.