Skip main navigation
For sale
  • $615,000

    112 Warwick Ct, Crestview Hills, KY 41017

    3beds
    1,841sqft
    Single Family Residence, Residential
    Built in 1959
    435 Square Feet Lot
    $-- Zestimate®
    $334/sqft
    $-- HOA

    What's special

    Relaxing by the lakeBeautifully finished lower levelPeaceful waterfront viewsFlat backyardWet bar
    Welcome to lakefront living in the heart of Crestview Hills! This beautiful 3-bedroom, 2-full-bath home offers the perfect combination of peaceful waterfront views and an unbeatable location, walking distance from shopping, dining, and entertainment. Bring your creativity to the first floor and make it yours! The versatile floor plan includes a dedicated office/workout room, providing the perfect space to work from home, exercise, or create a bonus room to fit your lifestyle. The beautifully finished lower level is made for entertaining, featuring a wet bar and a walkout that leads directly to the flat backyard. Whether you're enjoying your morning coffee overlooking the water, entertaining friends and family, or relaxing by the lake at the end of the day, this property offers a rare opportunity to enjoy waterfront living while still being close to everything Crestview Hills has to offer. A truly special home in an incredible location!
    22 days
    3,389
    69

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Chelsie Vogelpohl 859-609-2751,

    Keller Williams Realty Service

    Source: NKMLS,MLS#: 646570MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Primary bedroom
      • Features: Ceiling Fan(s), Hardwood Floors
      • Level: First
      • Area: 204
      • Dimensions: 17 x 12
      Bedroom 2
      • Features: Hardwood Floors
      • Level: First
      • Area: 144100
      • Dimensions: 1,310 x 110
      Bedroom 3
      • Features: Hardwood Floors
      • Level: First
      • Area: 12314
      • Dimensions: 94 x 131
      Bathroom 2
      • Features: Full Finished Bath
      • Level: Second
      • Area: 5751
      • Dimensions: 71 x 81
      Breakfast room
      • Features: Tile Flooring
      • Level: First
      • Area: 13755
      • Dimensions: 105 x 131
      Exercise room
      • Features: Tile Flooring
      • Level: Second
      • Area: 11502
      • Dimensions: 142 x 81
      Family room
      • Features: Walk-Out Access, Wet Bar, Luxury Vinyl Flooring
      • Level: Second
      • Area: 73010
      • Dimensions: 298 x 245
      Kitchen
      • Features: Pantry
      • Level: First
      • Area: 20829
      • Dimensions: 159 x 131
      Living room
      • Features: Fireplace(s), Hardwood Floors
      • Level: First
      • Area: 33132
      • Dimensions: 251 x 132
      Heating
      • Has Heating (Unspecified Type)
      Cooling
      • Attic Fan, Central Air
      Appliances
      • Included: Electric Cooktop, Electric Oven, Microwave, Refrigerator
      Features
      • Wet Bar, Storage, Sound System, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Chandelier, Built-in Features, Ceiling Fan(s), Natural Woodwork, Recessed Lighting
      • Doors: Pocket Door(s)
      • Windows: Wood Frames
      • Has basement: Yes
      • Number of fireplaces: 2
      • Fireplace features: Gas
      Interior area
      • Total structure area: 1,841
      • Total interior livable area: 1,841 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Driveway, Garage, Garage Faces Side, Off Street
      • Attached garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Patio
      • Exterior features: Fire Pit
      • Has view: Yes
      • View description: Lake, Pond
      • Has water view: Yes
      • Water view: Lake,Pond
      • Waterfront features: Waterfront
      Lot
      • Size: 435 Square Feet
      • Features: Cleared, Sloped, Sloped Down
      Details
      • Parcel number: 0153003006.00
      • Zoning description: Residential

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick
      • Foundation: Poured Concrete
      • Roof: Shingle
      Condition
      • New construction: No
      • Year built: 1959

      Utilities & green energy

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

      Community & HOA

      Community
      • Security: Smoke Detector(s)
      HOA
      • Has HOA: No
      Location
      • Region: Crestview Hills

      Financial & listing details

      • Price per square foot: $334/sqft
      • Tax assessed value: $325,700
      • Annual tax amount: $3,228
      • Date on market: 9/10/2026
      • Cumulative days on market: 22 days

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        9/11/2026Listed for sale$615,000+98.4%$334/sqft
        Source: NKMLS #646570 Report a problem
        10/12/2009Sold$310,000+14.2%$168/sqft
        Source: Public Record Report a problem
        1/3/2008Sold$271,560$148/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$3,228 -3.3%$325,700
        2024$3,338 -3.2%$325,700 +0.6%
        2023$3,450 -2.4%$323,600
        2022$3,534 -2.1%$323,600
        2021$3,610 -3.1%$323,600
        2020$3,724 $323,600 +4.4%
        2019$3,724 +5.7%$310,000
        2018$3,522 $310,000
        2017$3,522 +6.2%$310,000
        2015$3,316 +1.7%$310,000
        2014$3,260 $310,000
        2013$3,260 $310,000
        2012-- $310,000
        2011-- $310,000
        2010-- $310,000 +14.2%
        2009-- $271,500
        2008-- $271,500 +55.1%
        2007-- $175,000
        2006-- $175,000
        2005-- $175,000
        2004-- $175,000 +9.4%
        2003-- $160,000
        2002-- $160,000
        2001-- $160,000
        2000-- $160,000
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 41017

        Getting around

        42 / 100
        Car-Dependent
        37 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: JA Caywood Elementary
        • Middle: Turkey Foot Middle School
        • High: Dixie Heights High

        Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts