- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Hot
Street View
$610,000
Monthly Est:$3,036
3 Beds
2 Baths2 full baths
1,841sqft
112 Warwick Ct, Crestview Hills, KY 41017
$610,000
$3,036/moEst:
Get Pre-Approved
Single Family Residence
Built in 1959
$-- HOA
0.9 acre lot
$331/sq.ft
Description
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!
***Seller if Offering up to $5,000 credit to be used for updates/ buy down with acceptable offer***
- Houzeo last checked: 1 hour ago
- Listing updated: October 28, 2026 at 2:56 pm
- Listing Provided by: Chelsie Vogelpohl (859) 609-2751 DRE #261268 | Keller Williams Realty Service (859) 240-0727
- Source: Northern Kentucky Multiple Listing Service | MLS#: 646570
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1959
HOA Fees
-
Finished Area
1,841 sqft
Lot Size
0.9 acre lot
Basement Area
- sqft
MLS Name
Northern Kentucky Multiple Listing Service
MLS Number
646570
MLS Status
Active
Days on Market
49
Cumulative Days on Market
48
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 2
Interior
Cooling
Attic Fan, Central Air
Interior Features
Pocket Door(s), 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
Appliances
Electric Cooktop, Electric Oven, Microwave, Refrigerator
Window Features
Wood Frames
Exterior Features
Fire Pit
Sewer
Public Sewer
Heating
Natural Gas
Construction
Year Built
Year Built: 1959
Home type
Single Family Residence
Construction Materials
Brick
Architectural Style
Ranch
Roof
Shingle
Foundation Details
Poured Concrete
Utilities & Energy
Utilities
Cable Available, Natural Gas Available, Sewer Available, Water Available
Basement
Full Finished Bath, Storage Space, Walk Out Access
Parking Features
Attached, Driveway, Garage, Garage Faces Side, Off Street
Water Source
Public
Security Features
Smoke Detector(s)
Fireplace Features
Gas
Other Features
Lot Features
Cleared, Sloped, Sloped Down, Waterfront, Near Public Transit
Patio And Porch Features
Covered, Patio
Price History
| Date | Event | Price |
|---|---|---|
10/15/2026 Source: | Price Decreased | $610,000 -0.81% $331/sqft |
09/11/2026 Source: | Listed for Sale | $615,000 $334/sqft |
Nearby Homes
Find Homes by Property Features in Crestview Hills, KY
Nearby New Homes For Sale
Based on information from the Northern Kentucky Multiple Listing Service, Inc. through Oct 29, 2026, 02:15PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Northern Kentucky Multiple Listing Service, Inc. All Rights Reserved.
Advertising Broker: Donna Mink | Mink Realty
