luxury waterfront property for sale Locust Valley, United States

Welcome to 2 Aspen Place, a sprawling residence nestled on a .78-acre lot along a quiet, tree-lined street, offering 7 bedrooms and 6.5 baths. Bright entry foyer leads to a dramatic double-height living room with soaring vaulted ceilings, exposed wood beams, and a stone fireplace. The formal dining room with a second fireplace flows into an expansive sunroom lined with arched windows and French doors, overlooking the lush backyard and patio, enhancing the home’s open, airy feel. The custom chef’s eat-in kitchen features vaulted ceilings, high-end appliances, and a separate breakfast room, and opens to a sunlit den, along with a powder room, laundry room, and a guest suite with full bath. The main level includes the primary suite with stone fireplace, dual walk-in closets, and direct access to the backyard and gunite pool with spa. The marble primary bath features a jacuzzi tub and steam shower. Three additional bedrooms and two full baths complete the first floor, including one with direct outdoor access, ideal as a cabana bath. The main living space is framed by two upper-level wings. One side features an open office balcony overlooking the living room, while the other offers a separate wing with a sitting area, two bedrooms, and two en-suite marble baths. Features include hardwood floors, central and ductless AC, a full-house generator, partial basement with laundry and storage, and an attached 2-car garage with direct kitchen access. The grounds feature a 50-foot gunite pool with spa, brick patio with built-in BBQ, and a circular Belgian block driveway. Set in the prestigious Village of Great Neck Estates with its own village police and access to the waterfront park just steps away, featuring Olympic pool, kiddie pool, tennis, pickleball, marina, sports fields, and playground. Zoned for Saddle Rock Elementary with optional North or South middle and high school

Waterfront Sandy Beach Lot Overlooking Centerport Harbor & Northport Bay! This rare 1-acre buildable lot with 52 feet of sandy waterfront offers the perfect setting to design and build your dream home. Plans for a stunning residence are available upon request, designed to maximize the property’s natural beauty with views of the water from every window. Easy access to a sandy beach, minutes from restaurants, shops and marinas. Offering the ideal blend of a peaceful retreat and everyday convenience.