Beautifully Renovated Colonial in Great Neck
Welcome to this fully updated and move-in Colonial offering the perfect blend of comfort and style. This charming home features 3 spacious bedrooms and 1.5 modern baths, thoughtfully designed for everyday living. Step inside to discover gleaming hardwood floors and a sunlit living area that flows into a custom kitchen equipped with high-end stainless steel appliances and elegant finishes. Additional highlights include a full attic, full basement, and quality upgrades throughout the home. Enjoy year-round comfort with central air conditioning, gas heating, and gas cooking. The exterior boasts a stone terrace, lush, landscaped property, and outdoor surveillance cameras for added security. A true gem—don’t miss the opportunity to make this stunning Colonial your new home.
Sold for $1,062,000
$1,062,000
254-06 W End Drive, Great Neck, NY 11020
3beds
1,800sqft
Single Family Residence, Residential
Built in 1928
4,000 Square Feet Lot
$1,356,800 Zestimate®
$590/sqft
$5,056 Estimated rent
Home value
$1,356,800
$1.25M - $1.49M
$5,056/mo
Zestimate® history
Owner options
List your home for rent
$5,056/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,056/mo
Rent Zestimate®
Refinance and save
$6,461/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,461/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 startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Stone terraceElegant finishesCentral air conditioningGas heatingQuality upgradesHigh-end stainless steel appliancesGas cooking
Zillow last checked:
Listing updated:
Listed by:
Fariba Soleimani 516-967-9878,
LAFFEY REAL ESTATE 516-482-1111,
Sandra Lerner 516-286-0595,
LAFFEY REAL ESTATE
Bought with:
Hyun J. Lee, 10301223198
RE/MAX Team
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 889537
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Other
- Description: Full Basement- Unfinished
- Level: Basement
Heating
- Baseboard, Hot Water
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Gas Range, Range, Refrigerator, Washer
- Laundry: Washer/Dryer Hookup, In Basement
Features
- Formal Dining, Storage
- Flooring: Wood
- Basement: Full,Unfinished
- Attic: Full
- Number of fireplaces: 1
- Fireplace features: Living Room
Interior area
- Total structure area: 1,877
- Total interior livable area: 1,800 sqft
Property
Parking
- Total spaces: 5
- Parking features: Detached, Driveway, Garage
- Garage spaces: 1.5
- Has uncovered spaces: Yes
Features
- Patio & porch: Patio
Lot
- Size: 4,000 Square Feet
Details
- Parcel number: 228902061000228A
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
Condition
- Year built: 1928
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected, Sewer Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Great Neck
Financial & listing details
- Price per square foot: $590/sqft
- Tax assessed value: $943
- Annual tax amount: $19,311
- Date on market: 7/25/2025
- Cumulative days on market: 40 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 12/19/2025 | Sold | $1,062,000-15.6%$590/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #889537 Report a problem | ||
| 9/3/2025 | Pending sale | $1,258,000$699/sqft |
Source: OneKey® MLS as distributed by MLS GRID #889537 Report a problem | ||
| 7/25/2025 | Listed for sale | $1,258,000$699/sqft |
Source: OneKey® MLS as distributed by MLS GRID #889537 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $943 |
| 2023 | -- | $943 |
| 2022 | -- | $943 |
| 2021 | $17,672 +6.9% | -- |
| 2020 | $16,528 +10.9% | $1,357 |
| 2019 | $14,909 | $1,357 |
| 2018 | $14,909 +5% | $1,357 |
| 2017 | $14,194 +9.7% | $1,357 |
| 2016 | $12,945 +148.2% | $1,357 |
| 2015 | $5,216 +5.8% | $1,357 |
| 2013 | $4,931 +5.5% | $1,357 |
| 2012 | $4,675 -9.3% | $1,357 |
| 2011 | $5,154 +1.2% | $1,357 -8.3% |
| 2010 | $5,090 | $1,480 -19.1% |
| 2009 | -- | $1,830 -1.6% |
| 2008 | -- | $1,859 +1.1% |
| 2006 | -- | $1,838 -28.7% |
| 2005 | -- | $2,577 -41.1% |
| 2004 | -- | $4,375 |
| 2003 | -- | $4,375 -34.5% |
| 2002 | -- | $6,680 |
| 2001 | -- | $6,680 |
| 2000 | -- | $6,680 |
Find assessor info on the county website
Neighborhood: University Gardens
Nearby homes
- $1,050-- bd-- ba-- sqft25404 W End Dr, Flushing, NY 11362Off Market
- $1,326,3003 bd2 ba1.8k sqft254-08 End Dr, Great Neck, NY 11020Off Market
- $1,523,000-- bd-- ba4.8k sqft25404 W End Dr, Flushing, NY 11362Off Market
- $1,568,0005 bd5 ba4.8k sqft254-04 W End Dr, Little Neck, NY 11362Pending
- $708,000-- bd-- ba-- sqft47-23 Glenwood Dr, Great Neck, NY 11021Off Market
- $960,0003 bd3 ba-- sqft25412 W End Dr, Great Neck, NY 11020Sold
- $1,267,200-- bd1 ba1.5k sqft25411 Walden Ave, Great Neck, NY 11020Off Market
- $1,391,900-- bd3 ba1.7k sqft25409 W End Dr, Great Neck, NY 11020Off Market
Nearby schools
GreatSchools rating
- 10/10Lakeville Elementary SchoolGrades: 1-5Distance: 0.3 mi
- 9/10Great Neck South Middle SchoolGrades: 6-8Distance: 1.5 mi
- 10/10Great Neck South High SchoolGrades: 9-12Distance: 1.6 mi
Schools provided by the listing agent
- Elementary: Lakeville Elementary School
- Middle: Great Neck South Middle School
- High: Great Neck South 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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,356,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,356,800
- New York
- Queens County
- Great Neck
- 11020
- Queens
- University Gardens
- 254-06 W End Drive
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Great Neck Topics
