BEDS3
BATHS3 full 1 partial
SQUARE FEET3,660
MLS#1062299
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLQueens 25
Property Description
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 six 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!
Property Features
Property Type: Residential - Single Family
Cooling: Central Air
Fireplaces: 2
Garage: 2
Heating: Natural Gas, Other
Home Style: Other
Lot Size: 1.04 Acres
Taxes: $25,669
Year Built: 1987
Amenities
Other
Feature Descriptions
Appliances: Gas Range
Exterior: Other
Fireplace Y/N: Yes
GarageY/N: Yes
On Market Date: 2026-10-13
Parcel Number: 04542-0019
Parking Features: Driveway, Garage, Private
Parking Total: 6
Rental Term: Monthly
Rooms Total: 10
Sewer: Public Sewer
Spa Y/N: Yes
Utilities: Electricity Connected, Natural Gas Connected
Water: Public
Waterfront Features: Waterfront
Local Schools
High School: World Journalism Preparatory
Middle School: Jhs 194 William Carr
Elementary School: Ps 193 Alfred J Kennedy
School District: Queens 25
Estimate Your Payment
Estimated Payment
$ 26,206.03 per month $22,754.45 Principal & Interest $2,139.08 Property Tax $1,312.50 Homeowner's InsuranceChange Payment Information
Listed By / Shown By
Listing By
Agency Name: Exit Realty Team
Agency Contact: 718-358-4000
Shown By
Agent Name: Gautam Arora
Agent Phone: (917) 407-6647
Agency Title: Coldwell Banker American Homes
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
154-43 Riverside Drive | MLS# 1062299
This single family home located at 154-43 Riverside Drive, Beechhurst, NY 11357 is currently listed for sale with an asking price of $4,500,000. This property was built in 1987 and has 3 bedrooms and 3 full and 1 partial baths with 3660 sq. ft. 154-43 Riverside Drive is located within the Queens 25 school district. Search Beechhurst real estate on garora.cbamhomes.com today.