Stunning 5-Bed, 4.5-Bath Home with 4-Car Heated Garage, Walk-Out Basement & In-Law Quarters on Geist Reservoir (potentially)! Tucked away in a peaceful cul-de-sac, this spacious and versatile home offers exceptional living, entertaining, and investment potential. With 5 generously sized bedrooms, 2 kitchens, and 4 full bathrooms, there's room for everyone - plus more! The main level features a rare In-Law Quarters setup with a huge bedroom suite and a large private bath, ideal for multigenerational living or guests. The heart of the home opens to a finished walk-out basement complete with a full bar, second kitchen, and expansive living space, perfect for entertaining or even converting into separate living quarters. Upstairs are 4 more bedrooms including an additional Primary Bedroom w/its own bath! Car enthusiasts and hobbyists will love the heated/finished 4-car garage with ample storage and space for a workshop. Step outside to a backyard sanctuary with mature trees and tranquil views. Enjoy every season from the all-season sunroom, huge screened-in porch, or multiple decks that overlook a serene ravine. Here's the game-changer: the property connects to a dredgeable ravine, offering the potential to create your own Geist waterfront lot (was originally built in 1981 as a Water Front Property) - build equity while customizing your dream lifestyle! Don't miss this rare opportunity to own a home that combines luxury, flexibility, and future value - all in a prime location.