Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Warburg

Property view
Listing view 2
Listing view 3

479 W 152nd Street #4C, 
Manhattan, NY 10031

$662,000


2

Beds


2

Baths


750

Sq Ft


Condo

Active

Listed by

Karen D Shenker

Jessica Saleh Hunt

Compass

Last updated:

September 16, 2026, 10:28 AM

MLS#

RLS20093014

Source:

NY REBNY

About This Home

479 W 152nd Street #4C

PRICE IMPROVEMENT AND Showing by Appointment -- Move right in to this FULLY RENOVATED 2 bed/1.5 bath bright apartment situated in the heart of the Hamilton Heights/Sugar Hill Historic District - a quiet residential neighborhood on a beautiful tree-lined street. The open kitchen has glossy white lacquer cabinets, quartz granite countertops, top-of-the-line SS appliances including a brand new double door refrigerator with filtered water and automatic ice maker, gas range, built in microwave, Bosch dishwasher and a huge window that floods the space with natural light. The primary bedroom offers ample storage with a custom closet as well as a spacious walk-in closet at the front entrance. The 2nd bedroom could also make a perfect home office (as seen in the 2 virtually staged photos). The brand new in-unit stackable W/D makes laundry a breeze, while central AC/heating ensures year-round comfort. This unit faces the rear of the building allowing for peace and tranquility overlooking the trees. Both bathrooms have been completely renovated and the primary bathroom ensuite has an generous sized stall shower with a Dual Shower Head System which allows for a spa-like experience! Additional features: High ceilings, dual pane soundproof windows, bamboo floors, smooth gliding (laundry) barn door and new LED light fixtures throughout. Head upstairs to enjoy the building's common roof terrace, an inviting space perfect for relaxing or entertaining. Aqueduct Court Condominium (aka Hamilton Park) features include an elevator, electric gate, security system, BRAND new state-of-the-art Virtual Doorman, newly installed smart VIDEO intercom, attentive F/T Super, managing agent and a secure package room providing extra peace of mind for your deliveries and PETS are welcome! LENDING: The Condo has been approved by Guaranteed Rate - request contact details NOTE: A special assessment of $109.49 / month for capital improvements and to build future financial reserves. This boutique condo with magnificent architecture by award winning architect Michael Schmitt offers modern upgrades, turnkey living and if that’s not enough, the building is conveniently located to many neighborhood favorites cafes, restaurants and multiple subway lines (A/C/B/D/1) and buses all nearby. Complimentary access to the stunning public Convent Garden at 151st and St. Nicholas Ave and the Sugar Hill Hope Garden. (pics taken by Exclusive Broker) Please contact the primary exclusive broker. (virtual staging in a few pics showing alternative options)

Home Facts

Condo

2 Baths

2 Bedrooms

Built in 1920

Subdivision & Development:

Hamilton Heights

Price Summary

662,000

$882 per Sq. Ft.

MLS #:

RLS20093014

Last Updated:

September 16, 2026, 10:28 AM

Added:

4 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

1

Interior

Living Area:

750 Sq. Ft.


Structure

Structure

Building Area:

750 Sq. Ft.

Year Built:

1920


Finances & Disclosures

Finances

Price:

$662,000

Price per Sq. Ft:

$882 per Sq. Ft.

MLS Logo
This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. © 2026 The Real Estate Board of New York, Inc., All rights reserved. RLS Data display by Coldwell Banker Warburg This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
See this home in person
479 W 152nd Street #4C
Attend an upcoming open house
Wed, Sep 16
04:30 PM06:00 PM
Sun, Sep 20
01:00 PM01:45 PM

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.