Sign up to get new listings emailed daily! JOIN SIGN IN
Dawn Viola
Associate Real Estate Broker
REALTOR®
Cell: (631) 774-4369
Facebook Icon LinkedIn Icon GoogleBusiness Icon Blog Icon Realtor.com Icon Homes.com Icon Zillow Icon VCard Icon 
Refine Search

42-29 217th Street , Bayside, NY 11361

$2,175,000
  • 42-29 217th Street , Bayside, NY 11361 Main Photo

40 Total Photos [Click to View All]

New to the Market Active
BEDS7 BATHS5 full MLS#973542
STATUSActive PROPERTY TYPEMulti Unit - Multiple SCHOOLQueens 26

Property Description

Bayside North - First Time On The Market! Rare Detached Legal 3 Family Opportunity! Built To Last by an old world craftsman! This custom-built Solid Brick & Block residence on a 50X100 lot has only had one owner. Built in 1969 as a 2 family it was legally converted to a 3 family in 2000. This residence features two 3 bedroom/2 bath units and one 1 bedroom/1 bath unit, each with a private entrance. Long driveway, rear yard, built in garage, and additional parking. Being delivered fully vacant with no existing leases, this is a great opportunity to collect current fair market rents either by owner occupants looking for an income, or investors. This home was originally designed and built for multi-generational living under one roof offering plenty of privacy. Prime Queens County location Near All NYC Conveniences and amenities. Top-Rated District #26 Public Schools, Public Transportation, L.I.R.R, Houses Of Worship, Public Parks, Great Shopping, A Plethora Of Nearby Options For Fine And Casual Dining of International Cuisines, Pubs and Cafes. Short Distance To The Bay Terrace Shopping Center, Oakland Lake, The Wide-open Greenspaces Of John Golden & Crocheron Parks. Pride Of Ownership Reflects Throughout This Community Of Well-Maintained Homes. This property is being sold As Is. All information comes from sources believed to be reliable but not guaranteed and should be INDEPENDENTLY verified by purchaser(s). This includes, but is not limited to the verification of the year built, legal use and occupancy, real estate taxes, neighborhood school information and current zoning. All measurements are approximate are are for general informational purposes only and may be subject to errors. All offers subject to financing must be accompanied by a current and legible preapproval letter together with proof of funds. All offers represented as no mortgage contingency or ALL CASH will also be required to provide proof of funds.

42-29 217th Street | MLS# 973542

This multi-family property located at 42-29 217th Street , Bayside, NY 11361 is currently listed for sale with an asking price of $2,175,000. 42-29 217th Street is located within the Queens 26 school district. Search Bayside real estate on www.dawnviolarealtor.com today.

Property Features

Property Type: Multi Unit - Multiple
Basement: None
Cooling: Air Purification System, Central Air
Garage: 1
Heating: Forced Air, Hot Air, Natural Gas
Home Style: Colonial
Lot Size: 0.11 Acres
Taxes: $16,575
Year Built: 1969

Amenities

First Floor Bedroom
First Floor Full Bath
Eat-in Kitchen
Entrance Foyer
Storage

Feature Descriptions

Building Area Total: 3526
Community Features: Park, Playground, Tennis Court(s)
Exclusions: Top floor - 1 Dining Area Lighting Fixture - to be replaced
Exterior: Block, Brick
Fencing: Back Yard, Chain Link, Front Yard
Flooring: Hardwood
GarageY/N: Yes
Heating Units: 2
Heating Zones: 2
House Faces: West
Included In Taxes: Sewer, Trash
Laundry: Laundry Room
Lot Dimensions: 50 x 100
Lot Features: Back Yard, Cul-De-Sac, Front Yard, Landscaped, Near Public Transit, Near School, Near Shops
On Market Date: 2026-04-06
Parking Features: Driveway
Parking Total: 3
Patio And Porch: Patio
Rental Term: Monthly
Security: yes
Security Features: Fire Sprinkler System, Security Lights, Security System
Separate Electric Meters: 2
Separate Gas Meters: 2
Sewer: Public Sewer
Units: 3
Utilities: Cable Available, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water: Public

Local Schools

High School: Bayside High School
Middle School: Ms 158 Marie Curie
Elementary School: Ps 31 Bayside
School District: Queens 26

Estimate Your Payment

Estimated Payment

$ 13,013.61 per month $10,997.98 Principal & Interest $1,381.25 Property Tax $634.38 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Listed By / Shown By

Listing By

Agency Name: Northeast Real Estate Company
Agency Contact: 718-428-8877

agent picture

Shown By

Agent Name: Dawn Viola
Agent Phone: Cell: (631) 774-4369
Agency Title: Coldwell Banker American Homes

IDX logo

©2024 1864 Hempstead Turnpike Realty Inc. All rights reserved. Coldwell Banker® and the Coldwell Banker Logo are registered service marks owned by Coldwell Banker Real Estate LLC. 1864 Hempstead Turnpike Realty Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each office is independently owned and operated. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies. Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 04/06/2026. The listing information on this page last changed on 04/06/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Mon 04/06/2026 4:39:36 AM EST) or OneKey MLS (last updated Sun 04/05/2026 1:45:14 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker American Homes may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX 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, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the 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.



Privacy Policy / DMCA Notice / ADA Accessibility


Agent License Information: Associate Real Estate Broker

Login to My Homefinder

Pixel