Welcome to Mama Rosa Restaurant, a warm and inviting dining destination located in the heart of Great Neck’s vibrant downtown. Known for its welcoming atmosphere and charm, Mama Rosa offers a space where guests can enjoy comforting flavors, lively conversation, and memorable meals with friends. The restaurant’s cozy interior and neighborhood feel make it the perfect setting for everything from casual lunches too relaxed evening dinners. Situated along the bustling Middle Neck Road corridor in Great Neck, the restaurant benefits from strong foot traffic and a lively local community filled with shops, cafes, and everyday conveniences. Just moments away is the Great Neck LIRR Station, making it easily accessible for both local residents and visitors traveling from other parts of Long Island or Manhattan. With its prime location, neighborhood appeal, and reputation as a welcoming place to gather, Mama Rosa Restaurant represents a wonderful opportunity to enjoy or continue building a beloved dining experience in one of Nassau County’s most active and charming communities.
**VACANT**All Info Should Be Verified By Buyer. Commercial Condo for Sale in Desirable Professional Office in Great Neck .1200 sqft Condo Unit for Sale (Medical or Professional) 4 Separate Offices+ Reception Area+ Storage Area- and 2 Half Baths. Taxes is $12,000 Maintenance: $1000 per month. -***2 Deeded Parking Spots***. 2 Levels Parking, Doctor Private Parking. Near North Shore Hospital, Train Station and Highway., Additional information: Building Size:35400,Office Pct.:100,Rental Income:Y,vac_perc:100
An extremely rare offering — the only available development site on one of Great Neck’s busiest, highest-traffic commercial corridors. With unmatched visibility, constant vehicular and pedestrian flow, and immediate access to surrounding retail, dining, and residential neighborhoods, this site represents a once-in-a-generation opportunity. In a market defined by long-term ownership and near-zero vacancy, opportunities of this caliber simply do not come to market. Ideal for investors, developers, or end users seeking a premier footprint in one of Long Island’s most supply-constrained and affluent trade areas.
Ultra-prime 1031 exchange investment opportunity in the heart of Great Neck Plaza’s busiest commercial corridor. Fully occupied mixed-use commercial building featuring 10 tenants (5 retail + 5 office) with strong, in-place cash flow. Current annual income exceeds $800,000, delivering a rare close to 7% cap rate in a core, transit-oriented downtown location. The property offers long-term stability with significant upside potential. Located in the Business “B” District, which is undergoing zoning modernization encouraging mixed-use redevelopment, allowing for future value enhancement through reconfiguration or repositioning. Steps from LIRR, surrounded by national and local retailers, restaurants, and essential services. Ideal for investors seeking immediate yield, capital preservation, and future redevelopment or income growth potential in one of Long Island’s most established downtown markets.
Large mix use building in the excellent business district, Prime investment opportunity in the heart of Great Neck, Featuring 2 street level rtail store fronts and office on the 2nd floor, long drive way could park many cars. Excellent foot traffic and close to all shops restaurant, and transporation. must see....
1 Living room, 1 Meeting rooms, 3 Office room, 1 Bathroom. Maintenance $1345/M, around 750 sqft.
Rare opportunity to acquire a modern three-building commercial portfolio with 100 feet of prime Northern Boulevard frontage in the heart of Bayside. The package includes 210-12 Northern Blvd, 210-08 Northern Blvd, and 209-45 45th Road, totaling 11 units with 3 vacancies, including a flagship building delivered vacant. The anchor building features approx. 50’ x 100’ dimensions, tall ceilings, basement parking, and strong potential to build up, offering a rare chance for an end-user, medical group, or anchor tenant to establish a high-visibility presence along one of Queens’ most trafficked corridors. Built between 1999 and 2015, the properties offer modern construction, elevator access, efficient layouts, and low-maintenance systems. Two buildings are elevator-equipped, and the portfolio includes a secure underground garage with 12 parking spaces — a major competitive advantage in this market! Current vacancy creates immediate upside. Pro forma gross income of $913,800 and pro forma NOI of $698,861 (6.36% Cap!) position this asset for a significant performance lift once stabilized. Strategically located less than ½ mile from the Bayside LIRR, with exceptional visibility, access, and long-term tenant demand, this offering is ideal for investors seeking value-add yield, or owner-users looking to control a trophy Northern Blvd footprint.

Great Neck is located in New York. Great Neck, New York has a population of 11,034. Great Neck is more family-centric than the surrounding county with 46.71% of the households containing married families with children. The county average for households married with children is 35.86%.
The median household income in Great Neck, New York is $107,695. The median household income for the surrounding county is $126,576 compared to the national median of $69,021. The median age of people living in Great Neck is 32.9 years.
The average high temperature in July is 85.2 degrees, with an average low temperature in January of 26.3 degrees. The average rainfall is approximately 46.8 inches per year, with 23.3 inches of snow per year.