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.
Pending
$885,000
140-36 247th Street, Rosedale, NY 11422
5beds
2,883sqft
Single Family Residence, Residential
Built in 1920
5,000 Square Feet Lot
$911,300 Zestimate®
$307/sqft
$-- HOA
What's special
- 529 days |
- 9 |
- 0 |
Zillow last checked:
Listing updated:
Listing by:
Douglas Elliman Real Estate 718-631-8900,
Bryan Ecock 347-408-7191
Source: OneKey® MLS as distributed by MLS GRID,MLS#: L3593050
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
Bedroom 1
- Description: bedroom
- Level: First
Bedroom 1
- Description: bedroom
- Level: First
Bedroom 1
- Description: bedroom
- Level: Second
Bedroom 1
- Description: bedroom
- Level: Second
Bathroom 1
- Description: bath
- Level: First
Other
- Description: full
- Level: Basement
Other
- Description: Attic, currently used as a bedroom
Dining room
- Description: dining area
- Level: Second
Kitchen
- Description: kitchen
- Level: First
Kitchen
- Description: kitchen
- Level: Second
Living room
- Description: living room
- Level: First
Living room
- Description: living room
- Level: Second
Heating
- Hot Water
Cooling
- None
Appliances
- Included: Gas Water Heater
Features
- Basement: Full
- Attic: Full
Interior area
- Total structure area: 2,883
- Total interior livable area: 2,883 sqft
Property
Parking
- Parking features: Driveway, Private
- Has uncovered spaces: Yes
Features
- Levels: Two
Lot
- Size: 5,000 Square Feet
- Dimensions: 50 x 100
Details
- Parcel number: 135980059
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence, Residential
Condition
- Year built: 1920
Utilities & green energy
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Rosedale
Financial & listing details
- Price per square foot: $307/sqft
- Tax assessed value: $709,000
- Annual tax amount: $6,822
- Date on market: 11/25/2024
- Cumulative days on market: 360 days
- Listing agreement: Exclusive Agency
Estimated market value
$911,300
$820,000 - $1.01M
$3,836/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/24/2025 | Pending sale | $885,000$307/sqft |
Source:  Douglas Elliman #L3593050 Report a problem | ||
| 3/10/2025 | Contingent | $885,000$307/sqft |
Source: StreetEasy #S1744683 Report a problem | ||
| 2/11/2025 | Pending sale | $885,000$307/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #L3593050 Report a problem | ||
| 11/15/2024 | Listed for sale | $885,000$307/sqft |
Source: Douglas Elliman #23264475 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $42,540 -15.4% |
| 2023 | -- | $50,280 +20.1% |
| 2022 | -- | $41,880 +13.1% |
| 2021 | -- | $37,020 -9% |
| 2020 | $6,345 +5.9% | $40,680 -3.3% |
| 2019 | $5,991 +6.6% | $42,060 +56.5% |
| 2018 | $5,621 +8.4% | $26,872 +5.6% |
| 2017 | $5,185 +4.3% | $25,437 |
| 2016 | $4,974 | $25,437 +1.8% |
| 2015 | $4,974 +71.9% | $24,980 +5.9% |
| 2014 | $2,894 | $23,588 +5.3% |
| 2013 | -- | $22,394 +5.6% |
| 2012 | -- | $21,198 |
| 2011 | -- | $21,198 +1.8% |
| 2010 | -- | $20,817 +5.9% |
| 2009 | -- | $19,657 +5.3% |
| 2008 | -- | $18,662 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Rosedale
Nearby schools
GreatSchools rating
- 5/10P.S. / M.S. 138 SunriseGrades: PK-8Distance: 0.3 mi
- 5/10Excelsior Preparatorty High SchoolGrades: 9-12Distance: 1.3 mi
- 4/10Collaborative Arts Middle SchoolGrades: 6-8Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Ps/Ms 138 Sunrise
- Middle: Collaborative Arts Middle School
- High: Excelsior Prep High School
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other New York Topics
