OFF MARKET
57-19 254th Street
Little Neck, NY 11362
Little Neck
7 Beds
6 Baths
- 7 Beds
- 6 Baths
7 Beds
6 Baths
Homes for Sale Near 57-19 254th Street
Skip to last item
Listing by: Keller Williams Realty Greater
See more homes for sale inLittle NeckTake a look
Skip to first item
Local Information
© Google
-- mins to
Commute Destination
Description
This property is no longer available to rent or to buy. This description is from April 11, 2023
Brand New, Luxurious, Contemporary-Style All Brick Extra Large 2 Family House in the Heart of Little Neck. Upon Entry, You Are Greeted with White Marble Floors, Pristine White Walls, and Gorgeous Vaulted Ceilings. Beautiful Windows Allow for Tons of Natural Sunlight and Ambience. The First Family Duplex (4 Bedroom & 3.5 Baths) Includes the Entire Second Floor and Features High Vaulted Ceilings, Living Room, Dining Area, Eat-in-Kitchen, Granite Countertops, along with Top-of-the-Line Stainless Steel Appliances. The Second Family Portion (3 Bedrooms & 2 Baths) Includes a Living Room, Open Concept Kitchen, and Laundry Room. Complete with Granite Countertops, High Ceilings, and Top-of-the-Line Stainless Steel Appliances As Well. Features a Finished Basement with High Ceilings, Family Room, Full Bath, and Separate Entryway. Close to Shops, Public Transportation (Q30, QM5, QM8, & QM35). Excellent School District #26 (P.S. 221, JHS 67, & Cardozo High School). You Will Not Want to Miss This O
Home Highlights
Parking
Garage
Outdoor
No Info
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 57-19 254th Street
Interior Features |
|---|
Interior Details Basement: FinishedNumber of Rooms: 11 |
Beds & Baths Number of Bedrooms: 7Number of Bathrooms: 6Number of Bathrooms (full): 5Number of Bathrooms (half): 1 |
Appliances & Utilities Appliances: Hot Water: Gas Stand Alone |
Heating & Cooling Heating: Natural Gas,Hot WaterHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Natural Gas |
Gas & Electric Gas: Separate Gas Meters: 3 |
Windows, Doors, Floors & Walls Common Walls: No Common Walls |
Exterior Features |
|---|
Parking & Garage Number of Garage Spaces: 1Number of Covered Spaces: 1No CarportHas a GarageNo Attached GarageParking Spaces: 1Parking: Private,Detached,Garage,Off Street |
Water & Sewer Sewer: Public Sewer |
Property Information |
|---|
Year Built Year Built: 2021 |
Property Type / Style Property Type: Residential IncomeProperty Subtype: Multi FamilyArchitecture: Contemporary |
Building Construction Materials: BrickIs a New ConstructionNot Attached Property |
Property Information Parcel Number: 083440015 |
Price & Status |
|---|
Price List Price: $2,280,000 |
Status Change & Dates Off Market Date: Mon Nov 15 2021 |
Active Status |
|---|
MLS Status: U |
Location |
|---|
Direction & Address City: Little Neck |
School Information Elementary School: Ps 221 North Hills School (The)Elementary School District: Queens 26Jr High / Middle School: Jhs 67 Louis PasteurJr High / Middle School District: Queens 26High School: Benjamin N Cardozo High SchoolHigh School District: Queens 26 |
Community |
|---|
Community Features: Park, Near Public TransportNot Senior Community |
Lot Information |
|---|
Lot Area: 4600 sqft |
Compensation |
|---|
Buyer Agency Commission: 1.5Buyer Agency Commission Type: %Sub Agency Commission: 1.5Sub Agency Commission Type: % |
Notes The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed |
Miscellaneous |
|---|
BasementMls Number: 3341171Sub Agency Relationship OfferedAttribution Contact: 718-461-9494 |
Additional Information |
|---|
ParkNear Public TransportMlg Can ViewMlg Can Use: IDX |
Last check for updates: about 9 hours ago
Listed by Shirley Y Chen, (917) 254-0248
AAA Young Shuen Realty Inc, (718) 461-9494
Bought with: Chen Shen Chou, (718) 353-8818, Chous Realty Group Inc, (718) 353-8818
Source: OneKey® MLS, MLS#3341171
Price History for 57-19 254th Street
| Date | Price | Event | Source |
|---|---|---|---|
| 12/29/2021 | $2,150,000 | Sold | OneKey® MLS #3341171 |
Comparable Sales for 57-19 254th Street
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.08 | Multi-Family Home | $1,813,000 | 06/01/23 | 6 | 5 | 2,860 | |
0.55 | Multi-Family Home | $1,820,000 | 05/01/23 | 7 | 7 | - | |
0.85 | Multi-Family Home | $1,515,000 | 11/27/23 | 6 | 4 | 2,064 | |
1.03 | Multi-Family Home | $1,630,000 | 12/20/23 | 6 | 5 | - | |
0.94 | Multi-Family Home | $1,260,000 | 07/13/23 | 7 | 5 | - | |
0.67 | Multi-Family Home | $1,180,000 | 10/18/23 | 5 | 4 | 3,076 | |
0.65 | Multi-Family Home | $990,000 | 09/06/23 | 4 | 2 | 1,544 | |
0.96 | Multi-Family Home | $1,180,000 | 08/21/23 | 8 | 3 | 2,625 |
Assigned Schools
These are the assigned schools for 57-19 254th Street.
- Ps 221 The North Hills School
- PK-5
- Public
- 587 Students
10/10GreatSchools RatingParent Rating AverageIt's a wonderful school.. It truly lived upto "respect for all "mottoIt strives on developing every aspect of students whether it is academics or extra curricular activities .We are very glad that our kids are in this schoolParent Review7y ago - Benjamin N Cardozo High School
- 9-12
- Public
- 3410 Students
5/10GreatSchools RatingParent Rating AverageIt’s a very big school and the student body is diverse. The resources are there for all students and many do go on to good colleges. Then there are the other types of students who either show up to just mess around or rarely show up( somehow it’s mostly the black kids). The teachers are mostly good and some are great. Because of the large student body, students who need to be hand held and spoon fed will not do well at Cardozo. The staff is there to support me but if I dont show interest they won’t chase me down either.Student Review3mo ago - Jhs 67 Louis Pasteur
- 6-8
- Public
- 1044 Students
9/10GreatSchools RatingParent Rating AverageThe school has gone downhill in terms of safety since our older daughter graduated. My younger child was harassed, stalked and threatened by another student and nothing was done. A certain science teacher singled my child out for helping a classmate in need, the 8th grade AP wanted to file an oors, even though none were filed last year and my child was in danger.Parent Review1y ago 
Check out schools near 57-19 254th Street.
Check with the applicable school district prior to making a decision based on these schools. Learn more.
What Locals Say about Little Neck
- Matthew Wong
- Resident
- 2mo ago
"Safe and friendly neighborhood. Many shops and restaurants which makes it very convenient. Traffic is light."
- Trulia User
- Resident
- 1y ago
"family oriented neighborhood with lots of stores, houses of worship, schools and a grand variety of restaurants. "
- Trulia User
- Resident
- 2y ago
"Great place to live very safe and great school district and amazing people . Nice restaurant and shopping "
- Trulia User
- Resident
- 2y ago
"New here and still exploring the neighborhood. It’s pretty quiet neighborhood and mixed culture. Easy access to the expressway and nice people around and great school district"
- KC
- Resident
- 2y ago
"Easy to commute! Express bus to manhattan, LIRR and several major highways. So easy to get wherever yo need to go!"
- Trulia User
- Resident
- 2y ago
"excellent neighborhood to raise children near houses of worship very easy commute to anywhere LIRR and many highways and bus stops many ethnic and traditional supermarkets on the area one of the best school districts in Queens pice and fire department are near by."
- Trulia User
- Resident
- 2y ago
"Westmoreland Association. Park clean-ups. Westmoreland members meetings. Very quiet neighborhood even on a Friday and Saturday night. Respectful. "
- Trulia User
- Resident
- 2y ago
"Very easy commute to the city. Little Neck LIRR and Douglaston LIRR train stations are walking distance for many people within the community. It’s a safe neighborhood and very quiet. Even on a Friday/ Saturday night it’s silent outside. "
- Trulia User
- Resident
- 3y ago
"You see dog owners walking their dogs all the time. Many different types of dogs in the neighborhood and dog owners are friendly. "
- Jerry L.
- Resident
- 3y ago
"everything your family needs is in this neighborhood. many houses of worship, several supermarkets. "
- Amanda K.
- Resident
- 3y ago
"There are good schools in the area and it’s a fairly safe neighborhood for children/teenagers to walk unsupervised "
- Jerry L.
- Resident
- 3y ago
"excellent school district (26). 2 libraries and 3 play grounds. halloween hot spot. bike lanes for safety everywhere. "
- Tanyaperez82
- Resident
- 3y ago
"Children play outside and ride bikes. It’s pretty safe for children to play. However always watch your children."
- Drdc88
- Resident
- 3y ago
"The neighborhood is awesome. It’s relatively safe. The schools are good. The restaurant and stores are awesome. It’s living in the suburbs but all the options of the city minus the broadway shows."
- Chelsie M.
- Resident
- 3y ago
"Commute takes forever. That the one thing I would change is better transportation. I hate how long it takes me to get anywhere. Other than that it’s very nice"
- Earnestiena V. C.
- Resident
- 4y ago
"Sometimes the local churches throw events, northern boulevard is close and has lots of food and coffee options"
- Jerry L.
- Resident
- 4y ago
"excellent neighborhood for raising children and many places for parents to have great meals as a couple."
- Yeon E.
- Resident
- 4y ago
"Very safe Nice restaurants around Public transportation is available Major highways are near Good school district "
- Dywong2
- Prev. Resident
- 4y ago
"It is a safe neighborhood. Short distance to shopping. Many Fine dining. Friendly neighbors. Great place to raise young children with good schools and classmates."
- mike
- Resident
- 4y ago
"Best neighborhood in queens it’s like living on Long Island with queens taxes safe neighborhood manicured lawn‘s three line blocks friendly neighbors near LIRR LIE stop and shop fairway grocery stores Best school district in queens close to Little neck bay for fishing and Alley Pond Park nature trail picnic grounds. I can’t say enough about this neighborhood raise my family here and we all love it."
- Jerry L.
- Resident
- 4y ago
"super family friendly and centrally located to all your needs. peaceful and safe. the neighbors look out for each other."
- Eugene K.
- Resident
- 5y ago
"Location is conveniently between NYC and Long Island. Safe streets. Close to highways. Good public schools. South side is more rental based. Northside is more community based. "
- Hyejin.lee1983
- Resident
- 5y ago
"neighborhood is quite and clean everything is near it this makes it convenient. major highway is close by too"
- Metapan1976
- Resident
- 5y ago
"I wouldn’t know what to say because I don’t have a dog. But there are many places like parks and long fintan es walk for dog owner to walk their dog and there are lights to go out at nights "
- Bob
- Resident
- 5y ago
"The school district is one of the best in queens. Be friendly but cautious. Be excellent to one another, party on dudes"
- Fdny146
- Resident
- 5y ago
"Best area in Queens best school district great restaurants near lie Cross Island Northern State LIRR & busses. Safe quiet and exclusive. Queens taxes on Long Island boarder. "
- Julie B.
- Visitor
- 5y ago
"it is a community that is very close and you can't walk around without waking into someone you know..."
- Dragonbaby2k
- Resident
- 6y ago
"Great schools, convenient to both NYC and Long Isalnd, access to buses and RR, close to LIE and Northern State. Well kept homes, homes keep value, good diversity, decent mix of restaurants and markets. 2 libraries. The most reliable LIRR line. No issues with parking. Safest neighborhood in NYC"
- Judithanharrison
- Resident
- 6y ago
"it's a very clean, quiet, tree line community. Neighbors are helpful and friendly. It's highly resisential but close to supermarkets, mom and pop stores, shopping centers, boutiques, and major highways."
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Zillow, Inc are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Copyright 2024 OneKey® MLS. All rights reserved.
The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.
The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.
Homes for Rent Near 57-19 254th Street
Skip to last item
Skip to first item
Off Market Homes Near 57-19 254th Street
Skip to last item
- SOLDAPR 22, 2024Maureen Folan R E Group LLC
- SOLDAPR 22, 2024
- SOLDAPR 19, 2024Coldwell Banker American Homes
- SOLDAPR 19, 2024Daniel Gale Sothebys Intl Rlty
- See more homes for sale inLittle NeckTake a look
Skip to first item
57-19 254th Street, Little Neck, NY 11362 is a 7 bedroom, 6 bathroom multi-family built in 2021. 57-19 254th Street is located in Little Neck, Little Neck. This property is not currently available for sale. 57-19 254th Street was last sold on Dec 29, 2021 for $2,150,000 (6% lower than the asking price of $2,280,000). The current Trulia Estimate for 57-19 254th Street is $2,155,500.