Home For Sale
Luxury Custom Ranch w/ Guest Suite & Incredible Layout Discerning buyers will appreciate this stunning, custom, ranch featuring the utmost & unique features in a home, along w/ a perfect generational private-entry apartment with it's own kitchen, living room, laundry, & bath. The main floor showcases 8' solid-core 5-panel stained doors, upgraded farmhouse trim, a raised dining area w/ custom built-ins, expansive 12x8 patio doors, & main floor bedrooms, including one that is currently used as the office. The Chef's Kitchen offers over 40ft of granite counters, solid wood cabinetry w/ custom features (spice racks, roll-outs, K-cup organizer), 3 built-in ovens, warming drawer, bev fridge, pot filler, oversized sink, & stainless appliances. The vaulted Great Room includes a marble-surrounded fireplace, pre-wired surround sound, & patio access. Finished lower level w/ 10 ft ceilings boasts a full bath & ample room to entertain, including a movie area, pool room, & 2 bonus rooms w/ walk-in closets and a Jack-&-Jill bathroom. Located on a quiet street across from the neighborhood fountain. With no details overlooked- this home blends luxury, space, & function like no otProperty Details
- Beds: 4
- Baths: 0.0
- Sq Feet: 4281
- Year Built: 2018
- Location: (private lake, pond, creek)
- Acres: 2.110
- Waterview: Yes
- ViewTypes: Lake
- County: Boone County
- Heat/AC: Propane (Heating)
- Garage: Garage, Oversize
- Siding: Brick, Stone
- Roof: Shingle
- Stories: 1
- Fireplaces: Has Fireplace
- MLS #: 637096
Location
Click on map to activate | |
![]() |
|
(Open in Google Maps) (Bing Map)  (Mapquest Map) |
Contact Information:
|
||
Listing Agent: The Cindy Shetterly Team, Keller Williams Realty Services, 859-743-0212, 859-240-0727 Listing Site, Listing Status: Active
Copyright © 2025 Northern Kentucky MLS, Inc.. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
|
||
Ad Statistics:

Ad Number : | 6719454 |
Viewed: | 5 times |
Added: | Oct 14, 2025 |
Updated on: | Oct 14, 2025 |
All information provided is deemed reliable but is not guaranteed and should be independently verified. |