Unobstructed, panoramic water views await you from this stunning, direct waterfront, end unit that has been meticulously and completely renovated to an exceptionally high standard. West facing to enjoy endless sunsets over Bristol Harbor! Recently renovated gourmet kitchen with large island features new countertops, new white custom cabinetry, new tile backsplash, new paneled Sub-Zero refrigerator, new Wolf dual fuel range with griddle and double oven, new Cove dishwasher, and new Wolf gourmet drawer microwave. Walls of windows to savor the views from the kitchen, living room, dining area, primary bedroom & second bedroom. Both full bathrooms have been recently renovated and now feature zero clearance walk-in showers with rain shower heads and additional shower heads, radiant floor heat, floating vanities, and on-trend tile choices. The den has an internal window to bring in natural light and a new half bathroom has been added. Systems are all updated. As all the renovations have been done, the next owner can simply move in and enjoy the sparkling water views! Two terraces. Two garage spots & a storage unit. Two 35ft marina slips (can accommodate an up to 40ft boat) convey with the condo. Stone Harbour residents benefit from an infinity edge heated pool overlooking the harbor, a gym & beautifully landscaped waterfront grounds. Ideally located in the heart of historic downtown waterfront Bristol within walking distance to restaurants, shops & East Bay bike path to Providence.