OFF MARKET
242-34 54th Avenue
Little Neck, NY 11362
Douglaston
4 Beds
4 Baths
3,000 sqft
- 4 Beds
- 4 Baths
- 3,000 sqft
4 Beds
4 Baths
3,000 sqft
Homes for Sale Near 242-34 54th Avenue
Skip to last item
NEWOPEN SAT, 12:30-3PMListing by: Winzone Realty Inc- NEWOPEN SAT, 12:30-3PMListing by: Winzone Realty Inc
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
Magnificent large 4BR 3.5Bath Colonial over 3,000sqft. Features a center hall foyer, separate formal living room, dining room, eat-in-kitchen and fireplace den. Step out onto your large outdoor patio and enjoy your tree lined backyard. Primary bedroom with master bathroom and walk in closets on the 2nd floor with 3 additional bedrooms and another full jacuzzi bathroom. Walk out finished basement with tons of space and storage! 2 car attached garage and MORE!
Home Highlights
Parking
2 Car Garage
Outdoor
No Info
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 242-34 54th Avenue
Interior Features |
|---|
Interior Details Basement: FinishedNumber of Rooms: 8 |
Beds & Baths Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1 |
Dimensions and Layout Living Area: 3000 Square Feet |
Appliances & Utilities Appliances: Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer, Hot Water: Gas Stand AloneDishwasherDryerMicrowaveRefrigeratorWasher |
Heating & Cooling Heating: Natural Gas,BaseboardHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Natural Gas |
Fireplace & Spa Number of Fireplaces: 1Has a Fireplace |
Windows, Doors, Floors & Walls Common Walls: No Common Walls |
Exterior Features |
|---|
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Private,Attached |
Water & Sewer Sewer: Sewer |
Property Information |
|---|
Year Built Year Built: 1996 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Colonial |
Building Construction Materials: BrickNot a New ConstructionNot Attached Property |
Property Information Included in Sale: A/C Units, Alarm System, Central Vacuum, Dishwasher, Dryer, Garage Door Opener, Garage Remote, Mailbox, Microwave, Refrigerator, Washer, Whirlpool TubParcel Number: 081930170 |
Price & Status |
|---|
Price List Price: $1,595,000 |
Status Change & Dates Off Market Date: Wed Sep 14 2022 |
Active Status |
|---|
MLS Status: U |
Location |
|---|
Direction & Address City: Douglaston |
School Information Elementary School: Ps 94 David D Porter, Ps 98 Douglaston 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 |
Building |
|---|
Building Area Building Area: 3000 Square Feet |
Community |
|---|
Not Senior Community |
Lot Information |
|---|
Lot Area: 4500 sqft |
Compensation |
|---|
Buyer Agency Commission: 1.5Buyer Agency Commission Type: %Sub Agency Commission: 0Sub 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: 3390606Attic: Pull StairsAttribution Contact: 631-686-4724 |
Additional Information |
|---|
Mlg Can ViewMlg Can Use: IDX |
Last check for updates: 43 minutes ago
Listed by Arbi Asadourian, (646) 644-9164
R B Homes Inc, (631) 686-4724
Bought with: Arbi Asadourian, (631) 686-4724, R B Homes Inc, (631) 686-4724
Source: OneKey® MLS, MLS#3390606
Price History for 242-34 54th Avenue
| Date | Price | Event | Source |
|---|---|---|---|
| 10/20/2022 | $1,440,000 | Sold | OneKey® MLS #3390606 |
| 09/14/2022 | $1,595,000 | Pending | OneKey® MLS #3390606 |
| 04/11/2022 | $1,595,000 | Listed For Sale | OneKey® MLS #3390606 |
| 10/28/2021 | ListingRemoved | OneKey® MLS #3345882 | |
| 09/16/2021 | $1,595,000 | Listed For Sale | OneKey® MLS #3345882 |
| 08/09/2021 | ListingRemoved | OneKey® MLS #3329353 | |
| 07/13/2021 | $1,750,000 | Listed For Sale | OneKey® MLS #3329353 |
Comparable Sales for 242-34 54th Avenue
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.19 | Single-Family Home | $1,770,000 | 07/25/23 | 5 | 5 | 2,888 | |
0.43 | Single-Family Home | $1,360,000 | 08/31/23 | 4 | 4 | 2,568 | |
0.54 | Single-Family Home | $1,360,000 | 12/20/23 | 6 | 4 | 2,750 | |
0.27 | Single-Family Home | $2,460,000 | 04/19/24 | 4 | 5 | 1,360 | |
0.60 | Single-Family Home | $1,160,000 | 03/12/24 | 4 | 4 | 1,820 | |
0.36 | Single-Family Home | $960,000 | 07/13/23 | 4 | 3 | 1,110 |
Assigned Schools
These are the assigned schools for 242-34 54th Avenue.
- 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 - PS 98 The Douglaston School
- PK-5
- Public
- 263 Students
6/10GreatSchools RatingParent Rating AverageNYC public school with 250 students ! How better does it get. Of course you can pay $10k for a local catholic school or maybe $50k to send your child to Buckley Day School, similar class size, maybe you your child won’t get to ride a horse during school time but hey pay for those lessons separately, same level of education and save yourself $45k!Parent Review2y ago 
Check out schools near 242-34 54th Avenue.
Check with the applicable school district prior to making a decision based on these schools. Learn more.
Neighborhood Overview
Neighborhood stats provided by third party data sources.
What Locals Say about Douglaston
- Trulia User
- Prev. Resident
- 1y ago
"There is a dog park located not too far and plenty of spaces to walk your dog with great views of water"
- Trulia User
- Resident
- 2y ago
"The schools and the community makes this neighborhood special. Many dining choices and convenient stores like supermarket and pharmacy are within walking distance."
- Trulia User
- Resident
- 2y ago
"the schools are nice friendly neighborhood close to a really nice strip of stores with plenty to do and all your needs can be satisfied"
- Jimmy T.
- Resident
- 3y ago
"Wonderful neighborhood to live and raise a family. Accessible and convenient. Great school district and peace of living. "
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 242-34 54th Avenue
Skip to last item
Skip to first item
Off Market Homes Near 242-34 54th Avenue
Skip to last item
- SOLDAPR 22, 2024Keller Williams Realty Elite
- 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
242-34 54th Avenue, Little Neck, NY 11362 is a 4 bedroom, 4 bathroom, 3,000 sqft single-family home built in 1996. 242-34 54th Avenue is located in Douglaston, Little Neck. This property is not currently available for sale. 242-34 54th Avenue was last sold on Oct 20, 2022 for $1,440,000 (10% lower than the asking price of $1,595,000). The current Trulia Estimate for 242-34 54th Avenue is $1,417,200.