Welcome to this stunning, semi-detached home that perfectly blends modern design with functional living. 4 bedrooms with 3.5 baths, walk-in basement. Featuring a classic brick facade and massive floor-to-ceiling windows, this home is flooded with sunlight and offers an impressive first impression. It boasts spacious living areas, premium finishes, and a highly functional layout. Home comes with fully paid-off solar panel. 2 Block to Supermarket,store and bus Q30. 26 School district, short distance to P.S221 JHS 67. Perfectly positioned for an easy commute via nearby major highways.
Pending
$1,150,000
24975 57th Avenue, Little Neck, NY 11362
4beds
1,564sqft
Single Family Residence, Residential
Built in 2005
2,508 Square Feet Lot
$-- Zestimate®
$735/sqft
$-- HOA
What's special
Classic brick facadeMassive floor-to-ceiling windowsHighly functional layoutWalk-in basementPremium finishes
- 142 days
- 23
- 0
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Welhome Realty Inc 646-535-1268,
Manqing Xing 917-865-7373,
Min Xiao 347-654-7599,
Welhome Realty Inc
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 994449
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Baseboard
Cooling
- Central Air
Appliances
- Included: Dryer, Gas Cooktop, Gas Oven, Refrigerator, Washer
Features
- High Ceilings
- Basement: Finished,Full
- Attic: None
Interior area
- Total structure area: 1,564
- Total interior livable area: 1,564 sqft
Property
Parking
- Total spaces: 1
- Parking features: Attached, Garage
- Garage spaces: 1
Lot
- Size: 2,508 Square Feet
Details
- Parcel number: 083360053
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
- Attached to another structure: Yes
Materials
- Frame
Condition
- Year built: 2005
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Little Neck
Financial & listing details
- Price per square foot: $735/sqft
- Tax assessed value: $66,120
- Annual tax amount: $10,873
- Date on market: 5/4/2026
- Cumulative days on market: 141 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
| Date | Event | Price |
|---|---|---|
| 6/11/2026 | Pending sale | $1,150,000$735/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #994449 Report a problem | ||
| 5/4/2026 | Listed for sale | $1,150,000+40.2%$735/sqft |
Source: OneKey® MLS as distributed by MLS GRID #994449 Report a problem | ||
| 9/12/2019 | Sold | $820,000-1.8%$524/sqft |
Source: OneKey® MLS as distributed by MLS GRID #L3104234 Report a problem | ||
| 5/20/2019 | Listing removed | $835,000$534/sqft |
Source: Block & Lot Real Estate SVC #P1338518 Report a problem | ||
| 4/12/2019 | Price change | $835,000-7.1%$534/sqft |
Source: Block & Lot Real Estate SVC #P1338518 Report a problem | ||
| 3/18/2019 | Price change | $899,000-9.6%$575/sqft |
Source: Block & Lot Real Estate SVC #3104234 Report a problem | ||
| 2/27/2019 | Listed for sale | $995,000-16.4%$636/sqft |
Source: Block & Lot Real Estate SVC #3104234 Report a problem | ||
| 12/1/2018 | Listing removed | $1,190,000$761/sqft |
Source: Winzone Realty Inc #3039754 Report a problem | ||
| 6/14/2018 | Listed for sale | $1,190,000+111.6%$761/sqft |
Source: Winzone Realty Inc #3039754 Report a problem | ||
| 4/18/2012 | Sold | $562,500-2.2%$360/sqft |
Source: Public Record Report a problem | ||
| 3/17/2012 | Listed for sale | $575,000$368/sqft |
Source: Graceful Park Realty Inc. Report a problem | ||
| 1/25/2012 | Listing removed | $575,000$368/sqft |
Source: Graceful Park Realty Inc. #2433588 Report a problem | ||
| 11/16/2011 | Listed for sale | $575,000+0.3%$368/sqft |
Source: Graceful Park Realty Inc. #2433588 Report a problem | ||
| 9/26/2011 | Sold | $573,021-4.3%$366/sqft |
Source: Public Record Report a problem | ||
| 9/24/2011 | Listed for sale | $599,000$383/sqft |
Source: Graceful Park Realty #2433588 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $66,120 +4.7% |
| 2024 | -- | $63,180 -14.9% |
| 2023 | -- | $74,280 +18.8% |
| 2022 | -- | $62,520 +11.6% |
| 2021 | -- | $56,040 -5.5% |
| 2020 | $10,685 +9.2% | $59,280 -5.2% |
| 2019 | $9,784 +4.1% | $62,520 +39.2% |
| 2018 | $9,398 +2.6% | $44,928 |
| 2017 | $9,159 +14.1% | $44,928 +5.5% |
| 2016 | $8,027 | $42,600 +1.3% |
| 2015 | $8,027 +50% | $42,067 +6% |
| 2014 | $5,350 | $39,686 -2% |
| 2013 | -- | $40,500 +3.4% |
| 2012 | -- | $39,180 +5.7% |
| 2011 | -- | $37,080 -0.5% |
| 2010 | -- | $37,260 -2.2% |
| 2009 | -- | $38,100 -4.9% |
| 2008 | -- | $40,080 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: Little Neck
Nearby schools
Schools provided by the listing agent
- Elementary: Ps 221 North Hills 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.
Similar homes
- $999,0003 bd3 ba1.3k sqft240-53 66th Avenue, Little Neck, NY 11362For Sale
MLS ID #1049269, Dan Dan Tian, Listing by: Century Homes Realty Group LLC. OneKey® MLS as distributed by MLS GRID - $1,158,0004 bd2 ba1.1k sqft50-27 192nd Street, Fresh Meadows, NY 11365For Sale
MLS ID #1031297, Xing Zheng, Listing by: Winzone Realty Inc. OneKey® MLS as distributed by MLS GRID - $1,215,0005 bd4 ba1.4k sqft5628 213th Street, Bayside, NY 11364For Sale
MLS ID #1011619, Xiuhui Lin, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID - $1,149,9994 bd3 ba1.2k sqft148-39 58th Avenue, Flushing, NY 11355For Sale
MLS ID #1032107, Vera Y. Wu, Listing by: Winzone Realty Inc. OneKey® MLS as distributed by MLS GRID - $1,479,0004 bd4 ba1.6k sqft8019 UTOPIA Parkway, Jamaica Estates, NY 11432For SaleMLS ID #1054748, Jatinder P. Singh, Listing by: Voro LLC. OneKey® MLS as distributed by MLS GRID
- $1,150,0003 bd3 ba1.3k sqft146-23 22nd Avenue, Whitestone, NY 11357For SaleMLS ID #1017951, Xiao Zheng, Listing by: Jamie Realty Group. OneKey® MLS as distributed by MLS GRID
- $1,088,0003 bd4 ba1.4k sqft4709 188th Street, Flushing, NY 11358For SaleMLS ID #1034829, Wen Jin Chen, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID
- $1,150,0003 bd3 ba1.1k sqft15031 17th Road #RANCH, Whitestone, NY 11357New ConstructionMLS ID #993870, Virginia Jee CBR, Listing by: Home Sweet Homes Real Prop Inc. OneKey® MLS as distributed by MLS GRID
- $1,199,0004 bd2 ba1.5k sqft141-66 73rd Terrace, Kew Garden Hills, NY 11367For SaleMLS ID #1010633, Irina Gilkarov, Listing by: Astor Brokerage Ltd. OneKey® MLS as distributed by MLS GRID
- $1,290,0004 bd3 ba1.7k sqft42-05 249th Street, Little Neck, NY 11363For SaleMLS ID #1024131, Vicky Wei, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID
- $1,050,0005 bd2 ba1k sqft16414 81st Avenue, Fresh Meadows, NY 11432For SaleMLS ID #1033418, Lina Shi RENE, Listing by: S10 Realty Group LLC. OneKey® MLS as distributed by MLS GRID
- $1,198,0004 bd2 ba1.7k sqft15811 79th Street, Howard Beach, NY 11414For SaleMLS ID #1051002, Steven Pacchiano, Listing by: Connexion I Rl Est Svcs Inc. OneKey® MLS as distributed by MLS GRID
- $1,075,0005 bd2 ba1.8k sqft21911 131st Avenue, Laurelton, NY 11413For SaleMLS ID #990510, Pedro J. Padilla SFR SRS, Listing by: Winzone Realty Inc. OneKey® MLS as distributed by MLS GRID
- $1,050,0003 bd2 ba1.4k sqft150-35 22nd Avenue, Whitestone, NY 11357For SaleMLS ID #1042487, Xiao Feng Pan CBR, Listing by: Winzone Realty Inc. OneKey® MLS as distributed by MLS GRID
- $955,0003 bd2 ba1.4k sqft5314 194th Street, Fresh Meadows, NY 11365For SaleMLS ID #995365, Helen H. Jang, Listing by: Canaan Realty International. OneKey® MLS as distributed by MLS GRID
- $899,0003 bd3 ba1.1k sqft94-28 209th Street, Queens Village, NY 11428For SaleMLS ID #1049881, Prahalad Mahadeo, Listing by: Getmore Realty Inc. OneKey® MLS as distributed by MLS GRID
- $847,9995 bd4 ba1.5k sqft205-15 111TH AVE, Saint Albans, NY 11412For SaleMLS ID #1040635, Sulaman Bacchus, Listing by: Valley National Homes Inc. OneKey® MLS as distributed by MLS GRID
- $899,9994 bd3 ba1.3k sqft17205 89th Avenue, Jamaica, NY 11432For SaleMLS ID #1036269, Rachel Ohayon, Listing by: Getmore Realty Inc. OneKey® MLS as distributed by MLS GRID
- $988,8003 bd3 ba1.2k sqft53-08 66th Street, Maspeth, NY 11378For SaleMLS ID #1050691, Jacky Shi J. Liu, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID
