151-17 23rd Avenue, Whitestone, NY 11357
OFF MARKET

151-17 23rd Avenue
Whitestone, NY 11357

Whitestone
  • 5 Beds
  • 2 Baths
  • 2,077 sqft

$1,586,900

Trulia Estimate
as of Jun 20, 2026
Est. Refi. Payment $8,930/mo*
Refinance Your Home

$1,586,900

Trulia Estimate
as of Jun 20, 2026
Est. Refi. Payment $8,930/mo*
Refinance Your Home
5 Beds
2 Baths
2,077 sqft

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

Opportunity knocks with this solid, beautifully maintained 2 Family home on a rare and very large 40 x 150 square foot lot in the highly desirable neighborhood of Whitestone, Queens.
Perfectly situated on a beautiful block, close to all - shops, restaurants, schools, major highways and public transportation - this fantastic property offers function, comfortable living and fantastic income production potential.
The entry level/ first floor unit features 3 bedrooms, 1 full bathroom, spacious Living room, Dining room, and an eat-in kitchen. Hardwood floors throughout. This unit also features 2 additional entries and exits leading to the side and rear of the property.
2nd floor unit features 2 bedrooms, 1 full bathroom, large Living room, Dining room and eat-in kitchen. Hardwood floors throughout.
Basement is fully finished with a large and inviting family area, office space, storage space, half bathroom, laundry room, boiler room and an entrance/Exit to the backyard.
This property sits on a 6,000 sq. ft lot and the lucky new owners will absolutely love their HUGE backyard, with a patio/BBQ area, lawn area, garden area and a wide 2 car garage!
In addition to the 2 car garage, the property also has a very long driveway which fits 5 cars.
This 2 Family property is a must see and will not last long!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from August 18, 2025

Home Highlights

Parking
Garage
Outdoor
No Info
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 151-17 23rd Avenue

Interior Features

Interior Details
Basement: Finished,Full,Storage Space,Walk-Out Access
Beds & Baths
Number of Bedrooms: 5Number of Bathrooms: 2Number of Bathrooms (full): 2
Appliances & Utilities
Utilities: Electricity Connected, Sewer Connected, Trash Collection Public, Water ConnectedLaundry: Washer/Dryer Hookup,Gas Dryer Hookup,In Basement,Laundry Room,Washer Hookup
Heating & Cooling
Heating: OilHas CoolingAir Conditioning: Wall/Window Unit(s)Has HeatingHeating Fuel: Oil
Fireplace & Spa
No FireplaceNo Spa
Gas & Electric
Gas: Separate Gas Meters: 2Has Electric on Property
Windows, Doors, Floors & Walls
Flooring: Hardwood
Levels, Entrance, & Accessibility
Floors: Hardwood

Exterior Features

Exterior Home Features
No Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageParking Spaces: 2Parking: Garage
Water & Sewer
Sewer: Public Sewer

Days on Market

Cumulative Days on Market: 23

Property Information

Year Built
Year Built: 1950
Property Type / Style
Property Type: Residential IncomeProperty Subtype: Duplex, Multi FamilyArchitecture: Cape Cod
Building
Construction Materials: BrickNot Attached Property

Price & Status

Price
List Price: $1,558,888
Status Change & Dates
Off Market Date: Wed Apr 16 2025

Active Status

MLS Status: Sold

Location

Direction & Address
City: Whitestone
School Information
Elementary School: Ps 79 Francis LewisJr High / Middle School: Jhs 189 Daniel Carter BeardHigh School: Flushing High SchoolHigh School District: Queens 25

Building

Building Area
Building Area: 2077 Square Feet

Community

Not Senior Community

Lot Information

Lot Area: 6000 sqft

Listing Info

Special Conditions: None

Offer

Listing Agreement Type: Exclusive Right To Sell

Miscellaneous

BasementMls Number: 836935Attic: Partial, UnfinishedAttribution Contact: 718-475-2700Showing Requirements: 24 Hour Notice
Last check for updates: about 10 hours ago
Listed by Alex Papaioannou, (718) 475-2700
Keller Williams Rlty Landmark, (718) 475-2700
Helen Tzelios, (516) 432-3400
Douglas Elliman Real Estate, (516) 432-3400
Bought with: Ying Gao, (718) 666-6066, Royalux Realty LLC, (718) 666-6066
Source: OneKey® MLS as distributed by MLS GRID, MLS#836935

Price History for 151-17 23rd Avenue

DatePriceEventSource
07/31/2025$1,560,000Sold
OneKey® MLS as distributed by MLS GRID #836935
04/16/2025$1,558,888ContingentStreetEasy #S1760971
04/16/2025$1,558,888PendingOneKey® MLS as distributed by MLS GRID #836935
03/18/2025$1,558,888Listed For SaleOneKey® MLS as distributed by MLS GRID #836935

Market trends in Whitestone

Last updated May 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$896K
$24.83KMoM
Sale-to-List Price
—
Price per sq ft
—
Available listings
196
15MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax
Assessment$1,560,000
Home facts updated by county records

