Skip main navigation
Off market
  • $1,555,500

    2965 Frankel Boulevard, Merrick, NY 11566

    4beds
    3,100sqft
    Single Family Residence, Residential
    Built in 2023
    6,180 Square Feet Lot
    $1,555,500 Zestimate®
    $502/sqft
    $5,086 Estimated rent

    Home value

    $1,555,500

    $1.48M - $1.65M

    $5,086/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,086/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

    $5,086/mo

    Rent Zestimate®

    Refinance and save

    $10,278/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

    $10,278/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

    Magnificent Brand New Waterfront Colonial Now Move In Ready! Approx. 3100 Square Feet Of Living! 9 Foot Ceilings, Beautiful Custom Kitchen ft. Oversized Island & New Samsung Appliances, Hardwood Floors, Fireplace, Dedicated Laundry Room, Features, Almost Unheard of, Bone Dry Waterfront Full Basement w. Egress! Large Master w. Huge Walk in + Master Bath and Balcony overlooking Park and Waterfront, Energy Rated & Home Energy Certified Home, Forced Air HVAC w. 2 zones, Attached 1.5 Car Garage, New Floating Dock on Wide Canal. Too Much to List! Nothing Better than New! Do Not Let This Opportunity Pass You By!, Additional information: Appearance:NEW CONSTR

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Listed by:

    Anthony Valenti 516-587-2974,

    Keystone Realty USA Corp 631-261-2800

    Bought with:

    Anthony LaBella, 10401360169

    EXP Realty

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • ENERGY STAR Qualified Equipment, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: ENERGY STAR Qualified Appliances, Gas Water Heater
    Features
    • Doors: ENERGY STAR Qualified Doors
    • Windows: ENERGY STAR Qualified Windows
    • Basement: Full
    • Attic: Partial
    • Number of fireplaces: 1
    Interior area
    • Total structure area: 3,100
    • Total interior livable area: 3,100 sqft

    Property

    Parking
    • Parking features: Attached, Driveway, Garage, Private
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Has view: Yes
    • View description: Panoramic
    • Waterfront features: Canal Access, Water Access
    Lot
    • Size: 6,180 sqft
    • Dimensions: 61 x 103
    Details
    • Parcel number: 2089631290000670

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Batts Insulation, Energy Star
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2023

    Utilities & green energy

    • Water: Public
    Green energy
    • Green verification: HERS Index Score

    Community & neighborhood

    Location
    • Region: Merrick

    Other

    Other facts
    • Listing agreement: Exclusive Right To Lease

    Price history

    DateEventPrice
    6/29/2023Sold$1,325,000-7.3%$427/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3418771 Report a problem
    5/1/2023Pending sale$1,429,999$461/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3418771 Report a problem
    3/15/2023Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3418771 Report a problem
    1/4/2023Price change$1,429,999-4.7%$461/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3418771 Report a problem
    7/26/2022Listed for sale$1,499,995+339.6%$484/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3418771 Report a problem
    8/29/2019Sold$341,250-31.7%$110/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3128612 Report a problem
    6/5/2019Price change$499,900-9.1%$161/sqft
    Source: Rock Realty Inc #3128612 Report a problem
    4/2/2019Price change$549,900-9.7%$177/sqft
    Source: Rock Realty Inc #3100920 Report a problem
    2/13/2019Listed for sale$609,000-48.1%$196/sqft
    Source: Rock Realty Inc #3100920 Report a problem
    1/30/2019Sold$1,172,831+160.6%$378/sqft
    Source: Public Record Report a problem
    12/11/2018Listed for sale--
    Source: Auction.com Report a problem
    1/18/2017Listing removed$450,000$145/sqft
    Source: MLS of Long Island #2890872 Report a problem
    12/16/2016Listed for sale$450,000-21.1%$145/sqft
    Source: C Y D Realty Group LLC #2890872 Report a problem
    4/19/2013Listing removed$570,000$184/sqft
    Source: EXIT Realty Premier #2441083 Report a problem
    10/25/2011Price change$570,000-0.9%$184/sqft
    Source: Exit Realty Premier #2441083 Report a problem
    6/11/2011Price change$575,000-6.5%$185/sqft
    Source: Exit Realty Results #2378549 Report a problem
    5/3/2011Price change$615,000-5.2%$198/sqft
    Source: Exit Realty Results #2378549 Report a problem
    3/25/2011Listed for sale$649,000$209/sqft
    Source: Exit Realty Results #2378549 Report a problem
    9/19/2010Listing removed$649,000$209/sqft
    Source: Exit Realty Results #2322197 Report a problem
    8/27/2010Listed for sale$649,000-7.2%$209/sqft
    Source: Exit Realty Results #2322197 Report a problem
    11/7/2009Listing removed$699,000$225/sqft
    Source: CENTURY 21 AA Realty #2131826 Report a problem
    8/21/2009Listed for sale$699,000-16.7%$225/sqft
    Source: CENTURY 21 AA Realty #2131826 Report a problem
    4/7/2008Listing removed$839,000$271/sqft
    Source: Coach Realtors Report a problem
    4/1/2008Listed for sale$839,000+5%$271/sqft
    Source: Coach Realtors Report a problem
    9/7/2007Sold$799,000-0.1%$258/sqft
    Source: Public Record Report a problem
    8/29/2005Sold$800,000$258/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $1,051 +62.2%
    2023-- $648 +110.4%
    2022-- $308
    2021$12,958 -70.1%--
    2020$43,350 +53%$1,698
    2019$28,327 $1,698
    2018$28,327 -22%$1,698
    2017$36,315 +30.1%$1,698
    2016$27,913 +246.8%$1,698
    2015$8,049 +12.3%$1,698
    2013$7,166 +16.4%$1,698
    2012$6,156 -57.8%$1,698 -2%
    2011$14,580 +3.3%$1,733 -5.2%
    2010$14,110 $1,829 -10.3%
    2009-- $2,040 +2%
    2008-- $2,000 -2.6%
    2006-- $2,053 -37.9%
    2005-- $3,305 -38.5%
    2004-- $5,378
    2003-- $5,378 -52.9%
    2002-- $11,410 -0.8%
    2001-- $11,500
    2000-- $11,500

    Find assessor info on the county website

    Neighborhood: 11566

    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.

    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
    $1,555,500
    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
    $1,555,500