- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$399,900
Monthly Est:$1,990
3 Beds
3 Baths2 full baths + 1 half bath
1,185sqft
142 Mermaid Ln #284, New York, NY 10473
$399,900
$1,990/moEst:
Get Pre-Approved
Condominium
Built in 2006
$700/mo HOA
1,134 sqft lot
$337/sq.ft
Description
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.
- Houzeo last checked: 12 hours ago
- Listing updated: August 12, 2026 at 9:01 am
- Listing Provided by: Gabriel Oquendo (718) 863-8778 | Go Real Estate Inc. (718) 863-8778
- Source: OneKey MLS-NY | MLS#: 1037452
Part of
Property Details
Status
Active
Type
Condominium
No. of Stories
-
County
City
Neighborhood
Year Built
2006
HOA Fees
$700/mo
Finished Area
1,185 sqft
Lot Size
1,134 sqft lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
1037452
MLS Status
Active
Days on Market
51
Cumulative Days on Market
1
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$700/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Security Gate
Club House
Basket Ball
Tennis
Pool
Parking
Snow Removal
Park Playground
Security Guard
Gym
Children's Playroom
Common Area Maintenance
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 3
Interior
Appliances
Other
Sewer
Public Sewer
Interior Features
Other
Heating
Forced Air, Other
Cooling
Central Air
Construction
Year Built
Year Built: 2006
Home type
Condominium
Construction Materials
Brick, Frame
Utilities & Energy
Parking Features
Assigned
Association Amenities
Basketball Court, Children's Playroom, Clubhouse, Fitness Center, Gated, Parking, Playground, Pool, Security, Snow Removal, Tennis Court(s)
Water Source
Public
Utilities
Cable Available, Cable Connected, Electricity Available, Natural Gas Available
Price History
| Date | Event | Price |
|---|---|---|
08/11/2026 Source: | Listed for Sale | $399,900 $337/sqft |
Nearby Homes
Find Homes by Property Features in New York, NY
Based on information from OneKey MLS, through Oct 01, 2026, 02:47PM. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. © 2026 OneKey® MLS. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group