Skip main navigation
Off market
Street View
  • $5,746,900

    17 Longwood Rd, Sands Pt, NY 11050

    5beds
    7baths
    7,700sqft
    SingleFamily
    Built in 2007
    2 Acres Lot
    $5,746,900 Zestimate®
    $746/sqft
    $7,320 Estimated rent

    Home value

    $5,746,900

    $5.11M - $6.44M

    $7,320/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

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

    Rent Zestimate®

    Refinance and save

    $37,220/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

    $37,220/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

     Not very often does a home of this caliber come onto the market. Reminiscent of old world construction, this very special brick Center Hall Colonial was built in 2007 and is accented by exceptional limestone trim work found on the entire exterior, garage and pool house.  The Victorian style turret and covered breezeway enhances the 7,700SF residence and lends a unique flavor to its design. No expense was spared and no detail was overlooked to create this classic, luxurious retreat bursting with amenities. Thoughtfully designed by architect Frank Capone for maximum privacy and comfort, the interior layout was created with a wonderful flow and brings the outdoors in. In both the principle rooms and the bedrooms, French Doors allow for plenty of natural light and lead to a variety of private terraces and decks.  In the heart of Sands Point on a quiet cul de sac, the pillared drive leads to the motor court, with inlaid stone, and the impressive entry. Guests are received in the two story Foyer, with its imported granite flooring and custom made teakwood staircase. Gracing this level are 10-foot ceilings, rare teakwood flooring and quality millwork. A Formal Living Room offers a beautiful custom wet bar, marble gas fireplace, recessed ceiling detail and comfortable seating areas. An octagonal shaped Study is beyond the living room. The 12-seat Formal Dining Room is ideal for family holiday celebrations or elegant dinner parties. Designed by Showcase Kitchens in Manhasset, the gourmet state-of-the-art eat-in-kitchen features a Sub Zero Refrigerator with 4 additional freezer drawers, all Viking appliances, including a 6-Burner Chef's Range with custom designed cast stone hood, a center island, maple cabinetry with soft-close drawers, double ovens, wine cooler, granite countertops and granite flooring with radiant heat. Enjoy informal dining in adjacent breakfast area. Flooded with light, the spacious Family Room has a wood burning fireplace and french doors leading to the courtyard and garden. Smartly accessible from 3 rooms, the spacious covered Loggia which overlooks the rose garden and verdant property beyond, is a wonderful space to entertain al fresco or simply relax with a book. Informal entry to the house can be accessed from the 4-car garage via the covered breezeway to the mudroom and rear staircase. Pass the perfectly landscaped courtyard with fountain on your way. Also located on the first floor, the guest wing is home to 2 Bedrooms, each with en suite Bathrooms and separate outdoor access.  Climb the main staircase and arrive at the second floor landing with its cozy sitting area.  Large doors lead to a spacious second floor deck overlooking the property with distant winter water views of Long Island Sound. The sumptuous Master Suite has a separate octagonally-shaped sitting room,  walk-in closet, a private outdoor space, and a master bath with double sinks, 2-person Jacuzzi tub, and large steam shower, all in tasteful granite. The Master Bath enjoys radiant heated floors. The entire house offers top-of-the-line bathroom fixtures from Waterworks, including the basement and pool house bathrooms. A bessler staircase leads to attic storage from the master closet. Across the hallway, two large Bedrooms, each with lovely en suite Bathrooms and walk-in closets, complete the second floor. This level enjoys 9-foot ceilings and oak flooring throughout.Discover an additional 3000 SF of living space in the lower level.  Enjoy a game of pool in the spacious recreation room or just relax in the comfortable seating area. The impressive home theatre with Creston Entertainment system, features a starlit ceiling and 8-person reclining stadium seating.  Additional rooms include a bedroom, 2 full granite bathrooms, a control room, a utility room, a home gym, a laundry room with 2 washers/2 dryers, a pantry with refrigerator, large cedar closet, storage area, and separate outdoor access via an underground tunnel - ideal for wine storage. La

    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.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7.5
    Heating
    • Other
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Refrigerator, Washer
    Features
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 7,700 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Garage - Attached
    Features
    • Exterior features: Brick
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 2 Acres
    Details
    • Parcel number: 0400B000259

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Roof: Other
    Condition
    • Year built: 2007

    Community & neighborhood

    Location
    • Region: Sands Pt

    Other

    Other facts
    • Basement
    • Basement-Finished
    • Bedroom
    • Full Bath
    • Half Bath
    • Heating system: Fireplace

    Price history

    DateEventPrice
    5/14/2015Sold$4,250,000-13.1%$552/sqft
    Source: Agent Provided Report a problem
    3/1/2015Pending sale$4,888,888$635/sqft
    Source: Laffey Fine Homes #2651518 Report a problem
    2/13/2015Listing removed$25,000$3/sqft
    Source: LAFFEY FINE HOMES INT'L #2725645 Report a problem
    2/10/2015Listed for rent$25,000$3/sqft
    Source: LAFFEY FINE HOMES INT'L #2725645 Report a problem
    10/26/2014Price change$4,888,888-1.7%$635/sqft
    Source: Laffey Fine Homes #2651518 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $3,384 -1.6%
    2023-- $3,440 -4.4%
    2022-- $3,600

    Find assessor info on the county website

    Neighborhood: 11050

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Port Washington

    Source: The MLS. 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$5,746,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
    $5,746,900