Skip main navigation
Off market
  • $2,281,700

    42 Erland Rd, Stony Brook, NY 11790

    5beds
    --sqft
    SingleFamily
    Built in 1888
    1.5 Acres Lot
    $2,281,700 Zestimate®
    $--/sqft
    $5,864 Estimated rent

    Home value

    $2,281,700

    $2.05M - $2.53M

    $5,864/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,864/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

    $5,864/mo

    Rent Zestimate®

    Refinance and save

    $15,555/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

    $15,555/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

    Tranquility is only one of many words to describe this one of a kind 5bd, 3.5 bath colonial sitting on 1.5 acres of waterfront property. Set back at the end of a 100 Ft. driveway, sits your own private oasis. Enjoy year round sunsets from your sprawling sunroom or boat house. The 110ft private bulkhead is perfect for a boat or kayak launch. This home offers many "smart" features, a water filtration system, beautiful moldings as well as an updated kitchen with granite countertops, a full basement partially finished with outside entrance, updated bathrooms, floors and windows as well as a large attic with cathedral ceilings and a separate 100 amp electric panel. Property also has a potting shed and seperate 1 bedroom 1 bath cottage with a seperate meter.

    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: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Other
    Cooling
    • Central
    Appliances
    • Included: Dryer, Refrigerator, Washer
    Features
    • Eat-in Kitchen, Den/Family Room, Home Office, Living Room / Dining Room, Entrance Foyer, Granite Counters, Master Bath, Powder Room, Storage, Walk-In Closet(s), Open Floorplan, Formal Dining Room, Exercise Room
    • Basement: Partially Finished, Full, Walk-Out Access

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Detached
    Features
    • Patio & porch: Deck
    • Fencing: Back Yard, Fenced
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Beach Access, Waterfront, Sound, Inlet, Water Access
    Lot
    • Size: 1.50 Acres
    • Features: Cul-De-Sec, Private
    Details
    • Parcel number: 0200152000200008000

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Condition
    • Year built: 1888

    Utilities & green energy

    • Sewer: Cesspool
    • Water: Public

    Community & neighborhood

    Location
    • Region: Stony Brook

    Other

    Other facts
    • Appliances: Dryer, Dishwasher, Range
    • ArchitecturalStyle: Colonial
    • Basement: Partially Finished, Full, Walk-Out Access
    • ExteriorFeatures: Sprinkler Lawn System, Dock
    • FireplaceYN: 1
    • Heating: Oil, Propane
    • Flooring: Hardwood
    • Inclusions: Dryer, Dishwasher, Oven/Range, Generator, A/C Units, Fireplace Equip
    • InteriorFeatures: Eat-in Kitchen, Den/Family Room, Home Office, Living Room / Dining Room, Entrance Foyer, Granite Counters, Master Bath, Powder Room, Storage, Walk-In Closet(s), Open Floorplan, Formal Dining Room, Exercise Room
    • ParkingFeatures: Private, Detached
    • PropertyType: Residential
    • WaterSource: Public
    • SeniorCommunityYN: 0
    • WaterfrontFeatures: Beach Access, Waterfront, Sound, Inlet, Water Access
    • LotFeatures: Cul-De-Sec, Private
    • PatioAndPorchFeatures: Deck
    • DirectionFaces: West
    • View: Water, Other, Skyline
    • Sewer: Cesspool
    • AtticDescription: Full
    • Fencing: Back Yard, Fenced
    • CommunityFeatures: Park

    Price history

    DateEventPrice
    7/1/2023Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    9/3/2021Sold$1,770,000-1.7%
    Source: Public Record Report a problem
    6/30/2021Pending sale$1,799,999
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    2/27/2021Listed for sale$1,799,999
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    2/27/2021Pending sale$1,799,999
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    2/27/2021Listed for sale$1,799,999
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    2/11/2021Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    1/20/2021Price change$1,799,999-2.7%
    Source: OneKey® MLS as distributed by MLS GRID #3280901 Report a problem
    10/2/2020Listed for sale$1,850,000+76.2%
    Source: Owner Report a problem
    10/25/2018Sold$1,050,000-30%
    Source: OneKey® MLS as distributed by MLS GRID #L3034804 Report a problem
    5/30/2018Listed for sale$1,500,000-16.6%
    Source: Daniel Gale Agency Inc #3034804 Report a problem
    2/10/2018Listing removed$2,200
    Source: REALTY CONNECT USA Report a problem
    1/11/2018Listed for rent$2,200
    Source: REALTY CONNECT USA Report a problem
    1/3/2018Listing removed$1,799,000
    Source: Realty Connect USA L I Inc #10355116 Report a problem
    11/21/2017Price change$1,799,000+12.5%
    Source: Realty Connect USA L I Inc #10355116 Report a problem
    9/27/2017Listed for sale$1,599,000-11.1%
    Source: Realty Connect USA L I Inc #2974006 Report a problem
    4/1/2017Listing removed$1,799,000
    Source: Realty Connect USA L I Inc #10355116 Report a problem
    11/17/2016Listed for sale$1,799,000
    Source: Realty Connect USA L I Inc #2897227 Report a problem
    11/30/2015Listing removed$2,200
    Source: Team Ardolino Report a problem
    9/22/2015Listed for rent$2,200
    Source: Team Ardolino Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $7,600
    2024-- $7,600
    2023-- $7,600
    2022-- $7,600
    2021-- $7,600
    2020-- $7,600
    2019-- $7,600
    2018-- $7,600
    2017$28,930 $7,600
    2016-- $7,600 -12.6%
    2015-- $8,700
    2014-- $8,700
    2012-- $8,700
    2011-- $8,700
    2010-- $8,700
    2009-- $8,700
    2008-- $8,700
    2007$24,019 +26.7%$8,700
    2005$18,954 +9%$8,700
    2004$17,396 +6%$8,700
    2003$16,404 +7.7%$8,700
    2002$15,236 $8,700

    Find assessor info on the county website

    Neighborhood: 11790

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • District: Three Village

    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
    $2,281,700
    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
    $2,281,700