Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Choice Properties

Property view
Listing view 2
Listing view 3

142 Mermaid Lane #284, 
Bronx, NY 10473

$399,900

3

Beds

3

Baths

1,185

Sq Ft

Condo

Active

Listed by

Gabriel Oquendo

Go Real Estate Inc.

Last updated:

September 16, 2026, 10:58 AM

MLS#

1037452

Source:

OneKey MLS

About This Home

142 Mermaid Lane #284

Welcome to Shorehaven Condominium! This spacious 3-bedroom, 2-bath duplex condominium offers a bright and functional layout featuring living room, dining areas, kitchen, and comfortably sized bedrooms. Residents can enjoy a variety of community amenities, including 24 hour gated security, a fitness center, swimming pool, waterfront views and beautifully maintained shared outdoor spaces Conveniently located near shopping, restaurants, parks, major highways, and public transportation, this property offers both comfort and convenience. Property is being sold AS-IS, WHERE-IS, with existing tenants in place. No interior access is currently available. Buyer is responsible for conducting all due diligence regarding the property, tenancy, and condition.

Home Facts

Condo

3 Baths

3 Bedrooms

Built in 2006

Price Summary

399,900

$337 per Sq. Ft.

MLS #:

1037452

Last Updated:

September 16, 2026, 10:58 AM

Added:

a month ago

Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

1,185 Sq. Ft.

Structure

Structure

Building Area:

1,185 Sq. Ft.

Year Built:

2006

Lot

Lot Size (Sq. Ft):

1,134

Finances & Disclosures

Finances

Price:

$399,900

Price per Sq. Ft:

$337 per Sq. Ft.

Source:OneKey MLS
Copyright 2026 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID . OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.