Date
Details
Price
Change
Source
6/27/2024
Listed
$1,791,900
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/29
$1,791,900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/29
Property Description
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 over 40% 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 111 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.
Full Property Details
Full Property Details for 218 Middle Neck Rd #111
General
- Price: $1,791,900
- Status: Active
- Type: Condo
- Source: Long_Island
- MLS ID: L3562126
- Updated: 10/2/2025
- Added to Site: 569 day(s) ago
Interior
- Number of Rooms: 8
- Interior Features: Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Master Downstairs, Pantry, Walk-In Closet(s), Formal Dining, First Floor Bedroom
- Appliances: Gas Water Heater, Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Washer
- Laundry Facilities: Yes
- Flooring: Hardwood
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
Bedrooms
- Total Bedrooms: 3
Other Rooms
- Laundry: In Unit
Additional Information
- Amenities: Pool, Tennis Court(s)
- Shared Amenities: Elevator(s), Fitness Center, Park, Building Link, Door Person, Trash
- Security/Safety: Fire Sprinkler System
Exterior
- Exterior Features: Mailbox
- Porch/Patio/Deck: Deck
Parking
- Garage: Yes
- Parking Features: Attached, Garage, Off Street, Parking Lot, Garage Door Opener
Location
- County: Nassau County
- Subdivision: The Rose At Great Neck
- Cross Streets: Clover Drive
- Driving Directions: 25A/Northern Blvd to Middle Neck Rd heading north to #218 Middle Neck Rd on left. Enter new property and park in front outside.
School Information
- High School District: Great Neck
- Elementary School: Saddle Rock School
- Middle School: Great Neck North Middle School
- High School: Great Neck North High School
Community
- Assoc. Fees Include: Exterior Maintenance, Other, Snow Removal, Trash
- Pets Allowed: Yes
- Pet Restrictions: Call
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Natural Gas, Forced Air
- Heating Zones: 2
Utilities
- Water: Public
- Utility Description: Cable Connected, Electricity Connected, Natural Gas Connected, See Remarks, Sewer Connected, Trash Collection Public, Water Connected
Structural Information
- Detached/Attached: Attached
- Construction: Other, Brick
- Basement: Yes
- Basement Desc.: See Remarks
- Common Walls: End Unit
- Windows: Floor to Ceiling Windows, Screens
- Entry Floor Number: 1
- Stories/Levels: 3
- Stories in Building: 3
- Sq. Ft. Source: Plans
- Year Built: 2024
Lot Features
- Lot Features: Near Public Transit, Near School, Near Shops, Sprinklers In Front, Sprinklers In Rear
Financial Considerations
- Taxes Include: Sewer
Disclosures and Reports
- Inclusions: , Cook Top, Dishwasher, Dryer, Garage Door Opener, Garage Remote, Mailbox, Microwave, Oven/Range, Refrigerator, Screens, Washer
Listed by Compass Greater NY LLC
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 218 Middle Neck Rd #111 —
Compass Greater NY LLC
Compass Greater NY LLC
917-293-0915
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 218 Middle Neck Rd #111
School District:Great Neck Public Schools
| Name | Grades | Distance |
|---|---|---|
Saddle Rock School 10 Hawthorne Lane, Great Neck, NY 11023 | K-5 | 0.6 mi |
Great Neck North Middle School 77 Polo Road, Great Neck, NY 11023 | 6-8 | 0.7 mi |
Great Neck South Middle School 349 Lakeville Rd, Great Neck, NY 11020 | 6-8 | 2.6 mi |
Great Neck North High School 35 Polo Road, Great Neck, NY 11023 | 9-12 | 0.5 mi |
Great Neck South High School 341 Lakeville Rd, Great Neck, NY 11020 | 9-12 | 2.6 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 218 Middle Neck Rd #111
Estimate the Cost
Estimate the Cost for 218 Middle Neck Rd #111
218 Middle Neck Road #111, Great Neck, NY 11021 (MLS# L3562126) is a Condo property with 3 bedrooms and 2 full bathrooms. 218 Middle Neck Road #111 is currently listed for $1,791,900 and was received on June 27, 2024. Want to learn more about 218 Middle Neck Road #111? Do you have questions about finding other Condo real estate for sale in Great Neck? You can browse all Great Neck real estate or contact a Coldwell Banker agent to request more information.