The Rose at Great Neck, New construction building approaching 50% sold out of 40 total new luxury condominiums on the North Shore of Long Island. This brand new mid-rise boutique building has immediate occupancy options. Offering an unparalleled luxury residential experience and amenities including a full array of 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, one of the largest in Great Neck, NY and hang out at the perfect place to unwind with seating and enjoy the outdoors that include views towards New York City Skyline. Private indoor garage parking and outside private parking lot. 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 courts in a Winter bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor, the Throgs Neck Bridge, Whitestone Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball, handball courts and snack bar. The Rose new luxury condominium building 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 2 bedroom and 3 bedroom options in this new building left. Unit 207 is two bedrooms and two baths, approximately 1,117 sqft, has private in unit 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.
New construction
$1,243,100
218 Middle Neck Road #207, Great Neck, NY 11021
2beds
1,117sqft
Condominium, Residential
Built in 2024
-- sqft lot
$-- Zestimate®
$1,113/sqft
$1,071/mo HOA
What's special
Waterfront esplanadeTennis courtsOlympic sized swimming poolRooftop common areaHandball courtsBig windowsStunning bathrooms
- 73 days |
- 223 |
- 4 |
Zillow last checked: 8 hours ago
Listing updated: December 07, 2025 at 12:09pm
Listing by:
Compass Greater NY LLC 516-517-4751,
Michael Stanco 917-293-0915,
Michael Misiti 347-539-9893,
Compass Greater NY LLC
Source: OneKey® MLS,MLS#: 928592
Tour with a local agent
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
- Level: Second
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Dishwasher, Dryer, Microwave, Refrigerator, Washer
- Laundry: In Unit
Features
- Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Primary Bathroom
- Flooring: Hardwood
- Windows: Screens
- Basement: See Remarks
- Attic: See Remarks
- Common walls with other units/homes: Center
Interior area
- Total structure area: 1,117
- Total interior livable area: 1,117 sqft
Video & virtual tour
Property
Parking
- Total spaces: 1
- Parking features: Attached, Covered, Garage, Off Street, Other, Garage Door Opener
- Garage spaces: 1
Features
- Levels: One
- Exterior features: Mailbox
Lot
- Features: Sprinklers In Front, Near Public Transit, Near School
Details
- Special conditions: None
Construction
Type & style
- Home type: Condo
- Architectural style: Other
- 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 207
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected, See Remarks, Sewer Connected, Trash Collection Public, Underground Utilities, Water Connected
Community & HOA
Community
- Features: Clubhouse, Pool, Tennis Court(s)
- Security: Fire Sprinkler System
- Subdivision: The Rose At Great Neck
HOA
- Has HOA: Yes
- Amenities included: Park, Building Link, Trash, Elevator(s), Fitness Center
- Services included: Gas, Maintenance Grounds, Sewer, Trash, Water, Heat, Maintenance Structure, Other
- HOA fee: $1,071 monthly
Location
- Region: Great Neck
Financial & listing details
- Price per square foot: $1,113/sqft
- Date on market: 10/25/2025
- Cumulative days on market: 74 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
Price history
| Date | Event | Price |
|---|---|---|
| 10/25/2025 | Listed for sale | $1,243,100$1,113/sqft |
Source: | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Estimated monthly payment
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
Neighborhood: Great Neck Estates
Nearby schools
GreatSchools rating
- 8/10Saddle Rock SchoolGrades: K-5Distance: 0.6 mi
- 7/10Great Neck North Middle SchoolGrades: 6-8Distance: 0.8 mi
- 9/10Great Neck North High SchoolGrades: 9-12Distance: 0.5 mi
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. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading





