Welcome to your waterfront dream home! This expansive Cape Cod-style residence is perfectly situated on a private canal with 175 feet of bulkhead, just four homes from the open river — and with no bridges to navigate, you’ll enjoy direct access to the bay beyond. Offering over 3,000 sq ft of living space, this 4-bedroom, 3-bathroom home is designed for comfort, style, and incredible water views. Inside, you’ll find gorgeous hardwood floors throughout, a cherry and granite kitchen featuring stainless steel appliances, and abundant storage to meet all your needs. The home features both a primary and junior en suite, each with private balconies overlooking the serene canal and capturing breathtaking sunsets over the river. Additional highlights include a detached 2-car garage with a loft above — There is a Whole-house generator for that peace of mind, In-ground sprinkler system for easy maintenance, and of course waterfront living! Don’t miss this rare opportunity to own a slice of paradise. They’re not making more waterfront — make this your coastal oasis today. Spacious Waterfront Cape Cod in Coveted Idle Hour Neighborhood.
Listed by Sanford Pines
·
Coldwell Banker American Homes
·
631-863-9800
Listed by Bryan J. Karp CBR
·
Coldwell Banker American Homes
Last updated October 19, 2025
·
Source: OneKey #917472
Listing Facts
TypeSingle-family
NeighborhoodOakdale
Bedrooms4
Bathrooms3
Days on Prevu27
Taxes$16,502/year
Size3,146 sqft
Price per sqft$302
Amenities
Dishwasher
Washer/Dryer
Parking
Location
Mortgage Calculator
Listing History
10/13/2025
Price Decreased
$949,000
09/25/2025
Listed by Coldwell Banker American Homes
$999,000
Property Details for 190 Connetquot Drive
Exterior
Construction
Property Attached: Yes
Year Built: 1934
Architectural Style: Cape Cod
Construction Materials: Frame
Features
View: River, Water
Waterfront Features: Bulkhead, Canal Front, River Access, Waterfront
Interior Features: First Floor Bedroom, First Floor Full Bath, Ceiling Fan(s), Chandelier, Chefs Kitchen, Crown Molding, Eat-in Kitchen, Entertainment Cabinets, Entrance Foyer, Formal Dining, Primary Bathroom, Quartz/Quartzite Counters, Storage, Walk-In Closet(s), Washer/Dryer Hookup
Measurements
Living Area: 3,146
Living Area Source: Other
Rooms
Bathrooms Full: 3
Bathrooms Total Integer: 3
Bedrooms Total: 4
Rooms Total: 12
Parking
Parking
Garage Spaces: 2
Garage: Yes
Parking Features: Detached, Driveway, Garage
Schools
Elementary School
Elementary School: Idle Hour Elementary School
Elementary School District: Connetquot
High School
High School: Connetquot High School
High School District: Connetquot
Middle or Junior School
Middle Or Junior School: Oakdale-Bohemia Middle School
Middle Or Junior School District: Connetquot
Utilities
Equipment
Cooling: Ductless, Wall/Window Unit(s)
Heating: Baseboard, Oil
Other Equipment: Generator, Irrigation Equipment
Sewer: Septic Tank
Utilities: Cable Connected, Electricity Connected, Phone Connected, Water Connected
Water Source: Public
The data relating to real estate for sale on this website comes in part from the IDX
Program of OneKey™ MLS. The source of the displayed data is either the property owner
or public record provided by non-governmental third parties. It is believed to be reliable
but not guaranteed. This information is provided exclusively for consumers’ personal,
non-commercial use. Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.