#863250, Listing office: EXP Realty
214-04 18th Ave Bayside, NY 11360
Property details
About 214-04 18th Ave
Rare Opportunity to own a One-of-a-Kind Mixed-Use Corner Property in Prime Bayside! Located on Bell Blvd in Bay Terrace, this well-maintained corner building features a versatile mixed-use layout: – Two spacious duplex apartments (each with 3 bedrooms & 3 bathrooms, full living and dining rooms, and kitchens) – One established dental office with flexible potential for medical, office, or beauty spa use (nail salon, lash studio, etc.) The first floor unit includes a large private terrace, and the property offers a private parking lot that fits up to 4 vehicles. Lots with natural light and featuring hardwood floors throughout, this property is ideal for those seeking an income-producing investment or an owner-user opportunity to live and operate a business in the same location. Don’t miss this incredible chance to own a multi-functional property in one of Queens’ most desirable neighborhoods!
Highlights
Summary
- Basement: Yes
- Interior: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Entrance Foyer, Formal Dining
- Parking: Parking Lot, Private
- Heating: Natural Gas
- Cooling: Central Air
- List Price: $1,888,000
- Year Built: 1970
- MLS Number: 877512
- MLS Name: ONEKEY2
- Office Name: E Realty International Corp
- Office Phone: (718) 886-8110
Listings courtesy of OneKey MLS as distributed by MLS GRID.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
DMCA NoticeThe data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 6/15/2025, 11:56:26 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$1,888,000
214-04 18th Ave
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
8
P.S. 169 Bay Terrace School
Public District PK-5
0.1 mi
•1825 212th St
8
P.S. 209 Clearview Gardens School
Public Magnet PK-5
0.8 mi
•1610 Utopia Pkwy
8
P.S. 159 School
Public District KG-5
0.8 mi
•20501 33rd Ave
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $75,327. The majority of Bayside, NY residents have income between $35k-100k annually. Residents typically live in single, no kids family. Most residents in this area have post secondary degree education.
Similar homes for sale
Frequently asked questions
About 214-04 18th Ave
The listing price of 214-04 18th Ave property is $1,888,000.
The property 214-04 18th Ave is a multi located in Bayside, New York, 11360.
Coming Soon: 214-04 18th Ave is Coming Soon. This listing has not previously been on the market, but will be on the market soon (no showings are allowed yet). A listing contract has been executed.
The nearby schools for 214-04 18th Ave are: P.S. 169 Bay Terrace School (GreatSchools Rating 8/10), P.S. 209 Clearview Gardens School (GreatSchools Rating 8/10), P.S. 159 School (GreatSchools Rating 8/10), Bell Academy (GreatSchools Rating 8/10), I.S. 25 Adrien Block School (GreatSchools Rating 7/10), J.H.S. 194 William Carr (GreatSchools Rating 7/10), Bayside High School (GreatSchools Rating 8/10), World Journalism Preparatory: A College Board School (GreatSchools Rating 8/10), Benjamin N. Cardozo High School (GreatSchools Rating 6/10).
The year of construction for 214-04 18th Ave is 1970.
This home is located at 214-04 18th Ave in Bayside, NY and zip code 11360 in the Bay Terrace neighborhood. Features: 0 bedroom, 0 bathroom. It has been listed on Rocket Homes since June 13, 2025 and is currently priced at $1,888,000.
Bayside, NY housing market in May 2025 saw over 207 listings sold above listed price, more than 936 sold at listed price and over 737 sold below. Between April and May 2025, Bayside, NY real estate market has seen increase in the number of listings by 0.3%. In May 2025 median list price was $875,081 and the average listing age was 121 days.