Title Page Background
DEBUG FN args: Array ( [0] => 3285 [1] => [2] => [3] => agent ) BEFORE: Site: 3285 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 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 = 3285 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3285 [1] => [2] => [3] => lender ) BEFORE: Site: 3285 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 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 = 3285 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3285 [1] => [2] => [3] => other ) BEFORE: Site: 3285 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3285 Igate: njhud LocID: 3285 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 = 3285 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

49a S Bay Avenue
Eastport, NY 11941
Thomas Schwaber with Realty Connect USA L I Inc, original listing - (631) 881-5160

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,675,000
Beds: 5
Baths: Full: 4, ½: 3
Status: Active
SqFt: 3924 Square Feet
Agency: Realty Connect USA L I Inc
Agency Phone: (631) 881-5160

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: Summer Spectacular in Eastport Perfectly situated at the end of South Bay Avenue in Eastport and directly across from Moriches Bay and Seatuck Cove, this traditional-style home sits on a beautifully manicured and arborvitae-lined 1.45-acre lot. Tucked away at the end of a private gravel driveway, this secluded retreat offers your ideal East End forever home. Step into the oasis-like backyard, where you'll find a spacious paver patio and a fully fenced-in 20x40 L-shaped, heated saltwater pool. The pool area features a charming gazebo, an outdoor kitchenette, and an entertainment-ready tiki bar. A hot tub just off the back porch invites you to unwind, and an outdoor shower and bathroom add to the convenience. Beyond the pool lies the expansive great lawn-perfect for entertaining or letting your imagination run wild. Outdoor enthusiasts will love the proximity to Pikes Beach, the famed Dune Road, and Cupsogue Beach, as well as easy access to local restaurants, shopping, and the Eastport Marina-just across the street-for boating enthusiasts. The front entrance boasts a welcoming composite deck, ideal for morning coffee or enjoying evening sunsets. Inside, a grand foyer with a curved staircase sets the tone for this impressive home. To the left, one of two primary suites includes an ensuite bathroom complete with a fireplace. Across the foyer is a formal dining room, perfectly suited for hosting gatherings. The heart of the home is the open-concept living room and kitchen, featuring high-end appliances including Sub-Zero and Bosch, granite countertops, and a massive center island. A separate butler's pantry is outfitted with a sink, convection microwave, dishwasher, wine fridge, and coffee bar. Adjacent guest quarters include a bedroom, full bathroom, powder room, and a separate laundry room. Upstairs, the second primary suite offers a luxurious ensuite bathroom with a clawfoot tub and dual walk-in closets with custom organizers. Down the hall are two additional spacious bedrooms and a full bathroom. Just one more flight up, a finished loft awaits-perfect for a home office, sitting area, or an additional bedroom. The finished basement is a dream space, currently used as a game room with a basketball hoop, billiards table, air hockey, and darts. It also features a dedicated fitness center, an office, a bathroom, ample storage, and utility rooms. Rounding out this remarkable home is an oversized three-car garage with a full stand-up loft currently used for storage. Notable upgrades include a newer roof and updated HVAC systems. **No Flood Insurance Required!**Start your summer in this magnificent home!
MlsNumber: --
ListingId: 11493384


Listing Provided By: Realty Connect USA L I Inc, original listing
Phone: (877) 647-1092
Office Phone: (631) 881-5160
Agent Name: Thomas Schwaber
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App