Homeowner tools

Estimated monthly rent$2,791/mo
List your home for rent

Homes for rent near 151-17 23rd Avenue

See what comparable homes in the neighborhood are renting for.
Skip to last item
Skip to first item

Comparable Sales for 151-17 23rd Avenue

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
15411 Willets Point Boulevard, Whitestone, NY
0.20
Multi-Family Home
$1,670,000
03/20/26
5
2
2,112
15180 20th Avenue, Flushing, NY
0.24
Multi-Family Home
$2,150,000
02/17/26
5
2
2,104
150-44 23rd Avenue, Whitestone, NY
0.10
Multi-Family Home
$1,350,000
10/30/25
4
3
2,352
150-28 19 Avenue, Whitestone, NY
0.31
Multi-Family Home
$1,515,000
09/22/25
4
2
1,840
150-29 16th Road, Whitestone, NY
0.49
Multi-Family Home
$1,480,000
03/17/26
6
2
2,244
15016 26th Avenue, Flushing, NY
0.29
Multi-Family Home
$1,280,000
05/29/26
4
2
2,550
16-11 149th Street, Whitestone, NY
0.56
Multi-Family Home
$1,315,000
04/23/26
5
2
2,146
28-10 150th street, Flushing, NY
0.41
Multi-Family Home
$1,440,000
08/07/25
4
2
1,776
14926 22nd Avenue, Whitestone, NY
0.23
Multi-Family Home
$1,650,000
08/27/25
6
4
3,319

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 151-17 23rd Avenue.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

Neighborhood Overview

Whitestone
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Whitestone

At least 449 Trulia users voted on each feature.

  • 91 % Say there are sidewalks

  • 83 % Say it's dog friendly

  • 80 % Say streets are well-lit

  • 73 % Say car is needed

  • 73 % Say there's holiday spirit

  • 73 % Say yards are well-kept

  • 71 % Say people would walk alone at night

  • 67 % Say parking is easy

  • 66 % Say it's walkable to grocery stores

  • 64 % Say it's walkable to restaurants

  • 61 % Say they plan to stay for at least 5 years

  • 56 % Say it's quiet

  • 54 % Say neighbors are friendly

  • 53 % Say kids play outside

  • 33 % Say there are community events

  • 31 % Say there's wildlife

