Located in Prestigious Great Neck Estates, this impressive Colonial exudes historic grandeur and timeless elegance. A two-story circular limestone foyer with a sweeping wrought-iron staircase opens through arched doorways to a grand formal living room featuring vaulted, hand-hewn beamed ceilings and a sculpted regal fireplace. The oversized formal dining room showcases ornate coffered ceilings and intricate plasterwork, while wide-plank hardwood floors throughout balance classic craftsmanship with modern sophistication. A fabulous kitchen and adjoining den flow seamlessly into a year-round sunroom, creating the perfect space for everyday living and entertaining. The home offers four spacious bedrooms, plus finished attic stairs leading to a third floor with outstanding potential for an additional bedroom, home office, or recreation space. Exclusive Village amenities include a waterfront park, tennis courts, pool club, summer camp, and private police services. Ideally zoned for choice of Great Neck South or North Middle School and conveniently located near town and the LIRR, this residence offers the ultimate blend of luxury, lifestyle, and location.