x
Showing 1 of 0
X
Save

5767 246th UPPER Crescent
Douglaston NY 11362 US

$275,000

Pending Listing ID 1000261
bed icon
1 bed
bath icon
1.00 Bath (1 Full)
home icon
Other

$275,000

Pending Listing ID 1000261
Save

5767 246th UPPER Crescent Brand New! Beech Hills! 1 Bedroom/1 Bath UPPER Unit located in the heart of the quiet tree-lined Community of Beech Hills located in Douglaston/Little Neck. Sunny & bright living room, dining area, renovated kitchen (2025), gas range/oven, dishwasher and refrigerator, microwave, in unit stackable washer/dryer, 1 full updated bath, 2 in wall AC units, new lighting fixtures and an ample number of closets and storage. Bonus: Huge attic storage in the upper units. Spacious Oversized Bedroom with mounted ceiling fan and double door closets. TOTAL Maintenance of $1, 005.69 Includes ALL UTILITIES! (Gas, Heat, Water, Electric), Taxes, Snow removal, Landscaping and Parking (2 Parking Decals Per Unit). Seller Installed private Alarm System. Enjoy outdoor areas to BBQ, Playgrounds, and Water Spray Park. Garages & Storage Units Available for a Fee. No Flip Tax for Buyer! This prime location is close to all transportation (LIRR & Express bus)- a quick commute to NYC, close to all major highways, shopping, parks and zoned for District 26 Schools. Don't Miss out on this Great Opportunity!

Collapse all

Property Features

  • Facts
  • Property Type: Residential Common Interest
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 1
  • Cooling System: Window Unit(s), Wall/Window Unit(s)
  • Heating Fuels: Hot Water(Heating), Steam

School Information

  • School
  • Ps 221 North Hills School(Elementary)
  • Jhs 67 Louis Pasteur(MiddleSchool)
  • Benjamin N Cardozo High School(HighSchool)

Property

  • propertytype: Residential Common Interest
  • propertysubtype: Other
  • listprice: 275000
  • unparsedaddress: 5767 246th UPPER Crescent
  • postalcity: Douglaston
  • stateorprovince: NY
  • country: US
  • postalcode: 11362
  • bathroomsfull: 1
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 700
  • livingareaunits: Square Feet
  • latitude: 40.759033
  • longitude: -73.734322
  • listagentfullname: Elise Alarimo
  • listagentemail: ealarimo@cbamhomes.com
  • listagentkey: 3yd-MLSLINY-120002
  • listagentmlsid: 120002
  • listagentpreferredphone: 5162636009
  • listagentofficephone: 5162636009
  • listofficekey: 3yd-MLSLINY-BRMN02
  • listofficemlsid: BRMN02
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1953
  • listingcontractdate: 2026-05-15
  • listagentfax: 5163343373
  • listagenturl: http://www.cbamhomes.com
  • countyorparish: Queens
  • elementaryschool: Ps 221 North Hills School
  • highschool: Benjamin N Cardozo High School
  • elementaryschooldistrict: Queens 26
  • middleorjuniorschooldistrict: Queens 26
  • highschooldistrict: Queens 26
  • appliances: Dishwasher, Dryer, Gas Oven, Gas Range, Refrigerator, Washer
  • cooling: Window Unit(s), Wall/Window Unit(s)
  • constructionmaterials: Brick
  • heating: Hot Water(Heating), Steam
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • parkingfeatures: Assigned, On Street
  • waterfrontyn: False
  • franchiseaffiliation: Coldwell Banker Real Estate
  • interiorfeatures: First Floor Bedroom, First Floor Full Bath, Ceiling Fan(s), Formal Dining, Galley Type Kitchen, Quartz/Quartzite Counters, Storage, Washer/Dryer Hookup
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bedroom 1, Dining Room
  • otherstructures: Storage
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -73.73432, 40.759033
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Coldwell Banker American Homes", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"ealarimo@cbamhomes.com", "ListBrokerageCity":"East Meadow", "ListBrokerageCountry":"US", "ListBrokerageEmail":"leads0822@leadparser.deltagroup.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/c5ababc31c90dea1011c91901ba23ee5/20210818200407414.png", "ListBrokerageName":"Coldwell Banker American Homes", "ListBrokeragePhone":"(800) 270-6318", "ListBrokeragePostalCode":"11554", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"1856 Hempstead Turnpike", "ListBrokerageWebsiteUrl":"http://www.cbamhomes.com", "ListOfficeAddress1":"10 Stewart Ave ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"BRMN02", "ListOfficeCity":"Hicksville", "ListOfficeCountry":"US", "ListOfficeEmail":"hicksville@cbamhomes.com", "ListOfficePostalCode":"11801", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"COOP - Other - Douglaston, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/5767-246th-Cres-A2_Little-Neck_NY_11362_M98445-47781?f=listhub&s=MLSLINY&m=1000261&c=rexren", "MLSModificationTimestamp":"2026-06-11 01:36:37", "Neighborhoods":[{"Description":null, "Name":"Beech Hills"}], "PostalCode":null, "RoomCount":35, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 6/11/2026 1:49:13 AM GMT
Source Updated Date: 7/3/2026 12:50:12 AM GMT

Courtesy of: Elise Alarimo, Coldwell Banker American Homes, ealarimo@cbamhomes.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.