240 West 123rd Street, Unit TERRA

240 W 123rd St
Harlem

$3,870,000
Price
4
Beds
2,156 Sq. Ft.
$1,795 / Sq. Ft.
2,156
Sq. Ft.
$1,795
per Sq. Ft.
New Construction
New Construction
a view of outdoor space yard and patio
a view of a dining room with furniture window and wooden floor
a backyard of a house with dining table and chairs
a living room with furniture and a large window
a living room with furniture and a window
a bathroom with a sink a mirror and a shower
a bedroom with a large bed and a potted plant
a bathroom with a sink and a mirror
a bedroom with a large bed and a large window
a bedroom with bed and a window
a bedroom with a bed and a mirror
front view of a building

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...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.

Property Details for 240 West 123rd Street, Unit TERRA

View
Other
LISTING UPDATED: 11/13/2025 10:19 AM

Property Details for 240 West 123rd Street, Unit TERRA

StatusActive
MLS IDRLS20048653
Days on Market97
Taxes$411 / month
Common Charges$1,223 / month
Min. Down Pymt-
Total Rooms6.0
Compass TypeUnitTriplex
MLS TypeCondominium
Year Built-
CountyNew York County

Building

Location

Listing Courtesy of Brown Harris Stevens Residential Sales LLC
Add your commute

Building Information for 240 West 123rd Street, Unit TERRA

Building/Complex240 W 123rd StFloor-Stories-Residences-Pet Policy-Pet Policy Details-Year Built-Building Age-

Payment Calculator

$20,757 per month

30 year fixed, 6.28% Interest

Principal and Interest

$19,123

Property Taxes

$411

Maintenance/Common Charges

$1,223

The Payment Calculator is for illustrative purposes only.

Property Information for 240 West 123rd Street, Unit TERRA

Summary
Location and General Information
  • Subdivision Name: South Harlem
  • Stories Total: 8
  • Exposures: North, South
  • Garage Spaces: 0.0
  • View: Yes
  • Zoning Description: R7A
Taxes and HOA
  • Tax Lot: 0050
  • Tax Deduction Percent: .00%
  • Tax Block: 01928
  • Association Fee Frequency: Monthly
  • Flip Tax: $0
  • Building Tax Lot: 0050
  • Tax Monthly Amount: 411.0
  • Tax Abatement YN: false
Parking
  • Garage: Yes
  • Garage Spaces Assigned YN: false
Property
Lot Information
  • Living Area: 2156.0
  • Living Area Units: SquareFeet
  • Building Name: Terra and Cielo
Building Information
  • Building Features: Elevators
  • Landmark Status YN: false
  • Building Laundry Features: Other
  • Building Pets Allowed: BuildingYes
  • Capital Reserves YN: false
  • Green Building YN: false
Property and Assessments
  • New Development: Yes
  • Sponsor Unit: Yes
  • Certificate Of Occupancy: Yes
  • Percent Of Common Elements: .00%
  • Common Interest: Condominium
  • Number Of Shares: 0
  • New Construction: Yes
  • Structure Type: HighRise
  • Property Condition: Excellent
Interior and Exterior Features
Exterior Features
  • Basement: Other
  • Exterior Features: Balcony
  • Patio And Porch Features: Patio
Interior Features
  • Cooling: CentralAir
  • Entry Level: 8
  • Appliances: WasherDryerAllowed
  • Fireplace: No
  • Kitchen Condition: Excellent
  • Floor Number: 8
  • Basement: No
  • Cooling: Yes
  • Laundry Features: WasherHookup, InUnit
  • Bathroom Condition: Excellent
  • ElevatorsTotal: 1
Multi Family
Multi-Family Information
  • Number Of Units Total: 2
Rental
Rental Information
  • Pets Allowed: UnitNo
  • Attendance Type: None
  • Land Lease: No

Property History for 240 West 123rd Street, Unit TERRA

DateEvent & SourcePriceAppreciationLink
Sep 15, 2025

Listed (Active)

RLS RESO #RLS20048653

$3,870,000—
Jun 10, 2025

Permanently Off Market

RLS RESO #RLS20021955

$4,185,000——
Jun 10, 2025

Temporarily Off Market

RLS RESO #RLS20021955

$4,185,000——
May 7, 2025

Listed (Active)

RLS RESO #RLS20021955

$4,185,000—
DateEvent & SourcePrice
09/15/2025

Listed (Active)

RLS RESO #RLS20048653

$3,870,000
06/10/2025

Permanently Off Market

RLS RESO #RLS20021955

$4,185,000
06/10/2025

Temporarily Off Market

RLS RESO #RLS20021955

$4,185,000
05/07/2025

Listed (Active)

RLS RESO #RLS20021955

$4,185,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Schools near 240 West 123rd Street, Unit TERRA

This home is within New York City Geographic District # 3.
Rating
School
Type
Grades
Distance
P.S. 76 A Phillip Randolph
Public - PK to 8
Beacon High School
Public - 9 to 12
West End Secondary School
Public - 6 to 12
Fiorello H Laguardia High School of Music, Art and Performing Arts
Public - 9 to 12
Rating
School
Distance
P.S. 76 A Phillip Randolph
PublicPK to 8

Beacon High School
Public9 to 12

West End Secondary School
Public6 to 12

Fiorello H Laguardia High School of Music, Art and Performing Arts
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Neighborhood Map and Transit

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 240 West 123rd Street, Unit TERRA, Harlem

240 West 123rd Street, Unit TERRA is for sale in Harlem. This property was listed for sale on September 15, 2025 by Brown Harris Stevens Residential Sales LLC, it's currently listed at $3,870,000. This listing's school district is New York City Geographic District # 3. Nearby schools include P.S. 76 A Phillip Randolph, Beacon High School and West End Secondary School. 240 West 123rd Street, Unit TERRA is a 4-bed, 4-bath, 2,156 sqft.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Brown Harris Stevens Residential Sales LLC

This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2025 The Real Estate Board of New York, Inc., All rights reserved. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey® MLS. Information Copyright 2025, OneKey® MLS. All data is deemed reliable but is not guaranteed accurate by Compass. See Terms of Service for additional restrictions. Compass · Tel: 212-913-9058 · New York, NY 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. ©2025 The Real Estate Board of New York, Inc., all rights reserved. This information is not guaranteed, should be independently verified and may not reflect all real estate activity in the market. Offers of compensation set forth here are for other RLSParticipants only and may not reflect other agreements between a consumer and their broker.©2025 The Real Estate Board of New York, Inc., All rights reserved.