Get new listings emailed daily! JOIN SIGN IN
Janet Berookhim
Licensed Associate Broker, SRES, CBR jberookhim@laffeyre.com Mobile 516-263-7072
REALTOR®, Mobile 516-263-7072
Cell: (516) 263-7072
Facebook Icon LinkedIn Icon Instagram Icon Zillow Icon 
Refine Search

140-36 247th Street, Rosedale, NY 11422

$885,000
  • 140-36 247th Street, Rosedale, NY 11422 Main Photo

29 Total Photos [Click to View All]

Agent photo

Janet Berookhim
Call: (cell) (516) 263-7072
Text: (516) 263-7072

Pending
BEDS5 BATHS3 full SQUARE FEET2,883 MLS#L3593050
STATUSPending PROPERTY TYPEResidential - Single Family SCHOOLQueens 29

Property Description

This well-maintained colonial home, located in the heart of Rosedale Queens, offers an amazing blend of classic charm and modern living. Nestled on a quiet, tree-lined street, this spacious property is absolute for anyone looking for comfort, convenience, and a welcoming neighborhood. Enjoy five generous bedrooms and three bathrooms, providing ample space for living. The finished basement adds extra living space for a home office, gym, or play area, plus additional storage and laundry. Relax or entertain in the large, private backyard, complete with a fenced-in area for kids and pets. A private driveway offers off-street parking, extra storage, or parking spaces. Rosedale offers easy access to major highways, the LIRR, and public transportation, making commuting effortless. Enjoy nearby shopping, dining, and parks, all within minutes.

140-36 247th Street | MLS# L3593050

This single family home located at 140-36 247th Street, Rosedale, NY 11422 is currently listed for sale with an asking price of $885,000. This property was built in 1920 and has 5 bedrooms and 3 full baths with 2883 sq. ft. 140-36 247th Street is located within the Queens 29 school district. Search Rosedale real estate on janetberookhim.laffey.com today.

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: Full
Cooling: None
Heating: Natural Gas, Hot Water
Lot Size: 0.11 Acres
Taxes: $6,822
Year Built: 1920

Feature Descriptions

Appliances: Gas Water Heater
Attic: Full
Days on Site: 503
Exterior: Frame
Lot Dimensions: 50x100
Number Of Kitchens: 2
On Market Date: 2024-11-25
Parcel Number: 13598-0059
Parking Features: Driveway, Private
Rental Term: Monthly
Rooms Total: 9
Units: 1
Water: Public

Local Schools

High School: Excelsior Prep High School
Middle School: Collaborative Arts Middle School
Elementary School: Ps/Ms 138 Sunrise
School District: Queens 29

TOUR THIS HOME

Choose a date and time to see 140-36 247th Street, Rosedale, NY 11422.
An agent will get in touch to confirm your request shortly.

Choose your video chat app
Request a Showing
  • Monday April 13
  • Tuesday April 14
  • Wednesday April 15
  • Thursday April 16
  • Friday April 17
  • Saturday April 18
  • Sunday April 19
  • Monday April 20
  • Tuesday April 21
  • Wednesday April 22
  • Thursday April 23
  • Friday April 24
  • Saturday April 25
  • Sunday April 26
  • Monday April 27
  • 7:00 AM
  • 7:30 AM
  • 8:00 AM
  • 8:30 AM
  • 9:00 AM
  • 9:30 AM
  • 10:00 AM
  • 10:30 AM
  • 11:00 AM
  • 11:30 AM
  • 12:00 PM
  • 12:30 PM
  • 1:00 PM
  • 1:30 PM
  • 2:00 PM
  • 2:30 PM
  • 3:00 PM
  • 3:30 PM
  • 4:00 PM
  • 4:30 PM
  • 5:00 PM
  • 5:30 PM
  • 6:00 PM
  • 6:30 PM
  • 7:00 PM
  • 7:30 PM
  • 8:00 PM
  • 8:30 PM
  • 9:00 PM
Preferred Communication Method

Estimate Your Payment

Estimated Payment

$ 2,796.25 per month $1,969.63 Principal & Interest $568.50 Property Tax $258.13 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: Douglas Elliman Real Estate
Agency Contact: 718-631-8900

Shown By

Agent Name: Janet Berookhim
Agent Phone: Cell: (516) 263-7072
Agency Title: Laffey Real Estate

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/12/2026. The listing information on this page last changed on 04/12/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 Sun 04/12/2026 12:00:42 AM EST) or OneKey MLS (last updated Sat 04/11/2026 11:53:10 PM EST). Real estate listings held by brokerage firms other than Laffey Real Estate 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

Login to My Homefinder

Pixel