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;

351 Bay Avenue
Milford, DE 19963
NICK CARTER with Jack Lingo - Lewes, original listing - (302) 227-3883

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,995
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 4800 Square Feet
Agency: Jack Lingo - Lewes
Agency Phone: (302) 227-3883

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: JUST REDUCED! <br /> <br /> This very unique bay front property sits upon the equivalent of 2 Bayfront lots and was originally part of the Slaughter Beach Hotel dating back to the late 1800's. The large parcel includes 0.84 acres on the Delaware Bay with 114 feet of direct beach frontage. <br /> <br /> The former hotel was stripped down to the studs and completely rebuilt, leaving as many original features of the structure as possible . It now stands 3.5 stories tall and includes, an elevator providing access to the first 3 floors, wrap around deck, living area off the kitchen, open floor plan with panoramic Delaware Bay views from each side of the home! <br /> <br /> The newly renovated ground floor includes laundry, massive storage, a whole house generator and new HVAC. The 2nd floor is the primary living, dining and kitchen area with a full bath. The 3rd floor provides 3 bedrooms - 2 of which have direct bay views and the 4th floor boasts a open beam bay front loft bedroom with a private sun deck overlooking the Bay. <br /> <br /> The oversized climate controlled, detached garage with a finished office space and/or potential 2-story dwelling area provides extra conditioned living area and more massive storage. <br /> <br /> The House is approximately 4,800 sq ft. The detached garage is estimated at 1,600 sq ft.<br /> <br /> <br /> Slaughter Beach is incorporated as a town with a volunteer fire department, beach pavilion, recreational park including tennis/pickleball courts, basketball courts, playground equipment and over sized public parking area. The Cedar Creek marina at the North end of town provides indoor boat storage, marine services and easy boating access to the Delaware Bay through the Mispillion Inlet,. The DuPont Nature Center and public boat ramp are located across the Cedar Creek Bridge to the North.
MlsNumber: --
ListingId: DESU2064330


Listing Provided By: Jack Lingo - Lewes, original listing
Phone: (302) 227-3883
Office Phone: (302) 227-3883
Agent Name: NICK CARTER
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