Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Realty

Property view
Listing view 2
Listing view 3

12-06 149th Street, 
Whitestone, NY 11357

$2,550,000

4

Beds

4

Baths

6,748

Sq Ft

Single Family

Active

Listed by

Xiao Zheng

Jamie Realty Group

Last updated:

September 19, 2026, 11:00 AM

MLS#

1033133

Source:

OneKey MLS

About This Home

12-06 149th Street

Conveniently located 3 unit commercial mixed use property in Whitestone. 82.17X85 IRR lot size, 82X47 building size, R2 zoning. The first floor is 2 separate commercial spaces each with one half bathroom. One of which is 2,102 interior sq/ft, the other is 3,854 interior sq/ft. The second floor is a residential space with 4 bedrooms, 2 full bathrooms, a living/dining room, and a kitchen. Full unfinished basement. 4 electric meters, and 2 gas meters. Close to shops, restaurants, parks, and schools. Close to the Q15 bus. Don't miss this chance to own this fantastic investment opportunity!

Home Facts

Single Family

4 Baths

4 Bedrooms

Built in 1931

Price Summary

2,550,000

$377 per Sq. Ft.

MLS #:

1033133

Last Updated:

September 19, 2026, 11:00 AM

Added:

1 month(s) ago

Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

4

Full Bathrooms:

2

Interior

Living Area:

6,748 Sq. Ft.

Structure

Structure

Architectural Style:

Colonial

Building Area:

6,748 Sq. Ft.

Year Built:

1931

Lot

Lot Size (Sq. Ft):

6,984

Finances & Disclosures

Finances

Price:

$2,550,000

Price per Sq. Ft:

$377 per Sq. Ft.

Source:OneKey MLS
Copyright 2026 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID . OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

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 Contact, 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 a 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.

Contact an Agent

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 Contact, 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 a 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.