Skip main navigation
Pending
  • $875,000

    175 Huguenot Street #2403, New Rochelle, NY 10801

    2beds
    1,494sqft
    Loading
    Condominium, Residential
    Built in 2007
    -- sqft lot
    $-- Zestimate®
    $586/sqft
    $2,136/mo HOA

    What's special

    Modern lightingSolar shadesStunning corner unitBeautifully updated throughoutFour-door refrigeratorFresh paintPremium stainless-steel appliances
    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. THIS UNIT HAS AN ACCEPTED OFFER.
    240 days
    |
    111
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Howard Hanna Rand Realty 914-328-0333,

    John Oliveri 914-715-7878

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: 930561MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Other
      • Description: Foyer, Dining Room, Kitchen, Powder Room, Living Room, Master BR, Master Bath, 2nd Br, 2nd Bath, Washer/Dryer
      • Level: First
      Heating
      • Hot Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
      Features
      • Cathedral Ceiling(s), Elevator, Primary Bathroom, Walk-In Closet(s)
      • Flooring: Hardwood
      • Windows: Floor to Ceiling Windows
      • Attic: None
      • Has fireplace: No
      • Common walls with other units/homes: 2+ Common Walls
      Interior area
      • Total structure area: 1,494
      • Total interior livable area: 1,494 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Underground
      • Garage spaces: 2
      Features
      • Levels: One
      • Pool features: In Ground
      Lot
      • Features: Near Public Transit, Near Shops, Views
      Details
      • Parcel number: 1000000001002390002403
      • Special conditions: None

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: Other
      • Property subtype: Condominium, Residential
      • Attached to another structure: Yes
      Materials
      • Brick
      Condition
      • Year built: 2007

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Trash Collection Public

      Community & HOA

      Community
      • Features: Fitness Center, Pool
      • Security: Fire Sprinkler System
      HOA
      • Has HOA: Yes
      • Amenities included: Door Person, Elevator(s), Fitness Center, Landscaping, Pool, Trash
      • Services included: Heat, Hot Water
      • HOA fee: $2,136 monthly
      • HOA name: Trump International
      Location
      • Region: New Rochelle

      Financial & listing details

      • Price per square foot: $586/sqft
      • Tax assessed value: $6,200
      • Annual tax amount: $9,041
      • Date on market: 11/21/2025
      • Cumulative days on market: 221 days
      • Listing agreement: Exclusive Right To Sell
      • Inclusions: oven/range

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        5/19/2026Pending sale$875,000$586/sqft
        Source: OneKey® MLS as distributed by MLS GRID #930561 Report a problem
        5/19/2026Listing removed$875,000$586/sqft
        Source: OneKey® MLS as distributed by MLS GRID #930561 Report a problem
        11/21/2025Listed for sale$875,000+22.4%$586/sqft
        Source: OneKey® MLS as distributed by MLS GRID #930561 Report a problem
        10/3/2010Listing removed$715,000$479/sqft
        Source: Better Homes and Gardens Rand Realty #3023298 Report a problem
        7/13/2010Listed for sale$715,000$479/sqft
        Source: Better Homes and Gardens Rand Realty #3023298 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 10801

        Getting around

        96 / 100
        Walker's Paradise
        59 / 100
        Good Transit
        57 / 100
        Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Columbus
        • Middle: Isaac E Young Middle School
        • High: New Rochelle High School

        Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes