Gretchen A. Loomis
Licensed Associate Real Estate Broker & Branch Manager
Accredited Buyer Representative, Certified Real Estate Brokerage Manager, Coldwell Banker Diamond Society, Coldwell Banker Multi-Million Dollar, Coldwell Banker Premier Office, Equal Housing Opportunity, Realtor, Year round homes, Starter homes, Camps, Seasonal cottages, Small farms, NYS canal area, Streams, Oneida Lake, Rivers, Acreage, Fish Creek, Commercial properties, Older homes and New construction, REALTOR®
Sylvan Beach, NY
Cell: (315) 264-3548 Office: (315) 762-4032 Fax: (315) 762-4070
social icon social icon 

42-29 217th Street , Bayside, NY 11361

New - 7 Hours Ago
View Full Photo Gallery

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 gretchen-loomis.coldwellbankerprime.com today.

Gallery

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

$ 6,856.23 per month $4,840.61 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)

Demographics

Listed By / Shown By

Listing By

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

Shown By

Agent Name: Gretchen A. Loomis
Agent Phone: (315) 264-3548 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

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/07/2026. The listing information on this page last changed on 04/07/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 Tue 04/07/2026 12:00:38 AM EST) or Global MLS (last updated Mon 04/06/2026 11:52:02 PM EST) or New York State Alliance MLS (last updated Mon 04/06/2026 11:58:34 PM EST) or Hudson Valley Catskill Region MLS (last updated Mon 04/06/2026 11:51:14 PM EST) or OneKey MLS (last updated Mon 04/06/2026 11:53:07 PM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties 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.



C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell Banker®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. 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.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel