• Sign Up
  • Log In
Skyler Realty LLC
Daniel S. Colomban
(845) 517-8188dancolomban@outlook.com
    • Search
      • Search Homes
      • Featured Listings
      • Sold Properties
    • Communities
    • Buying
      • Buying Process
      • Mortgage Calculator
    • Selling
      • Selling Process
      • Request a Valuation
    • About
      • About Skylar Realty
      • Meet the Experts
      • Join Our Team
    • Articles
    • Contact
    • Daniel S. Colomban(845) 517-8188
      dancolomban@outlook.com
      Copy Email
    • Skyler Realty LLC
      84 Orange Turnpike
      Sloatsburg, NY 10974
      (845) 357-8500
    • Skyler Realty LLC
      Hamilton Heights
      New York, NY 10030
      (845) 517-8188

    Explore

    • Property Search
    • Communities
    • Buying
    • Selling

    About

    • About
    • Contact Us
    • Testimonials
    • Home
    Skyler Realty LLC - Footer Logo
    • NAR Logo
    • onekey logo
    • AIA logo


      • Privacy
      • Terms
      • DMCA
      • Accessibility
      • Fair Housing
      © 2026 Skyler Realty LLC. All rights reserved.
      Website built by CloseHack.
      OneKey MLS

      IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

      $699,900
      For Sale

      175 Huguenot Street #1802

      New Rochelle, NY 10801
      2 beds | 2.5 baths | #951384
      • Save
      • Contact
      • Share
      • Price Change Alerts
      31 photos
      Type:Purchase
      Structure:Condo
      Zone:Residential

      Description

      Own this Ultra-luxurious large two bedroom, two and a half bath corner unit, 1475 square feet with high ceilings, gourmet kitchen with granite counter tops, Jenn-air appliances, Brazilian hardwood floors throughout, floor to ceiling windows with unbelievable water views of Long Island Sound. Enjoy morning sunrise from every room. Primary bedroom suite with lavish spa bath, walk in closet, laundry in unit, private garage parking. Trump Plaza offers 24 hr concierge, security, indoor heated pool, newly renovated fitness center, community room with outdoor terrace, parking on site. Storage facility connected to building. 175 Huguenot St, New Rochelle has a Walk Score of 95 out of 100. Perfectly positioned at 175 Huguenot Street, New Rochelle, this home boasts an exceptional Walk Score of 95—a true Walker’s Paradise. Just minutes from Metro-North, shopping, banking, fine dining, entertainment, and more, daily errands are effortless and car-free.

      • Interior Details
          • InteriorCathedral Ceiling(s), Elevator, Granite Counters, Primary Bathroom, Walk-In Closet(s)
        • Heating & Cooling
          • HeatingElectric, Forced Air, Natural Gas
          • CoolingCentral Air, Wall/Window Unit(s)
        • Beds & Baths
          • Bathrooms2.5
          • Bedrooms2
          • Full Baths2
          • Half Baths1
      • Property Details
          • Lot DescriptionNear Public Transit, Near School, Views
          • Pool FeaturesCommunity, In Ground, Indoor
          • ViewWater
          • Stories39
        • Parking
          • Parking FeaturesGarage, Underground
          • Parking TypeGarage
          • Parking Spaces1.0
          • Parking Garage1
      • Construction Details
          • Property TypePurchase
        • Condition
          • Year Built2006
      • Utilities / Energy Details
          • AppliancesCooktop, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer, Indirect Water Heater
          • Utility FeaturesTrash Collection Private, Trash Collection Public
          • Sewer InformationPublic Sewer
          • Utility SourcePublic
      • Community and Neighborhood Details
          • SubdivisionTrump Plaza New Rochelle
          • Community FeaturesPark
        • Location
          • Middle SchoolIsaac E Young Middle School
          • Elementary SchoolTrinity Elementary School
          • High SchoolNew Rochelle High School
          • CountyWestchester County
          • School DistrictNew Rochelle
      • Financial Details
          • Original List Price$699,900
          • Taxes Annual$9,042
          • Days on Market (Cumulative)1
        • HOA
          • Hoa2104.0
          • Hoa Fees2104.0
      • Restrictions
          • Pets AllowedNumber Limit
      • Other
          • MLS #951384

      Location

      Legal

      IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

      Last Updated: Today at 1:20 PM. Source: ONEKEY

      Provided By
      Listing Agent: Rosetta Bulfamante (#KEY20333)
      Listing Office: Houlihan Lawrence Inc. (#KEYHOULAW31)

      Skyler Realty LLCReal Estate Agent | Architectural Designer | Founder of Architee Studios
      Facebook
      Google
      OR

      Interested in Purchasing 175 Huguenot Street #1802?

      Get an estimate on monthly payments on this property.

      Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

      Estimated Monthly Payment
      $0.00
      Loan Amount
      $0.00
      $
      years

      Down Payment

      $
      %
      10.0%

      Interest Rate

      %
      6.0%

      Tax Rate

      %
      2.6%
      $
      $
      annually
      $
      monthly