One of a kind waterfront gem located in the highly coveted enclave of Idle Hour. This exclusive gated compound offers unparalleled direct access to the Connetquot River and the Great South Bay. Step inside this luxurious residence to find an open-concept design that seamlessly integrates inviting living spaces with a formal dining area perfect for entertaining. The fully renovated, state-of-the-art kitchen is a chef's dream. It boasts stunning quartz countertops, a convenient prep sink, top-of-the-line stainless steel appliances, and an elegant stone backsplash. This exquisite home features six spacious bedrooms and four full bathrooms.The exterior of the property is an entertainer's paradise. Multiple patios and decks provide ample space for outdoor dining, relaxation, and socializing. Amazing opportunity!