Once in a lifetime opportunity! Water sports compound on Connetquot River in the historic Idle Hour section, a stones throw to the Great South Bay with views of the Arboretum and the most incredible sunsets!! Approximately 225 feet of bulkhead with large cut out for 50 foot boat, additional floating dock, water and electric at bulkhead. Brackish water. Approximately 4000 square-foot colonial with brand new roof. No flood insurance needed! Yard features enormous Trex deck, great for entertaining, with flowerbed. Stamped concrete patio, two second floor decks, beautiful 8 person gazebo. Gated entry with paving stone skirt and path leading to your double door two-story grand entry. Vaulted ceilings, recessing skylights, many floor to ceiling windows and glass sliders out to resort style yard, custom wall and crown molding. Sunken formal living room with double stone woodburning fireplace. Den/family room with fireplace and glass sliders out to deck. Enormous dining room with hardwood floors. Chef's kitchen with white cabinets, maple cherry Island with stools. Granite countertops, tile backsplash, lots of cabinet and counter space. Additional prepping/bar area with sink. High-end stainless steel appliances, double oven and built-in wine bar and microwave. Beautiful undercabinet lighting. Enormous great room/game room with French doors out to yard, opens up to mudroom with front loading washer and dryer. Enormous primary suite with hardwood floors, walk-in closets, slider out to private deck, primary suite bath with Jacuzzi tub and large glass standup shower. Unobstructed views of the Connetquot River as you sit in the tub. Additional three spacious bedrooms, all with breathtaking views of the river. Additional hallway bath with jacuzzi tub and shower. Fourth bedroom with private walkout deck with spiral staircases to lower deck. 400 amp electrical panel (Two 200 amp) House has natural gas connection. Three air conditioning units, one brand new, one is one year old, one is two years old.