x
Showing 1 of 0
X
Save

42-46 247th Street
Little Neck NY 11363 US

$1,199,888

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,199,888

Active Listing ID 991207
Save

42-46 247th Street Opportunity is here in Little Neck, Queens. This property offers unparalleled long-term value. Why You'll Love It: 3+ spacious bedrooms, 1.5 bathrooms, a formal dining room, cozy living room, and a bonus home office/sitting room. Bonus Square Footage: A full walk-up attic and a full basement with a private outside entrance-perfect for storage, a rec room, or guest space. Top-Tier Education: Situated in the highly coveted, Public School District #26 (including PS 98 Douglaston and JHS 67 Louis Pasteur). Commuter's Paradise: Enjoy a quiet, peaceful neighborhood feel while maintaining easy, rapid access to the LIRR, MTA buses, local shopping, and dining. Parking for 4+ Vehicles: Long private driveway plus a detached garage. Bring your design ideas and planting tools for the yard! This property is a rare find in a "silent zone" neighborhood where daily errands don't even require a car. This single-family Cape Cod, building size 22 x 24, with 1, 496 sq. ft sits on a prime 40' x 115' lot (4, 600 sq. ft.) featuring highly desirable R3-1 zoning, which permits conversion or construction of a two-family residence. Whether your goal is to flip, generate steady rental income in a high-demand market, or clear the lot for a custom luxury build, the fundamentals here are unbeatable.

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

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: 1199888
  • 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 1, Bedroom 2, Bathroom 2, Dining Room, Bedroom 1, Bedroom 3, Basement, Office
  • securityfeatures: Security
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -73.7418, 40.768883
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-MLSLINY-991207", "OpenHouseEndTime": "2026-06-28 13:00:00", "OpenHouseId": "4031032", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-06-28 11:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }, { "AppointmentRequiredYN": false, "ListingKey": "3yd-MLSLINY-991207", "OpenHouseEndTime": "2026-06-28 13:00:00", "OpenHouseId": "5901409", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-06-28 11: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":"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-07-18 17:09:38", "Neighborhoods":[], "PostalCode":null, "RoomCount":9, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":7934, "TaxDescription":null, "TaxYear":"2026"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/1/2020 12:00:00 AM GMT
Source Updated Date: 8/5/2026 12:36:28 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.