Stunning and one of a kind! This 3,400+ sq ft farmhouse colonial set on a quiet cul-de-sac in coveted Avon Crest, is unlike anything on the market. Rich architectural details set the tone throughout - stone and brick fireplaces, soaring wood beams, vaulted ceilings, and hardwood, slate & brick flooring that tell a story of exceptional craftsmanship. A versatile first-floor bedroom and full bath is ideal for guests, a home office, or multi-generational living. The magnificent sunroom opens to views of the in-ground pool and spa - seamlessly connecting inside and out. The massive primary en-suite is an oasis with a stunning overlook into the sunroom. Outside, a gardener's paradise awaits - a meadow of wildflowers, a dedicated fenced gardening area, and a charming greenhouse make this property as extraordinary outdoors as it is in. The finished basement with a custom bar offers ample room for recreation or home gym, plus a workshop area. The oversized 2-car garage, updated primary bath, and new HVAC including an efficient dual system heat pump, complete this exceptional home. Wooded, private, and award-winning Niskayuna schools. Some homes simply have to be seen to be believed.