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

322 Anchorage Drive
Woodbury, NY 11797

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,799,000
Beds: 6
Baths: 5
Status: Active
SqFt: 4538
Agency: Compass Greater NY LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1979
Notes: PRICE IMPROVEMENT! Welcome to the epitome of luxury living in Woodbury Estates! This 4500+ square foot, stucco, colonial contemporary home has been completely renovated in 2023, boasting a level of opulence that is truly unmatched. From the moment you set foot inside, you'll be captivated by the exquisite craftsmanship and high-end finishes that define every inch of this remarkable property. This magnificent home offers an impressive 6 bedrooms, 4 full baths, and 1 half bath. It is the epitome of spacious elegance. The layout is thoughtfully designed, with dual staircases & 4 bedrooms located upstairs, including an additional en-suite 5th bedroom or bonus room, providing flexibility and comfort. As you enter the primary suite, you'll immediately notice the meticulous attention to detail that sets it apart. The generous size of the room creates a sense of spaciousness and tranquility, providing ample room for relaxation and unwinding. But what truly sets this primary bedroom suite apart is the unbelievable dressing area. The custom closets are a masterpiece of design, offering dedicated spaces for clothing, shoes, accessories, and more. They are tailored to your needs, ensuring that everything has its place and is easily accessible. No more clutter or chaos; instead, you'll experience the joy of a perfectly organized wardrobe. One of the standout features of this home is its attention to energy efficiency and comfort. Thermal custom commercial windows not only enhance the aesthetic appeal but also provide exceptional insulation, making this home as eco-friendly as it is luxurious. Step onto the radiant heat on the first floor and in all full bathrooms which ensures a cozy and inviting atmosphere year-round. The open concept kitchen is a chef's dream, equipped with top-of-the-line appliances and finishes that will elevate your culinary experience. Technology meets luxury with Smart Audio and Sonos systems throughout the home, allowing you to enjoy your favorite music in every corner, creating the perfect ambiance for any occasion. NEWLY DONE finished basement and laundry. As you venture outside, you'll discover a private oasis on this expansive 1-acre property. An inground heated gunite pool with a hot tub beckons you to relax and unwind, while two changing rooms ensure your comfort. The built-in BBQ and bar area provide the ideal setting for outdoor gatherings and entertainment. Sports enthusiasts will delight in the hard tru tennis court, offering endless opportunities for friendly matches and exercise. Located in the prestigious Syosset School District, this home is not just a residence; it's a lifestyle. Immerse yourself in the luxury of Woodbury Estates, where every detail has been meticulously considered to provide the ultimate in comfort and convenience. Don't miss your chance to own this masterpiece of modern living.
MlsNumber: 3544387


Listing Provided By: Compass Greater NY LLC, original listing
Name: Compass Greater NY LLC
Phone: (212) 913-9058
Office Name: Compass Greater NY LLC
Office Phone: (516) 703-3360
Agent Name: Frances Mazer
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 = 3249 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 Sasha Petukhova
Sasha Petukhova
ASCIICompass
Call Today!: (516) 816-4494

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App