Nestled in Stamford's highly sought-after Waterside neighborhood, this beautifully reimagined 5BR 2.5BA Colonial seamlessly blends timeless charm with sophisticated modern living. The sun-filled main level welcomes you with an expansive living room centered around a stylish fireplace and oversized picture windows, flowing effortlessly into the dining area and stunning state-of-the-art gourmet kitchen featuring custom white shaker cabinetry, premium stainless steel appliances, designer tile backsplash, granite countertops, and an oversized center island perfect for entertaining. Sliders lead directly to a spacious rear deck overlooking the private fenced yard, creating seamless indoor-outdoor living. This level is rounded out by a beautifully renovated full bath, spacious primary bedroom, and two additional well-proportioned bedrooms, all complemented by hardwood floors and refined finishes throughout. The upper level offers exceptional flexibility with two additional bedrooms and a full bath set apart enough to function as an ideal in-law suite, guest quarters, or private home office retreat. The fully finished lower level provides additional living space perfect for a family room, media room or gym. Outside, enjoy a large level fenced yard complete with deck, hot tub, firepit area, and storage shed, ideal for relaxing or entertaining. Perfectly positioned just moments from Stamford's waterfront, beaches, parks, Metro-North, and vibrant downtown dining and nightlife!