Sourced by Trulia users. Learn more about our methodology.
  • Pamela.g83
    "Clean area good neighborhood family friendly good public transportation and great public schools close to shopping centers and supermarkets "
    1
    Flag
  • Zoila
    "4 of the july it’s beautiful very good niegborhood Easter Christmas new year it’s gorgeous we have very good people around and very quite nice and clean "
    2
    Flag
  • Trulia User
    "Very friendly people also very diverse, I feel safe wherever I go and I don’t need to worry about having strangers passing by "
    0
    Flag
  • Trulia User
    "great area to raise a family......................................................................................."
    0
    Flag
  • Trulia User
    "I live in the neighborhood only 6 months and I love it so much. It’s very safe, very clean, nice neighborhood. People are very friendly. Easy to commute in Manhattan and other areas. "
    7
    Flag
  • Trulia User
    "I’m loved this area totally wish I could live hear its beautiful has birds and lovely neighbors excellent parking "
    0
    Flag
  • Trulia User
    "I’ve been living here for almost 10 years. The streets and sidewalks are well maintained for the most part. Although the public transportation is not the greatest, it is easily accessed to all major roadways and surrounded by many iconic neighborhoods. "
    7
    Flag
  • Trulia User
    "I live a year here n l♡ve it just hope I dont have to move n find something so I can stay living here."
    1
    Flag
  • Trulia User
    "People walk there dogs all the time. People are responsible and clean.a great place to meet other dog owners. "
    0
    Flag
  • Trulia User
    "100 % recommended great community very accessible to the groceries, bus station kid safe no big issues reported "
    3
    Flag
  • Trulia User
    "Compared to other areas Whitestone has larger lots and more single family homes. Most front yards are well kept, and relatively quiet.while bus is needed to get to trains, it is relatively a short ride and to the end stop of the 7 train. There are to a of bused in flushing. Relatively high and stable home ownership means you are likely to know your neighbors. "
    1
    Flag
  • Trulia User
    "It's a very nice neighborhood I came to visit it a couple of times and everytime I visited I had a great experience and would consider moving here if I had the opportunity to. Shopping is close public transportation I a fast and reliable the people so far are friendly down to earth people."
    1
    Flag
  • Trulia User
    "I’ve been living here for 32 years. This neighborhood is safe, pretty, quiet you hear birds chirping in the morning which I love!"
    4
    Flag
  • Trulia User
    "It’s a nice and safe neighborhood with beautiful houses and cooperative apartments. It’s close to the water and little bay park is awesome. "
    0
    Flag
  • Trulia User
    "It’s a little inconvenient to not be able to access a train but the buses gets the job done. The buses mostly run on time. "
    0
    Flag
  • Trulia User
    "Great and easy to get to work and back from work close to a lot of store and highways love it. "
    0
    Flag
  • Trulia User
    "I’ve lived here for 24 years and although it’s changed in that time it’s still a great place to live."
    3
    Flag
  • Trulia User
    "Long time for the distance. Might as well bike ride. There’s so many people and cars its getting worse and worse."
    0
    Flag
  • Trulia User
    "In Le Havre, the clubhouse has events pretty regularly - bingo nights, special holiday parties for the kids, etc. and in the summer, there’s always something going on at the pool."
    0
    Flag
  • Trulia User
    "Not ideal for comuting...on the other hand it is the most beautiful neighborhood in queens. Suburbs feeling but still in NYV. Doesn't get better than Whitestone."
    0
    Flag
  • Trulia User
    "Christmas is one of the most beautiful holiday if you live in whitestone. Most the houses are so nicely decorated with the most beautiful lights. "
    0
    Flag
  • Trulia User
    "Yes it is fine with me. I am an animal lover. I own a cat. Most people live in my neighbourhood own small friendly pets. "
    0
    Flag
  • Trulia User
    "I’ve lived here for 3 years and I really like it. Good school district. Safe and family friendly. It’s a good place to live. "
    1
    Flag
  • Trulia User
    "Christmas ! It's very breathtaking to see how some people decorate their houses during Christmas. It's the most beautiful thing ever. "
    0
    Flag
  • Trulia User
    "it's good easy commute but you should own a car. Great places to eat, and lots of activities in the park."
    0
    Flag
  • Trulia User
    "I’ve lived in Whitestone my whole life that’s 55 yrs and have raised my 3 kids here as well. It’s a very safe neighborhood and would highly recommend it to anyone looking for a nice safe and secure place to live whether your looking to start a family or even if your a single person looking for a nice place to call home."
    1
    Flag
  • Trulia User
    "My neighborhood has great public transit access, and with a 5 min drive you will be near all restaurants."
    0
    Flag
  • Trulia User
    "Clean, safe, family oriented neighborhood with good public schools & good choices of private schools. "
    0
    Flag
  • Trulia User
    "LeHavre is a hidden gem. As someone originally from Long Island, this place is a hybrid between an apartment complex and country club. Love it!"
    0
    Flag
  • Alexander J.
    "Dogs are not allowed in Clearview gardens, whitestone’s largest coop. There is a dog park in little bay park. "
    4
    Flag
  • Danny H.
    "It's a great place to raise your children. Lots of parks, it's a very family oriented environment with plenty of activities to do, and the school districts are amazing."
    2
    Flag
  • Audrey F.
    "Been here over 35 years. Clean. Quiet most of the time. Friendly people. Good schools. Stores nearby and transportation. If needed. "
    20
    Flag
  • Dnicoz
    "Quiet. Suburban neighborhood in queens, away from the chaos but still near the city! Local businesses, food, and other things right in the area "
    2
    Flag
  • JACQUELINE I.
    "There's a dog park under the Thrigs Neck Bridge and entire neighborhood is dog friendly. Great vets, too, like at Whitestone Animal Hospital. "
    2
    Flag
  • Judychausanders
    "Schools are great, neighbors can be friendly, but some can be super racist too. The restaurants around here are mostly pizzerias and Chinese take out. "
    5
    Flag
  • Diana.trejo78
    "Great quiet area to live in without having to be bothering by anyone. Bus stops close by and stores within walking distance "
    1
    Flag
  • Judychausanders
    "It takes about 1.5 hrs by bus and train to get into union square, Manhattan. The commute is long and most of the time the train are packed. "
    2
    Flag
  • Minji C.
    "This neighborhood has a great school system. The kids are safe and can go to lots of parks. Lived here all my life and wont want to live anywhere else. "
    0
    Flag
  • Cathrynleew
    "There is a dog park very close by. Depending on where you live it could be a 5 minute walk or a 5 minute car ride. "
    0
    Flag
  • Benzinnyc
    "There’s a dog park in Whitestone. The neighborhood is very dog friendly even shops nearby, are dog friendly and will give your dog a cookie. "
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

Explore by feature - Garage

Explore by feature - Air Conditioning

Explore by feature - Pool

Explore by feature - Washer/dryer

Explore by feature - Outdoor Space

Homes for sale near 151-17 23rd Avenue

Skip to last item
Skip to first item

Off Market Homes Near 151-17 23rd Avenue

Skip to last item
Skip to first item
Based on information submitted to the MLS GRID as of 2026-02-06 15:18:24 PST. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. Click here for more information
151-17 23rd Avenue, Whitestone, NY 11357 is a 5 bedroom, 2 bathroom, 2,077 sqft multi-family built in 1950. 151-17 23rd Avenue is located in Whitestone, Whitestone. This property is not currently available for sale. 151-17 23rd Avenue was last sold on Jul 31, 2025 for $1,560,000 (0% higher than the asking price of $1,558,888). The current Trulia Estimate for 151-17 23rd Avenue is $1,586,900.