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

1233 Beech Street
Atlantic Beach, NY 11509
Amanda Rosenberg with THE HELLER ORGANIZATION INC, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,200,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: THE HELLER ORGANIZATION INC
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Desirably located in The Water Club's prestigious gated community is a rare opportunity to own a uniquely designed corner home on a 7,525 square foot lot, currently being offered for the first time in over 35 years. Enjoy direct access to private beachfront reserved exclusively for The Water Club owners and their guests. Experience the tranquility of partial Atlantic Beach views from the balcony off the primary master suite, and bask in ample natural sunlight streaming in from skylights and four exposures throughout the home. Enhancing the serene ambiance are soaring cathedral ceilings in the living room, which accentuate the open, split-level layout, featuring 4 bedrooms and 3.5 bathrooms. On the first floor, the entry foyer dramatically leads into the living room, which flows into the formal dining room, a gourmet kitchen boasting Gaggenau appliances and exotic African cherry wood custom cabinetry, a dining area, a den with a fireplace, and a powder room. On the second floor, the primary suite is separated from two additional bedrooms and a bathroom by an atrium overlooking the first floor. On the lower level is a fourth bedroom, a bathroom, three additional spacious rooms, and a laundry room. Perhaps best of all is the thoughtfully designed bi-level backyard, which is accessible through both the first and lower levels. Additional features include a heated two-car garage, a reverse-osmosis filtration system, and a Bang & Olufsen sound system throughout the home. With proper approval, a swimming pool may be added. The Water Club is an exclusive, self-managed gated community with 24-hour security and private beach access, located in prime Nassau County, 25 miles from Midtown Manhattan. Monthly HOA fees include landscaping, snow removal, and maintenance of the pool at The Water Club, which is monitored by lifeguards throughout the summer months (Memorial Day through Labor Day, from 10:00am to 8:00pm daily). Currently, the monthly HOA fee is $1,100 and will remain unchanged for the 2025 calendar year. An additional $200 per month fee will be assessed until December 31, 2025 for roadway repaving. Current annual property taxes are $19,308. Shown exclusively by appointment only (no open houses).
MlsNumber: --
ListingId: 11368737


Listing Provided By: THE HELLER ORGANIZATION INC, original listing
Phone: (917) 923-3066
Agent Name: Amanda Rosenberg
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.


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 = 3394 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 Taniya Jones
Taniya Jones
ASCIIKeller Williams Realty Gold Coast
Call Today!: (718) 678-0789

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App