Skip main navigation
Sold
  • $2,190,000

    57-27 246th Pl, Little Neck, NY 11362

    6beds
    4,700sqft
    Single Family Residence
    Built in 1950
    -- sqft lot
    $2,256,800 Zestimate®
    $466/sqft
    $5,607 Estimated rent

    Home value

    $2,256,800

    $2.05M - $2.48M

    $5,607/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,607/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,607/mo

    Rent Zestimate®

    Refinance and save

    $13,314/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $13,314/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Newly built Two Family Luxury Home in Little Neck offers approx. 3,200 sq.ft of living space on a 47X100 ft lot. It's located in the prime location is surrounded by luxury homes and beautiful scenery, making it one of the safest and most attractive residential areas. It's close to Douglaston Golf Course, with extremely convenient access to shopping and transportation. Various stores and supermarkets are within walking distance, including only a few minutes' walk to the New World Supermarket. Top rated 26 school district: PS221 Elementary School and 67 Junior High School are just steps away. It's a great layout and design, the home features stainless steel appliances, Pella windows, a brand new foundation, detached two car garage, and a wide private driveway with multiple parking spaces. The basement with a lot of windows and natural lights, 9-foot ceilings, and is built with an all brick and concrete structure. The roof high quality glazed tiles, with additional foam insulation for better temperature control and highly energy efficient. Heated floor, central air heating and cooling system. Three separate central air conditioning units ensure comfort while saving on energy. 360-degree outdoor surveillance cameras are installed. The first family unit includes 4 bedrooms and 3.5 bathrooms: the first floor is a grand living room with high ceilings, a dining room, and a half bath. The second floor has 4 bedrooms and 3 bathrooms, with 4 balconies that expand the living space and provide perfect spots for relaxing. The second family unit includes open kitchen, 2 bedrooms and 3 bathrooms, large living and dining room, also a huge attic bonus. It also features a hidden wine cellar, ideal for wine storage and entertaining guests. This perfectly designed two family luxury home combines the best of both investment and residence opportunities!

    Zillow last checked:

    Listing updated:

    Listed by:

    Fei Guo,

    Skylux Realty, Inc

    Source: StreetEasy,MLS#: S1724267

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 8
    • Full bathrooms: 7
    • 1/2 bathrooms: 1
    Cooling
    • Central Air
    Interior area
    • Total structure area: 4,700
    • Total interior livable area: 4,700 sqft

    Property

    Features
    • Patio & porch: Other
    • Exterior features: Balcony, Garden
    Details
    • Special conditions: Resale

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Condition
    • Year built: 1950

    Community & HOA

    Community
    • Subdivision: Little Neck
    Location
    • Region: Little Neck

    Financial & listing details

    • Price per square foot: $466/sqft
    • Annual tax amount: $15,912
    • Date on market: 6/27/2024

    Price history

    DateEventPrice
    12/31/2025Sold$2,190,000-21.8%$466/sqft
    Source: OneKey® MLS as distributed by MLS GRID #898454 Report a problem
    9/20/2025Pending sale$2,798,888$596/sqft
    Source: OneKey® MLS as distributed by MLS GRID #898454 Report a problem
    8/6/2025Price change$2,798,888-1.8%$596/sqft
    Source: OneKey® MLS as distributed by MLS GRID #898454 Report a problem
    1/31/2025Price change$2,850,000-4.4%$606/sqft
    Source: OneKey® MLS as distributed by MLS GRID #819495 Report a problem
    6/26/2024Listed for sale$2,980,000$634/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3561940 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: Little Neck

    Nearby schools

    GreatSchools rating