An incredible opportunity to create something truly special in one of Great River's most desirable waterfront locations. Set along the beautiful Connetquot River, this property offers exceptional water views, privacy, and the rare chance to renovate, rebuild, or create your dream waterfront residence. Surrounded by impressive homes and the natural beauty Great River is known for, this property is all about location, lifestyle, and potential. Enjoy boating, breathtaking sunsets, and serene waterfront living while still being conveniently located near local dining, shopping, beaches, and transportation. A rare waterfront opportunity in Great River - bring your vision and make it your own.
Single-familyProperty Type
1941Year Built
0.68 acresLot Size
$814Price/Sq.Ft.
1 garage spacesParking
Listing by Tammy Ramsay• Eric G Ramsay Jr Assoc LLC
Islip, located between Great South Bay and the Connetquot River State Park Preserve, is a waterfront and suburban Brentwood neighborhood with salt-air marinas and leafy parkland. The neighborhood’s character concentrates around Main Street near Islip Avenue, where low-slung storefronts, cafés, and local services set a steady, walkable rhythm. Architectural cues lean toward mid-century ranches and Cape-style homes, with pockets of newer infill along wider arterials. Islip’s shoreline geography shapes weekends around docks, bay views, and boat traffic. Community pillars include the Bayard Cutting Arboretum, the historic Islip Art Museum, and the Sayville Ferry Service for Fire Island days. Rail service at Islip station adds a commuter cadence without overpowering the residential feel.
Provided by Walk Score and Local Logic
Offer insights
279 Great River Rd · $1,499,000
$1.5M and above
75% chance or better to win
Why $1.5M+ is a strong offer
DAYS ON MARKET
20 days
The average home goes pending in 26 days.
SALE-TO-LIST
103.1%
Most homes are selling 3% above list price.
About offer insights
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Dining
Interior features
Eat-in kitchen
Attic (see remarks)
No basement
7 total rooms
Bathrooms
2 full bathrooms
Kitchen
Refrigerator included
Heating & cooling
Central air conditioning
Natural gas heating
Exterior features
Waterfront property
Home design
Single-family residence
Parking
1-car garage
1-space carport
Driveway
Construction
Vinyl siding
Utilities
Public sewer
Electricity connected
Water connected
Electricity and solar
View estimated energy costs and solar savings for this home