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 = 3285 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 = 3285 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 = 3285 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;

16 Linden Lane
Westhampton Beach, NY 11978
Rod Cummings with Saunders & Associates, original listing - (631) 288-4800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,500,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 5140 Square Feet
Agency: Saunders & Associates
Agency Phone: (631) 288-4800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1993
Notes: This gorgeous country estate is a true oasis located on a quiet waterfront lane and down a private driveway just east of Turkey Bridge in charming Quiogue with immediate access to Westhampton Beach Village shopping and gorgeous ocean beaches. Set on over an acre, the farmhouse-style home has been completely renovated and updated and features six large bedrooms (four en-suite), five full bathrooms and two half bathrooms. There is a lovely en-suite bedroom on the first floor. Designer decorated with impeccable details and custom finishes throughout there are multiple gathering and entertaining spaces both inside and out including a great open living and dining room with fireplace, an oversized and spectacular eat-in chef's kitchen with a huge island, new stainless steel appliances, professional Wolf stove, and two Sub-zero refrigerators. The home spans two floors of gracious living spaces including a large home office/den, a spacious den/multi-purpose room with walls of French doors leading outside, a large gym/sport room, and an expansive open mud room with laundry and a bathroom that is accessible to the outdoor space. For the fine wine collector there's a hidden climate controlled cellar for storage and tastings. The sprawling outdoor amenities include mature lush gardens and expansive lawns and a large heated free-form Gunite pool with room for a sport court. Secluded and very private yet just a stone's throw from all the village has to offer. A spectacular offering in a prime location!
MlsNumber: --
ListingId: 11321744


Listing Provided By: Saunders & Associates, original listing
Phone: (631) 288-4800
Office Phone: (631) 288-4800
Agent Name: Rod Cummings
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App