42 Erland Rd, Stony Brook, NY 11790 | MLS 2897227 | Listing Information | MLSLI.com - Long Island Real Estate
Find the perfect home, schedule showing times and more!
Rentals
Commercial
Land
Sold Properties
Find the right Agent, Mortgage or Title Officer for you.
Buyer / Seller Resources
Mobile App
Property Detail - Below navigation

42 Erland Rd,  Stony Brook NY, 11790

(Active )
$1,799,000
|
5 beds, 3 Full/1 Half baths
|
MLS# 2897227
Skip Slideshow
Last Update: 12/7/2016 7:47 PM
Listing Summary
Stony Brook Village
Three Village
Colonial
1
5
3 Full/1 Half
2897227
Active

Rare Opportunity To Own A Piece Of Stony Brook's History! Named "Tranquility" By Its Current Owners, This Magnificent Waterfront Home Sets The Standard For Gracious Living. Nestled On 1.5Acres, It Offers Beautifully Appointed Main House With Water Views From Most Every Room, Separate Guest Cottage, Detached Garage, Beach Cabana & Bulkhead. Close To Suny,Train & Shopping!
Price
$1,799,000
Stony Brook Village
Suffolk County
5
3 Full/1 Half
2897227
Active
Description
Rare Opportunity To Own A Piece Of Stony Brook's History! Named "Tranquility" By Its Current Owners, This Magnificent Waterfront Home Sets The Standard For Gracious Living. Nestled On 1.5Acres, It Offers Beautifully Appointed Main House With Water Views From Most Every Room, Separate Guest Cottage, Detached Garage, Beach Cabana & Bulkhead. Close To Suny,Train & Shopping!
Listing Information
Property Type: Single Family, Other
Colonial 1 11
5 3 1
1.5 65,340 1888
Neighborhood
Room Information
1
Eat In
Formal Dining
Full
Floor Plan
Full Unfinished With Outside Ent, Laundry, Full Bath, Other
Entry Foyer, Flr,Fdr,Kit,Breakfast Rm,Library,Sunroom,.5Ba,
Master Suite With Full Bath,4 Family Bedrooms/Office
Unfinished Walk-Up Attic
Interior Features/Utilities
2
Oil
Cac
Public
2
3
Exterior / Lot Features
Frame
2
Det
16 Zones
Front
Brick
N
Financial Considerations
$28,070
$28,070
$26,918
Other
N

Stony Brook Real Estate

Stony Brook is located in New York. Stony Brook, New York 11790 has a population of 13,207.

The median household income in Stony Brook, New York 11790 is $133,899. The median household income for the surrounding county is $87,778 compared to the national median of $53,046. The median age of people living in Stony Brook 11790 is 44.5 years.

Loading nearby sales and history ...
Courtesy: Realty Connect USA L I Inc
Information is deemed reliable but is not guaranteed.

Ask a Question?
Send Now
Start a no spam email conversation
My Drive Time
Enter your work address to view actual drive times with traffic for this property

No    Yes

Calculate & Save Calculating ...
Calculating ...
Here is the weekday INRIX Drive Time from this property to .

When you register, you will receive ...

Weekday drive times
Plus all these great features

  • Drive Time calculations that inform you about traffic conditions from the property you are interested in to your place of work, along with driving directions.
  • Automatic Drive Time calculations for every property. Simply enter your work address to start.
  • Access to INRIX Drive Time data that is used by Garmin, Pioneer, Toyota, and many other well-known companies.
  • Other benefits from being a registered user including: saved properties, saved searches, price alerts, notes, direct access to your agent and much more!

Register or login today to take advantage of Drive Time
Nearby homes for sale
Recent sales nearby