Skip main navigation
For sale
  • Price cut: $24K (6/27)
    $975,000

    283 Pipe Stave Hollow Road, Miller Place, NY 11764

    5beds
    3,241sqft
    Loading
    Single Family Residence, Residential
    Built in 1969
    0.46 Acres Lot
    $-- Zestimate®
    $301/sqft
    $-- HOA

    What's special

    Luxury primary suiteLarge bedroomTwo electric panelsGleaming hardwoodsMeticulously landscaped ultra-private lotCentral vacuum systemTwo separate basements
    Diamond Colonial - Nestled in highly sought-after North Miller Place—just minutes from Cedar Beach on the Long Island Sound, local shopping, and major roadways—this spectacular, contractor's-own custom estate is a rare masterpiece of high-end craftsmanship and design. UNPARALLELED MULTI-GENERATIONAL POTENTIAL! This exceptionally rare property offers two entirely separate living spaces under one roof, making it ideal for multi-family living, extended guests, or potential accessory/guest quarters (with proper permits). Designed for total independence, the home features two separate basements, two natural gas burners, two electric panels, two meters, and two separate laundry rooms. The Main Residence: Features a sun-drenched, open layout with a wainscoted foyer, formal living and dining spaces, a massive second-floor bonus room/office, and a cozy step-down family room with a brick fireplace. The gourmet chef’s kitchen boasts custom cabinetry, premium quartz countertops, a center island, and high-end stainless steel appliances. Retreat to a luxury primary suite complete with a rustic barn door, custom spa-bath, and a massive walk-in closet. The Private Wing/Extension: Connected via elegant French doors off the main dining room, this separate wing offers a living room with its own fireplace, a jaw-dropping octagonal formal dining room with tray ceilings, a large bedroom, a premium full bath with double vanity, and a dedicated custom staircase leading to its own full, walkout basement with sliding glass doors and full egress windows. Premium Upgrades Throughout: Gleaming hardwoods, luxury vinyl wide-plank flooring, Andersen windows, multi-zone central A/C, central vacuum system, stunning custom moldings/trim work, and a two-car side-entry garage. The Backyard Oasis: Set on a meticulously landscaped, ultra-private lot that backs to a quiet wooded buffer. The park-like grounds feature mature shade trees, lush perennial gardens, and a massive custom concrete patio perfect for summer entertaining. Top-tier quality, unmatched flexibility, and a premier North Shore location—opportunities this unique and thoughtfully executed rarely hit the market. Schedule your private tour today before it's gone!
    102 days
    |
    858
    |
    50
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Coldwell Banker American Homes 631-331-9700,

    Theresa S. Ottomano HFR 631-682-8567,

    David H. Lunenfeld 516-528-5107,

    Coldwell Banker American Homes

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Heating
      • Baseboard, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Convection Oven, Dishwasher, Dryer, Gas Oven, Gas Range, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer, Gas Water Heater
      • Laundry: Laundry Room, Multiple Locations
      Features
      • First Floor Bedroom, First Floor Full Bath, Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, In-Law Floorplan, Kitchen Island, Open Floorplan, Open Kitchen, Pantry, Primary Bathroom, Quartz/Quartzite Counters, Recessed Lighting, Storage, Tray Ceiling(s), Walk-In Closet(s)
      • Flooring: Ceramic Tile, Hardwood, Tile, Vinyl
      • Basement: Full,Walk-Out Access
      • Attic: Full,Pull Stairs
      • Number of fireplaces: 2
      Interior area
      • Total structure area: 3,241
      • Total interior livable area: 3,241 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Garage
      • Garage spaces: 2
      Features
      • Patio & porch: Covered, Deck, Porch
      Lot
      • Size: 0.46 Acres
      • Features: Back Yard, Front Yard, Garden, Landscaped, Level, Near Shops, Private, Sprinklers In Front, Sprinklers In Rear
      • Residential vegetation: Partially Wooded
      Details
      • Parcel number: 0200096000600020000
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Traditional
      • Property subtype: Single Family Residence, Residential
      Materials
      • Frame, Vinyl Siding
      Condition
      • Updated/Remodeled
      • Year built: 1969

      Utilities & green energy

      • Sewer: Cesspool
      • Water: Public
      • Utilities for property: Electricity Connected, Natural Gas Connected, Trash Collection Public, Water Connected

      Community & HOA

      Community
      • Subdivision: North Of Route 25A/North Miller Place
      HOA
      • Has HOA: No
      Location
      • Region: Miller Place

      Financial & listing details

      • Price per square foot: $301/sqft
      • Tax assessed value: $3,700
      • Annual tax amount: $16,868
      • Date on market: 4/29/2026
      • Cumulative days on market: 101 days
      • Listing agreement: Exclusive Right To Sell
      • Electric utility on property: Yes

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        6/27/2026Price change$975,000-2.4%$301/sqft
        Source: OneKey® MLS as distributed by MLS GRID #992170 Report a problem
        4/29/2026Listed for sale$999,000+173.7%$308/sqft
        Source: OneKey® MLS as distributed by MLS GRID #992170 Report a problem
        12/3/2020Sold$365,000-3.9%$113/sqft
        Source: OneKey® MLS as distributed by MLS GRID #L3209620 Report a problem
        8/21/2020Pending sale$380,000$117/sqft
        Source: Coldwell Banker Realty #3209620 Report a problem
        5/15/2020Listed for sale$380,000$117/sqft
        Source: Coldwell Banker Residential #3209620 Report a problem
        3/25/2020Listing removed$380,000$117/sqft
        Source: Coldwell Banker Residential Brokerage - Setauket Regional Office #3209620 Report a problem
        3/22/2020Listed for sale$380,000$117/sqft
        Source: Coldwell Banker Residential #3209620 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $3,700
        2024-- $3,700
        2023-- $3,700
        2022-- $3,700 -9.2%
        2021-- $4,075
        2020-- $4,075
        2019-- $4,075
        2018-- $4,075
        2017$14,132 $4,075
        2016-- $4,075
        2015-- $4,075
        2014-- $4,075
        2013-- $4,075
        2012-- $4,075
        2011-- $4,075
        2007$10,797 +19.1%$4,075
        2005$9,067 +2.1%$4,075
        2004$8,883 +9.4%$4,075
        2003$8,116 +5.7%$4,075
        2002$7,676 $4,075
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 11764

        Getting around

        45 / 100
        Car-Dependent
        42 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Andrew Muller Primary School
        • Middle: North Country Road School
        • High: Miller Place 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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes