Beautifully renovated 4-bedroom, 2.5-bath home located in School District 26. This move-in-ready residence features hardwood floors throughout, updated electrical and plumbing systems, a finished basement, attic space, and a newly constructed backyard deck ideal for outdoor enjoyment. Conveniently located near the LIRR, local parks, shopping, dining, public transportation, and major bus routes including the Q12 to Flushing. Enjoy easy access to everyday amenities while living in a well-maintained residential setting. A wonderful opportunity to own a thoughtfully updated home with generous living space and excellent convenience.
Listed by Weilian Jo
·
P R O Links Realty Inc
·
718-487-9992
Last updated June 14, 2026
·
Source: OneKey #999588
Listing Facts
TypeSingle-family
NeighborhoodDouglaston
Bedrooms4
Bathrooms3
Days on Prevu34
Taxes$5,217/year
Size1,080 sqft
Price per sqft$832
Amenities
Dishwasher
Washer/Dryer
Parking
Location
Mortgage Calculator
Listing History
06/04/2026
Status changed to Active
$899,000
05/28/2026
Status changed to Temporarily Off Market
$899,000
05/13/2026
Listed by P R O Links Realty Inc
$899,000
Estimated Closing Costs
Total
$27,390
Attorney Fees
$4,000
Title Insurance
$4,046
Bank Attorney
$1,500
Mortgage Recording Tax
$13,844
Other Closing Costs
$4,000
Estimated closing costs are based on the list price of $899,000 and a 20% downpayment. These estimates are for indicative purposes only. Actual closing costs may vary for each transaction. See the Closing Costs Calculator for calculations specific to your situation.
Interior Features: First Floor Bedroom, Eat-in Kitchen, Marble Counters, Pantry
Measurements
Living Area: 1,080
Living Area Source: Public Records
Rooms
Basement: Finished, Full
Has Basement: Yes
Bathrooms Full: 2
Bathrooms Half: 1
Bathrooms Total Integer: 3
Bedrooms Total: 4
Rooms Total: 7
Parking
Parking
Garage Spaces: 1
Garage: Yes
Parking Features: Parking Lot
Schools
Elementary School
Elementary School: Ps 94 David D Porter
Elementary School District: Queens 26
High School
High School: Benjamin N Cardozo High School
High School District: Queens 26
Middle or Junior School
Middle Or Junior School: Jhs 67 Louis Pasteur
Middle Or Junior School District: Queens 26
Utilities
Equipment
Cooling: ENERGY STAR Qualified Equipment
Heating: Baseboard, Hot Water, Natural Gas
Sewer: Public Sewer
Utilities: Cable Available, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available, Sewer Available, Sewer Connected, Trash Collection Public, Water Available, Water Connected
Water Source: Public
Frequently Asked Questions
How many bedrooms and bathrooms does this single-family home have?
There are 4 bedrooms and 3 bathrooms in this single-family home at 40-08 247th Street.
What schools are nearby to 40-08 247th Street?
Nearby schools include the Ps 94 David D Porter Elementary School, Jhs 67 Louis Pasteur Middle School, and Benjamin N Cardozo High School.
Does this single-family home have parking?
Yes, there is 1 parking space available for 40-08 247th Street.
What are the annual taxes for 40-08 247th Street?
Annual taxes for this single-family home are estimated at $5,217.
How does 40-08 247th Street compare to other single-family homes in Douglaston?
This single-family home is listed 52% below the average price for single-family homes in Douglaston and has been on the market for 61 less days than the typical home in this area.
What is the square footage on this single-family home?
According to the MLS, this listing is 1,080 sqft.
40-08 247th Street is a 4-bedroom, 3-bath single-family home for sale in Little Neck NY 11363. On Prevu for 34 days at $899,000. This property features 1,080 square feet of living space, located in Douglaston. The median listing price for single-family homes in this area is $1,135,400. Nearby schools include Ps 94 David D Porter Elementary School, Jhs 67 Louis Pasteur Middle School, and Benjamin N Cardozo High School. Additional amenities include dishwasher, parking, and washer/dryer. Explore more single-family home listings in Queens.
The data relating to real estate for sale on this website comes in part from the IDX
Program of OneKey™ MLS. The source of the displayed data is either the property owner
or public record provided by non-governmental third parties. It is believed to be reliable
but not guaranteed. This information is provided exclusively for consumers’ personal,
non-commercial use. Information Copyright 2026, OneKey™ MLS. All Rights Reserved.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.