240 W 123RD Street #TERRA
MLS® #RLS20048653
Listing by Brown Harris Stevens Residential Sales LLC
4
Bedrooms
4.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
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 vibrant 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
51
Median Asking Price
$1.10M
Median $/Sqft
$951
Avg Days on Market
N/A
New This Week
1
Price Reduced
41%
Sold (30 Days)
2
Median Sale Price
$605K
Live data from RLS at REBNY • Updated 2/16/26, 2:28 AM EST
Similar Listings in South Harlem
View All
Active
77 E 110TH Street #2A
Condo • RLS #RLS20060702
Active
1400 5TH Avenue #THC2
Condo • RLS #RLS20057471
Active
23 W 116TH Street #12D
Condo • RLS #RLS20016126
Active
1485 5TH Avenue #13A
Condo • RLS #RLS20044929
Active
18 MORNINGSIDE Avenue #3
Condo • RLS #RLS20025945
Active
371 MORNINGSIDE Avenue #8B
Condo • RLS #RLS20070508
Location
240 W 123RD Street #TERRA, South Harlem, New York County
Listing Data
RLS® at REBNY (Real Estate Board of New York) via Trestle API. Updated in real-time.
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.
Listing 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.
RLS Data display by Keller Williams NYC. Data last updated on 2/16/2026 at 7:28 AM UTC