Skip main navigation
Sold for $4,126,000
Street View
    • $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,374,000 Zestimate®
    $781/sqft
    $8,137 Estimated rent

    Home value

    $4,374,000

    $3.94M - $4.86M

    $8,137/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $8,137/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $8,137/mo

    Rent Zestimate®

    Refinance and save

    $27,636/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $27,636/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Expansive windowsElevator shaftOversized rooftop terraceDouble islandsLaundry roomSoaring ceilingsMultiple walk-in closets
    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.

    Zillow last checked:

    Listing updated:

    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 as distributed by MLS GRID,MLS#: 877898MLS Logo

    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 & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Great Neck

    Financial & listing details

    • Price per square foot: $781/sqft
    • Tax assessed value: $1,970
    • Annual tax amount: $31,558
    • Date on market: 6/16/2025
    • Cumulative days on market: 39 days
    • Listing agreement: Exclusive Right To Sell
    • Electric utility on property: Yes

    Price history

    DateEventPrice
    8/26/2025Sold$4,126,000-5.8%$781/sqft
    Source: OneKey® MLS as distributed by MLS GRID #877898 Report a problem
    7/25/2025Pending sale$4,380,000$830/sqft
    Source: OneKey® MLS as distributed by MLS GRID #877898 Report a problem
    6/16/2025Listed for sale$4,380,000+12.3%$830/sqft
    Source: OneKey® MLS as distributed by MLS GRID #877898 Report a problem
    8/28/2024Sold$3,900,000-11.2%$739/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3531519 Report a problem
    3/14/2024Pending sale$4,390,000$831/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3531519 Report a problem
    2/14/2024Listed for sale$4,390,000$831/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3531519 Report a problem
    2/12/2024Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3461298 Report a problem
    2/7/2024Listed for sale$4,390,000$831/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3461298 Report a problem
    1/29/2024Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3461298 Report a problem
    12/12/2023Price change$4,390,000-4.6%$831/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3461298 Report a problem
    2/28/2023Listed for sale$4,600,000+211.9%$871/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3461298 Report a problem
    8/24/2021Sold$1,475,000+1.1%$279/sqft
    Source: Public Record Report a problem
    6/10/2021Pending sale$1,459,000$276/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3275567 Report a problem
    4/23/2021Price change$1,459,000-4.5%$276/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3275567 Report a problem
    3/9/2021Price change$1,528,000-3.8%$289/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3275567 Report a problem
    2/23/2021Price change$1,588,000-3.6%$301/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3275567 Report a problem
    1/14/2021Price change$1,648,000-5.7%$312/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3275567 Report a problem
    12/15/2020Price change$1,748,000-2.9%$331/sqft
    Source: B & R DEVELOPMENT & SALES LLC #3275567 Report a problem
    11/25/2020Price change$1,799,999-10%$341/sqft
    Source: Owner Report a problem
    11/6/2020Listed for sale$1,999,999+77.6%$379/sqft
    Source: Owner Report a problem
    9/12/2014Listing removed$4,600$1/sqft
    Source: Charles Rutenberg Realty Inc #10174729 Report a problem
    9/8/2014Listed for rent$4,600$1/sqft
    Source: Charles Rutenberg Realty Inc #10174729 Report a problem
    7/15/2014Listing removed$4,600$1/sqft
    Source: Charles Rutenberg Realty Report a problem
    7/2/2014Listed for rent$4,600$1/sqft
    Source: Charles Rutenberg Realty Inc #2686812 Report a problem
    12/15/2012Listing removed$4,600$1/sqft
    Source: Laffey Fine Homes #2530745 Report a problem
    10/2/2012Listed for rent$4,600$1/sqft
    Source: Laffey Fine Homes #2530745 Report a problem
    3/1/2004Sold$1,126,000+83.1%$213/sqft
    Source: Public Record Report a problem
    10/23/1997Sold$615,000$116/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $1,360
    2023-- $1,360
    2022-- $1,360
    2021$26,107 +0.3%--
    2020$26,039 +11.6%$2,500
    2019$23,335 $2,500
    2018$23,335 +4.8%$2,500
    2017$22,267 +4.8%$2,500
    2016$21,254 +262.6%$2,500
    2015$5,861 +4.9%$2,500
    2013$5,588 +8.2%$2,500
    2012$5,166 -58%$2,500 -12.5%
    2011$12,290 +5.1%$2,857 -4.9%
    2010$11,689 $3,003 -17%
    2009-- $3,616 +3.5%
    2008-- $3,493 +6%
    2006-- $3,296 -36.2%
    2005-- $5,170 -35.9%
    2004-- $8,066
    2003-- $8,066 -42.2%
    2002-- $13,950
    2001-- $13,950
    2000-- $13,950
    Find assessor info on the county website

    Neighborhood: Saddle Rock

    Nearby homes

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Saddle Rock School
    • Middle: Great Neck North Middle School
    • High: Great Neck North High School

    Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $4,374,000
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $4,374,000

    Nearby cities

    Nearby neighborhoods

    Nearby zip codes

    Other Great Neck Topics

      Search
      Updates
      Favorites
      Plan
      Inbox