Its Finally Here! The Home You've Always Dreamed of. Spectacular 8100 Sq Ft Colonial with 7 Bedrooms & 7.55 Baths on Almost 2 Acres of Prime Waterfront Property in Hewlett Harbor. Upon Entering the Massive Circular Driveway You Are Drawn to This Stately Brick House Gut Renovated 25 Years Ago. Upon Entering the Home You are Greeted by the 2 Story Entry Foyer Which is Open to the Second Floor Balcony. The Walls of Windows Provide Tons of Natural Light and Spectacular Water Views. Wonderful Flow for Entertaining in The Living Room, Den, XL Eat in Kitchen, Spacious Formal Dining Room & Library with Elegant Wood Cabinetry. The Main Floor Primary Suite is Overlooking the Waterfront, With a Radiant Heated Bath with Double Sinks & Toilets, a Jacuzzi Tub & Steam Shower. You will be Wowed by the 2 Walk in Closets. On the Second Level you will Find 5 Spacious Bedrooms with Huge Walk in Closets & Ensuite Baths. The Three Bedrooms Overlooking the Waterfront Have Access to the Terrace to Sit Outside and Enjoy the Water Views. The Full Finished 2100 Sq Ft Basement Redone 10 Years Ago, Boasts a Theatre, Recreation Room, Gym, Wine Cellar, Cedar Closet, Bonus Rm & Full Bath with Steam Shower. In Addition to the Grand Circular Driveway There's a 3 Car Attached Garage . The Resortlike Yard Features a Gunite Heated Pool/Spa, Outdoor Kitchen for Entertaining with BBQ, Refrigerator, Sink & Granite Countertops. Spacious Patio and a Redone 215' Vinyl Bulkhead that Has Been Raised. Every Opulent Amenity!! Great Location in Hewlett Harbor, Steps from Hewlett Bay Park. Convenient to LIRR, Shops, Trans, Houses of Worship, 15 Minutes to the Beach and 40 Min to NYC. Wonderful SD#14 Hewlett Woodmere. Don't miss This Gem!
51 days
|
1,011
|
29
|
Zillow last checked:
Listing updated:
Listed by:
Douglas Elliman Real Estate516-623-4500,
Ronnie B. Gerber516-238-4299
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1000982
Pool features: In Ground, Pool Cover, Pool/Spa Combo
Has spa: Yes
Fencing: Back Yard,Fenced
Has view: Yes
View description: Open, Water
Has water view: Yes
Water view: Water
Waterfront features: Bayfront, Bulkhead, Water Access, Waterfront
Frontage length: 215 Ft
Lot
Size: 1.58 Acres
Features: Back Yard, Front Yard, Garden, Landscaped, Near Golf Course, Near Public Transit, Near School, Near Shops, Private, Sprinklers In Front, Sprinklers In Rear
Details
Parcel number: 201742K0001020
Special conditions: None
Construction
Type & style
Home type: SingleFamily
Architectural style: Colonial
Property subtype: Single Family Residence, Residential
Materials
Brick, Frame
Condition
Updated/Remodeled
Year built: 1964
Utilities & green energy
Sewer: Public Sewer
Water: Public
Utilities for property: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected
Community & HOA
Community
Security: Security System, Smoke Detector(s)
HOA
Has HOA: No
Location
Region: Hewlett
Financial & listing details
Price per square foot: $710/sqft
Tax assessed value: $3,392
Annual tax amount: $104,767
Date on market: 6/8/2026
Cumulative days on market: 51 days
Listing agreement: Exclusive Right To Sell
Listing terms: Cash,Contract,Conventional
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
6/8/2026
Listed for sale
$5,750,000+303.5%$710/sqft
Source: OneKey® MLS as distributed by MLS GRID #1000982Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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.