Welcome to this stunning waterfront retreat with breathtaking sunsets. Discover the perfect blend of luxury, sophistication, and waterfront living in this fully renovated 5-bedroom, 5 full bath, and 2 half bath home. Located at the end of a quiet cul-de-sac, this exceptional property sits on 1.77 acres at the highest point of Gooseneck Point Road, offering sweeping views of the Shrewsbury River. With 300 feet of waterfront, a private 129-foot dock, and a boat lift, this home is a boater's paradise. Every detail of this home has been meticulously upgraded, featuring a custom chef's kitchen with high-end appliances and a butler's pantry equipped with a dishwasher, oven, fridge, sink, and nugget ice maker. The primary suite boasts vaulted ceilings, a private balcony, and a spa-like bath with a soaking tub, while a new downstairs guest suite includes a custom en-suite bath. Designed with both elegance and functionality, this home offers a dedicated office, a recreation room with a loft, and a custom bar and study that exude charm and sophistication. The four-seasons sunroom provides breathtaking panoramic water views, while three inviting fireplaces create a welcoming ambiance. The meticulously landscaped grounds create a private, picturesque retreat, featuring lush gardens, mature trees, and a manicured lawn. A detached two-story garage includes a home gym and additional bonus space, while the bluestone front porch and Belgian block driveway lead to an attached three-car garage, providing ample storage and workspace. The heated 20x40 gunite pool with an automatic cover adds to the home's resort-like appeal. Gas lanterns enhance its timeless charm, while a whole-house generator ensures uninterrupted comfort. This fully upgraded waterfront retreat seamlessly blends elegance, modern amenities, and breathtaking natural beauty. Schedule a private tour today!