Skip main navigation
For sale
  • $2,399,999

    2829 Frankel Boulevard, Merrick, NY 11566

    8beds
    6,818sqft
    Loading
    Single Family Residence, Residential
    Built in 1991
    0.37 Acres Lot
    $-- Zestimate®
    $352/sqft
    $-- HOA

    What's special

    Waterfront homeTwo gas working fireplacesBreathtaking viewsMagnificent indoor poolStunning waterfront viewsHigh-quality washers and dryersWalk-in closet
    A one of a kind masterpiece of unique architecture. Waterfront home, where luxury meets comfort and breathtaking views! The home boasts a magnificent indoor pool that is designed for both relaxation and recreation. The pool is adorned with sparkling tiles and offers a serene oasis right within the comfort of your home. The oversized kitchen in this home is a culinary haven. It is meticulously designed with ample space for meal preparation and entertaining. The countertops, crafted from beautiful granite, provide a luxurious touch and plenty of room for cooking and serving. State-of-the-art appliances. Convenience is paramount in this home, which is why it includes not just one, but two well-equipped laundry rooms. These rooms are equipped with high-quality washers and dryers, allowing for efficient and organized laundry care. To accommodate your vehicles and provide secure parking, this home features a spacious two-car garage. This garage offers ample space for your cars, along with extra storage room for tools, equipment, or recreational gear. In this home, you'll find a spacious cedar closet. This closet is custom-built with high-quality cedar wood, which not only exudes a pleasant aroma Enhancing both warmth and ambiance, this home features two gas working fireplaces. These fireplaces are designed to create a cozy atmosphere and serve as focal points in both the formal living room and the office. This home includes formal living and dining rooms that exude elegance and sophistication. The formal living room is tastefully decorated with beautiful hardwood floors, creating a warm and inviting space for relaxation and socializing. The formal dining room, adjacent to the living room, offers a refined setting for hosting formal dinners and special occasions, complemented by the stunning waterfront views. The office in this home is a dedicated space for work or study. Throughout this home, you'll find a seamless blend of hardwood and granite floors. The hardwood floors exude timeless elegance and add warmth to the living spaces, while the granite floors in the kitchen and bathrooms provide a luxurious touch. Indulge in ultimate relaxation and rejuvenation with the steam shower this home provides. This luxurious feature allows you to unwind and melt away the stress of the day. The walk-in closet in this home is designed to accommodate your storage needs while providing a touch of luxury. This spacious closet offers ample room for organizing and displaying your wardrobe, shoes, and accessories. With custom-built ins. Too much to list this property is a must see!!
    180 days
    |
    737
    |
    17
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Resource Realty Group 917-654-9835,

    Natan Amos 516-341-8471

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: 947687MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 8
      • Bathrooms: 6
      • Full bathrooms: 5
      • 1/2 bathrooms: 1
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator, Stainless Steel Appliance(s)
      • Laundry: Washer/Dryer Hookup
      Features
      • Breakfast Bar, Built-in Features, Central Vacuum, Chefs Kitchen, Eat-in Kitchen, Entertainment Cabinets, Entrance Foyer, Formal Dining, Granite Counters, High Ceilings, His and Hers Closets, Kitchen Island, Natural Woodwork, Pantry, Primary Bathroom, Recessed Lighting, Soaking Tub, Stone Counters, Storage, Walk Through Kitchen, Wet Bar
      • Basement: Finished,Full
      • Attic: None
      • Has fireplace: Yes
      Interior area
      • Total structure area: 8,400
      • Total interior livable area: 6,818 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage, Off Street, Private
      • Garage spaces: 2
      Features
      • Has private pool: Yes
      • Pool features: In Ground, Indoor
      • On waterfront: Yes
      • Waterfront features: Bulkhead, Canal Front, Water Access, Waterfront
      Lot
      • Size: 0.37 Acres
      Details
      • Parcel number: 2089631290000960
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence, Residential
      Materials
      • Frame
      Condition
      • Year built: 1991

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Merrick

      Financial & listing details

      • Price per square foot: $352/sqft
      • Tax assessed value: $1,567
      • Annual tax amount: $40,918
      • Date on market: 1/2/2026
      • Cumulative days on market: 36 days
      • Listing agreement: Exclusive Right To Sell
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        1/2/2026Listed for sale$2,399,999+4.3%$352/sqft
        Source: OneKey® MLS as distributed by MLS GRID #947687 Report a problem
        12/11/2025Listing removed--
        Source: Owner Report a problem
        11/11/2025Listed for sale$2,300,000-8%$337/sqft
        Source: Owner Report a problem
        9/16/2023Listing removed--
        Source: Owner Report a problem
        6/15/2023Price change$2,500,000+4.2%$367/sqft
        Source: Owner Report a problem
        5/31/2023Listed for sale$2,400,000$352/sqft
        Source: Owner Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024-- $1,348 -6.4%
        2023-- $1,440 -5.9%
        2022-- $1,530
        2021$34,847 +19.5%--
        2020$29,161 -0.2%$1,533 -6.6%
        2019$29,228 $1,642 -6.3%
        2018$29,228 -0.5%$1,752 -5.9%
        2017$29,378 -0.6%$1,861 -5.6%
        2016$29,549 +258%$1,971 -5.2%
        2015$8,254 -10%$2,080 -14.9%
        2013$9,173 -7.7%$2,443 -10.9%
        2012$9,941 -62.1%$2,742 -12%
        2011$26,216 +4.4%$3,116 -9%
        2010$25,100 $3,425 -7.7%
        2009-- $3,710 -14.7%
        2008-- $4,347 +6%
        2006-- $4,101 -37.7%
        2005-- $6,587 -42%
        2004-- $11,352 -11.8%
        2003-- $12,874 -12.7%
        2002-- $14,742 -7.9%
        2001-- $16,000
        2000-- $16,000

        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 11566

        Getting around

        54 / 100
        Somewhat Walkable
        16 / 100
        Minimal Transit
        39 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Norman J Levy Lakeside School
        • Middle: Merrick Avenue Middle School
        • High: John F Kennedy 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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel