5 Normandy SquareGuilderland, NY 12009Price: $949,800

Come Explore .... 5 Normandy Square, Guilderland, NY 12009 -- tucked away on a manicured cul-de-sac in the Guilderland School District, this custom home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated. From the moment you enter the soaring two-story foyer-great room, the double-trayed 18' LED ceiling and floor-to-ceiling windows and fireplace tell you this isn't your average Albany County home. The great room opens to a gourmet kitchen with a massive island, beverage cooler, and pot filler. The breakfast nook and transitional sunroom lead to an expansive covered patio with a woodburning lodge fireplace, raftered ceilings, paddle fans, an all-weather TV, and a natural-gas Weber grill kitchen -- built for effortless, entertaining in the shadows of Thatcher Park. Less than 100 feet away sits the most flexible space of all: a 40'x60' (2,600+ sq ft) accessory dwelling unit with potential for recreation center/small business headquarters, or even light manufacturing. Could be used for car storage, a golf simulator, a theatre, dance studio, it is a blank slate. The ADU includes a 2BR/1.5BA apartment, ideal for multigenerational living, guests, or more offices for a home-based business. The 3,781 sq ft, natural-light-filled 4BR/3.5BA main house has a first-floor primary suite and 3-car garage. Combined: over 5,500 sq ft, 6 bedrooms, 4 full and 2 half baths, newer mechanicals, and unparalleled flex space near Costco, Hannaford, and all Guilderland/Altamont has to offer. This is the unicorn -- that unique Altamont, NY property you've been searching for. Stop by fall in love and say ''AHHH'' -- you've arrived home.