Experience a year-round Entertainer's Dream on Waterfront Lot in Trant Berkshire! Enjoy the ultimate indoor-outdoor lifestyle of this one-of-a-kind waterfront home nestled on a generous 3/4 acre lot in the heart of Great Neck. The expansive sunroom is the centerpiece of the home-featuring soaring ceilings, walls of windows, and a built-in entertaining kitchen perfect for gatherings. Step outside to your backyard oasis with an in-ground pool, boat lift and deep water access-ideal for boating, swimming and summer fun. Inside, the flexible layout offers a spacious first floor primary suite with update bath and private deck, plus multiple living areas, a home office, large FROG with private entry, perfect for guests or multi-generational living. Updated kitchen with granite counters, stainless appliances and gas range. Vaulted family room with gas fireplace and plenty of storage throughout. A rare opportunity for waterfront living with standout spaces for entertaining both inside & out!