Welcome to Davenport Farm - North Stamford's premier and quintessential New England enclave. First time on the market, this stately 6,400+ sq ft modern farmhouse blends timeless charm with grand-scale living. A sweeping two-story foyer sets the stage, leading into a formal living/dining area with open-hearth fireplace and piano alcove. The heart of the home features a sunlit eat-in kitchen with a spacious island, oversized pantry, farm table seating, and arched stone fireplace - all flowing seamlessly to a wraparound porch for al fresco dining. A vaulted dining room with exposed beam ceiling, wood-hewn mantle fireplace, and wet bar offers the perfect holiday entertaining space. Rich hardwood floors, a powder room, laundry, and oversized 2-car garage complete the main level. Upstairs you will find two en-suite bedrooms including a front-to-back primary suite with spa-like bath, two walk-in closets, fireplace and a stunning loft ideal for a home office or dressing room. An additional private guest or au-pair suite over the garage features its own entrance and full bath. The finished 1,700+ sq ft lower level offers a gym, playroom, studio, storage, and more. Endless flexibility and potential awaits in this one-of-a-kind home. Rarely available and sold "As Is" - don't miss this extraordinary opportunity in a storybook setting.