$4,750,000

Est. Mortgage $24,019/mo *

Quick Pre-Approval

Brochure

Call Text Schedule Tour Request More Information

154-43 Riverside Drive, Beechhurst, NY, 11357

View larger map Directions

8 rooms

4 beds

3 Full / 1 Half baths

1987

Contemporary

Welcome to this beautiful contemporary home on the water situated behind a private gate with giant windows throughout the property, for tremendous water views in every room. The home features 4 bedrooms, 4 bathrooms, huge rooms for entertaining and a massive backyard sitting on the water. This home was completely renovated and ready to move into. This is the entertainer's dream home with a beautiful enclosed glass patio with a wet bar that leads out to an outside patio on the water with a hot tub. The home has multiple decks throughout the property, perfect for entertaining in all seasons and weather that bring beautiful uninterrupted views of the water.

Status:

Active

Type:

Single-family residential

Garage:

2-car Private, Attached, 2 Car Attached, Driveway, Garage, Off Street, On Street

Heating:

Natural Gas, Baseboard

Cooling:

Central Air

Basement:

None, Walk-Out Access

Acreage:

0.37

Est. Taxes:

$22,000

Construction

Brick, Frame, Stone, Stucco

Lot Description:

Level, Stone/Brick Wall, Private

View Description:

Bridge(s), Open, Other, Water

Amenities:

Gated

Waterfront:

Yes

Middle School:

Is 237

High School:

Bayside High School

School District:

Community District 25

Appliances:

Dishwasher, Dryer, Microwave, Refrigerator

MLS #:

3454223

Community Info

School Info

Ps 193 Alfred J Kennedy

Rating: 9/10

Enrollment: 560

Distance: 0.38 Miles

Community Rating:

Efstathios & Stamatiki Valiots Greek-American Scho

Enrollment: 125

Distance: 0.64 Miles

Community Rating:

St Lukes School

Enrollment: 403

Distance: 0.88 Miles

Community Rating:

The Lowell School

Enrollment: 250

Distance: 0.88 Miles

Community Rating:

Qsac School

Enrollment: 70

Distance: 0.88 Miles

Community Rating:

Holy Trinity School

Enrollment: 169

Distance: 0.88 Miles

Community Rating:

Whitestone Academy

Enrollment: 58

Distance: 0.88 Miles

Community Rating:

Jhs 194 William Carr

Rating: 7/10

Enrollment: 1,273

Distance: 0.91 Miles

Community Rating:

Ps 79 Francis Lewis

Rating: 9/10

Enrollment: 1,084

Distance: 0.98 Miles

Community Rating:

Ps 209 Clearview Gardens

Rating: 8/10

Enrollment: 560

Distance: 1.01 Miles

Community Rating:

Ps 184 Flushing Manor

Rating: 10/10

Enrollment: 521

Distance: 1.28 Miles

Community Rating:

St Mel School

Enrollment: 350

Distance: 1.62 Miles

Community Rating:

Jhs 185 Edward Bleeker

Rating: 9/10

Enrollment: 1,514

Distance: 1.64 Miles

Community Rating:

Bell Academy

Rating: 9/10

Enrollment: 364

Distance: 1.67 Miles

Community Rating:

P.S. 169 Bay Terrace

Rating: 9/10

Enrollment: 428

Distance: 1.67 Miles

Community Rating:

Ps 21 Edward Hart

Rating: 7/10

Enrollment: 1,347

Distance: 1.68 Miles

Community Rating:

Holy Cross High School

Enrollment: 886

Distance: 1.7 Miles

Community Rating:

Ps 129 Patricia Larkin

Rating: 7/10

Enrollment: 1,079

Distance: 1.88 Miles

Community Rating:

Ps 72 Dr William Dorney

Rating: 6/10

Enrollment: 745

Distance: 1.96 Miles

Community Rating:

Bayside High School

Rating: 6/10

Enrollment: 2,868

Distance: 2.13 Miles

Community Rating:

Ps 159

Rating: 8/10

Enrollment: 654

Distance: 2.14 Miles

Community Rating:

Elm Community Charter School

Enrollment: 103

Distance: 2.16 Miles

Community Rating:

St Fidelis Elementary School

Enrollment: 194

Distance: 2.17 Miles

Community Rating:

College Point Collaborative

Rating: 3/10

Enrollment: 154

Distance: 2.17 Miles

Community Rating:

St Mel Catholic Academy

Enrollment: 139

