Milton Coste

Licensed Real Estate Associate Broker

(917) 416-7433
240 W 123RD Street #TERRA
Interested in this property?
Active For Sale Condo

$3,499,000

$1,623 per sq ft

240 W 123RD Street #TERRA

South Harlem, Manhattan

Terra and Cielo

MLS® #RLS20048653

RLS at REBNY

Listing by Brown Harris Stevens Residential Sales LLC

4

Bedrooms

3.5

Baths

2,156

Sq. Ft.

2025

Year Built

Quick Summary

Bedrooms 4
Bathrooms 4 full, 1 half
Living Area 2,156 sq ft
Year Built 2025
Ownership Condo
HOA/Common Charges $1,223/mo
Property Taxes Contact for details
Parking Garage
Neighborhood South Harlem
Floor 8 of 8

Property Highlights

  • Views: Other
  • Exposure: North,South facing
  • Outdoor Space: Patio, Balcony

Property Details

Type Condo
Ownership Condominium
Total Rooms 10
Baths 3 Full, 1 Half
Floor 8 of 8
View Other
Exposure North,South
Cooling Central Air
Pets Yes
Year Built 2025 (New)
Living Area 2,156 sq ft
Parking Garage Available
Structure Type HighRise
Basement Other
Parcel # 1928-0050
Block/Lot 01928/0050

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

Building Other Washer Hookup In Unit

Exterior Features

Balcony Private Outdoor Space Over60 Sqft Patio Balcony

Building Amenities

Elevators

Appliances

Washer Dryer Allowed

Building Information

Financial Details

Common Charges $1,223/mo
RE Taxes Contact for details
Original Price $3,870,000
Previous Price $3,870,000

South 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 Neighborhood

Active 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 All

Location

Loading map...

240 W 123RD Street #TERRA, South Harlem, New York County

Floor Plans

Floor Plan 1

Building Information

Official NYC property records for this building

2023
Year Built
3 years old
7
Floors
2
Residential Units
R7A
Zoning District
Two Family Dwellings

Tax & Assessment

Assessed Value: $80,760
Land Value: $22,620
Exemptions: $0

Note: Individual unit taxes may differ. Verify current tax bills with NYC DOF.

Lot Area: 1,396 SF
Building Area: 5,484 SF
Built FAR: 3.93
Allowed FAR: 4

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

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-7433
MLS® ID: RLS20048653
First Listed: 9/15/2025
On Market: 9/15/2025
Price Changed: 4/7/2026
Contract Date: 9/15/2025

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.

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 at REBNY

RLS Data display by Keller Williams NYC. Data last updated on 5/4/2026 at 3:31 PM UTC

Buying a Condo? Start Here

Co-op vs. Condo: Which Is Right for You?

Ownership structure, board approval, financing: the full comparison.

Read article

Condo Due Diligence Checklist

What to review before signing: financials, reserve fund, offering plan.

Read article

How to Read a Condo Offering Plan

Decode the offering plan before you commit to any new development.

Read article

NYC Mansion Tax: 2026 Guide

How the tiered mansion tax works for purchases over $1M.

Read article

Interested in this property?

Your info is secure and never shared.

Call Text Email