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
$914,800 Zestimate®
$307/sqft
$-- HOA
What's special
- 617 days |
- 5 |
- 0 |
Zillow last checked:
Listing updated:
Listed 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
- Natural Gas, 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
Materials
- Frame
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: $850,000
- Annual tax amount: $6,822
- Date on market: 11/25/2024
- Cumulative days on market: 145 days
- Listing agreement: Exclusive Agency
Estimated market value
$914,800
$823,000 - $1.02M
$5,598/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 |
|---|---|---|
| 2025 | -- | $51,000 +19.9% |
| 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
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
- 5/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.
- $914,100-- bd-- ba2.3k sqft14037 247th St, Rosedale, NY 11422Off Market
- $406,000-- bd-- ba1.3k sqft249 46th Ave #46, Jamaica, NY 11422Off Market
- $489,100-- bd-- ba-- sqft10-31A Cross Island Plz #31A, Rosedale, NY 11422Off Market
- $528,000-- bd-- ba-- sqft10-31A Cross Island Plz #31A, Rosedale, NY 11422Off Market
- $689,000-- bd-- ba2.2k sqft258 39afran Lewis Blvd, Rosedale, NY 11422Off Market
- $689,000-- bd-- ba2.2k sqft258 39afran Lewis Blvd, Rosedale, NY 11422Off Market
- $709,0003 bd1 ba-- sqft12 Undisclosed Address, Rosedale, NY 11422Off Market
- $845,0003 bd3 ba-- sqft0 Brookville Blvd, Rosedale, NY 11422Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $889,9905 bd2 ba1.7k sqft11510 Van Wyck Expressway, South Ozone Park, NY 11420For Sale
MLS ID #1032388, Rajesh Ramjeawan, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID - $819,0005 bd3 ba1.5k sqft101-30 224th Street, Queens Village, NY 11429For Sale
MLS ID #1032360, Martin A. Dabao, Listing by: Realty Executives Today. OneKey® MLS as distributed by MLS GRID - $725,0005 bd3 ba1.4k sqft13360 244th Street, Rosedale, NY 11422For Sale
MLS ID #998695, Kenneth McKnight, Listing by: LAFFEY REAL ESTATE. OneKey® MLS as distributed by MLS GRID - $775,0003 bd3 ba1.7k sqft11545 172nd Street, Jamaica, NY 11434For Sale
MLS ID #1033181, Curtis A. White, Listing by: Transparent Realty LLC. OneKey® MLS as distributed by MLS GRID - $879,9994 bd3 ba2k sqft2440 Wallen Lane, Bellmore, NY 11710For SaleMLS ID #1034772, Nicole M. Arminio, Listing by: Voro LLC. OneKey® MLS as distributed by MLS GRID
- $899,0003 bd2 ba1.5k sqft8819 Billings Street, Bellerose, NY 11427For SaleMLS ID #1029654, Justin Chew, Listing by: RE/MAX 1st Choice. OneKey® MLS as distributed by MLS GRID
- $949,9905 bd3 ba2.1k sqft147-23 225th Street, Springfield Gardens, NY 11413For SaleMLS ID #1027971, Kenny Kamil Sattaur, Listing by: RE/MAX Southshore Realty. OneKey® MLS as distributed by MLS GRID
- $950,0005 bd3 ba2.3k sqft214 Lowell Avenue, Floral Park, NY 11001For SaleMLS ID #1030042, Michael J. Rose, Listing by: OverSouth LLC. OneKey® MLS as distributed by MLS GRID
- $995,0003 bd3 ba1.4k sqft17519 74th Avenue, Fresh Meadows, NY 11366For SaleMLS ID #1034581, Solomon Davydov, Listing by: Exit Realty First Choice. OneKey® MLS as distributed by MLS GRID
- $899,0004 bd3 ba2.3k sqft33 N Tyson Avenue, Floral Park, NY 11001For SaleMLS ID #1021605, James A. McGuire CBR, Listing by: Andron Realty Group Tulip R E. OneKey® MLS as distributed by MLS GRID
- $989,0004 bd2 ba1.5k sqft407 Sheridan Boulevard, Inwood, NY 11096For SaleMLS ID #1015857, Tina Rossetti, Listing by: Signature Premier Properties. OneKey® MLS as distributed by MLS GRID
- $859,0004 bd3 ba1.4k sqft8050 88th Road, Woodhaven, NY 11421For SaleMLS ID #998139, Neal J. Khoorchand, Listing by: Century 21 Professional Realty. OneKey® MLS as distributed by MLS GRID
- $789,0003 bd2 ba1.7k sqft182-26 143rd Avenue, Springfield Gardens, NY 11413For SaleMLS ID #966766, Charlemagne Benjamin CBR, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID
- $898,0004 bd2 ba2k sqft94 Union Place, Lynbrook, NY 11563For SaleMLS ID #1003444, Elizabeth A. John, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID
- $995,0005 bd3 ba1.9k sqft8905 Moline Street, Queens Village, NY 11428For SaleMLS ID #976852, Reema Sharma, Listing by: S H V Real Estate Corp. OneKey® MLS as distributed by MLS GRID
- $749,0004 bd3 ba3.2k sqft1046 Dickens Street, Far Rockaway, NY 11691For SaleMLS ID #981541, Mathias Coni, Listing by: Oversouth LLC. OneKey® MLS as distributed by MLS GRID
- $899,0884 bd3 ba1.8k sqft130 Custer Avenue, Williston Park, NY 11596For SaleMLS ID #973019, Janell Giordano, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID
- $649,9993 bd3 ba1.7k sqft2474 Harrison Avenue, Baldwin, NY 11510For SaleMLS ID #1034264, Nicholas Santillo, Listing by: Signature Premier Properties. OneKey® MLS as distributed by MLS GRID
- $850,0005 bd2 ba2.5k sqft3357 Lawrence Avenue, Oceanside, NY 11572For SaleMLS ID #904729, Jovanny Rodriguez CBR, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID
- $819,0004 bd2 ba1.6k sqft78 Ambrose Avenue, Malverne, NY 11565For SaleMLS ID #1023937, Paige A. McManus, Listing by: Douglas Elliman Real Estate. OneKey® MLS as distributed by MLS GRID
