Stunning and one of a kind! This 3,400+ sq ft farmhouse lodge colonial nestled 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. The magnificent four-season sunroom opens to views of the in-ground pool and spa -- seamlessly connecting inside and out. The primary en-suite is an oasis with a stunning overlook into the sunroom. Outside, a gardener's paradise awaits -- a sweeping meadow of wildflowers, a dedicated fenced gardening area, and a charming greenhouse make this property as extraordinary outdoors as it is in. A versatile first-floor bedroom and full bath is ideal for guests, a home office, or multi-generational living. Partially finished basement with workshop, an oversized 2-car garage, updated primary bath, and newer HVAC, including a dual heating system heat pump, complete this exceptional home. Wooded, private, and award-winning Niskayuna schools. Some homes simply have to be seen to be believed.