x
Showing 1 of 0
X
Save

42-46 247th Street
Little Neck NY 11363 US

$1,498,000

Active Listing ID 985292
lot icon
Lot: 0.11 Acres
home icon
Other

$1,498,000

Active Listing ID 985292
Save

42-46 247th Street Whether you're looking to live in, generate rental income, or build a larger custom 2-family home, this property presents a rare opportunity in one of Queens' most desirable neighborhoods. Located in the heart of Little Neck, Queens, this 2-family home , Zoned R3-1 offers space, flexibility, and exceptional potential. Featuring 4 bedrooms, 2 full bathrooms, a spacious kitchen, formal dining room, inviting living room, and a home office / sitting room, this property is ideal for both end-users and investors alike. Situated within a top-rated public school district # 26, this home provides both comfort and long-term value. Its convenient location offers easy access to the LIRR, MTA buses, schools, shopping, dining, and everyday essentials. R3-1 Zoning: The 0.5 FAR (Floor Area Ratio) may be increased by an attic allowance of up to 20% for the inclusion of a space beneath a pitched roof. The perimeter wall may rise to 21 feet before sloping or being set back to a maximum building height of 35 feet.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.11 Acres
  • Property Type: Residential Multi Family
  • Property Sub-type: Other
  • Features
  • Cooling System: Wall/Window Unit(s), Window Unit(s)
  • Floor Covering: Hardwood
  • Heating Fuels: Steam
  • Additional Features
  • Basement

School Information

  • School
  • Ps 94 David D Porter(Elementary)
  • Jhs 67 Louis Pasteur(MiddleSchool)
  • Benjamin N Cardozo High School(HighSchool)

Property

  • propertytype: Residential Multi Family
  • propertysubtype: Other
  • listprice: 1498000
  • unparsedaddress: 42-46 247th Street
  • postalcity: Little Neck
  • stateorprovince: NY
  • country: US
  • postalcode: 11363
  • bathroomsfull: 0
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.1056
  • lotsizeunits: Acres
  • lotsizearea: 0.1056
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 40.768881
  • longitude: -73.741799
  • listagentfullname: David Esposito
  • listagentemail: nyesposito@gmail.com
  • listagentkey: 3yd-MLSLINY-190866
  • listagentmlsid: 190866
  • listagentpreferredphone: 7183098656
  • listagentofficephone: 7183098656
  • listofficekey: 3yd-MLSLINY-DAER01
  • listofficemlsid: DAER01
  • 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: 1925
  • listingcontractdate: 2026-04-14
  • listagentfax: 7188866811
  • listagenturl: http://www.facebook.com/pages/Flushing-NY/Century-Homes-Realty-Group-LLC/150320127915
  • countyorparish: Queens
  • parcelnumber: 08116-0110
  • elementaryschool: Ps 94 David D Porter
  • highschool: Benjamin N Cardozo High School
  • elementaryschooldistrict: Queens 26
  • middleorjuniorschooldistrict: Queens 26
  • highschooldistrict: Queens 26
  • cooling: Wall/Window Unit(s), Window Unit(s)
  • constructionmaterials: Shingle Siding
  • flooring: Hardwood
  • heating: Steam
  • numberofunitstotal: 2
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 4
  • parkingfeatures: Driveway
  • waterfrontyn: False
  • franchiseaffiliation: EXIT Realty
  • interiorfeatures: Entrance Foyer
  • architecturalstyle: Cape Cod
  • rooms: Basement
  • basement: Walk-Out Access, Full
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.7418, 40.768883
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-MLSLINY-985292", "OpenHouseEndTime": "2026-04-18 14:00:00", "OpenHouseId": "3240859", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-04-18 12:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }, { "AppointmentRequiredYN": false, "ListingKey": "3yd-MLSLINY-985292", "OpenHouseEndTime": "2026-04-18 14:00:00", "OpenHouseId": "3240867", "OpenHouseRemarks": "Agents, please accompany your buyer.", "OpenHouseStartTime": "2026-04-18 12:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Century Homes Realty Group LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"nyesposito@gmail.com", "ListBrokerageCity":"Flushing", "ListBrokerageCountry":"US", "ListBrokerageEmail":"ErezDaniel@Gmail.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/c5ababc31f72300b011f7259d1c10009/20091118141416753.pjpeg", "ListBrokerageName":"Century Homes Realty Group LLC", "ListBrokeragePhone":"(718) 886-6800", "ListBrokeragePostalCode":"11354", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":"Suite 201", "ListBrokerageUnparsedAddress":"34-36 Union Street", "ListBrokerageWebsiteUrl":"http://www.facebook.com/pages/Flushing-NY/Century-Homes-Realty-Group-LLC/150320127915", "ListOfficeAddress1":"3436 Union St Ste 201 ", "ListOfficeAddress2":"Suite 201", "ListOfficeBrokerMlsId":"DAER01", "ListOfficeCity":"Flushing", "ListOfficeCountry":"US", "ListOfficeEmail":"centuryhomesrealty@gmail.com", "ListOfficePostalCode":"11354", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"MULTI_FAMILY - Cape Cod - Little Neck, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/4246-247th-St_Little-Neck_NY_11363_M30095-95603?f=listhub&s=MLSLINY&m=985292&c=rexren", "MLSModificationTimestamp":"2026-04-20 13:42:36", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":7977, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/20/2026 1:44:34 PM GMT
Source Updated Date: 4/27/2026 6:49:05 AM GMT

Courtesy of: David Esposito, Century Homes Realty Group LLC, nyesposito@gmail.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.