Title Page Background
DEBUG FN args: Array ( [0] => 1852 [1] => [2] => [3] => agent ) BEFORE: Site: 1852 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1852 Igate: njhud LocID: 1852 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1852 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1852 [1] => [2] => [3] => lender ) BEFORE: Site: 1852 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1852 Igate: njhud LocID: 1852 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1852 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1852 [1] => [2] => [3] => other ) BEFORE: Site: 1852 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1852 Igate: njhud LocID: 1852 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1852 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

229 Glengariff
Massapequa Park, NY 11762
Josh Goldfeder with Serhant LLC, original listing - (646) 480-7665

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,598,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5000 Square Feet
Agency: Serhant LLC
Agency Phone: (646) 480-7665

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: New Construction Luxury Residence in Massapequa Park! Voted #1 Place to Live in New York! This magnificent new construction home at 229 Glengariff offers unparalleled luxury and sophisticated living. <br /> <br /> Highlights: This expansive 5,000 sqft residence boasts 5 bedrooms and 3.5 bathrooms, including first and second-floor ensuite bedrooms. Situated on a generous 100x100 lot, this property features a fully finished 1,000 sqft basement with an outside entrance and an additional 500 sqft of mechanical/storage space. Enjoy a massive 200 sqft+ primary ensuite with imported Italian stone, his and hers closets, double showers, and a soaking tub.<br /> <br /> Interior Features: Step inside to 9ft ceilings on the first floor, a grand 19’ foyer, and solid wood interior doors throughout. The first floor includes a large den with a gas fireplace, a formal dining room, and a living room. The chef’s kitchen is equipped with high-end stainless steel appliances, an oversized island, double wall oven or oven/microwave combo, 36” gas cooktop, and a butler pantry with a wine fridge. Other features include red oak hardwood floors, extensive crown molding, wainscoting, and a first-floor sound system.<br /> <br /> Exterior Features: This home offers double-hung energy-efficient windows, cedar impression shingles, and high-end PVC board & batten trim. Enjoy a 20ft+ covered front porch with stacked ledger and Cambridge stones, black gutters, accent soffit lighting, and an oversized two-car garage with Lift Master (Smart/WiFi) automatic openers. The property is fully landscaped with a multi-zone sprinkler system, perimeter privacy trees (with drip irrigation), and a sodded front yard.<br /> <br /> Additional Features: Benefit from spray foam insulation throughout, three heating/cooling zones, a 90-gallon efficient water heater, and a stand-up attic with plywood flooring for storage. The property is Ring doorbell and alarm ready, and internet/TV ready for easy connection. The backyard offers ample space for a future pool, outdoor kitchen, play area, or half-sport court of your choosing! <br /> <br /> Don't miss this opportunity to own a stunning, custom-built home in the highly sought-after Massapequa Park!
MlsNumber: --
ListingId: 865380


Listing Provided By: Serhant LLC, original listing
Phone: (516) 870-8110
Office Phone: (646) 480-7665
Agent Name: Josh Goldfeder
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App