Welcome to this stunning 3-bedroom, 2 full, 2 half bathroom colonial located in the heart of a sought-after Waterford neighborhood. With its charming curb appeal, this home boasts a 2-car attached garage & a thoughtfully designed layout perfect for modern living. Step inside to gleaming hardwood floors that flow throughout the first and second levels. The open floor plan creates an inviting atmosphere, ideal for entertaining or cozy family gatherings. The updated kitchen is a chef's dream, featuring granite countertops, stainless steel appliances, a spacious center island, and a farmhouse sink. A French slider off the kitchen leads to an upper-level deck overlooking your private backyard with an in-ground pool. The primary bedroom suite, complete with double closets, a luxurious en-suite bath with double sinks, and an adjoining office space for your convenience. This home also offers central AC & security system. The bonus room above the garage, with plush wall-to-wall carpeting, offers endless possibilities-playroom, home gym, or media room. The walkout finished basement extends your living space with a recreation room, a half bath, and a kitchenette, with direct access to the pool area for seamless indoor-outdoor entertaining. Located in a well-established and popular neighborhood, this home offers both convenience and tranquility, close to schools, shopping, and local amenities - Great Neck Country Club, Waterford Beach, Eugene O'Neill Theater are just a few miles away