Skip main navigation
Pending
  • $1,568,000

    254-04 W End Drive, Little Neck, NY 11362

    5beds
    4,864sqft
    Loading
    Single Family Residence, Residential
    Built in 2012
    7,350 Square Feet Lot
    $-- Zestimate®
    $322/sqft
    $-- HOA

    What's special

    EXTRA LARGE LOT OPPORTUNITY AWAITS! This partially built home offers the perfect chance to bring your vision to life. Set on a 7,350 sq ft lot, the structure is well underway, providing a solid foundation for your dream residence within Little Neck. Whether you're a builder, investor or future homeowner ready to put your personal stamp on a property, this is a rare opportunity to create a brand new custom home without starting from scratch. 24 hr notice needed to schedule an appointment of the property.
    115 days
    |
    49
    |
    0
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Compass Greater NY LLC 516-517-4751,

    Nicholas Colombos 917-453-9333,

    Angela Dooley 516-315-7781,

    Compass Greater NY LLC

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 5
      • Full bathrooms: 4
      • 1/2 bathrooms: 1
      Primary bedroom
      • Description: Large Primary En Suite with very high ceilings, 3 exposures, 2 separate balconies, set up for double sink bathroom
      • Level: Second
      Bedroom 1
      • Description: 1st Floor En Suite Bedroom Layout with Private Entrance, near separate laundry room
      • Level: First
      Basement
      • Description: High Ceiling Lower Level with Outdoor Access, a separate area may be transformed to a movie theatre
      • Level: Lower
      Bonus room
      • Description: Bonus areas/ rooms located on 2nd and 3rd floors with windows
      • Level: Third
      Living room
      • Description: Expansive Great Room Layout off Entry Foyer with High Ceilings
      • Level: First
      Heating
      • Other
      Cooling
      • None
      Appliances
      • Included: None
      • Laundry: Laundry Room
      Features
      • Eat-in Kitchen
      • Basement: Unfinished
      • Attic: Full
      Interior area
      • Total structure area: 4,864
      • Total interior livable area: 4,864 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Driveway
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Levels: Three Or More
      • Has view: Yes
      • View description: Open
      Lot
      • Size: 7,350 Square Feet
      Details
      • Parcel number: 082640001
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Mediterranean
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick
      Condition
      • Actual
      • Year built: 2012

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: None

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Little Neck

      Financial & listing details

      • Price per square foot: $322/sqft
      • Annual tax amount: $21,248
      • Date on market: 4/6/2026
      • Cumulative days on market: 83 days
      • Listing agreement: Exclusive Right To Sell

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        5/7/2026Contingent$1,568,000$322/sqft
        Source: NY State MLS #11686708 Report a problem
        4/28/2026Listed for sale$1,568,000$322/sqft
        Source: NY State MLS #11686708 Report a problem
        4/27/2026Pending sale$1,568,000$322/sqft
        Source: OneKey® MLS as distributed by MLS GRID #977270 Report a problem
        4/6/2026Listed for sale$1,568,000-1.3%$322/sqft
        Source: OneKey® MLS as distributed by MLS GRID #977270 Report a problem
        12/15/2025Listing removed$1,588,000$326/sqft
        Source: OneKey® MLS as distributed by MLS GRID #920142 Report a problem
        12/1/2025Price change$1,588,000-5.5%$326/sqft
        Source: OneKey® MLS as distributed by MLS GRID #920142 Report a problem
        10/10/2025Listed for sale$1,680,000$345/sqft
        Source: OneKey® MLS as distributed by MLS GRID #920142 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.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Little Neck

        Getting around

        92 / 100
        Walker's Paradise
        44 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Ps 94 David D Porter
        • 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