Skip main navigation
Sold for $4,050,000
  • $4,050,000

    255 Piping Rock Road, Old Brookville, NY 11545

    5beds
    --sqft
    Single Family Residence, Residential
    Built in 2023
    2.2 Acres Lot
    $4,565,100 Zestimate®
    $--/sqft
    $8,247 Estimated rent

    Home value

    $4,565,100

    $4.15M - $5.02M

    $8,247/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $8,247/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,247/mo

    Rent Zestimate®

    Refinance and save

    $22,252/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

    $22,252/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

    Extraordinary New Contemporary Home With Expansive Living Space Overlooking More Than 2 Acres Of Exquisitely Landscaped Grounds And Sweeping Lush Green Lawns. Your Sanctuary For Living, Playing, Relaxing, And Entertaining. A Charmed Retreat Far From The Stress Of Today's World Featuring Impeccable Style And Modern Grace, This Home Is Well-Suited For Today's Luxurious Lifestyle. As You Step Inside You Are Welcomed By Spacious Natural Light Filled Open Floor Plan Where Sophisticated Architecture Puts An Emphasis On Family Enjoyment Blending Uncompromised Quality, Design, And Luxury. This Home Is Rich With Amenities Matchless Finishes, Oversized Rooms, And A Floating Hollywood Staircase. Appreciate The Main Floor Which Features An Incredible Ambiance While Offering Areas To Relax, Dine And Entertain. Lose Yourself In The Warmth Of One Of The Three Fireplaces And Smell The Aroma's Coming From The Spacious, High-End Eat-In Gourmet Kitchen Which Is As Sleek As It Is Functional. Relax And Wind Down Your Day In The Finished Lower Level, Or Step Outside To Your Private Oasis. Luxury And Serenity, Swim In The Pool, Have A Cocktail On The Pavilion, Serve Hors-D'-Oeuvres From The Outdoor Door Kitchen, Put Your Feet Up At The Fire Pit. Supported By A Full House Generator, You And Your Family Will Always Feel Comfy. The Estate Is Encircled By Grand Estates And Beautiful Properties. Only Minutes From Award Winning Golf, Delightful Village Shops, Restaurants, Beaches, Boating And Train Station Providing A Comfortable Commute To Manhattan. Park Your Car In The Courtyard Or 3-Car Heated Garage. Locust Valley School District And Close To Private Schools Too. Yes, This Home Is The One You Wished You Lived In. And Now It Can Be Yours. Completion Date Summer 2023., Additional information: Interior Features:Guest Quarters,Lr/Dr

    Zillow last checked:

    Listing updated:

    Listed by:

    Lisa M. Fasano CBR 516-717-9748,

    Compass Greater NY LLC 516-703-3360,

    Stuart L. Bayer 516-375-1005,

    Douglas Elliman Real Estate

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 6
    • 1/2 bathrooms: 1
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Cooktop, Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Tankless Water Heater, Trash Compactor, Washer
    Features
    • Cathedral Ceiling(s), Central Vacuum, Eat-in Kitchen, Entertainment Cabinets, Entrance Foyer, Formal Dining, Primary Bathroom, Pantry
    • Flooring: Hardwood
    • Windows: New Windows, Screens
    • Basement: Finished,Full
    • Attic: Full
    • Number of fireplaces: 3

    Property

    Parking
    • Parking features: Attached, Garage Door Opener, Private
    Features
    • Levels: Three Or More
    • Patio & porch: Patio
    • Has private pool: Yes
    • Pool features: In Ground
    • Fencing: Fenced
    Lot
    • Size: 2.20 Acres
    • Dimensions: 2.20
    • Features: Level, Near School, Near Shops, Sprinklers In Front, Sprinklers In Rear
    Details
    • Parcel number: 241522K0002170

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    • Attached to another structure: Yes
    Materials
    • Stone, Stucco
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2023

    Utilities & green energy

    • Electric: Generator
    • Sewer: Septic Tank
    • Water: Public

    Community & neighborhood

    Security
    • Security features: Fire Sprinkler System, Security System
    Location
    • Region: Glen Head

    Other

    Other facts
    • Listing agreement: Exclusive Right To Lease

    Price history

    DateEventPrice
    3/12/2024Listing removed--
    Source: Zillow Rentals Report a problem
    3/8/2024Listed for rent$20,000
    Source: Zillow Rentals Report a problem
    11/28/2023Sold$4,050,000-11.9%
    Source: OneKey® MLS as distributed by MLS GRID #L3478956 Report a problem
    10/16/2023Pending sale$4,599,000
    Source: OneKey® MLS as distributed by MLS GRID #3478956 Report a problem
    5/18/2023Listed for sale$4,599,000+228.5%
    Source: OneKey® MLS as distributed by MLS GRID #3478956 Report a problem
    7/13/2021Sold$1,400,000-9.4%
    Source: OneKey® MLS as distributed by MLS GRID #L3251939 Report a problem
    5/11/2021Pending sale$1,545,000
    Source: Douglas Elliman #3251939 Report a problem
    5/11/2021Listing removed--
    Source: Douglas Elliman Report a problem
    3/22/2021Pending sale$1,545,000
    Source: Douglas Elliman #3251939 Report a problem
    3/21/2021Listing removed--
    Source: Douglas Elliman Report a problem
    3/13/2021Pending sale$1,545,000
    Source: Douglas Elliman #3251939 Report a problem
    3/13/2021Listing removed--
    Source: Douglas Elliman Report a problem
    1/8/2021Pending sale$1,545,000
    Source: Douglas Elliman #3251939 Report a problem
    9/14/2020Listed for sale$1,545,000-9.1%
    Source: Douglas Elliman Real Estate #3251939 Report a problem
    8/1/2005Sold$1,700,000
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $1,473
    2023-- $1,473 -5.6%
    2022-- $1,561
    2021$31,524 +5%--
    2020$30,025 +12.9%$2,888
    2019$26,599 $2,888
    2018$26,599 +3.8%$2,888
    2017$25,617 +7.3%$2,888
    2016$23,880 +483.5%$2,888
    2015$4,093 +6.6%$2,888
    2013$3,840 +6.8%$2,888
    2012$3,596 -80.8%$2,888 -23%
    2011$18,694 +9.3%$3,751 -0.6%
    2010$17,100 $3,774 -20.3%
    2009-- $4,736 +3.2%
    2008-- $4,589 -3.5%
    2006-- $4,757 -36.7%
    2005-- $7,510 -39.5%
    2004-- $12,413
    2003-- $12,413 -47.6%
    2002-- $23,700
    2001-- $23,700
    2000-- $23,700

    Find assessor info on the county website

    Neighborhood: Old Brookville

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Middle: Locust Valley Middle School
    • High: Locust Valley 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
    $4,565,100
    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
    $4,565,100