x
Showing 1 of 0
X
Save

42-46 247th Street
Little Neck NY 11363 US

$1,498,000

Active Listing ID 991207
bed icon
3 bed
bath icon
2.00 Bath (1 Full , 1 Half)
lot icon
Lot: 0.11 Acres
home icon
Single Family Residence

$1,498,000

Active Listing ID 991207
Save

42-46 247th Street Whether you're looking to live in, generate rental income, or build a larger custom family home, this property presents a rare opportunity in one of Queens' most desirable neighborhoods. Located in the heart of Little Neck, Queens, this home is Zoned R3-1 which offers space, flexibility, and exceptional potential. Featuring 3 bedrooms, 1.5 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. All information deemed accurate yet should be independently verified by buyer agent / broker agent and or buyer. Shown by appointment.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.11 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 1
  • 1/2 Bathrooms: 1
  • Cooling System: Wall/Window Unit(s), Window Unit(s)
  • Floor Covering: Hardwood
  • Heating Fuels: Natural Gas
  • Additional Features
  • Basement

School Information

  • School
  • Ps 98 Douglaston School(Elementary)
  • Jhs 67 Louis Pasteur(MiddleSchool)
  • Benjamin N Cardozo High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1498000
  • unparsedaddress: 42-46 247th Street
  • postalcity: Little Neck
  • stateorprovince: NY
  • country: US
  • postalcode: 11363
  • bathroomsfull: 1
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.105
  • lotsizeunits: Acres
  • lotsizearea: 0.105
  • livingarea: 1496
  • 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-27
  • listagentfax: 7188866811
  • listagenturl: http://www.facebook.com/pages/Flushing-NY/Century-Homes-Realty-Group-LLC/150320127915
  • countyorparish: Queens
  • parcelnumber: 08116-0110
  • elementaryschool: Ps 98 Douglaston School
  • highschool: Benjamin N Cardozo High School
  • elementaryschooldistrict: Queens 26
  • middleorjuniorschooldistrict: Queens 26
  • highschooldistrict: Queens 26
  • appliances: Dishwasher, Microwave, Oven, Range, Refrigerator, Gas Water Heater
  • cooling: Wall/Window Unit(s), Window Unit(s)
  • constructionmaterials: Shingle Siding
  • flooring: Hardwood
  • heating: Natural Gas
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 4
  • parkingfeatures: Driveway
  • waterfrontyn: False
  • franchiseaffiliation: EXIT Realty
  • interiorfeatures: Ceiling Fan(s), Entrance Foyer, Formal Dining
  • architecturalstyle: Cape Cod
  • rooms: Bathroom 2, Bedroom 2, Basement, Bedroom 1, Bedroom 3, Dining Room, Bathroom 1
  • basement: Walk-Out Access, Full
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.7418, 40.768883
  • 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":"SINGLE_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=991207&c=rexren", "MLSModificationTimestamp":"2026-04-28 20:41:36", "Neighborhoods":[], "PostalCode":null, "RoomCount":9, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":7934, "TaxDescription":null, "TaxYear":"2026"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/28/2026 8:45:29 PM GMT
Source Updated Date: 5/4/2026 6:54:04 PM 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.