See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

240 W 123rd St, New York, NY, 10027

4beds
4baths
2,156sqft
$3,150,000
$1,461price/sqft
$19,938/moest. monthly cost
$797,520/yrincome needed

About This Home

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.

Getting Around

98
WalkingWalker's Paradise
100
TransitRider's Paradise
85
BikeVery Bikeable

Schools

4/10
Ps 154 Harriet TubmanGrades PK-50.2 mi
8/10
Columbia Secondary SchoolGrades 6-120.3 mi

Construction

Condition

  • Year built: 2025

Type & Style

  • Home type: Condo
  • Property subType: Condominium

Interior

Appliances

  • Appliances included: Dishwasher,Washer/Dryer

Bedrooms & Bathrooms

  • Bedrooms: 4
  • Bathrooms: 4
  • Full bathrooms: 3
  • 1/2 bathrooms: 1

Cooling

  • Cooling features: Central Air

Features

  • Flooring: Hardwood

Interior Area

  • Total structure area: 2,156
  • Total interior livable area: 2,156 sqft

Property

Details

  • Parcel number: 019280050
  • Special condition: Sponsor Unit

Features

  • Patio & porch: Other
  • Exterior features: Balcony,Garden
  • Has view: Yes
  • View description: Garden

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Heat Wave
    Heat WaveModerate
  • Winter Weather
    Winter WeatherModerate
  • Tsunami
    TsunamiInsufficient Data

How This Home’s Risks Compare

Heat Wave
Winter Weather
Tsunami

FEMA Declared Disasters in New York County and New York

Flood
Severe Storm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $15,928$191,136
Home Insurance *$1,791$21,492
Property Taxes $1,863$22,356
Electricity $356$4,275
Total$19,938$239,256
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$683,588/yr
40% on housing$598,140/yr
45% on housing$531,680/yr

New York FAIR Plan Programs

New York Property Insurance Underwriting Association

Covered
WildfireWildfire
HailHail
WindWind
Visit Website →
Current Policies
Residential: 20,669Commercial: 1,556
Total Premiums$32.27M
Total Exposure$7.63B

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 2.0%
2.0%
0%30.0%
Electricity Growth Rate10-year average: 7.1%
7.1%
0%15.0%
Property Taxes Growth Rate2-year average: 1.0%
1.0%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$1,461This listing

vs Other Active Listings

Avg $/sqft

ZIP 10027$592
New York County$1,488

vs Homes Sold Last Month

Median $/sqft

ZIP 10027$620
New York County$1,203

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

No zestimate history available

Price History

DateEventPrice
2026-04-07Price change$3,499,000
2025-09-15Price change$3,870,000
2025-06-10Price change$4,375,000
2025-05-07Listed for sale$4,185,000
2015-07-30Sold$975,000
2013-06-05Sold$390,000
2001-04-26Sold$144,000
2000-10-24Sold$10,000

For Sale by Agent

AgentCandice Milano
BrokerageBrown Harris Stevens

Similar Homes