Perched at the end of a cul-de-sac in a gated community, this refined home offers stunning, unobstructed views of the Cincinnati skyline—visible right from the living room. A soaring two-story entry and updated staircase introduce an elegant, open layout. Hardwood floors and exposed brick archways flow into a gourmet kitchen with LG appliances, granite countertops, pot filler, and wine fridge. A custom wine cellar with WhisperKOOL cooling holds up to 162 bottles. Upstairs, the sun-drenched primary suite features oversized windows and a luxurious bath with a glass steam shower and dual showerheads. Two additional bedrooms and a flexible bonus room offer space for work, play, or rest. Outside, enjoy professionally designed landscaping, tailored lighting, and a pergola—perfect for entertaining. Smart upgrades include Ecobee thermostats, Lutron switches, Eufy fingerprint locks, and Ring security. Minutes to downtown, Devou Park, and CVG.
For sale
$695,000
547 Scenic Dr, Park Hills, KY 41011
3beds
2,268sqft
Est.:
Single Family Residence, Residential
Built in 2004
7,840.8 Square Feet Lot
$-- Zestimate®
$306/sqft
$52/mo HOA
What's special
Gated communityUpdated staircaseWhisperkool coolingWine fridgeProfessionally designed landscapingGourmet kitchenSoaring two-story entry
- 32 days
- on Zillow |
- 2,057 |
- 128 |
Zillow last checked: 7 hours ago
Listing updated: April 12, 2025 at 11:32pm
Listed by:
Varun Varma 513-307-3599,
Coldwell Banker Realty FM
Source: NKMLS,MLS#: 630944

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 306
- Dimensions: 18 x 17
Bedroom 2
- Level: Second
- Area: 120
- Dimensions: 10 x 12
Bedroom 3
- Level: Second
- Area: 130
- Dimensions: 13 x 10
Den
- Level: Second
- Area: 130
- Dimensions: 13 x 10
Dining room
- Level: First
- Area: 150
- Dimensions: 15 x 10
Entry
- Level: Lower
- Area: 128
- Dimensions: 8 x 16
Kitchen
- Level: First
- Area: 156
- Dimensions: 13 x 12
Laundry
- Level: First
- Area: 64
- Dimensions: 8 x 8
Living room
- Level: First
- Area: 340
- Dimensions: 20 x 17
Other
- Level: First
- Area: 15
- Dimensions: 3 x 5
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Cooktop, Gas Oven, Dishwasher, Refrigerator
Features
- Crown Molding, Ceiling Fan(s), High Ceilings
- Doors: Multi Panel Doors
- Windows: Double Hung, Vinyl Frames
- Basement: Full
- Attic: Storage
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 2,268
- Total interior livable area: 2,268 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Garage, Garage Door Opener, Garage Faces Front
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Three Or More
- Stories: 3
- Has view: Yes
- View description: City, Skyline
Lot
- Size: 7,840.8 Square Feet
- Dimensions: .18
Details
- Parcel number: 0413000021.13
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Wood Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- Year built: 2004
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Natural Gas Available, Water Available
Community & HOA
HOA
- Has HOA: Yes
- HOA fee: $625 annually
Location
- Region: Park Hills
Financial & listing details
- Price per square foot: $306/sqft
- Tax assessed value: $450,000
- Annual tax amount: $5,149
- Date on market: 3/25/2025
- Loading
- Loading