Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,628,000

  • For Sale
  • Active
  • Multi-Family
  • 5 Total Beds
  • 2 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Prime Bayside Legal 2-Family | Rare Triplex Owner Residence | 2 Garages Beautifully maintained legal 2-family home featuring a spacious 3-bedroom triplex owner's residence that lives like a single-family home, plus a separate 1-bedroom rental apartment providing strong income potential. A finished lower level currently configured as additional living space offers flexible use and potential bonus income (buyer to verify). Diamond condition and move-in ready. Highlights include: "¢ Approx. 2,628 SF interior "¢ Rare 2 private garages + driveway parking "¢ Low annual taxes (~$13,200) "¢ Flexible layout ideal for owner-occupants or investors Conveniently located near Bay Terrace Shopping Center, Little Neck Bay waterfront, Fort Totten Park, schools, and express buses to Manhattan. Vacant delivery available. By appointment only.

Full Property Details for 215-40 23rd Ave

General

  • Price: $1,628,000
  • Taxes: $12,790
  • Status: Active
  • Type: Multi-Family
  • Source: Long_Island
  • MLS ID: 963703
  • Updated: 3/9/2026
  • Added to Site: 48 day(s) ago

Interior

  • Interior Features: First Floor Bedroom
  • Laundry Facilities: Yes
  • Flooring: Hardwood

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 4

Bedrooms

  • Total Bedrooms: 5

Other Rooms

  • Laundry: In Basement

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking Features: Driveway

Location

  • County: Queens
  • Cross Streets: Water edge drive
  • Driving Directions: See Google.com

School Information

  • High School District: Queens 26
  • Elementary School: Ps 169 Bay Terrace
  • Middle School: Bell Academy
  • High School: Bayside High School

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air
  • Heating Type: Forced Air, Hot Air

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Electricity Available, Natural Gas Available, Water Available

Structural Information

  • Architectural Style: Contemporary
  • Detached/Attached: Attached
  • Construction: Brick, Frame
  • Basement: Yes
  • Basement Desc.: Finished
  • Building Size: 2628
  • Square Feet: 2,628
  • Year Built: 1970

Lot Features

  • Lot Size (Acres): 0.0758
  • Lot Size (Sq. Ft.): 3,300

Financial Considerations

  • Tax Amount: $12,790.92

Disclosures and Reports

  • Special Conditions: None
  • Property ID: 05952-0003

Listed by B Square Realty

Quickly Find Out More

* Indicates a required field

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 Send Message, 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 an 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.

We Value Your Privacy

Listing agent

— 215-40 23rd Ave —

  • B Square Realty

718-353-0225

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 215-40 23rd Ave

School District:New York City Geographic School District 25
NameGradesDistance
P.S. 169 Bay Terrace
18-25 212th St, Queens, NY 11360
PK-50.2 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 215-40 23rd Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
3/09/2026
Price Reduced
$1,628,000
-1.27%
MLS
2/20/2026
Listed
$1,649,000
67.41%
MLS
11/26/2013
Sold
$985,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 215-40 23rd Ave

Year
Property Taxes
Change
Tax Assessment
Change
2025
$13,558
6%
$68,925
-16%
2024
$12,779
6%
$82,020
34%
2023
$12,040
2%
$61,344
-32%
2022
$11,758
-3%
$90,300
15%
2021
$12,105
13%
$78,600
6%
2020
$10,668
7%
$74,280
7%
2019
$9,980
2%
$69,480
36%
2017
$9,784
—
$51,120
3%
2017
$9,784
3%
$49,464
1%
2016
$9,506
5%
$49,104
3%
2015
$9,051
159%
$47,865
6%
2014
$3,491
10%
$45,156
6%
2013
$3,167
—
$42,600
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 215-40 23rd Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Listed by B Square Realty

Similar Properties near 215-40 23rd Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

43-18 215th Pl, Bayside, NY 11361 - Photo 1
$1,598,000
Open House

43-18 215th Pl  Bayside, NY 11361

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by Jamie Realty Group
47-25 212th St, Bayside, NY 11361 - Photo 1
$1,498,000
Open House

47-25 212th St  Bayside, NY 11361

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by P R O Links Realty Inc
208-04 47th Ave, Bayside, NY 11361 - Photo 1
$1,698,000

208-04 47th Ave  Bayside, NY 11361

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by E Realty International Corp
208-02 47th Ave, Bayside, NY 11361 - Photo 1
$1,698,000

208-02 47th Ave  Bayside, NY 11361

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by E Realty International Corp

Just Listed near 215-40 23rd Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

3-35 Warwick Ave, Douglaston, NY 11363 - Photo 1 Just Listed
$1,099,000

3-35 Warwick Ave  Douglaston, NY 11363

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 1,544
    Sq. Ft.
Listed by Keller Williams Rlty Landmark
1-27 Beverly Rd, Douglaston, NY 11363 - Photo 1 Just Listed
$5,398,000

1-27 Beverly Rd  Douglaston, NY 11363

  • Single Family
  • Active
  • Updated 10 hours ago
  • 6
    Beds
  • 7
    Total Baths
  • 5,200
    Sq. Ft.
Listed by Jason Mitchell Real Estate NY
246-15 57th Dr, Douglaston, NY 11362 - Photo 1 Just Listed
$458,000
Open House

246-15 57th Dr  #Upper  Douglaston, NY 11362

  • Co-op
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 1
    Total Bath
Listed by Chous Realty Group Inc
251-67 61st Ave, Little Neck, NY 11362 - Photo 1 Just Listed
$350,000
Open House

251-67 61st Ave  #693  Little Neck, NY 11362

  • Co-op
  • Active
  • Updated 9 hours ago
  • 2
    Beds
  • 1
    Total Bath
Listed by Daniel Gale Sothebys Intl Rlty

21540 23rd Avenue, Bayside, NY 11360 (MLS# 963703) is a Multi-Family property with 2 units containing 5 bedrooms and 4 full bathrooms. 21540 23rd Avenue is currently listed for $1,628,000 and was received on February 20, 2026. Want to learn more about 21540 23rd Avenue? Do you have questions about finding other Multi-Family real estate for sale in Bayside? You can browse all Bayside real estate or contact a Coldwell Banker agent to request more information.

Tour this property