Distance: 2.17 Miles

Promise Christian Academy

Enrollment: 209

Distance: 2.17 Miles

Community Rating:

Windsor School

Enrollment: 36

Distance: 2.17 Miles

Agets

Enrollment: 169

Distance: 2.17 Miles

Ps 214 Cadwallader Colden

Rating: 8/10

Enrollment: 447

Distance: 2.19 Miles

Community Rating:

Mott Hall Community School

Rating: 4/10

Enrollment: 339

Distance: 2.21 Miles

Community Rating:

Ps 32 State Street

Rating: 7/10

Enrollment: 996

Distance: 2.23 Miles

Community Rating:

Bronx Delta School

Rating: 4/10

Enrollment: 340

Distance: 2.23 Miles

Urban Institute Of Mathematics

Rating: 8/10

Enrollment: 377

Distance: 2.23 Miles

Community Rating:

St. Agnes Academic School

Enrollment: 192

Distance: 2.29 Miles

Community Rating:

St Benedict School

Enrollment: 319

Distance: 2.29 Miles

Community Rating:

Msgr Scanlan High School

Enrollment: 464

Distance: 2.29 Miles

Community Rating:

Preston High School

Enrollment: 439

Distance: 2.29 Miles

Community Rating:

St Frances De Chantal School

Enrollment: 326

Distance: 2.29 Miles

Community Rating:

Villa Maria Academy-Elementary School

Enrollment: 330

Distance: 2.29 Miles

Community Rating:

Our Lady-Blessed Sacrament School

Enrollment: 383

Distance: 2.3 Miles

Community Rating:

World Journalism Preparatory: A College Board School

Rating: 6/10

Enrollment: 587

Distance: 2.31 Miles

Community Rating:

Is 25 Adrien Block

Rating: 8/10

Enrollment: 1,049

Distance: 2.31 Miles

Community Rating:

Ps 242 Leonard P Stavisky Early Childhood School

Rating: 7/10

Enrollment: 400

Distance: 2.32 Miles

Community Rating:

Ps 29

Rating: 8/10

Enrollment: 701

Distance: 2.36 Miles

Community Rating:

Ps 22 Thomas Jefferson

Rating: 9/10

Enrollment: 918

Distance: 2.42 Miles

Community Rating:

Queens High For Language Studies

Rating: 5/10

Enrollment: 426

Distance: 2.44 Miles

Community Rating:

Queens Academy High School

Rating: 1/10

Enrollment: 309

Distance: 2.45 Miles

Community Rating:

Veritas Academy

Rating: 4/10

Enrollment: 571

Distance: 2.46 Miles

Community Rating:

Flushing High School

Rating: 3/10

Enrollment: 1,620

Distance: 2.47 Miles

Community Rating:

Ms 101 Edward R Byrne

Rating: 7/10

Enrollment: 543

Distance: 2.48 Miles

Community Rating:

Ps 304 Early Childhood School

Rating: 9/10

Enrollment: 514

Distance: 2.48 Miles

Community Rating:

William Spyropoulos Greek-American Day School

Enrollment: 397

Distance: 2.49 Miles

Community Rating:

St. Andrew Avellino School

Enrollment: 240

Distance: 2.49 Miles

Community Rating:

Assemblies Of God Korean Ny

Enrollment: 157

Distance: 2.54 Miles

Ps 41 Crocheron

Rating: 10/10

Enrollment: 463

Distance: 2.55 Miles

Community Rating:

Flushing International High School

Rating: 2/10

Enrollment: 401

Distance: 2.6 Miles

Community Rating:

Jhs 189 Daniel Carter Beard

Rating: 5/10

Enrollment: 774

Distance: 2.6 Miles

Community Rating:

St Joseph's School for the Deaf

Enrollment: 75

Distance: 2.63 Miles

Grand Concourse Academy Charter School

Rating: 9/10

Enrollment: 579

Distance: 2.67 Miles

Community Rating:

Hospital Schools

Enrollment: 331

Distance: 2.72 Miles

P.S. 130

Rating: 10/10

Enrollment: 403

Distance: 2.75 Miles

Community Rating:

Ps 20 John Bowne

Rating: 9/10

Enrollment: 1,205

Distance: 2.8 Miles

Community Rating:

Ps 107 Thomas A Dooley

Rating: 8/10

Enrollment: 929

Distance: 2.82 Miles

Community Rating:

St Michael's School

Enrollment: 269

