INVESTOR OPPORTUNITY - DRIVE-BY VIEWING ONLY - DO NOT WALK PROPERTY
The Enclave by Edaward P Mellon-Rare opportunity to acquire a double lot totaling 0.3 acres in a prime Stony Brook location. This property is being sold strictly AS-IS. Absolutely no access to interior or grounds permitted. Drive-by viewing only. This well-positioned double lot offers convenient proximity to transportation (0.5 miles to train station), schools (1 mile), and hospital (1.5 miles). Cash buyers or investors with renovation/construction experience preferred. Seller makes no representations or warranties regarding the condition of the property. All inspections and due diligence are the responsibility of the buyer.
97 days
|
123
|
6
|
Zillow last checked:
Listing updated:
Listed by:
Daniel Gale Sothebys Intl Rlty631-288-1050,
Jacqulene Mitrani PSA SFR631-833-9074
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 991478
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 3
Full bathrooms: 2
1/2 bathrooms: 1
Heating
Other
Cooling
None
Appliances
Included: None
Features
Other
Basement: See Remarks
Attic: Partial
Has fireplace: No
Interior area
Total structure area: 2,500
Total interior livable area: 2,500 sqft
Property
Parking
Parking features: Driveway
Has uncovered spaces: Yes
Lot
Size: 4,356 Square Feet
Dimensions: .3
Details
Parcel number: 0200174000600031000
Special conditions: None
Construction
Type & style
Home type: SingleFamily
Architectural style: Craftsman
Property subtype: Single Family Residence, Residential
Attached to another structure: Yes
Materials
Advanced Framing Technique
Condition
Fixer
Year built: 1915
Utilities & green energy
Sewer: Other
Water: Other
Utilities for property: See Remarks, Trash Collection Public, Water Connected
Community & HOA
HOA
Has HOA: No
Location
Region: Stony Brook
Financial & listing details
Price per square foot: $180/sqft
Tax assessed value: $500,000
Annual tax amount: $11,404
Date on market: 4/27/2026
Cumulative days on market: 97 days
Listing agreement: Exclusive Right To Sell
Listing terms: Cash
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
5/28/2026
Pending sale
$450,000$180/sqft
Source: OneKey® MLS as distributed by MLS GRID #991478Report a problem
4/28/2026
Listed for sale
$450,000$180/sqft
Source: OneKey® MLS as distributed by MLS GRID #991478Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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.