Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Realty
Property view
Listing view 2
Listing view 3

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

$1,811,900


3

Beds


2

Baths


1,663

Sq Ft


Condo

Pending

Listed by

Michael Stanco

Michael Misiti

Compass Greater Ny LLC.

Last updated:

January 10, 2026, 09:01 AM

MLS#

947161

Source:

OneKey MLS

About This Home

218 Middle Neck Road #311

Immediate occupancy available in The Rose at Great Neck. 40-New Luxury Condominiums on the North Shore of Long Island. This brand new boutique mid-rise building is now approximately 50% sold out. Offering an unparalleled luxury residential experience and amenities including virtual doorman services, welcome lobby, resident lounge with YouTube TV, plus gym fitness center with treadmill, bike and free weights. 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. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces. 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 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, handball courts and snack bar. The Rose was creatively designed by famed architects Mojo Stumer with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Unit 311 is three bedrooms and two baths, approximately 1,663 sqft, private laundry. Big windows in the condo bring in natural light. 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. Just 0.7 miles 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. Welcome home.

Home Facts

Condo

2 Baths

3 Bedrooms

Built in 2025

Price Summary

1,811,900

$1,089 per Sq. Ft.

MLS #:

947161

Last Updated:

January 10, 2026, 09:01 AM

Added:

16 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2

Interior

Living Area:

1,663 Sq. Ft.


Structure

Structure

Building Area:

1,663 Sq. Ft.

Year Built:

2025


Finances & Disclosures

Finances

Price:

$1,811,900

Price per Sq. Ft:

$1,089 per Sq. Ft.

Source:OneKey MLS
Copyright 2026 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID . OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.