Distance: 2.85 Miles

Community Rating:

Lutheran School Of Flushing & Bayside

Enrollment: 84

Distance: 2.85 Miles

Community Rating:

Our Lady of the Blessed Sacrament

Enrollment: 324

Distance: 2.85 Miles

Sacred Heart School

Enrollment: 342

Distance: 2.85 Miles

Community Rating:

Ps 14 Senator John Calandra

Rating: 8/10

Enrollment: 579

Distance: 2.9 Miles

Community Rating:

Women S Academy Of Excellence

Rating: 1/10

Enrollment: 246

Distance: 2.98 Miles

Community Rating:

Archimedes Academy for Math, Science and Technology Applications

Rating: 4/10

Enrollment: 642

Distance: 2.98 Miles

Community Rating:

The Bronx Mathematics Preparatory School

Rating: 5/10

Enrollment: 230

Distance: 2.98 Miles

Community Rating:

Most Holy Redeemer Catholic Academy

Enrollment: 226

Distance: 3.04 Miles

St Kevin School

Enrollment: 594

Distance: 3.07 Miles

Community Rating:

Ps 138 Samuel Randall

Rating: 4/10

Enrollment: 657

Distance: 3.07 Miles

Community Rating:

Saddle Rock School

Rating: 7/10

Enrollment: 562

Distance: 3.08 Miles

Community Rating:

The Active Learning Elementary School

Rating: 10/10

Enrollment: 454

Distance: 3.11 Miles

Community Rating:

Ps 182

Rating: 4/10

Enrollment: 768

Distance: 3.12 Miles

Community Rating:

Ps 24 Andrew Jackson

Rating: 9/10

Enrollment: 1,048

Distance: 3.15 Miles

Community Rating:

Bronx Bridges High School

Rating: 3/10

Enrollment: 320

Distance: 3.2 Miles

Millenium Art Academy

Rating: 3/10

Enrollment: 428

Distance: 3.2 Miles

Community Rating:

Gotham Collaborative High School

Rating: 1/10

Enrollment: 499

Distance: 3.2 Miles

Community Rating:

Bronx Compass High School

Rating: 3/10

Enrollment: 387

Distance: 3.2 Miles

Community Rating:

Antonia Pantoja Preperatory Academy

Rating: 4/10

Enrollment: 436

Distance: 3.2 Miles

Community Rating:

Bronx Community High School

Rating: 2/10

Enrollment: 151

Distance: 3.2 Miles

Community Rating:

Ps 69 Journey Prep

Rating: 10/10

Enrollment: 635

Distance: 3.25 Miles

Community Rating:

Ms 158 Marie Curie

Rating: 7/10

Enrollment: 1,078

Distance: 3.26 Miles

Community Rating:

Holy Cross Elementary School

Enrollment: 368

Distance: 3.26 Miles

Community Rating:

Ps 31 Bayside

Rating: 8/10

Enrollment: 537

Distance: 3.27 Miles

Community Rating:

Great Neck North Middle School

Rating: 8/10

Enrollment: 823

Distance: 3.28 Miles

Community Rating:

Ps 36 Unionport

Rating: 8/10

Enrollment: 759

Distance: 3.29 Miles

Community Rating:

East West School Of International Studies

Rating: 8/10

Enrollment: 651

Distance: 3.34 Miles

Community Rating:

Is 237

Rating: 8/10

Enrollment: 1,382

Distance: 3.34 Miles

Community Rating:

Flushing Christian School

Enrollment: 120

Distance: 3.36 Miles

Community Rating:

Muslim Center Junior High School

Enrollment: 164

Distance: 3.36 Miles

Community Rating:

Lowell High School

Enrollment: 249

Distance: 3.36 Miles

Most Holy Redeemer Catholic

Enrollment: 289

Distance: 3.36 Miles

Ps 376

Enrollment: 170

Distance: 3.37 Miles

Community Rating:

Great Neck North High School

Rating: 7/10

Enrollment: 1,172

Distance: 3.39 Miles

Community Rating:

Jhs 131 Albert Einstein

Rating: 5/10

Enrollment: 477

Distance: 3.43 Miles

Community Rating:

Success Academy Bronx 4

Rating: 8/10

Enrollment: 548

Distance: 3.43 Miles

Community Rating:

School Information courtesy of GreatSchools

Walk Score

Mass Transit

Yelp

Listing courtesy of Laffey Real Estate 516-627-4343