240 West 123RD Street #TERRA, New York City, NY 10027
Listing Courtesy of Brown Harris Stevens Residential Sales LLC
$3,870,000
Potential Rebate: $58,050
Overview
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.<br> <br> 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.<br> <br> 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.<br> <br> For added convenience, Terra includes a Miele stackable washer and dryer, featuring a condensing system that provides energy-efficient and space-saving laundry solutions.<br> <br> 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.<br>
Home Features
- •Central Air
- •Washer Hookup
- •In Unit
- •Balcony
- •Private Outdoor Space Over 60 Sqft
- •Washer Dryer Allowed
Estimated Monthly Payment
$20,346 per month
30 year fixed, 6.28% Interest
Estimated Rebate for this Home
One-time rebate at closing
$58,050
Monthly savings impact
$161/mo
Effective Purchase Price
$3,811,950
(Home Price - Estimated Rebate)
💡 Estimated rebate from our commission
The rebate is paid to you at closing and can help offset closing costs or other expenses.
Calculator Disclaimer: Commission structures vary by property, developer, and transaction. Resale properties typically offer around 3% buyer-side commission, and new developments around 5%, but this is not guaranteed. New developments are often open to negotiation, and each property and transaction is unique. Rebate amounts shown are estimates only. Please confirm commission terms and rebate eligibility with Regis Roumila for the specific property you are interested in. This information is not provided by the Real Estate Board of New York (REBNY).
Similar Homes
100 CLAREMONT Avenue #35C, New York City, NY 10027
Listing Courtesy of Corcoran Sunshine Marketing Group
RLS IDX Data display by Real Estate Rebate Team. This 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. IDX information is provided exclusively for consumers’ personal, non-commercial use and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information furnished regarding property for sale, rental or financing is from sources deemed reliable, but no warranty or representation is made as to the accuracy thereof and same is submitted subject to errors, omissions, change of price, rental or other conditions, prior sale, lease or financing or withdrawal without notice. All dimensions are approximate. For exact dimensions, you must hire your own architect or engineer and the number of bedrooms listed is for informational purposes and is not a legal conclusion. Please consult with your own architect or engineer for exact dimensions and legal specifications.
The Real Estate Rebate Team
Listing Courtesy of Brown Harris Stevens Residential Sales LLC
Data Source: TRESTLE #RLS20048653
RLS at REBNY
Why Buy With Us
Rebates Up To
2.5%
25+ Years
Experience
REBNY & NAR
Member
Verified
Listings
RLS IDX Data display by Real Estate Rebate Team. This 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. IDX information is provided exclusively for consumers’ personal, non-commercial use and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information furnished regarding property for sale, rental or financing is from sources deemed reliable, but no warranty or representation is made as to the accuracy thereof and same is submitted subject to errors, omissions, change of price, rental or other conditions, prior sale, lease or financing or withdrawal without notice. All dimensions are approximate. For exact dimensions, you must hire your own architect or engineer and the number of bedrooms listed is for informational purposes and is not a legal conclusion. Please consult with your own architect or engineer for exact dimensions and legal specifications.
The Real Estate Rebate Team
Listing Courtesy of Brown Harris Stevens Residential Sales LLC
Data Source: TRESTLE #RLS20048653
RLS at REBNY
Price Analysis
Compare average listing prices and value metrics for Terra and Cielo against the surrounding South Harlem market.
Average List Price
Price Per SqFt
92.40% Lower
than the South Harlem price-per-sq-ft average
Units in this building are listed below the neighborhood average, potentially offering better value per square foot compared to surrounding properties.
