Key Details
$675,000
2 Beds
1.5
715
$944
4
Condo
Excellent
4C
4
For Sale
Description
PRICE REDUCTION and ready move in. Fully renovated light-filled 2 bed/1.5 bath apartment which is perfectly 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 is a chef’s dream with glossy white lacquer cabinets, quartz granite countertops, top-of-the-line SS appliances including a brand new double door refrigerator, gas range, 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 entrance. The 2nd bedroom could also make a perfect home office (as seen in the pics).
The new in-unit washer/dryer 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 oversized stall shower with aDual 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, state of the art Virtual Doorman, video intercom, attentive F/T Super, managing agent and a secure package room providing extra peace of mind for your deliveries. Pet friendly too! Note: J51 Tax Abatement
This boutique condo with magnificent architecture by award winning architect Michael Schmitt offers modern upgrades, turnkey living and if thats 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 by Exclusive Broker)
Dont miss this incredible opportunityschedule your private showing today with the exclusive #1 broker.
(virtual staging in a few pics showing alternative options)
Video Tour
Important Stuff
| Common Charges | $827/mo |
| Taxes | $143/yr |
| Financing / Down Payment | 10% |
| Pets | No Pets |
Home Features
Dishwasher Doorman Elevator Laundry In Unit
Building Amenities
Doorman Elevator
Building Info
| Building Name | AQUEDUCT COURT |
| Address | 479 West 152nd Street |
| Year Built | 1895 |
| Total Units | 15 |
| Stories | 6 |
| Service Level | Elevator |
| Building Type | Condo |
| Building Pets Policy | Unknown |
| More on StreetEasy | View Building |
Map
History
| Listed | May 23, 2026 |
| Days on Market | 78 |
| Last Updated | August 4, 2026 |
Full public sale/price history isn't available through our listing feed for this property. See this listing on StreetEasy for recorded sale history where available.
What It'll Cost
Known monthly carrying costs (excludes mortgage): $839/mo · Common Charges $827 · Taxes $12/mo (est.)
For a full breakdown of closing costs, mansion tax, mortgage recording tax, and title insurance on this $675,000 purchase, use our NYC Buyer Closing Cost Calculator and our Commission Rebate Calculator to see how much NestApple can rebate you at closing.
Similar Listings
Similar Listings Sold
Closed-sale data isn't available through our current listing feed for this neighborhood. Check StreetEasy for recent comparable sales.