Spectacular water views from every window of this spacious two bedroom, two and a half baths unit at Trump Plaza New Rochelle! Offering approximately 1,299 sq ft of refined living space. This beautifully appointed unit features: Jenn-Air appliances, granite countertops, floor to ceiling windows, hardwood floors, primary suite with spa-like bath & custom walk-in closet, private in unit laundry. Full service Luxury amenities Include: heated indoor pool, 24-hour concierge, doorman, security, newly updated community room with outdoor terrace, playroom, business center, workout facility. Private garage parking available. Ideally located walking distance downtown and New Rochelle Train Station with easy access to Manhattan & Amtrak, plus endless dining, banking, dog walk, entertainment, and much more.
Pending
$679,900
175 Huguenot Street #1804, New Rochelle, NY 10801
2beds
1,299sqft
Condominium, Residential
Built in 2006
-- sqft lot
$-- Zestimate®
$523/sqft
$1,853/mo HOA
What's special
Floor to ceiling windowsHeated indoor poolPrivate garage parking availableCustom walk-in closetJenn-air appliancesHardwood floorsGranite countertops
- 106 days |
- 186 |
- 5 |
Zillow last checked:
Listing updated:
Listed by:
Houlihan Lawrence Inc. 914-636-6700,
Rosetta Bulfamante 914-403-0617
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 978861
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Other
- Description: Entrance foyer with coat closet, powder room, open kitchen with washer/dryer, dining area, living room with juliette doors and great water views, main bedroom with walk in custom closet and spa bath, second bedroom with full bath.
- Level: First
Heating
- Electric, Forced Air, Natural Gas
Cooling
- Central Air, Wall/Window Unit(s)
Appliances
- Included: Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Washer, Indirect Water Heater
- Laundry: In Unit
Features
- Cathedral Ceiling(s), Elevator, Granite Counters, Primary Bathroom, Walk-In Closet(s)
- Flooring: Carpet, Hardwood
- Windows: Drapes
- Basement: None
- Attic: None
- Has fireplace: No
- Common walls with other units/homes: Center,2+ Common Walls
Interior area
- Total structure area: 1,299
- Total interior livable area: 1,299 sqft
Property
Parking
- Total spaces: 1
- Parking features: Garage, Private
- Garage spaces: 1
Features
- Levels: One
- Exterior features: Juliet Balcony
- Pool features: Indoor
- Has view: Yes
- View description: City, Neighborhood, Panoramic, Water
- Has water view: Yes
- Water view: Water
Lot
- Features: Near Public Transit, Near School, Near Shops, Views
Details
- Parcel number: 1000000001002390001804
- Special conditions: None
Construction
Type & style
- Home type: Condo
- Architectural style: Other
- Property subtype: Condominium, Residential
- Attached to another structure: Yes
Materials
- Stucco
Condition
- Year built: 2006
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Private, Trash Collection Public, Water Connected
Community & HOA
Community
- Features: Park
- Security: Building Security, Fire Sprinkler System
- Senior community: Yes
HOA
- Has HOA: No
- Amenities included: Business Center, Children's Playroom, Concierge, Door Person, Elevator(s), Fitness Center, Lounge, Parking, Pool, Receiving Room, Security, Snow Removal, Trash
- Services included: Common Area Maintenance, Maintenance Structure, Snow Removal, Trash, Water
- HOA fee: $1,853 monthly
- HOA name: Trump Plaza New Rochelle
Location
- Region: New Rochelle
Financial & listing details
- Price per square foot: $523/sqft
- Annual tax amount: $8,006
- Date on market: 4/3/2026
- Cumulative days on market: 105 days
- Listing agreement: Exclusive Right To Sell
- Inclusions: washer, dryer, refrigerator, dishwasher, stove top, oven,
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/28/2026 | Pending sale | $679,900$523/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #978861 Report a problem | ||
| 4/3/2026 | Listed for sale | $679,900+18527.4%$523/sqft |
Source: OneKey® MLS as distributed by MLS GRID #978861 Report a problem | ||
| 3/16/2024 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 2/28/2024 | Price change | $4,000-4.8%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/8/2024 | Price change | $4,200-2.3%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/27/2023 | Listed for rent | $4,300+13.2%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/30/2020 | Listing removed | $3,800$3/sqft |
Source: Houlihan Lawrence #H6079430 Report a problem | ||
| 10/26/2020 | Listed for rent | $3,800+1.3%$3/sqft |
Source: Houlihan Lawrence #H6079430 Report a problem | ||
| 3/11/2020 | Sold | $3,650$3/sqft |
Source: Agent Provided Report a problem | ||
| 2/21/2020 | Listing removed | $3,750$3/sqft |
Source: Houlihan Lawrence #5025871 Report a problem | ||
| 1/30/2020 | Price change | $3,750-3.8%$3/sqft |
Source: Houlihan Lawrence #5025871 Report a problem | ||
| 11/30/2019 | Price change | $3,900-2.5%$3/sqft |
Source: Houlihan Lawrence #5025871 Report a problem | ||
| 11/7/2019 | Price change | $4,000-4.8%$3/sqft |
Source: Houlihan Lawrence #5025871 Report a problem | ||
| 8/17/2019 | Listed for rent | $4,200+7.7%$3/sqft |
Source: Houlihan Lawrence #5025871 Report a problem | ||
| 6/29/2018 | Listing removed | $3,900$3/sqft |
Source: Houlihan Lawrence #4824096 Report a problem | ||
| 6/18/2018 | Price change | $3,900-2.5%$3/sqft |
Source: Houlihan Lawrence #4824096 Report a problem | ||
| 5/30/2018 | Listed for rent | $4,000$3/sqft |
Source: Houlihan Lawrence #4824096 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Climate risks
Neighborhood: 10801
Nearby schools
GreatSchools rating
- 6/10Columbus Elementary SchoolGrades: K-5Distance: 0.9 mi
- 7/10Isaac E Young Middle SchoolGrades: 6-8Distance: 0.7 mi
- 4/10New Rochelle High SchoolGrades: 9-12Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Trinity Elementary School
- 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.
- $694,4002 bd3 ba1.2k sqft175 Huguenot St UNIT 2302, New Rochelle, NY 10801Off Market
- $509,8001 bd2 ba925 sqft175 Huguenot St PENTHOUSE 504, New Rochelle, NY 10801Off Market
- $706,8002 bd2 ba1.2k sqft175 Huguenot St UNIT 1101, New Rochelle, NY 10801Off Market
- $--2 bd2 ba-- sqft175 Huguenot St UNIT 1007, New Rochelle, NY 10801Off Market
- $695,0002 bd3 ba1.4k sqft175 Huguenot St UNIT 1606, New Rochelle, NY 10801For Sale
- $708,2002 bd3 ba1.2k sqft175 Huguenot St UNIT 1404, New Rochelle, NY 10801Off Market
- $--2 bd2 ba1.4k sqft175 Huguenot St, New Rochelle, NY 10801Off Market
- $204,663-- bd-- ba-- sqft175 Huguenot St UNIT PENTHOUSE 604, New Rochelle, NY 10801Off Market
- $501,9001 bd2 ba935 sqft175 Huguenot St, New Rochelle, NY 10801Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $689,9002 bd3 ba1.2k sqft175 Huguenot Street #2602, New Rochelle, NY 10801For Sale
MLS ID #1006518, Rosetta Bulfamante, Listing by: Houlihan Lawrence Inc.. OneKey® MLS as distributed by MLS GRID - $695,0002 bd3 ba1.4k sqft175 Huguenot Street #1606, New Rochelle, NY 10801For Sale
MLS ID #1006020, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID - $815,0002 bd3 ba1.4k sqft175 Huguenot Street #2503, New Rochelle, NY 10801For Sale
MLS ID #1022287, Rosetta Bulfamante, Listing by: Houlihan Lawrence Inc.. OneKey® MLS as distributed by MLS GRID - $719,0002 bd3 ba1.4k sqft175 Huguenot Street #2006, New Rochelle, NY 10801For Sale
MLS ID #998693, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID - $535,0002 bd3 ba1.2k sqft175 Huguenot Street #1607, New Rochelle, NY 10801For SaleMLS ID #1006521, Rosetta Bulfamante, Listing by: Houlihan Lawrence Inc.. OneKey® MLS as distributed by MLS GRID
- $515,0001 bd2 ba825 sqft175 Huguenot Street #2205, New Rochelle, NY 10801For SaleMLS ID #1016047, Scott Cohen, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID
- $724,9002 bd2 ba1.4k sqft2287 Johnson Avenue #3B, Bronx, NY 10463For SaleMLS ID #929465, Chintan Trivedi, Listing by: RE/MAX In The City. OneKey® MLS as distributed by MLS GRID
- $660,0002 bd2 ba1k sqft974 Summit Ave Unit 408, Jersey City, NJ 07307For SaleMLS ID #260013864, MEGHAN PERIH. HCMLS
- $925,0002 bd3 ba1.4k sqft35 N Chatsworth Avenue #2H, Larchmont, NY 10538For SaleMLS ID #976862, Mary Gail Barry, Listing by: Compass Greater NY, LLC. OneKey® MLS as distributed by MLS GRID
- $798,0002 bd2 ba1.4k sqftSolaria Riverdale, Bronx, NY 10463ActiveMLS ID #S1814374, Charles G Brophy, Listing by: Douglas Elliman. StreetEasy
- $720,0002 bd2 ba965 sqft140-21 32nd Avenue #6A-N, Flushing, NY 11354For SaleMLS ID #1003147, Mabel L. Sung ABR SRS, Listing by: RE/MAX Team. OneKey® MLS as distributed by MLS GRID
- $675,0001 bd2 ba1k sqft1 Renaissance Square #10G, White Plains, NY 10601For SaleMLS ID #948249, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID
- $825,0002 bd2 ba1.4k sqftSolaria Riverdale, Bronx, NY 10463ActiveMLS ID #S1815097, Deena Spindler, Listing by: Brown Harris Stevens. StreetEasy
- $925,0002 bd3 ba1.4k sqft10 City Place #31F, White Plains, NY 10601For SaleMLS ID #1017817, Dawn Knief, Listing by: Julia B Fee Sothebys Int. Rlty. OneKey® MLS as distributed by MLS GRID
- $660,0001 bd2 ba1k sqft1 Renaissance Square #10C, White Plains, NY 10601For SaleMLS ID #951132, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID
- $670,0001 bd2 ba1k sqft1 Renaissance Square #10A, White Plains, NY 10601For SaleMLS ID #947672, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID
- $730,0002 bd2 ba1k sqft24 Avenue At Port Imperial APT 215, West New York, NJ 07093For SaleMLS ID #260013550, MUKTA BHATIA. HCMLS
- $665,0001 bd2 ba1k sqft1 Renaissance Square #10E, White Plains, NY 10601For SaleMLS ID #947674, John Oliveri, Listing by: Howard Hanna Rand Realty. OneKey® MLS as distributed by MLS GRID
- $630,0001 bd2 ba887 sqft25 City Place #4B, White Plains, NY 10601For SaleMLS ID #1020634, Imma Carletto, Listing by: Serhant LLC. OneKey® MLS as distributed by MLS GRID
- $465,0001 bd1 ba1.1k sqft1270 North Avenue #5A, New Rochelle, NY 10804For SaleMLS ID #876954, Michele Silverman Bedell, Listing by: Silversons Realty, LLC. OneKey® MLS as distributed by MLS GRID
