788 Connecticut View Drive
Mill Neck, NY 11765
- 4 beds
- 5 baths
- 4,998 sqft
- 8,000 sqft lot
- $359 per sqft
- 2004 build
- – on site
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
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 23, 2025
•
MLS# 811686 —
The Building
-
Year Built:2004
-
Basement:true
-
Architectural Style:Post Modern
-
Construction Materials:Frame
-
Patio And Porch Features:Deck, Patio
-
Building Area Units:Square Feet
-
Security Features:Security System
-
Attic:None
Interior
-
Living Area:4998
-
Total Rooms:9
-
Interior Features:First Floor Bedroom, First Floor Full Bath, Cathedral Ceiling(s), Central Vacuum, Chefs Kitchen, Eat-in Kitchen, Formal Dining, High Ceilings, Kitchen Island, Primary Bathroom, Open Floorplan, Walk-In Closet(s), Wet Bar
-
Fireplace Features:Living Room
-
Fireplaces Total:1
-
Fireplace:true
-
Living Area Source:Public Records
-
# of Kitchens:1
Financial & Terms
-
Lease Considered:false
The Property
-
Lot Features:Back Yard, Cul-De-Sac, Landscaped
-
Lot Size Acres:0.1837
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Lot Size SqFt:8,000 Sqft
-
Property Attached:false
-
Waterfront:false
Listing Agent
- Contact info:
- Agent phone:
- (516) 314-0953
- Office phone:
- (516) 759-0400
Taxes
-
Tax Year:2025
-
Tax Source:Municipality
-
Tax Annual Amount:25056.15
-
Tax Lot:307
Beds
-
Total Bedrooms:4
Baths
-
Full Baths:4
-
Half Baths:1
-
Total Baths:5
The Listing
-
Special Listing Conditions:None
-
Virtual Tour URL Branded:
Heating & Cooling
-
Heating:Oil
-
Cooling:Central Air
-
# of Heating Zones:4
Utilities
-
Sewer:Cesspool
-
Utilities:See Remarks
-
Water Source:Public
Appliances
-
Appliances:Dishwasher, Dryer, Microwave, Washer
Schools
-
High School:Oyster Bay High School
-
Elementary School:Theodore Roosevelt School
-
High School District:Oyster Bay East Norwich
-
Middle School:Contact Agent
The Community
-
Association:false
-
Senior Community:false
-
Subdivision Name:Mill Neck Estates
Parking
-
Garage:true
-
Garage Spaces:1
-
Carport:false
Monthly cost estimate

Asking price
$1,799,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$9,633
|
Taxes | $2,088 |
Insurance | $494 |
Utilities | $290 See report |
Total | $12,505/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
2/6/25
Feb 6, 2025
|
Listed / Active | ONEKEY | $1,799,000 |