Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Timberland Properties
Property view
Listing view 2
Listing view 3

175 Huguenot Street #2403, 
New Rochelle, NY 10801

$875,000


2

Beds


3

Baths


1,494

Sq Ft


Condo

Active

Listed by

John Oliveri

Howard Hanna Rand Realty

Last updated:

January 10, 2026, 12:27 PM

MLS#

930561

Source:

OneKey MLS

About This Home

175 Huguenot Street #2403

Unquestionably the finest home and the largest of the two Bed Room layouts available in Trump Plaza. This stunning corner unit is perfectly situated for panoramic views of the Long Island Sound and the Manhattan skyline. With 9 ft. floor to ceiling windows you will feel as though you are living in a glass house in the sky! Renowned Trump luxury and amenities, terrific urban conveniences and elegant city life complete the package for this fine home. Beautifully updated throughout, this move-in–ready home features new engineered wood flooring, fresh paint, modern lighting, solar shades, smart thermostats, and upgraded HVAC units. The living and dining areas feel bright and open, complemented by LED recessed lighting and updated fixtures. The kitchen was fully remodeled with porcelain floors, high-end cherry wood cabinetry, quartzite countertops and backsplash, under-cabinet lighting, a redesigned soffit, and premium stainless-steel appliances, including a 30-inch range, four-door refrigerator, dishwasher, and stainless/glass hood. Both bathrooms have been completely renovated with floor-to-ceiling porcelain tile, premium glass enclosures, new vanities, upgraded fixtures, recessed medicine cabinets, LED lighting, new exhaust fans, and modern switches. The secondary bathroom includes heated floors, while the primary features a cast-iron tub with quartz surround and double sinks. Additional upgrades include new smoke detectors, pocket doors, new HVAC in multiple rooms, and thoughtful finishes throughout. Parking is optional and not included with the purchase of the unit. Monthly cost is $208 per car.

Home Facts

Condo

3 Baths

2 Bedrooms

Built in 2007

Price Summary

875,000

$585 per Sq. Ft.

MLS #:

930561

Last Updated:

January 10, 2026, 12:27 PM

Added:

2 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

1,494 Sq. Ft.


Structure

Structure

Building Area:

1,494 Sq. Ft.

Year Built:

2007


Finances & Disclosures

Finances

Price:

$875,000

Price per Sq. Ft:

$585 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.