855.375.4001
Listing Courtesy of: John Oliveri - Howard Hanna Rand Realty 914-328-0333

175 HUGUENOT ST Unit 2403 NEW ROCHELLE, NY 10801

Down payment assistance icon
Condo Residence
2 Beds
3 Baths
... Bed/Bath
1,494 Sq. Ft.

Property Activity

Time on Site
days
Days on Market
Views
Saves
Last updated on 12/18/2025 5:07 AM
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. Continue reading
MLS#
930561
Property Type
Condo
Bedrooms
2
Bathrooms
2 Full/1 Half
Year Built
2007
HOA Fee
$2,030 Monthly
Square Feet
1,494 sq. ft
Stories
1.0
Sewer
Public Sewer

Receive an email as soon as the price changes

Receive an email

as soon as the price changes
Get Price Alerts
price alerts icon

Get Price Alerts

Don't miss your chance. Receive an email as soon as the price changes.

Notify Me

Get email alerts when
a home price changes

Sign up
view of kitchen

Walk Score measures the walkability of any address, Transit Score measures access to public transit on a scale of 1-100.

Source: Walk Score®
scales icon

How much home can I afford?

Kickstart your home search journey with our online Pre-Approval.

Get Started
megaphone icon

See How Much You Could Save

Thinking about buying or selling? Talk to one of our Mortgage Professionals today to see how much you could save on your next home. Call us at 833-981-2030.

Let's Talk
Listing Courtesy of: John Oliveri - Howard Hanna Rand Realty 914-328-0333
Andrea D. Conner, License 10311208085, Xome Inc., License 10991227159, [email protected], 844-400-XOME (9663), 750 Highway 121 Bypass, Suite 100, Lewisville, Texas 75067


Listings courtesy of One Key MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of 11/13/2024. 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. Properties displayed may be listed or sold by various participants in the MLS. Per New York legal requirement, click here for the Standard Operating Procedures. Copyright 2025, OneKey MLS, Inc. All Rights Reserved.
This content last refreshed on 12/18/2025 5:07 AM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.
save icon Save
save icon Save
share icon Share
checkmark icon Get Pre-Approved