Skip main navigation
Sold for $264,900 on 09/27/24
  • $264,900

    174 Stillwater Dr, Berea, KY 40403

    3beds
    1,400sqft
    Single Family Residence
    Built in 2024
    9,104.04 Square Feet Lot
    $283,100 Zestimate®
    $189/sqft
    $1,986 Estimated rent

    Owner options

    List your home for rent

    $1,986/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $1,986/mo

    Rent Zestimate®

    Refinance and save

    $1,513/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $1,513/mo

    Est. payment

    What's special

    Welcome to this brand new floor plan new construction home! This home features 3 bedrooms, 2 full baths, a great room, split bedroom design, covered front porch and back patio for low Maintenace, granite counter tops, stainless steel Whirlpool appliances and much more! This home is also energy star rated with spray foam insulation in the walls as well as a duel fuel heat pump for maximum efficiency.

    Zillow last checked: 8 hours ago

    Listing updated: August 28, 2025 at 11:53pm

    Listed by:

    Bradley Warford 859-582-7757,

    Century 21 Pinnacle

    Bought with:

    Bradley Warford, 208360

    Century 21 Pinnacle

    Source: Imagine MLS,MLS#: 24014600MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Level: First
    Bedroom 1
    • Level: First
    Bedroom 2
    • Level: First
    Bathroom 1
    • Description: Full Bath
    • Level: First
    Bathroom 2
    • Description: Full Bath
    • Level: First
    Great room
    • Level: First
    Great room
    • Level: First
    Utility room
    • Level: First
    Heating
    • Heat Pump, Dual Fuel
    Cooling
    • Heat Pump
    Appliances
    • Included: Dishwasher, Microwave, Refrigerator, Range
    • Laundry: Electric Dryer Hookup, Washer Hookup
    Features
    • Walk-In Closet(s), Ceiling Fan(s)
    • Flooring: Laminate
    • Windows: Insulated Windows, Screens
    • Has basement: No
    Interior area
    • Total structure area: 1,400
    • Total interior livable area: 1,400 sqft
    • Finished area above ground: 1,400
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached Garage, Driveway, Garage Door Opener, Garage Faces Front
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Levels: One
    • Patio & porch: Patio, Porch
    • Has view: Yes
    • View description: Mountain(s), Neighborhood
    Lot
    • Size: 9,104 sqft
    Details
    • Parcel number: 007200180010

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Brick Veneer, Vinyl Siding
    • Foundation: Block, Slab
    • Roof: Dimensional Style
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2024

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Electricity Connected, Natural Gas Available, Sewer Connected, Water Connected

    Community & neighborhood

    Location
    • Region: Berea
    • Subdivision: Stoney Creek Comm