Recently Viewed Properties
See This Home
Save This Listing
Close

$1,888,000 Sale Pending

  • For Sale
  • Pending
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 1 Car Garage
  • Updated 12 days ago
See This Home
Save This Home
See This Home
Save This Home
Private beach access complements this luxurious, opulent, and spacious mint-condition Colonial featuring 4 bedrooms and 4 full baths. A dramatic two-story entry foyer welcomes you into an elegant interior with a large eat-in kitchen, center island, and an open layout flowing into the expansive family room. Additional entertaining spaces include a formal dining room and a sunken living room with soaring vaulted ceilings, electronically operated skylights, and sliding glass doors opening to a magnificent Zen-inspired garden with room for a swimming pool. The second-floor primary suite features cathedral ceilings, a walk-in closet, and a spa-inspired en-suite bath. Exceptional custom details throughout include imported doors, custom-edged glass windows, granite flooring, handcrafted iron banisters, and custom millwork. The full finished basement offers a separate outside entrance and additional flexible living or recreational space. Additional amenities include central air conditioning, three-zone heating, an intercom system with video displays, and a two-car garage. Surrounded by lush landscaping and mature greenery, this exceptional Whitestone residence is conveniently located near parks, transportation, shopping, and the village.

Full Property Details for 2-40 150th St

General

  • Price: $1,888,000
  • HOA FEE: $125/month
  • Taxes: $13,961
  • Status: Pending
  • Type: Single Family
  • Source: Long_Island
  • MLS ID: 1035917
  • Updated: 9/28/2026
  • Added to Site: 59 day(s) ago

Interior

  • Number of Rooms: 10
  • Interior Features: Breakfast Bar, Eat-in Kitchen, Formal Dining, Granite Counters, Kitchen Island, Natural Woodwork, Open Floorplan, Open Kitchen, Primary Bathroom, Recessed Lighting, Sound System, Speakers, Walk-In Closet(s), Washer/Dryer Hookup, Whole House Entertainment System
  • Appliances: Other
  • Flooring: Hardwood

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Additional Information

  • Shared Amenities: Other

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Parking Features: Attached, Driveway, Private

Location

  • County: Queens

School Information

  • High School District: Queens 26
  • Elementary School: Ps 193 Alfred J Kennedy
  • Middle School: Jhs 185 Edward Bleeker
  • High School: Bayside High School

Community

  • Association: Yes
  • Assoc. Fees Include: Common Area Maintenance, Trash

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air
  • Heating Type: Forced Air, Natural Gas, Radiant Floor

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Cable Available, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected

Structural Information

  • Architectural Style: Colonial
  • Detached/Attached: Detached
  • Construction: Brick
  • Basement: Yes
  • Basement Desc.: Finished, Full Basement, Walk-Out Access
  • Windows: Skylight(s)
  • Sq. Ft. Source: Other
  • Year Built: 1999

Lot Features

  • Property View: Water
  • Lot Size (Acres): 0.1061
  • Lot Size (Sq. Ft.): 4,620

Water Features

  • Water View: Yes
  • Water Front View: Beach Front

Financial Considerations

  • Association Fee: Yes
  • Association Fee: $125
  • Assoc Fee Freq.: Monthly
  • Tax Amount: $13,961

Disclosures and Reports

  • Special Conditions: None
  • Property ID: 04493-0077

Listed by Prime Realty

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 2-40 150th St —

  • Prime Realty

718-229-2922

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 2-40 150th St

School District:New York City Geographic School District 25
NameGradesDistance
Ps 193 Alfred J Kennedy
152-20 11th Ave, Queens, NY 11357
PK-50.7 mi
Jhs 185 Edward Bleeker
147-26 25th Dr, Queens, NY 11354
6-81.6 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 2-40 150th St Get Price Alerts and Save Property

Date
Details
Price
Change
Source
8/13/2026
Listed
$1,888,000
11.12%
MLS
11/03/2021
Sold
$1,699,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 2-40 150th St

Year
Property Taxes
Change
Tax Assessment
Change
2025
$14,131
1%
$70,358
-15%
2024
$14,026
6%
$83,220
26%
2023
$13,232
5%
$65,879
-16%
2022
$12,622
-14%
$78,300
-7%
2021
$14,728
-1%
$83,760
11%
2020
$14,814
2%
$75,540
9%
2019
$14,524
15%
$69,300
6%
2017
$12,602
—
$65,528
6%
2017
$12,602
11%
$61,819
6%
2016
$11,349
-2%
$58,320
-4%
2015
$11,543
8%
$60,610
6%
2014
$10,663
7%
$57,180
—
2013
$9,975
—
$57,120
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 2-40 150th St

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Listed by Prime Realty

Similar Properties near 2-40 150th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1501-23 Powells Cove Blvd, Whitestone, NY 11357 - Photo 1
$1,880,000

1501-23 Powells Cove Blvd  Whitestone, NY 11357

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
Listed by Keller Williams Rty Gold Coast
150-129 Powells Cove Blvd, Whitestone, NY 11357 - Photo 1
$2,100,000

150-129 Powells Cove Blvd  Whitestone, NY 11357

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,243
    Sq. Ft.
Listed by Keller Williams Rty Gold Coast
145-27 13th Ave, Whitestone, NY 11357 - Photo 1
$1,698,888
Open House

145-27 13th Ave  Whitestone, NY 11357

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 1,814
    Sq. Ft.
Listed by Suydam Agency Inc
154-60 Riverside Dr, Whitestone, NY 11357 - Photo 1
$1,980,000

154-60 Riverside Dr  Whitestone, NY 11357

  • Single Family
  • Active
  • 4
    Beds
  • 5
    Total Baths
  • 2,800
    Sq. Ft.
Listed by Prospes Real Estate Corp

Just Listed near 2-40 150th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

121-35 5th Ave, College Point, NY 11356 - Photo 1 Just Listed
$528,000
Open House

121-35 5th Ave  College Point, NY 11356

  • Condo
  • Active
  • Updated 4 days ago
  • 1
    Bed
  • 1
    Total Bath
Listed by Apple Realty Group Corp
120-02 9th Ave, College Point, NY 11356 - Photo 1 Just Listed
$1,488,000
Open House

120-02 9th Ave  College Point, NY 11356

  • Multi-Family
  • Active
  • Updated 11 hours ago
  • 5
    Total Beds
Listed by AAA Young Shuen Realty Inc
120-61 5th Ave, College Point, NY 11356 - Photo 1 Just Listed
$1,750,000

120-61 5th Ave  College Point, NY 11356

  • Multi-Family
  • Active
  • Updated 1 day ago
  • 5
    Total Beds
Listed by E Realty International Corp
18-20 126th St, College Point, NY 11356 - Photo 1 Just Listed
$1,280,000

18-20 126th St  College Point, NY 11356

  • Multi-Family
  • Active
  • Updated 1 day ago
  • 6
    Total Beds
Listed by Keller Williams Rlty Landmark

2-40 150th Street, Whitestone, NY 11357 (MLS# 1035917) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 2-40 150th Street is currently listed for $1,888,000 and was received on August 12, 2026. Want to learn more about 2-40 150th Street? Do you have questions about finding other Single Family real estate for sale in Whitestone? You can browse all Whitestone real estate or contact a Coldwell Banker agent to request more information.

Tour this property