Welcome to one of the most versatile and expansive homes in Ashcroft Place. This completely refreshed exceptional residence offers over 4,000 square feet of above grade living space complete with 7 bedrooms, 5 of them on the 2nd level and 2 on the lower level. There are a total of 6 baths, 4 full baths, 3 are ensuites, on the 2nd level, a powder room on the main level and a large 3/4 lower level bath. All new paint, all new luxury carpet and light fixtures. The professionally finished basement is designed for both comfortable living and entertainment as well as multi-generational living. The main level features generous living spaces ideal for everyday living and hosting. The stunning lower level is complete with two additional bedrooms, flex/ office space, a large private bath and a custom-built bar and entertainment area. Whether used for multi-generational living, guest accommodations, or a private retreat, this home delivers unmatched versatility with a functional 7-bedroom layout. Some of the many special features of this home are a hot water and filtered water spigots at kitchen sink, double oven, laundry chute, four seasons room, office/flex space on 2 levels, heated floors in flex space and bathroom of basement, 100 inch pull down projection screen, extra wide staircase with large landing, ADT alarm system, 3 car tandem garage with custom epoxy floors, custom built patio with lighting and large firepit, invisible fence system in both front and backyards and so much more! Step outside to your private backyard oasis and enjoy tranquil water views. a perfect backdrop for relaxing evenings, outdoor dining, or hosting gatherings in this lovely neighborhood. Located in a sought-after Oswego community near highly rated schools, parks and amenities this home offers a unique combination of size, flexibility and scenic surroundings. Homes with this level of space, finished living area and waterfront appeal are seldom available.