Experience unparalleled modern luxury in this extraordinary residence located in the prestigious Village of Saddle Rock. This architectural masterpiece showcases breathtaking water and bridge views from a rare, oversized rooftop terrace - an impressive 1,000-square-foot space overlooking the serene Little Neck Bay. From the moment you enter the grand foyer, you're welcomed by soaring ceilings, an elegant glass staircase, and expansive windows that bathe the home in natural light.
Spanning approximately 5,300+/- square feet, including a fully finished 2,500+/- square foot walk-out lower level, this home is a true sanctuary of comfort and style. Superior craftsmanship is evident throughout, featuring thick-cut moldings, radiant heat flooring, and thoughtfully designed entertaining spaces. The gourmet eat-in kitchen features double islands, a seamless stone backsplash, and a full suite of ultra-luxury, chef-grade appliances. Designed with versatility in mind, it can easily accommodate a Kosher setup, offering two of everything - dishwashers, stoves, sinks, and more.
The residence offers 6 generously sized bedrooms and 5.5 bathrooms, including a grand primary suite with multiple walk-in closets and a spa-inspired marble bathroom complete with a soaking tub. The finished lower level includes a game room/bonus space, ample storage, a laundry room, and direct access to the attached two-car garage. An elevator shaft is already in place, allowing for easy installation. A second-floor wet bar with a wine refrigerator offers the perfect transition before ascending the spiral staircase to the show-stopping rooftop terrace.
Residents enjoy access to award-winning Saddle Rock Elementary and Great Neck North Middle and High Schools. Ideally situated near the Great Neck Library and just moments from Saddle Rock Village Park, which features a neighborhood dock and marina, a waterfront pool, tennis courts, and basketball courts.
Sold for $4,126,000 on 08/26/25
$4,126,000
15 Gristmill Lane, Great Neck, NY 11023
6beds
5,280sqft
Single Family Residence, Residential
Built in 2023
0.34 Acres Lot
$4,140,300 Zestimate®
$781/sqft
$8,137 Estimated rent
Owner options
What's special
Zillow last checked: 7 hours ago
Listing updated: August 26, 2025 at 02:06pm
Listed by:
Jingwen Ding 929-365-2185,
Daniel Gale Sothebys Intl Rlty 516-466-4036
Bought with:
Jason P. Friedman, 10401223998
Daniel Gale Sothebys Intl Rlty
Sarah R. Friedman, 40FR0973610
Daniel Gale Sothebys Intl Rlty
Source: OneKey® MLS,MLS#: 877898

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Other
- Description: Walk Out/ Access to Garage - Finished Basement with Game Room, Media Area, Bedroom, Full Bath, Utilities, Ample Storage & Laundry
- Level: Basement
Other
- Description: Foyer, Formal DiningRm, Formal LivingRm, EIK & Den Combo, WetBar/Pantry, PowderRm
- Level: First
Other
- Description: Primary with EnSuite and WICs, 4 Additional Bedrooms and 3 Full Baths PLUS Wetbar Leading Out to Stairs/ RoofDeck
- Level: Second
Heating
- Radiant
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Freezer, Oven, Range, Refrigerator, Washer, Wine Refrigerator
- Laundry: Washer/Dryer Hookup, In Basement
Features
- Built-in Features, Cathedral Ceiling(s), Chefs Kitchen, Crown Molding, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, His and Hers Closets, Kitchen Island, Marble Counters, Primary Bathroom, Open Floorplan, Open Kitchen, Pantry, Soaking Tub, Stone Counters, Storage, Tray Ceiling(s)
- Flooring: Hardwood, Tile
- Windows: Floor to Ceiling Windows, Oversized Windows
- Basement: Finished,Full,Storage Space,Walk-Out Access
- Attic: See Remarks
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 5,280
- Total interior livable area: 5,280 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Driveway, Garage
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Three Or More
- Patio & porch: Deck, Patio
- Fencing: Fenced
- Has view: Yes
- View description: Bridge(s), Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 0.34 Acres
- Features: Level
Details
- Parcel number: 2249023270000020
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Modern
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Stucco
Condition
- Actual
- Year built: 2023
- Major remodel year: 2023
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected
Community & neighborhood
Location
- Region: Great Neck
Other
Other facts
- Listing agreement: Exclusive Right To Sell
Services availability
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$4,140,300
2% more+$82,806
With Zillow Showcase(estimated)$4,223,106