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
$898,200 Zestimate®
$307/sqft
$-- HOA
What's special
- 409 days |
- 13 |
- 0 |
Zillow last checked: 8 hours ago
Listing updated: February 11, 2025 at 12:04pm
Listing by:
Douglas Elliman Real Estate 718-631-8900,
Bryan Ecock 347-408-7191
Source: OneKey® MLS,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: 239 days
- Listing agreement: Exclusive Agency
Estimated market value
$898,200
$808,000 - $997,000
$5,009/mo
Price history
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 #L3593050 Report a problem | ||
| 11/15/2024 | Listed for sale | $885,000$307/sqft |
Source: Douglas Elliman #23264475 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $42,540 -15.4% |
| 2023 | -- | $50,280 +20.1% |
| 2022 | -- | $41,880 +13.1% |
Find assessor info on the county website
BuyAbility℠ payment
Estimated monthly payment
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
Neighborhood: Rosedale
Nearby schools
GreatSchools rating
- 4/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. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
