240 W 123RD Street #TERRA
MLS® #RLS20048653
Listing by Brown Harris Stevens Residential Sales LLC
4
Bedrooms
3.5
Baths
2,156
Sq. Ft.
2025
Year Built
Quick Summary
Property Highlights
- Views: Other
- Exposure: North,South facing
- Outdoor Space: Patio, Balcony
Property Details
Listing History
| Event | Date | Price | Change |
|---|---|---|---|
| Listed | Sep 15, 2025 | $3,870,000 | - |
| Currently | May 4, 2026 | $3,499,000 | -9.6% |
Description
Terra is an extraordinary 4-bedroom convertible, 3.5-bath four-story residence offering a seamless connection between indoor and outdoor living. With abundant natural light pouring into every room, the home features multiple balconies and an expansive private garden, designed for entertaining or quiet relaxation.
The bright, open-concept living area provides a welcoming space, blending modern elegance with comfort, making it well-suited for gatherings or peaceful retreats. The kitchen is thoughtfully designed, featuring sleek Caesarstone countertops, custom cabinetry, a four-zone induction cooktop, and a suite of state-of-the-art Fisher & Paykel appliances, offering both functionality and elegance.
On the top floor, the primary suite spans an entire level, providing a private retreat with its own balcony and generous closet space. The primary bathroom offers a spa-like experience, with Porcelanosa porcelain tiles, custom Silestone vanities, and Carrara marble accents, complemented by anti-slip flooring for safety and comfort.
For added convenience, Terra includes a Miele stackable washer and dryer, featuring a condensing system that provides energy-efficient and space-saving laundry solutions.
Nestled in the heart of Upper Manhattan, Harlem offers a rich tapestry of history, culture, and vibrant living. Known for its iconic brownstones and tree-lined streets, the neighborhood boasts a thriving arts scene, with renowned venues like the Apollo Theater and Studio Museum of Harlem just steps away. Riverside Park and Central Park provide ample green spaces for morning jogs or weekend picnics. Harlem's diverse dining scene ranges from classic soul food to trendy eateries. With easy access to multiple subway lines, commuting Downtown or to other boroughs is a breeze, while the nearby Harlem River Drive offers quick access to the George Washington Bridge and major highways, making LaGuardia and JFK airports easily reachable.
Features & Amenities
Interior Features
Exterior Features
Building Amenities
Appliances
Building Information
Financial Details
About South Harlem
View All South Harlem ListingsSouth Harlem, often called 'SoHa,' has become one of Upper Manhattan's most sought-after areas due to its proximity to Central Park North and Columbia University. The neighborhood features a stunning array of restored brownstones and a popular restaurant scene along Frederick Douglass Boulevard. The real estate market is a mix of high-end new construction condominiums and historic cooperatives that offer a sophisticated lifestyle at the intersection of Harlem and the Upper West Side.
South Harlem Live Market Data
View NeighborhoodActive Listings
59
Median Asking Price
$949K
Median $/Sqft
$925
Avg Days on Market
N/A
New This Week
7
Price Reduced
42%
Sold (30 Days)
3
Median Sale Price
$1.02M
Live data from RLS at REBNY • Updated 5/4/26, 11:31 AM EST
Similar Listings in South Harlem
View All303 W 113TH Street #PH
Condo • RLS #RLS20077613
7 E 124TH Street
Single Family Residence • RLS #RLS20075421
1485 5TH Avenue #13A
Condo • RLS #RLS20044929
1485 5TH Avenue #15H
Condo • RLS #RLS20077333
5 W 120TH Street #1
Condo • RLS #RLS20069221
321 W 110TH Street #7A
Condo • RLS #RLS20084744
Browse More NYC Properties
In This Neighborhood
By Property Type
By Borough
Location
240 W 123RD Street #TERRA, South Harlem, New York County
Floor Plans
Building Information
Official NYC property records for this building
Tax & Assessment
Note: Individual unit taxes may differ. Verify current tax bills with NYC DOF.
Source: NYC PLUTO (Primary Land Use Tax Lot Output), NYC Department of City Planning (data.cityofnewyork.us)
Want help estimating ownership costs or understanding building compliance? Let's discuss
Listing Data
RLS® at REBNY (Real Estate Board of New York) via Trestle API. Updated in real-time.
Building Data
NYC PLUTO (Primary Land Use Tax Lot Output), NYC Department of City Planning. Updated quarterly.
Market Data
RLS® at REBNY (Real Estate Board of New York). Live data updated in real-time.
Map & Location
OpenStreetMap contributors via Leaflet. Geocoding via Nominatim.
All data is provided for informational purposes only and should be independently verified. See our Data Sources Policy for more information.
Frequently Asked Questions
Common questions about this property
The current listed common charges are $1,223 per month. Confirm the exact amount with the listing broker before making an offer.
This property has 4 bedrooms and 3 full bathrooms and 1 half bathroom.
The listed interior living area is 2,156 square feet. Verify dimensions independently during due diligence.
According to MLS records, the building was constructed in 2025, making it approximately 1 years old.
This listing is a condominium. Buyers receive a deed to their individual unit and own their space outright, subject to condo association rules.
Pets are permitted at this property. Contact the listing broker for weight limits or breed restrictions.
At the current list price of $3,499,000 for 2,156 sq ft, the asking price per square foot is approximately $1,623. This figure is for reference only and may differ from appraised or assessed values.
To schedule a private showing, contact Milton Coste at (917) 416-7433 or [email protected]. Per REBNY guidelines effective 2025, a Buyer Representation Agreement is required before a buyer's broker can show you properties. You may attend open houses independently without one.
Have a question not answered here?
(917) 416-7433Listing Courtesy of Brown Harris Stevens Residential Sales LLC - Candice L Milano
Listing Contact: (212) 381-2639
Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York's Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer's personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing 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. This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Broker Commission Disclosure: Broker commissions are not set by law and are fully negotiable.
Buyer Notice: Planning to work with a buyer's broker? A Buyer Representation Agreement is required before your broker can show you properties, per REBNY/UCBA guidelines (effective 2025). You may attend open houses independently without one.
RLS Data display by Keller Williams NYC. Data last updated on 5/4/2026 at 3:31 PM UTC