Welcome to 29 Hickory Drive, an exquisite contemporary Expanded Ranch home nestled in the prestigious Village of Great Neck Estates. This pristine 6 Bedroom, 6 Bathroom residence offers over 3,600 Sq.Ft. of luxurious living space, blending classic elegance with modern amenities. Step into the formal living room, which seamlessly flows into the dining area, creating an inviting space for both intimate gatherings and grand celebrations. The newly redesigned eat-in kitchen features gleaming marble countertops that lead into the Breakfast Room and top-of-the-line Thermador appliances, perfectly complemented by rich French Terracotta tile floors. The den is the heart of the home, boasting doors that open up to an expansive exterior deck, ideal for alfresco dining and entertaining. The main level includes two well-appointed bedrooms and a full bathroom with stylish Art Deco tile accents. Additionally, there is a charming library / media room with a full bathroom that grants direct access to the backyard oasis and a bedroom or office with 10ft ceilings that leads out to the outdoor gardens. Retreat to the spacious Owner's Loft on the second floor, which has a dressing room with multiple closets, access to a private rooftop deck and a luxurious marble en-suite bathroom featuring a soaking tub and a walk-in shower. With walls adorned with Pecky Cypress, the charming walkout lower level is designed for both functionality and leisure featuring an exclusive soundproof legal office studio, a bonus Arcade/ Game Room, a Fitness Area, 1.5 bathrooms, ample storage space and access to the 2 car attached garage. Head outside to discover your private backyard sanctuary, complete with an Award Winning in-ground gunite pool and lush privacy landscaping that seamlessly integrates with the adjacent Village Nature Preserve. The property is also outfitted with beautiful brick walkways, a cozy front porch and a floating wooden deck, great for hosting or grilling outdoors. Additional details include a 1-year old roof using Timberline Lifetime Shingles, a wood-burning fireplace and several operational skylights that provide the interior of the home with generous natural light. Located at the end of a cul-de-sac on .48 Acres, this hilltop residence is a short walk to neighborhood amenities including an Olympic Sized Swimming Pool, private parks, indoor/outdoor tennis courts, a marina and dock/boat launch, playgrounds and more. Zoned within the sought-after Optional Great Neck School Zone.