Skip main navigation
Pending
    • $1,199,888

    42-46 247th Street, Little Neck, NY 11363

    3beds
    1,496sqft
    Single Family Residence, Residential
    Built in 1925
    4,600 Square Feet Lot
    $-- Zestimate®
    $802/sqft
    $-- HOA

    What's special

    Detached garageLong private drivewayFormal dining roomFull walk-up attic
    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.
    159 days
    66
    1

    Zillow last checked:

    Listing updated:

    Listed by:

    Century Homes Realty Group LLC 718-886-6800,

    David Esposito 718-309-8656

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: 991207MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 1
      • 1/2 bathrooms: 1
      Bedroom 1
      • Description: 3 Bedrooms, 1 full bathroom, closets and walk up stairs to the full attic.
      • Level: Second
      Other
      • Description: Then Attic, could be used as guest room, home office, etc.
      • Level: Third
      Basement
      • Description: Unfinished basement with private outside entrance, bathroom, meter room.
      • Level: Basement
      Living room
      • Description: Foyer area, Living roon, Dining room, Screened in porch, Kitchen, bathroom, laundry room and a room could be home office, guest bedroom, etc.
      • Level: First
      Heating
      • Natural Gas
      Cooling
      • Wall/Window Unit(s)
      Appliances
      • Included: Dishwasher, Microwave, Oven, Range, Refrigerator, Gas Water Heater
      Features
      • Ceiling Fan(s), Entrance Foyer, Formal Dining
      • Flooring: Hardwood
      • Basement: Full,Walk-Out Access
      • Attic: Full
      • Has fireplace: No
      Interior area
      • Total structure area: 1,496
      • Total interior livable area: 1,496 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Driveway
      • Has garage: Yes
      • Has uncovered spaces: Yes
      Lot
      • Size: 4,600 Square Feet
      • Dimensions: 40 x 115
      Details
      • Parcel number: 081160110
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cape Cod
      • Property subtype: Single Family Residence, Residential
      Materials
      • Shingle Siding
      Condition
      • Actual
      • Year built: 1925

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected

      Community & HOA

      Community
      • Security: Building Security
      HOA
      • Has HOA: No
      Location
      • Region: Little Neck

      Financial & listing details

      • Price per square foot: $802/sqft
      • Annual tax amount: $7,934
      • Date on market: 4/27/2026
      • Cumulative days on market: 121 days
      • Listing agreement: Exclusive Right To Sell
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/25/2026Pending sale$1,199,888$802/sqft
        Source: OneKey® MLS as distributed by MLS GRID #991207 Report a problem
        6/23/2026Price change$1,199,888-7.7%$802/sqft
        Source: OneKey® MLS as distributed by MLS GRID #991207 Report a problem
        5/10/2026Price change$1,300,000-13.2%$869/sqft
        Source: OneKey® MLS as distributed by MLS GRID #991207 Report a problem
        4/27/2026Listed for sale$1,498,000$1,001/sqft
        Source: OneKey® MLS as distributed by MLS GRID #991207 Report a problem
        4/27/2026Listing removed$1,498,000$1,001/sqft
        Source: OneKey® MLS as distributed by MLS GRID #985292 Report a problem
        4/14/2026Listed for sale$1,498,000$1,001/sqft
        Source: OneKey® MLS as distributed by MLS GRID #985292 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Little Neck

        Getting around

        90 / 100
        Walker's Paradise
        43 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Ps 98 Douglaston School
        • Middle: Jhs 67 Louis Pasteur
        • High: Benjamin N Cardozo High School

        Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other New York Topics

              Search
              Updates
              Favorites
              Plan
              Inbox