Experience ultimate luxury and impeccable design in this completely renovated waterfront condo! The attention to detail and high-quality materials used throughout are unmatched, sexy and sleek. Perched upon the second floor in one of the best locations in the development, you have a large private balcony overlooking a magnificent water view of Greenport Harbor out to the Bay! The kitchen is equipped with all new appliances, quartz countertops, marble backsplash, custom window shutters, instant hot/cold water filtration system and access to a small balcony perfect for easy access to grill! The living room is a showstopper which includes vaulted ceilings with custom wood beams, a sophisticated wood burning fireplace with marble mantle and sliders to the waterside balcony. The primary bedroom has its own access to the waterside patio and also has custom wood ceiling beams, custom closets, and an en-suite bathroom. Both the primary bathroom and guest bathroom have been gutted to the studs with all new plumbing and electric, Carrara marble showers with custom frameless shower doors, Carrara marble floors, Restoration Hardware extra wide vanities with Carrara marble vanity top/backslash. There are 6 inch modern base moldings and new doors throughout, along with custom decorative wood trim in the hallway, and full size stackable washer/dryer. Pull down stairs have been added to hatch to attic to provide extra storage. Stirling Cove is one of the most desirable complexes on the North Fork. Each unit has its own deeded boat slip (docks have been recently redone), there is a private beach, tennis/pickle ball, heated pool and its two blocks from Greenport Village restaurants and shops!! Charging stations for electric cars on site! This condo is truly a designer's showcase and a one-of-a-kind gem! Turnkey and ready to go for Summer 2024!!, Additional information: Appearance:Mint,ExterioFeatures:Tennis,Interior Features:Lr/Dr