




240 W 123rd St, New York, NY, 10027
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
Schools
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
- Winter Weather
- Tsunami
How This Home’s Risks Compare
FEMA Declared Disasters in New York County and New York
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
| Monthly | Annual | |
|---|---|---|
| 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 |
Income You'd Need if You Spent...
New York FAIR Plan Programs
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.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
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
| Date | Event | Price |
|---|---|---|
| 2026-04-07 | Price change | $3,499,000 |
| 2025-09-15 | Price change | $3,870,000 |
| 2025-06-10 | Price change | $4,375,000 |
| 2025-05-07 | Listed for sale | $4,185,000 |
| 2015-07-30 | Sold | $975,000 |
| 2013-06-05 | Sold | $390,000 |
| 2001-04-26 | Sold | $144,000 |
| 2000-10-24 | Sold | $10,000 |
