This stunning, massive, colonial has incredible curb appeal. Offering 5406 square feet, 9 bedrooms, 5 full baths and 2 half baths above ground, with another 2441 square feet below ground, this property truly is one of a kind with a total of 7847 finished square feet. Situated on a 1.2 acre lot, directly across the street from a horse farm provides a rare opportunity of enjoying your morning coffee while taking in the view. The main entrance of the home leads to the large, renovated, open concept, living room, transition wet bar area and kitchen. The kitchen is an absolute dream featuring a massive, full slab, granite island with bar seating and a gas cooktop. A second granite island, providing even more seating. Stainless cafe appliances, stone backsplash, custom cabinetry, wine racks, farmhouse sink and much more. The first floor also presents a large primary suite with two closets, and full bath. The tub has a hidden feature where a TV pops up for you're enjoyment while relaxing. Also on the first floor is a half bath and a second half bath with laundry room combo. The upper levels are split up into 2 sides. Each with a separate staircase. Each side features 3 beds on the second level and 2 full baths, including an ensuite on each floor with its own full bath. The upper level on the right side provides a massive common area as well. The third level provides 2 additional, large, finished bedrooms which can also serve other purposes if desired. The basement serves as an apartment with 2 full baths, bedroom, kitchen/common area with unique bank safe door, and gym. The basement comes fully furnished and with its own entrance. In the back of the home is a large, detached, 2 car garage with plenty of additional storage and potential for more. New deck with gas line ran to grill, newly paved driveway, central air, zoned heat, tankless water. All of this in Guilderland schools. Too much to describe for this one, very unique and a true must see.