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

39 Sundown Drive
Bellport, NY 11713

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 4
Baths: 3
Status: Active
SqFt: 1745
Agency: Coldwell Banker M&D Good Life

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1996
Notes: Welcome to your new home at 39 Sundown Drive,Bellport, NY! This charming L-Shaped Rand offers an impressive 1,745 square feet of first-floor living space, featuring an open floor plan that flows seamlessly from room to room,creating a functional and comfortable living area. Interior Highlights: Living Area: The den is beautifully illuminated by skylights, providing ample sun-drenched light, making it a perfect spot for relaxation and entertainment. Bedrooms: The home boasts three generously sized bedrooms on the first floor, one of which is currently used as a home office. Additionally, there is a fourth bedroom with an egress window in the basement, offering numerous possibilities. Primary Suite: The MAster en suite includes a full bath and two closets, one of which is a walk-in with access to a scuttle attic access for massive additional storage space. Kitchen: The eat-in-kitchen features a cozy breakfast nook and an updated (2 year-old) energy star appliances, making it a delightful space for meal preparation and family gatherings. Bathrooms: There are two full bathrooms on the first floor, ensuring convenience and comfort for all residents and guests. Basement Features; The full finished basement adds over 1,700 square feet of additional living space,including : A hugerecreatin room, perfect for entertainment and relaxation. A laundry room and a full bathroom.Three additional rooms/bedrooms, two of which have large walk-in closets, and a one with an egress window, making it and investor's dream. Outdoor Living: The backyard is a quarter-acre haven, ideal for summer gatherings and outdoor activities. The rear deck off the den is perfect for enjoying warm summer evenings.The spacious yard can easily accommodate swing sets, a pool, or any other amenities you may desire.Additional Amenities: This home is situated in the South Country School District and features public water, sewers, natural gas and underground utilities. 1 Car Attached Garage & room for 4 cars in the driveway & Newer roof (2014) & 3 zone heat. The location offers easy access to shopping, top-rated eateries in Suffolk County, NY and public transportation. In total, this home offers an expansive 3,495 square feet of finished living space, combining the first floor and the finished basement. Ideal for an expanding family, 39 Sundown Drive is a perfect blend of comfort, functionally, and style. Welcome Home!
MlsNumber: 3554751


Listing Provided By: Coldwell Banker M&D Good Life, original listing
Name: Coldwell Banker M&D Good Life
Phone: (631) 878-6080
Office Name: Coldwell Banker M&D Good Life
Office Phone: (631) 289-1400
Agent Name: Theodore Gounelas
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 = 3285 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 Joann Gerena and Sam Fama
Joann Gerena and Sam Fama
ASCIIBelzak and Bodkin Realty Corp
Call Today!: (631) 495-1982
Or: (631) 682-2107

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App