This beautifully designed and impeccably maintained Colonial features 5 bedrooms and 2.5 baths, offering a perfect blend of elegance and comfort. Step inside to a classic foyer which opens to a spacious living room, complemented by an adjoining formal dining space. The newly updated gourmet kitchen impresses with quartz countertops, stylish backsplash, and a center island, flowing seamlessly into the generous family room complete with a marble-accented gas fireplace and pocket doors all ideal for entertaining! The first floor also includes a private home office. The oversized primary suite serves as a retreat, showcasing a spa-inspired ensuite with double vanity, steam shower, and travertine tile. The additional bedrooms are well-proportioned and inviting, providing ample space for family or guests. Relax in the sunroom overlooking a thoughtfully landscaped backyard. Outside, enjoy the beauty of stamped concrete walkways, a patio, and vibrant perennial gardens. Recent updates include the half bathroom and mudroom, roof, gutters, exterior paint, tankless water heater, and a Generac generator offering peace of mind for years to come. Situated in a quiet neighborhood, yet conveniently located near parks, major routes, and Albany International Airport, this home delivers an exceptional combination of style, function, and location!