Welcome to this beautifully maintained 4-bedroom, 2.5-bath home with approx. 2,500 square feet of versatile living space, where the backyard is truly the star of the show! Designed for entertaining and everyday enjoyment, the private backyard features a stunning in-ground pool with a cascading 3-tier stone waterfall, stamped concrete surround, mature landscaping, spacious Trex-deck, grilling pergola and a fire pit area - creating your own private outdoor retreat. Inside, the flexible floor plan accommodates a variety of lifestyles. A spectacular Adirondack-style addition showcases soaring wood cathedral ceilings, walls of windows for plentiful natural light, and a Jøtul gas stove. Ideal as a great room, family room, home office, or den, this inviting space is complemented by an additional front living area. The recently updated kitchen features beautiful granite countertops, cherry cabinetry, a tile backsplash, refrigerator w/cabinet-matching door panels for a seamless built-in look, and a seating area. Vaulted ceilings enhance the living and dining rooms, while porcelain tile flooring is complemented by cherry and oak hardwoods throughout the first floor. Providing the convenience of one-level living, the spacious first-floor primary suite features cathedral ceilings, cherry hardwood flooring, walk-in closet, double vanity, and a private bath. Three additional second-floor bedrooms with oak hardwood flooring, and a second full bath, complete the upper level. A first-floor laundry room adds everyday convenience, while the spacious basement provides exceptional flexibility including a finished area for a rec room, home gym or additional living space, along with a workshop and storage room. Additional highlights include a heated 2-car garage, inground sprinkler system and 2 separate central air systems. Conveniently located minutes from shopping, restaurants, parks and everyday amenities, Within the outstanding Guilderland school district.