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 = 1874 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 1874 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 1874 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

94 Anchorage Drive
West Islip, NY 11795

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: Cosentino Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1964
Notes: Luxury Living at its Finest! Spectacular Water Views overlooking the Great South Bay & Robert Moses Bridge. A 75ft Bulkhead is equipped w/ Electric & Boat Lift, just 200ft from the Bay & on a wide canal. This beautiful home sits on 75x150 of Lush Manicured grounds. A Gracious 4Bdrms, 2.5bths has an open floorplan. A Lovely Entry w/ updated Mahogany hardwood floors and Powder Rm, lead into a Formal Dining Room w/ Custom Pocket Doors, Built in Break Front, & Bay Window. Custom EIK w/ Granite Countertops, Top of the Line Stainless Steel Appls, Ceramic Tile Floor, & 16ft Oversized Sliders that open to a Gorgeous Mahogany Deck & Cooking Area with Grill, & Starboard Cabinetry. Great for Hosting that Special Dinner! A Spacious Livingroom with Gleaming Mahogany Hardwood Floors open to a Sitting Room with an Elegant Stone Fireplace, Bar, and 16ft sliders that have Water views from every room. The Large Den or 5th bedroom has Built In Shelves, Engineered Hardwood Floors, and closet. The Primary Suite has Windows Throughout, Walk in Closet, Walnut hardwood floors, Vaulted Ceiling & Access to the Balcony with Stunning Water Views Overlooking the Canal and Bay. What better way to enjoy your morning coffee. The Ensuite features a Steam Walk in Shower, Porcelain Tile, & a Custom Vanity. 3 Additional Bdrms, Walnut Hardwood Flooring and an Updated Full Bath. Every Room on this level has Water Views. This Country Club Backyard Boasts a Salt Water Inground Pool with Pavers Galoree,Bar Area, Private Dock, and Specimen Plantings. Fully Equipped Generator for the Whole House, Gas/CAC, Radiant Heat in the Bathrooms, IGS, & 2 Car Garage, A perfect setting for that summer event! Come Escape to this Stunning Oasis, Amazing Sunrises and Sunsets with Picturesque views.Close to Fire Island, Beaches, Manhattan, Montauk & the Hamptons!
MlsNumber: 3550377


Listing Provided By: Cosentino Realty Group, original listing
Name: Cosentino Realty Group
Phone: (516) 253-7501
Office Name: Cosentino Realty Group LLC
Office Phone: (631) 263-6869
Agent Name: Diane Cosentino
Disclaimer: Copyright © 2024 OneKey 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 = 1874 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;
Real Estate Expert Photo for Suzanne Rivera
Suzanne Rivera
ASCIIRE/MAX Superior
Call Today!: (631) 300-0947

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App