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 updated bath and private deck, plus multiple living areas, a home office and large FROG with private entry, perfect for guests or multi-generational living. Updated kitchen with granite counters and stainless appliances, vaulted family room with gas fireplace and plenty of storage throughout. A rare opportunity for waterfront living with standout spaces for entertaining both inside and out!