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

39157 Garfield Avenue
Selbyville, DE 19975
Bita Dayhoff with Compass, original listing - (410) 220-5745

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 4356 Square Feet
Agency: Compass
Agency Phone: (410) 220-5745

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Step into luxury! <br /> <br /> 39157 Garfield Avenue is nestled in the charming town of Selbyville, DE, just .9 miles from Fenwick Island beach, offering a perfect blend of coastal serenity and modern convenience. <br /> <br /> The home itself is a stunning 6-bedroom all with ensuite bathrooms, 2 half bathrooms, canal-front home designed for both relaxation and entertainment. The house is freshly painted with upgraded bathrooms and a brand-new roof installed in April 2025. The roof has a 50-year warranty which is transferable with the sale of the house. It is a beautifully furnished, turnkey home, ready for immediate enjoyment. <br /> <br /> Whether as a personal getaway or a lucrative investment property. Every room is thoughtfully equipped with high-quality furniture and décor, ensuring both comfort and style.<br /> <br /> This 4,532 sq. ft. masterpiece boasts four decks, a hot tub, a private dock, and a billiards room, making it the perfect waterfront retreat. Parking for six (6) makes for easy access.<br /> <br /> The heart of the home is its gourmet kitchen, equipped with granite countertops, stainless steel appliances, a large island, and custom cabinetry—perfect for entertaining or preparing meals for large groups. The layout flows seamlessly into the open concept living and dining areas, which feature a gas fireplace and a wet bar, creating an inviting atmosphere.<br /> <br /> Beyond its stunning canal-front location and impressive amenities, this property offers a solid and lucrative rental history, making it an ideal investment. The home comes with a list of repeat renters, some of whom have been enjoying their stays year after year. It is primarily rented by the same groups from June 15th to August 31st, ensuring a steady rental income without the need for constant new bookings. Property is rented from June 15th to August 31, 2025. Rental income is transferred to new owner. <br /> <br /> This home is perfect for those looking to experience coastal living at its finest. Its proximity to Fenwick Island’s beaches, restaurants, and entertainment makes it a desirable retreat for both personal use and rental opportunities. The Fenwick Island area is known for its beautiful beaches, boating opportunities, and vibrant local attractions. Residents enjoy easy access to restaurants, shopping, and outdoor activities, all while being just a short drive from Ocean City, MD. <br /> <br /> Whether you're looking for a vacation getaway or a full-time residence, this property offers the best of coastal living.
MlsNumber: --
ListingId: DESU2084418


Listing Provided By: Compass, original listing
Phone: (410) 220-5745
Office Phone: (410) 220-5745
Agent Name: Bita Dayhoff
Disclaimer: Copyright © 2025 Bright 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => sussex [3] => DE [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: sussex State: DE Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: sussex State: DE 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 = 319 AND i.igate IN ('dehud','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 = 'dehud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Charlene Bury
Charlene Bury
ASCIIRE/MAX Horizon
Call Today!: (330) 519-5311

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App