Waterfront 4 Bedroom Condominium For Sale in Sheepshead Bay, Brooklyn NY 11235. Prime waterfront gated community on Emmons Avenue. This Unique Duplex Apartment is configured as 4 Bedrooms and 3 Bathrooms, totaling in 3,459 SF of Space including Roof Terrace. Astonishing waterfront apartment with all the windows facing the bay, designed with taste end elegance, equipped with top of the line appliances. Large Rooms and High Ceilings. In addition such apartment includes Roof Terrace, Balconies, and Florida Room. Amenities include gym, swimming pool, community private boardwalk.