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','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 = 1874 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 = 1874 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;

998 Pacific Street
Lindenhurst, NY 11757
Rory Sherman with Charles Rutenberg Realty Inc, original listing - (516) 575-7500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 2200 Square Feet
Agency: Charles Rutenberg Realty Inc
Agency Phone: (516) 575-7500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1946
Notes: Welcome to your new sanctuary on the Great South Bay in Lindenhurst-a stunning 2-bedroom, 3-bathroom boater's paradise. You will enjoy breathtaking panoramic views and luxurious living harmoniously blended across three levels of elegant space. Experience unobstructed sweeping views of the Great South Bay from every angle of this exquisite home. With 80 feet of Navy wall bulkhead, this home is a boaters paradise. You will enjoy a front-row seat to stunning sunrises and serene sunsets every day. This expansive home features three thoughtfully designed levels, each offering unique spaces for relaxation and entertainment. The main level is designed to capture and enhance the natural beauty of its surroundings. Large windows flood the space with light, creating a bright and airy atmosphere perfect for both everyday living and entertaining. Both the main and lower level have radiant heating in the floors. The large primary suite boasts a huge ensuite with double vanity, extra wide 4ft shower with dual shower heads, body sprayers and jetted Jacuzzi Tub featuring water views. As you enter the kitchen you are greeted with granite counter tops and Stainless steel appliances, ample counter space, and custom cabinetry. Whether you're preparing a casual meal or hosting a dinner party, this kitchen has everything you need. The living area seamlessly connects to the wraparound waterfront deck with brand new Trex Deck. It is perfect for enjoying morning coffee, evening cocktails, or simply soaking in the tranquil surroundings. The expansive outdoor space is ideal for summer gatherings or peaceful solitude. The upper level boasts a family room, storage room and two bonus rooms that can become bedrooms with proper permits. The lower level is perfect for hosting guests or creating your own entertainment zone. With plenty of space for a game room, media area, or additional guest quarters, this level adds flexibility and functionality to your living experience. The summer kitchen provides ease and convenience while prepping for BBQ's and is perfect for entertaining guests. All three bathrooms are beautifully designed, featuring contemporary fixtures, stylish tile work, and ample space for pampering. Situated in the charming community of Lindenhurst, you'll benefit from a serene environment while being conveniently close to local amenities, schools, and transportation options. This remarkable home offers an unparalleled living experience on the Great South Bay, combining luxurious interiors with stunning natural beauty and versatile living spaces. Don't miss the opportunity to make this waterfront dream home yours. Schedule a showing today and envision the life you could lead in this extraordinary setting!
MlsNumber: --
ListingId: 3579657


Listing Provided By: Charles Rutenberg Realty Inc, original listing
Phone: (631) 258-8552
Office Phone: (516) 575-7500
Agent Name: Rory Sherman
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','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;
Real Estate Expert Photo for John Ciervo
John Ciervo
ASCIIAliano Real Estate
Call Today!: (631) 512-6157

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App