x
Showing 1 of 0
X
Save

190 Connetquot Drive
Oakdale NY 11769 US

$899,000

Active Listing ID 917472
bed icon
4 bed
bath icon
3.00 Bath (3 Full)
lot icon
Lot: 0.24 Acres
home icon
Single Family Residence

$899,000

Active Listing ID 917472
Save

190 Connetquot Drive 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.24 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • Cooling System: Window Unit(s), Wall/Window Unit(s), Ductless
  • Floor Covering: Hardwood, Tile - Ceramic
  • Heating Fuels: Baseboard, Oil
  • Additional Features
  • Fireplace
  • Waterfront

School Information

  • School
  • Idle Hour Elementary School(Elementary)
  • Oakdale-Bohemia Middle School(MiddleSchool)
  • Connetquot High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 899000
  • unparsedaddress: 190 Connetquot Drive
  • postalcity: Oakdale
  • stateorprovince: NY
  • country: US
  • postalcode: 11769
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.24
  • lotsizeunits: Acres
  • lotsizearea: 0.24
  • livingarea: 3146
  • livingareaunits: Square Feet
  • latitude: 40.738935
  • longitude: -73.153271
  • listagentfullname: Sanford Pines
  • listagentemail: sandypines10@gmail.com
  • listagentkey: 3yd-MLSLINY-108974
  • listagentmlsid: 108974
  • listagentpreferredphone: 5164453571
  • listagentofficephone: 5164453571
  • listofficekey: 3yd-MLSLINY-BRMN22
  • listofficemlsid: BRMN22
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1934
  • listingcontractdate: 2025-09-25
  • listagentfax: 6312651044
  • listagenturl: http://www.cbamhomes.com
  • countyorparish: Suffolk County
  • parcelnumber: 0500-350-00-01-00-085-000
  • elementaryschool: Idle Hour Elementary School
  • highschool: Connetquot High School
  • elementaryschooldistrict: Connetquot
  • middleorjuniorschooldistrict: Connetquot
  • highschooldistrict: Connetquot
  • appliances: Dishwasher, Dryer, Electric Range, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer
  • cooling: Window Unit(s), Wall/Window Unit(s), Ductless
  • constructionmaterials: Frame
  • flooring: Hardwood, Tile - Ceramic
  • heating: Baseboard, Oil
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage
  • view: River, Water
  • waterfrontyn: True
  • franchiseaffiliation: Coldwell Banker Real Estate
  • interiorfeatures: 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
  • waterfrontfeatures: Waterfront, River Access
  • architecturalstyle: Cape Cod
  • rooms: Bedroom 2, Bedroom 1, Bedroom 3, Bedroom 4, Dining Room, Bathroom 1, Bathroom 2, Bathroom 3
  • otherstructures: Storage
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.153275, 40.738934
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-MLSLINY-917472", "OpenHouseEndTime": "2026-02-15 13:30:00", "OpenHouseId": "1315509", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-02-15 12:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Coldwell Banker American Homes", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"sandypines10@gmail.com", "ListBrokerageCity":"East Meadow", "ListBrokerageCountry":"US", "ListBrokerageEmail":"leads0822@leadparser.deltagroup.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/c5ababc31c90dea1011c91901ba23ee5/20210818200407414.png", "ListBrokerageName":"Coldwell Banker American Homes", "ListBrokeragePhone":"(800) 270-6318", "ListBrokeragePostalCode":"11554", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"1856 Hempstead Turnpike", "ListBrokerageWebsiteUrl":"http://www.cbamhomes.com", "ListOfficeAddress1":"28 E Main St ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"BRMN22", "ListOfficeCity":"Smithtown", "ListOfficeCountry":"USA", "ListOfficeEmail":"smithtown@cbamhomes.com", "ListOfficePostalCode":"11787", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Cape Cod - Oakdale, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/190-Connetquot-Dr_Oakdale_NY_11769_M32751-26969?f=listhub&s=MLSLINY&m=917472&c=rexren", "MLSModificationTimestamp":"2026-02-15 18:39:37", "Neighborhoods":[], "PostalCode":null, "RoomCount":12, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":16502, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 2/15/2026 6:51:16 PM GMT
Source Updated Date: 2/20/2026 6:50:30 PM GMT

Courtesy of: Sanford Pines, Coldwell Banker American Homes, sandypines10@gmail.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.