Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3384 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3384 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3384 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

41 Stillwater Lane
Saint James, NY 11780
Shan Chowdhury Dual Lic. with Brown Harris Stevens (Westhampton Beach), original listing - (631) 288-5500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,495,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 6524 Square Feet
Agency: Brown Harris Stevens (Westhampton Beach)
Agency Phone: (631) 288-5500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: A one-of-a-kind modern masterpiece overlooking Stony Brook Harbor, this new construction home with its striking design is a beautiful juxtaposition of its natural surroundings. Designed by visionary architect, Bob King, this home is a perfect blend of industrial strength and modern elegance. The only home in the region that is wrapped in high-performance aluminum composite paneling, the exterior is not just stunning, it is virtually maintenance-free and engineered to stand the test of time. Spanning over 6,500 interior square feet across three floors, there are five bedroom, five bathrooms, a magnificent column free 50ft x 40ft great room, lower lever with walk-out deck, wine cellar, panic/safe room, and a futuristic glass enclosed link that seamlessly connects the main residence to the four-car garage. The layout has been thoughtfully designed for both form and function. Perched on a hill near the Stillwater Road cul-de-sac, the lot is uniquely positioned to have a southern exposure with breathtaking water views which is extremely rare on the north shore. Benefits of a southern exposure on this part of Long Island include increased natural light throughout the day and less wear and tear on the exterior of waterfront homes from harsh weather. Whether you enter through the front door or use the glass link, you're immediately greeted by an expansive great room with an open kitchen / dining area, fireplace, custom 10 ft windows, massive wraparound terrace, and gorgeous views of the harbor and Nissequogue golf course. On the second floor there are a total of 3 bedrooms, each with its own ensuite bathroom. The primary includes a large walk-in closet, floor to ceiling windows, and a wraparound balcony. The lower level features a beautiful open room with fireplace that can be used as a rec room, home theater, gym, etc. There are two additional bedrooms with water views, a full bathroom, panic room / home safe, and a wine cellar. This level also leads out to the deck where plans are in place for the new homeowner to finish an outdoor entertainment space to their liking which can include a sauna, hot / cold plunge, and an infinity pool. All major systems are in place: power, radiant heated floors, plumbing, electrical, insulation, and ductwork, with a fully completed exterior. What remains is the exciting part: bringing the new homeowner's personal vision to life. Interior and pool renderings offer a glimpse of the extraordinary possibilities ahead. Listing ID#920832
MlsNumber: --
ListingId: 11453019


Listing Provided By: Brown Harris Stevens (Westhampton Beach), original listing
Phone: (631) 288-5206
Office Phone: (631) 288-5500
Agent Name: Shan Chowdhury Dual Lic.
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3384 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Patrick Canty
ASCIIeXp Realty
Call Today!: (631) 943-9161

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App