Skip main navigation
Sold for $2,425,000
  • $2,425,000

    40 Overlook Drive, Aquebogue, NY 11931

    4beds
    3,800sqft
    Single Family Residence, Residential
    Built in 2004
    1.2 Acres Lot
    $2,666,900 Zestimate®
    $638/sqft
    $8,541 Estimated rent

    Home value

    $2,666,900

    $2.45M - $2.91M

    $8,541/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $8,541/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $8,541/mo

    Rent Zestimate®

    Refinance and save

    $18,318/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $18,318/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Introducing a truly extraordinary custom designed residence nestled on nearly 160 feet of picturesque waterfront. Offering an unparalleled waterfront lifestyle on Long Island's North Fork. Expansive windows and multi-level decks allow for panoramic vistas of the lush landscaping and creek beyond. Attention to detail is evident in this premier offering of over 3000sf. The gourmet kitchen with gas range, wet bar and island serves as a hub for memorable meals and gatherings. Sliding doors flank the rear eastern exposure allowing for seamless flow to the outside & into the waterfront all-seasons room with radiant floor. Cozy up in the library/den with custom woodwork and one of 3 fireplaces. The primary suite replete with private deck offers spectacular views and features a walk-in closet & ensuite bath with radiant floors. Extensive dockage to accommodate up to 8 boats, currently docked is a 65 foot boat, with deep-water access to Peconic Bay. Docks have a dedicated electric meter and water. The heated saltwater pool is a private sanctuary providing an idyllic escape. Custom driveway with Belgian block surround leads to the 2 car attached garage. Full finished lower level offers a "Yacht Club" recreation space with ample room for provisioning for your next voyage, full bathroom and office. This majestic home on Meeting House Creek is an unmatched waterfront opportunity and is sited 10 feet above mean high tide & is FEMA compliant. Indulge in the serenity and beauty of waterfront living., Additional information: Appearance:Diamond+++,Location Features:Protected Wetland,Separate Hotwater Heater:Y

    Zillow last checked:

    Listing updated:

    Listed by:

    Allison Galasso 631-258-1192,

    Kerrigan Country Realty 631-288-9600

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: L3480571MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced Air, Oil
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Refrigerator, Washer, Oil Water Heater
    Features
    • Cathedral Ceiling(s), Central Vacuum, Chandelier, Eat-in Kitchen, Entrance Foyer, Formal Dining, First Floor Bedroom, Granite Counters, Primary Bathroom, Speakers, Whole House Entertainment System
    • Flooring: Hardwood
    • Windows: Blinds, Insulated Windows, Screens, Skylight(s)
    • Basement: Finished,Full,Walk-Out Access
    • Attic: Partial
    • Number of fireplaces: 3
    Interior area
    • Total structure area: 3,800
    • Total interior livable area: 3,800 sqft

    Property

    Parking
    • Parking features: Attached, Driveway, Garage Door Opener, Private
    • Has uncovered spaces: Yes
    Features
    • Levels: Three Or More
    • Patio & porch: Deck, Patio, Porch
    • Exterior features: Private Entrance, Speakers
    • Has private pool: Yes
    • Pool features: In Ground
    • Has view: Yes
    • View description: Panoramic, River, Water
    • Has water view: Yes
    • Water view: River,Water
    • Waterfront features: Beach Access, Creek, River Front, Waterfront, Water Access
    Lot
    • Size: 1.2 Acres
    • Dimensions: 1.2
    • Features: Cul-De-Sac, Level, Sloped, Sprinklers In Front, Sprinklers In Rear
    Details
    • Parcel number: 0600086000100032000
    • Zoning: Residential
    • Other equipment: Pool Equip/Cover

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Cedar
    Condition
    • Actual
    • Year built: 2004

    Utilities & green energy

    • Sewer: Cesspool
    • Water: Public
    • Utilities for property: Trash Collection Public

    Community & HOA

    Community
    • Security: Security System
    HOA
    • Has HOA: No
    • Amenities included: Powered Boats Allowed
    Location
    • Region: Riverhead

    Financial & listing details

    • Price per square foot: $638/sqft
    • Tax assessed value: $1,498,775
    • Annual tax amount: $24,000
    • Date on market: 6/6/2023
    • Listing agreement: Exclusive Right To Lease
    • Exclusions: Grill, Hot Tub

    Price history

    DateEventPrice
    8/1/2026Listing removed$30,000$8/sqft
    Source: Zillow Rentals #389349 Report a problem
    10/27/2025Price change$30,000+66.7%$8/sqft
    Source: OneKey® MLS as distributed by MLS GRID #878349 Report a problem
    6/16/2025Listed for rent$18,000-10%$5/sqft
    Source: Zillow Rentals Report a problem
    9/13/2024Listing removed$20,000$5/sqft
    Source: Zillow Rentals Report a problem
    7/17/2024Price change$20,000-20%$5/sqft
    Source: Zillow Rentals Report a problem
    7/6/2024Listed for rent$25,000$7/sqft
    Source: Zillow Rentals Report a problem
    6/26/2024Listing removed--
    Source: Zillow Rentals Report a problem
    5/31/2024Price change$25,000+25%$7/sqft
    Source: Zillow Rentals Report a problem
    4/23/2024Listed for rent$20,000$5/sqft
    Source: Zillow Rentals Report a problem
    4/16/2024Sold$2,425,000-3%$638/sqft
    Source: Public Record Report a problem
    1/11/2024Sold$2,500,000-9.1%$658/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3480571 Report a problem
    9/28/2023Pending sale$2,750,000$724/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3480571 Report a problem
    6/6/2023Listed for sale$2,750,000-15.4%$724/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3480571 Report a problem
    1/1/2023Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3412895 Report a problem
    7/15/2022Listed for sale$3,250,000+550%$855/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3412895 Report a problem
    8/28/2003Sold$500,000$132/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $122,300
    2024-- $122,300 +15.9%
    2023-- $105,500
    2022-- $105,500
    2021-- $105,500
    2020-- $105,500
    2019-- $105,500
    2018-- $105,500
    2017$18,542 $105,500
    2016-- $105,500
    2015-- $105,500
    2014-- $105,500
    2013-- $105,500
    2012-- $105,500
    2011-- $105,500
    2007$15,446 +86.6%$105,500 +56.3%
    2005$8,280 +6.2%$67,500
    2004$7,794 +8.8%$67,500
    2003$7,165 +5.3%$67,500
    2002$6,805 $67,500
    2001-- $67,500
    2000$6,912 $67,500
    Find assessor info on the county website

    Neighborhood: 11901

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Aquebogue Elementary School
    • Middle: Riverhead Middle School
    • High: Riverhead Senior High School

    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.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,666,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,666,900