A PHP Error was encountered

Severity: 8192

Message: trim(): Passing null to parameter #1 ($string) of type string is deprecated

Filename: controllers/Listing.php

Line Number: 140

Backtrace:

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 140
Function: trim

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 21
Function: getListingData

File: C:\www_resoft\bam\site_dev\index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: trim(): Passing null to parameter #1 ($string) of type string is deprecated

Filename: controllers/Listing.php

Line Number: 140

Backtrace:

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 140
Function: trim

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 21
Function: getListingData

File: C:\www_resoft\bam\site_dev\index.php
Line: 315
Function: require_once

Single Family, 4 ANGELAS Place #, Schuylerville-Throgs Neck-Edgewater Park - Real Estate Brooklyn :: Brick&Mortar LLC

‹ Back to Listings

Status: Active

4 ANGELAS Place, #

Schuylerville-Throgs Neck-Edgewater Park

$1,899,000
 |  5 Beds  |  3.5 Baths  |  5,237SF

Description

Waterfront Single-Family Condo - Over 7K SqFt of Modern Living - Private In-ground Pool  

This rare single-family, stand-alone condominium offers over 7,000 square feet of modern living directly on the Long Island Sound. With 5 bedrooms and 3 bathrooms, the home is designed for both scale and comfort. Panoramic water views stretch from the Throggs Neck to the Whitestone Bridge, with every room capturing the scenery. Expansive balconies extend from each space, creating a seamless connection between indoors and out.  

Completely gut-renovated, the residence combines contemporary design with thoughtful detail. White oak floors flow throughout, complemented by marble flooring on the main level and soaring ceilings that amplify light and scale. The kitchen is outfitted with Bosch appliances, while radiant heated floors and a multi-zone central air system ensure year-round comfort.  

Private amenities include a two-car garage, an in-ground pool with a dedicated mechanical room, and a gated community setting. The lower level features its own separate entrance, adding flexibility for guests or extended living. The owner is also open to customizing walk-in closets to suit individual needs, offering ...
More >

Property Details

  • Single Family

Amenities

  • Private Outdoor Space Over60 Sqft
  • Cooling: Central Air
  • Patio, Terrace
  • View: Other
  • Smoke Free
  • Washer Dryer Allowed
  • Pets: Building Yes, No

The Neighborhood

Schuylerville-Throgs
Neck-Edgewater
Schuylerville-Throgs Neck-Edgewater Park

Schuylerville-Throgs Neck-Edgewater Park Guide ›
All Neighborhoods ›

For information on 4 ANGELAS Place, # contact:

realtor top real estate agent

Megan Eisenberg

Licensed RE Salesperson

917-822-2474

Licensed RE Salesperson
megan@brickandmortar.com
917-822-2474

Listing courtesy of Corcoran Group
The First Name field is required.
The Last Name field is required.
The Email field is required.
The Mobile Number field is required.. Please enter a valid phone number.
All information is intended only for the visitor’s personal, noncommercial use. 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. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. RLS Data display by Brick & Mortar.