Skip main navigation
Sold for $1,170,000
  • $1,170,000

    218 Middle Neck Road #313, Great Neck, NY 11021

    2beds
    1,189sqft
    Condominium, Residential
    Built in 2024
    -- sqft lot
    $1,191,600 Zestimate®
    $984/sqft
    $5,690 Estimated rent

    Home value

    $1,191,600

    $1.07M - $1.32M

    $5,690/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

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

    Rent Zestimate®

    Refinance and save

    $7,816/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

    $7,816/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

    The Rose at Great Neck. This brand new building consists of 40-New Luxury Condominiums on the North Shore of Long Island, located in the Village of Great Neck Estates and is now over 40% sold out. Unit 313 is a two bedroom and two bath on the top third floor, approximately 1,189 sqft, includes private laundry in the unit, an open floor plan and large windows bringing in natural light. The brand new boutique midrise building offers many amenities including virtual doorman services, welcome lobby, business lounge with tv plus a gym fitness center. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Very special full on golf simulator coming soon to the building. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a Winter bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, Whitestone Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball and handball courts. The Rose was creatively designed by Mojo Stumer architects with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Short trip to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary.

    Zillow last checked:

    Listing updated:

    Listed by:

    Michael Misiti 347-539-9893,

    Compass Greater NY LLC 516-517-4751,

    Michael Stanco 917-293-0915,

    Compass Greater NY LLC

    Bought with:

    Debbie Menjivar, 10401281273

    Century 21 AA Realty

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    • Full bathrooms: 2
    Other
    • Description: Ef, Lr, Dr, Eik, Bedroom, Hall Bath, Primary Bedroom En-suite Bathroom, Washer/Dryer
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Refrigerator, Washer, Gas Water Heater
    • Laundry: In Unit
    Features
    • Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Formal Dining, Primary Bathroom
    • Flooring: Hardwood
    • Basement: See Remarks
    • Attic: See Remarks
    Interior area
    • Total structure area: 1,189
    • Total interior livable area: 1,189 sqft

    Property

    Parking
    • Parking features: Garage Door Opener, Covered, Garage, Private
    • Has garage: Yes
    Features
    • Levels: One
    • Exterior features: Mailbox
    Lot
    • Features: Near Public Transit, Near School, Near Shops, Sprinklers In Front

    Construction

    Type & style
    • Home type: Condo
    • Property subtype: Condominium, Residential
    • Attached to another structure: Yes
    Materials
    • Brick, Other
    • Foundation: Other
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2024
    Details
    • Builder model: Unit 313

    Utilities & green energy

    • Water: Public
    • Utilities for property: Trash Collection Public

    Community & HOA

    Community
    • Features: Clubhouse, Pool, Tennis Court(s)
    • Security: Video Cameras
    • Subdivision: The Rose At Great Neck
    HOA
    • Has HOA: No
    • Amenities included: Building Link, Door Person, Trash, Elevator(s), Fitness Center, Park
    • Services included: Maintenance Structure, Other, Snow Removal, Maintenance Grounds
    Location
    • Region: Great Neck

    Financial & listing details

    • Price per square foot: $984/sqft
    • Date on market: 7/31/2024
    • Cumulative days on market: 462 days
    • Listing agreement: Exclusive Right To Sell
    • Inclusions: , Dishwasher, Door Hardware, Dryer, Garage Door Opener, Garage Remote, Mailbox, Microwave, Oven/Range, Refrigerator, Video Cameras, Washer

    Price history

    DateEventPrice
    8/17/2026Listing removed$5,900$5/sqft
    Source: OneKey® MLS as distributed by MLS GRID #1001741 Report a problem
    7/15/2026Price change$5,900-6.3%$5/sqft
    Source: OneKey® MLS as distributed by MLS GRID #1001741 Report a problem
    6/10/2026Price change$6,300-3.1%$5/sqft
    Source: OneKey® MLS as distributed by MLS GRID #1001741 Report a problem
    5/19/2026Listed for rent$6,500$5/sqft
    Source: OneKey® MLS as distributed by MLS GRID #1001741 Report a problem
    5/15/2026Sold$1,170,000-8.6%$984/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3569442 Report a problem
    3/13/2026Pending sale$1,280,600$1,077/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3569442 Report a problem
    9/11/2025Listed for sale$1,280,600$1,077/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3569442 Report a problem
    5/6/2025Pending sale$1,280,600$1,077/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3569442 Report a problem
    8/1/2024Listed for sale$1,280,600$1,077/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3569442 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: Great Neck Estates

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • 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
    $1,191,600
    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,191,600