Nestled on a quiet cul-de-sac in the exclusive hamlet of Great River, this stunning brick Colonial offers 5,500 square feet of beautifully designed living space. Featuring 5 bedrooms and 4 .5 baths, this exceptional residence combines timeless elegance with modern amenities. The first floor boasts a spacious primary en suite with a full bath, formal dining room, living room with soaring cathedral ceilings and fireplace, inviting den, powder room, laundry room, and private guest quarters complete with a bedroom, full bath, and separate side entrance. An elevator provides convenient access throughout the home. The second level offers three generously sized bedrooms, two additional flex rooms perfect for a home office or gym, and a bonus room with dramatic vaulted ceilings, rustic wood beams, and a private full bath featuring radiant heat offering the flexibility to serve as a luxurious second primary suite. A massive walk-up attic with soaring ceilings provides endless possibilities for future expansion, recreation, or storage. Additional highlights include three new central air conditioning units, a brand-new roof, new oil burner, elevator, full basement, and numerous recent upgrades. Step outside to your private backyard retreat featuring a heated saltwater pool, permanent outdoor lighting, nine security cameras, and professionally landscaped grounds with 30 Green Giant arborvitaes creating exceptional privacy. Close to golf, boating and the scenic Connetquot River, this is a rare opportunity to enjoy the very best of Great River living.