Skip main navigation
Off market
  • $1,925,400

    788 Connecticut View Dr, Mill Neck, NY 11765

    4beds
    4,998sqft
    Single Family Residence
    Built in 2004
    7,840 Square Feet Lot
    $1,925,400 Zestimate®
    $385/sqft
    $7,717 Estimated rent

    Home value

    $1,925,400

    $1.64M - $2.25M

    $7,717/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,717/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

    $7,717/mo

    Rent Zestimate®

    Refinance and save

    $12,925/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

    $12,925/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

    Walls of windowsSoaring architectural ceilingsHuge bi-level patioSpacious connecting bathBreathtaking sunny verdant vistasSpacious decksGrassy lawn

    Welcome to Twin Peaks! What an incredible home. Built into a wooded hillside overlooking Connecticut, across Mill Neck Creek and the village of Bayville, it features three amazing levels with spectacular views of sparkling waters, boats, and magnificent trees. Every level has wonderful access to the outside from either spacious decks or a huge bi-level patio leading to a grassy lawn and playground. The main level houses a guest suite/study and a warm and inviting great room with stone fireplace, charming dining area, and a fabulous lodge-like gourmet kitchen, Additional rooms include a laundry room with drop zone and sink, a lovely powder room, and delightful sunny, two-story foyer with skylit staircase. The middle level holds two lovely bedrooms, with spacious connecting bath, and a spacious, luxurious primary suite with large marble primary bath, walk-in closet, large private porch. The lower level provides a fabulous place for entertaining with a huge entertainment room with kitchenette, a full bath, plus storage and utility rooms. The attached one-car garage features basement and sub-basement with ample storage areas accessed from two levels. All this space (4,998 square-feet) includes soaring architectural ceilings, and walls of windows, including triangular clerestories, set inside gables, that flood the home with breathtaking sunny, verdant vistas. Located in the northern section of Mill Neck, a peninsula forming the western shore of Oyster Bay, you will enjoy easy access to Oyster Bay Village with its Theodore Roosevelt Park and Beach, shopping district with delightful boutiques and restaurants, and train station with an hour commute to Manhattan. Sharing Mill Neck with many grand and historic estates, you can enjoy a scenic location convenient to golf courses, marinas, equestrian trails, and all the fun venues which is why Locust Valley area has come to be known as the new Hamptons. Come explore this unique and stunning home and enjoy vacation-style living year-round. View 3D tour, floor plan, and special feature list. Annual Association Fee: $1,989

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Source: Douglas Elliman,MLS#: 811686MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Interior area
    • Total structure area: 4,998
    • Total interior livable area: 4,998 sqft

    Property

    Features
    • Patio & porch: Patio
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 7,840 Square Feet

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Other
    • Property subtype: Single Family Residence
    Condition
    • Year built: 2004

    Community & HOA

    Community
    • Subdivision: Mill Neck
    Location
    • Region: Mill Neck

    Financial & listing details

    • Price per square foot: $385/sqft
    • Date on market: 2/6/2025
    • Lease term: Contact For Details

    Price history

    DateEventPrice
    3/31/2025Listing removed$1,799,000$360/sqft
    Source: Douglas Elliman #811686 Report a problem
    2/6/2025Listed for sale$1,799,000$360/sqft
    Source: OneKey® MLS as distributed by MLS GRID #811686 Report a problem
    11/9/2019Listing removed$6,200$1/sqft
    Source: Daniel Gale Assoc Inc #3155277 Report a problem
    8/12/2019Listed for rent$6,200+3.3%$1/sqft
    Source: Daniel Gale Assoc Inc #3155277 Report a problem
    7/1/2018Listing removed$6,000$1/sqft
    Source: Daniel Gale Assoc Inc #3002087 Report a problem
    6/12/2018Price change$6,000-3.2%$1/sqft
    Source: Daniel Gale Assoc Inc #3002087 Report a problem
    5/3/2018Price change$6,200-4.6%$1/sqft
    Source: Daniel Gale Assoc Inc #3002087 Report a problem
    2/5/2018Listed for rent$6,500+1.6%$1/sqft
    Source: Daniel Gale Assoc Inc #3002087 Report a problem
    9/23/2014Listing removed$6,400$1/sqft
    Source: Daniel Gale Assoc Inc #2694974 Report a problem
    8/1/2014Listed for rent$6,400$1/sqft
    Source: Daniel Gale Assoc Inc #2694974 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: Mill Neck

    Nearby schools

    GreatSchools rating
    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
    $1,925,400
    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
    $1,925,400