Exclusive Gated Waterfront Estate – Luxury Living at Its Finest!
Welcome to this extraordinary contemporary waterfront estate, where elegance, privacy, and breathtaking water views come together to create an exceptional living experience. Situated on an expansive, gated property, this stunning residence offers 3 spacious bedrooms, 3.5 elegant bathrooms, and multiple indoor and outdoor entertaining spaces.
Thoughtfully designed across multiple levels, the home features three bedrooms on the third floor, including one with a versatile loft currently used as a gym. The entire fourth level is dedicated to the luxurious primary suite, offering a private balcony overlooking the water, an expansive dressing room, and a spa-inspired bathroom with a Jacuzzi tub.
The beautifully designed kitchen features quartz countertops, premium appliances, a center island, and a comfortable dining area. An impressive enclosed glass patio with a wet bar provides the perfect setting for year-round entertaining and opens to a spectacular waterfront patio featuring a built-in hot tub spa. Multiple decks offer additional spaces to relax, entertain, and enjoy the stunning water views.
Additional highlights include two working fireplaces, custom etched-glass door inserts, a cedar closet, abundant storage, and a conveniently located third-floor laundry room. An attached two-car garage and additional parking for four or more vehicles provide exceptional convenience.
Surrounded by a spacious, private setting, this remarkable property offers a rare combination of luxury, comfort, and waterfront tranquility. Experience the ultimate waterfront lifestyle, where every day feels like a vacation!
For sale
$4,500,000
154-43 Riverside Drive, Beechhurst, NY 11357
3beds
3,660sqft
Single Family Residence, Residential
Built in 1987
1.04 Acres Lot
$-- Zestimate®
$1,230/sqft
$-- HOA
What's special
Premium appliancesSpacious private settingExpansive dressing roomAttached two-car garageBreathtaking water viewsCenter islandCedar closet
- 4 days
- 340
- 12
Zillow last checked:
Listing updated:
Listed by:
Exit Realty Team 718-358-4000,
Charles Chul Chang CBR,
Hae Ryung A. Chang 718-358-4000,
Exit Realty Team
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1062299
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Natural Gas, Other
Cooling
- Central Air
Appliances
- Included: Gas Range
Features
- Other
- Attic: None
- Number of fireplaces: 2
Interior area
- Total structure area: 3,660
- Total interior livable area: 3,660 sqft
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Driveway, Garage, Private
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Has spa: Yes
- On waterfront: Yes
- Waterfront features: Waterfront
Lot
- Size: 1.04 Acres
Details
- Parcel number: 045420019
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence, Residential
Materials
- Other
- Foundation: Other
Condition
- Year built: 1987
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Natural Gas Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Whitestone
Financial & listing details
- Price per square foot: $1,230/sqft
- Annual tax amount: $25,669
- Date on market: 10/13/2026
- Cumulative days on market: 95 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 10/13/2026 | Listed for sale | $4,500,000-18.2%$1,230/sqft |
Source: | ||
| 7/22/2024 | Listing removed | $5,500,000$1,503/sqft |
Source: StreetEasy #1708661 Report a problem | ||
| 4/3/2024 | Listed for sale | $5,500,000+507.7%$1,503/sqft |
Source: StreetEasy Report a problem | ||
| 2/1/1996 | Sold | $905,000$247/sqft |
Source: Public Record Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Climate risks
Neighborhood: Whitestone
Nearby schools
Schools provided by the listing agent
- Elementary: Ps 193 Alfred J Kennedy
- Middle: Jhs 194 William Carr
- High: World Journalism Preparatory
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.





