MAJOR PRICE REDUCTION – Motivated Seller, All Offers Considered!
Rare investment opportunity — purchase with tenant in place. This spacious 2BR/2.5BA condo at Trump Plaza New Rochelle offers approximately 1,200 sq ft of luxury living with stunning views from every window.
Unit highlights: Jenn-Air appliances, granite countertops, hardwood floors, spa bath, walk-in closet in primary bedroom, and new in-unit laundry.
Building amenities (included in common charges): Heated indoor pool, 24-hour concierge, door man, security, newly updated fitness center, community room with outdoor terrace, children's playroom, business centers, private garage parking available.
Prime location: Steps from New Rochelle Train Station with direct Manhattan and Amtrak access, plus dining, shopping, and entertainment nearby.
Owner wants a quick sale — don't miss this opportunity!
For sale
Price increase: $30K (8/25)
$565,000
175 Huguenot Street #1607, New Rochelle, NY 10801
2beds
1,200sqft
Condominium, Residential
Built in 2006
-- sqft lot
$-- Zestimate®
$471/sqft
$1,712/mo HOA
What's special
Heated indoor poolPrivate garage parking availableSpa bathJenn-air appliancesHardwood floorsGranite countertopsNew in-unit laundry
- 90 days
- 1,071
- 58
Likely to sell faster than
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#: 1006521
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Other
- Description: Entrance hall with large closet, powder room, open kitchen, dining area, living room with Juliette doors, laundry, full hall bath, second bedroom, main bedroom with walk in closet and spa bath.
- Level: First
Heating
- Electric, Forced Air
Cooling
- Central Air, Wall/Window Unit(s)
Appliances
- Included: Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Washer, Indirect Water Heater
- Laundry: Inside
Features
- Elevator, Granite Counters, Primary Bathroom, Walk-In Closet(s)
- Flooring: Hardwood
- Windows: Floor to Ceiling Windows, Oversized Windows
- Basement: None
- Attic: None
- Has fireplace: No
- Common walls with other units/homes: End Unit
Interior area
- Total structure area: 1,200
- Total interior livable area: 1,200 sqft
Property
Parking
- Total spaces: 1
- Parking features: Garage, Underground
- Garage spaces: 1
Features
- Levels: One
- Exterior features: Juliet Balcony
- Pool features: Indoor
- Has view: Yes
- View description: City, Neighborhood
Lot
- Features: Near Public Transit, Near School, Near Shops, Views
Details
- Parcel number: 1000000001002390001607
- Special conditions: None
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium, Residential
- Attached to another structure: Yes
Materials
- Stone, Stucco
Condition
- Actual
- Year built: 2006
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Trash Collection Private, Trash Collection Public
Community & HOA
Community
- Features: Park
- Security: Building Security, Fire Alarm, Fire Sprinkler System
- Subdivision: Trump Plaza New Rochelle
HOA
- Has HOA: Yes
- Amenities included: Elevator(s), Fitness Center, Park
- Services included: Common Area Maintenance, Water
- HOA fee: $1,712 monthly
- HOA name: Akam
- HOA phone: 212-986-0001
Location
- Region: New Rochelle
Financial & listing details
- Price per square foot: $471/sqft
- Tax assessed value: $5,000
- Annual tax amount: $7,453
- Date on market: 6/1/2026
- Cumulative days on market: 91 days
- Listing agreement: Exclusive Right To Sell
- Inclusions: washer, dryer, refrigerator, microwave, stove top, oven, light fixtures
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/25/2026 | Price change | $565,000+5.6%$471/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #1006521 Report a problem | ||
| 6/10/2026 | Price change | $535,000-5.3%$446/sqft |
Source: OneKey® MLS as distributed by MLS GRID #1006521 Report a problem | ||
| 6/1/2026 | Listed for sale | $565,000+9.7%$471/sqft |
Source: OneKey® MLS as distributed by MLS GRID #1006521 Report a problem | ||
| 9/30/2025 | Listing removed | $515,000$429/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 9/9/2025 | Price change | $515,000-4.5%$429/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 9/5/2025 | Listing removed | $3,900$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/11/2025 | Price change | $539,000-3.6%$449/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 7/7/2025 | Price change | $3,900+8.3%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 7/7/2025 | Price change | $559,000+1.8%$466/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 5/20/2025 | Listed for rent | $3,600+5.9%$3/sqft |
Source: Zillow Rentals Report a problem | ||
| 5/13/2025 | Price change | $549,000-2.8%$458/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 3/18/2025 | Price change | $565,000-2.6%$471/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 7/1/2024 | Listed for sale | $580,000+17.2%$483/sqft |
Source: OneKey® MLS as distributed by MLS GRID #H6315590 Report a problem | ||
| 6/4/2021 | Listing removed | -- |
Source:  Houlihan Lawrence Inc Report a problem | ||
| 4/20/2021 | Price change | $3,400-2.9%$3/sqft |
Source: Houlihan Lawrence Inc #H6097417 Report a problem | ||
| 3/26/2021 | Price change | $3,500-2.8%$3/sqft |
Source: Houlihan Lawrence Inc #H6097417 Report a problem | ||
| 3/15/2021 | Price change | $3,600-1.4%$3/sqft |
Source: Houlihan Lawrence Inc #H6097417 Report a problem | ||
| 2/19/2021 | Listed for rent | $3,650+10.6%$3/sqft |
Source: Houlihan Lawrence Inc #H6097417 Report a problem | ||
| 9/27/2019 | Listing removed | $495,000$413/sqft |
Source: Better Homes and Gardens Rand Realty #4916480 Report a problem | ||
| 5/23/2019 | Price change | $495,000-2.9%$413/sqft |
Source: Better Homes and Gardens Rand Realty #4916480 Report a problem | ||
| 5/17/2019 | Listing removed | $3,300$3/sqft |
Source: Better Homes and Gardens Rand Realty - White Plains #4914798 Report a problem | ||
| 5/14/2019 | Price change | $510,000-4.7%$425/sqft |
Source: BHG Rand Realty #4916480 Report a problem | ||
| 5/2/2019 | Listed for rent | $3,300$3/sqft |
Source: Better Homes and Gardens Rand Realty - White Plains #4914798 Report a problem | ||
| 4/23/2019 | Listed for sale | $535,000+30.5%$446/sqft |
Source: BHG Rand Realty #4916480 Report a problem | ||
| 1/8/2015 | Sold | $410,000-41.7%$342/sqft |
Source: Public Record Report a problem | ||
| 10/23/2007 | Sold | $702,800$586/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $5,000 |
| 2024 | -- | $5,000 |
| 2023 | -- | $5,000 |
| 2022 | -- | $5,000 |
| 2021 | -- | $5,000 |
| 2020 | -- | $5,000 |
| 2019 | -- | $5,000 |
| 2018 | -- | $5,000 |
| 2017 | -- | $5,000 |
| 2016 | -- | $5,000 |
| 2015 | $4,844 | $5,000 |
| 2014 | $4,844 | $5,000 |
| 2013 | $4,844 | $5,000 |
| 2012 | -- | $5,000 |
| 2011 | -- | $5,000 |
| 2010 | -- | $5,000 |
| 2009 | -- | $5,000 |
| 2008 | -- | $5,000 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 10801
Nearby schools
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.
- $677,8002 bd3 ba1.2k sqft175 Huguenot St UNIT 2302, New Rochelle, NY 10801Off Market
- $507,4001 bd2 ba925 sqft175 Huguenot St PENTHOUSE 504, New Rochelle, NY 10801Off Market
- $696,5002 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
Similar homes
- $660,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 - $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 - $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 - $565,0002 bd2 ba1k sqft50 Columbus Avenue #507, Tuckahoe, NY 10707For Sale
MLS ID #1030313, Daria Kelty, Listing by: Houlihan Lawrence Inc.. OneKey® MLS as distributed by MLS GRID - $445,0001 bd1 ba1.1k sqft25 Leroy Place #511, New Rochelle, NY 10805For SaleMLS ID #1039890, Jeffrey D. Hanrahan, Listing by: Keller Williams Realty Group. OneKey® MLS as distributed by MLS GRID
- $409,9991 bd1 ba900 sqft25 Leroy Place #206, New Rochelle, NY 10805For SaleMLS ID #1028569, Daniele Lovecchio, Listing by: HomeSmart Homes & Estates. OneKey® MLS as distributed by MLS GRID
- $519,0002 bd1 ba1.1k sqft1434 110th Street #5A, College Point, NY 11356For SaleMLS ID #1044559, Hsin Yuan Yang, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID
- $425,0001 bd1 ba971 sqft25 Leroy Place #501, New Rochelle, NY 10805For SaleMLS ID #996787, Amy Marino, Listing by: Coldwell Banker Realty. OneKey® MLS as distributed by MLS GRID
- $499,9992 bd2 ba1.4k sqft23 Water Grant Street #4N, Yonkers, NY 10701For SaleMLS ID #1019119, Eric Stein, Listing by: RE/MAX Distinguished Hms.&Prop. OneKey® MLS as distributed by MLS GRID
- $645,0002 bd2 ba1k sqft460 W 236th Street #6A, Bronx, NY 10463For SaleMLS ID #954620, Christopher Casey, Listing by: Sotheby's International Realty. OneKey® MLS as distributed by MLS GRID
- $399,0001 bd1 ba791 sqft1155 Warburton Avenue #5A, Yonkers, NY 10701For SaleMLS ID #1040500, Sara C. Reel, Listing by: Julia B Fee Sothebys Int. Rlty. OneKey® MLS as distributed by MLS GRID
- $539,0001 bd1 ba600 sqft35-20 146th Street #3B, Flushing, NY 11354For SaleMLS ID #1044523, Shirley Y. Chen, Listing by: Prime Realty. OneKey® MLS as distributed by MLS GRID
- $649,9992 bd2 ba1.1k sqft1155 Warburton Avenue #3PR, Yonkers, NY 10701For SaleMLS ID #1003407, Sara C. Reel, Listing by: Julia B Fee Sothebys Int. Rlty. OneKey® MLS as distributed by MLS GRID
- $578,0001 bd1 ba800 sqft1 Bay Club Drive #11J, Bayside, NY 11360For SaleMLS ID #1023403, Baimei Wan, Listing by: Winzone Realty Inc. OneKey® MLS as distributed by MLS GRID
- $599,0001 bd2 ba991 sqft63-36 99th Street #5B, Rego Park, NY 11374For SaleMLS ID #1019408, Aaron S. Nathans, Listing by: NYC Red Group LLC. OneKey® MLS as distributed by MLS GRID
