Skip main navigation
Off market
  • $2,805,800

    245 Arleigh Rd, Douglaston, NY 11363

    5beds
    4,000sqft
    SingleFamily
    Built in 1930
    0.25 Acres Lot
    $2,805,800 Zestimate®
    $701/sqft
    $6,552 Estimated rent

    Home value

    $2,805,800

    $2.67M - $2.95M

    $6,552/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $6,552/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

    $6,552/mo

    Rent Zestimate®

    Refinance and save

    $17,226/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

    $17,226/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

    Luxury country living In Douglas Manor, a waterfront community just 25 minutes from NYC, where historical elegance and old world prestige meet modern lifestyle. This unique classical center hall colonial situated on the highest point of Douglas Manor is just two blocks away from the Little Neck Bay shore and marina with incredible views of the bay at sunset and conveniently close to the train station, restaurants and shops. The majestic residence is a rare gem with a great layout and one of the largest backyards in the Manor perfect for a swimming pool.From the central foyer the space opens up to show the beautiful layout of the house. To the right the large living room with a fire place and huge bay window connects to a spectacular sun room/den overlooking the backyard, and lush front yard garden. To the left the space flows into the formal dining room and further extends into a charming sun room that can also be used as an office. The whole first floor is an amazing entertaining space flooded with sun light and views of the garden through the multitude of windows. The staircase is filled with light from the arched window on the first landing.The second floor features a comfortable master suite with a great terrace, two more bedrooms with terrace and a full bathroom.On the third floor there are two more bedrooms and a half bathroom.Douglaston, a onetime vacation destination for wealthy residents of Manhattan, is now part of New York City, but the country life style, the huge trees, the 650-acre Alley Pond Park with its hiking trails and wetlands have been lovingly preserved by its long time resident families.The Douglas Manor Association owns and operates the entire waterfront, with a dock, pier, beach and waterfront park. Residents enjoy summer sailing camp for kids, tennis ,swimming and fine dining at the Douglaston Club, a private yacht, tennis and pool club based in the 19th-century mansion built by the founding Douglas family. With excellent schools, low NYC taxes and a fast commute to Manhattan, Douglas Manor is a truly unique residential neighborhood.

    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: 5
    • Full bathrooms: 2
    • 1/2 bathrooms: 3
    Heating
    • Other
    Cooling
    • Central
    Appliances
    • Included: Dryer, Refrigerator, Washer
    Features
    • Attic: Y
    Interior area
    • Total interior livable area: 4,000 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Lot
    • Size: 0.25 Acres
    Details
    • Parcel number: 080470042

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Other
    Condition
    • Year built: 1930

    Community & neighborhood

    Location
    • Region: Douglaston

    Other

    Other facts
    • A/C: Cac
    • Den/Family Room: Y
    • Detached/Attached: Det
    • Driveway: Pvt
    • Eat In Kitchen: Y
    • Heat: Hw
    • Picture: Y
    • W/W Carpet: Y
    • Water: Public
    • Attic: Y
    • Wood Floors: Y
    • Fuel: Gas
    • Office: Y
    • Zone: 12
    • LIST TYPE: P
    • # Kitchens: 1
    • County: Queens

    Price history

    DateEventPrice
    10/21/2025Listing removed$2,999,000$750/sqft
    Source: OneKey® MLS #838426 Report a problem
    3/21/2025Listed for sale$2,999,000+69.4%$750/sqft
    Source: OneKey® MLS #838426 Report a problem
    5/1/2018Sold$1,770,000-18.6%$443/sqft
    Source: OneKey® MLS #L2939983 Report a problem
    3/11/2018Pending sale$2,175,000$544/sqft
    Source: Douglas Elliman #2939983 Report a problem
    11/25/2016Price change$2,175,000+8.8%$544/sqft
    Source: Douglas Elliman #2874735 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $86,880 -4%
    2023-- $90,480
    2022-- $90,480 +5.8%

    Find assessor info on the county website

    Neighborhood: Douglaston

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Community District 26

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.