Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Warburg

Property view
Listing view 2
Listing view 3

45-02 Ditmars Boulevard #231, 
Queens, NY 11105

$399,000

—

Bed

1

Bath

576

Sq Ft

Condo

Pending

Listed by

Dimitrios Koufakos

Modern Spaces

Last updated:

September 18, 2026, 03:23 AM

MLS#

RLS20017289

Source:

NY REBNY

About This Home

45-02 Ditmars Boulevard #231

Unit 231 at Pistilli Grand Manor is a large studio apartment boasting 12-foot ceilings and over sized windows. It has a modern kitchen with full-sized stainless steel appliances, including a dishwasher. Major loft vibes with a custom-built queen-size loft bed—super functional, and perfect for making the most of the space. Underneath, you’ve got built-in storage to keep things tidy and tucked away. HVAC unit for year-round comfort.

Pistilli Grand Manor is located just a short walk to all the Ditmars attractions that everyone wants and loves... Subway station, restaurants, cafes, bagel shops, public transportation and minutes to LGA!

The building was once home to the Steinway Piano Factory. It offers great amenities including a 24-hour doorman, laundry on every floor, Building Link concierge, a 2,000 sq ft fitness center, storage units, a large parking garage, and a live-in superintendent.

Pets are allowed with board approval.

Home Facts

Condo

1 Bath

Built in 1900

Subdivision & Development:

Ditmars Steinway

Price Summary

399,000

$692 per Sq. Ft.

MLS #:

RLS20017289

Last Updated:

September 18, 2026, 03:23 AM

Added:

a year ago

Rooms & Interior

Bathrooms

Total Bathrooms:

1

Full Bathrooms:

1

Interior

Living Area:

576 Sq. Ft.

Structure

Structure

Architectural Style:

Prewar

Building Area:

576 Sq. Ft.

Year Built:

1900

Finances & Disclosures

Finances

Price:

$399,000

Price per Sq. Ft:

$692 per Sq. Ft.

MLS Logo
This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. © 2026 The Real Estate Board of New York, Inc., All rights reserved. RLS Data display by Coldwell Banker Warburg This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.

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.