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 = 319 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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 = 319 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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 = 319 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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;

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: $2,749,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 6400 Square Feet
Agency: Jack Lingo - Lewes
Agency Phone: (302) 227-3883

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: Own a piece of Delaware History!! This very unique bay front property was originally part of the Slaughter Beach Hotel dating back to the late 1800's. The current owners ancestors bought this property 100 years ago and have enjoyed it through many generations! The large parcel includes 1.26 acres on the Delaware Bay with 175 feet of direct beach frontage. In 1981-83, Richard Johnson & Son Contractors were hired to completely renovate the home, by relocating and elevating it onto pilings to have a better Bay View. The former hotel was stripped down to the studs and completely rebuilt, leaving as many original features of the structure as possible (see the attached history) . 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! The ground floor includes 2 living spaces as well as a second kitchen with a full bath and sauna, laundry, storage, 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 (former attic) boasts a open beam bay front loft bedroom with a private sun deck overlooking the Bay. The oversized climate controlled, detached garage with a finished office space and potential 2-story dwelling area provides extra conditioned living area and massive storage. <br /> <br /> The home was restained in early June. The elevator and whole house generator serviced and, every window in the home has been recently replaced with A-Series Anderson windows! The heating and cooling systems in both home and garage have been recently replaced and upgraded, as well. Bathroom fixtures are also new! <br /> <br /> Slaughter Beach is incorporated as a town with their own 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. 4966-SL
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 © 2024 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

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 = 319 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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 Javia Campbell
Javia Campbell
ASCIICENTURY 21 Gold Key Realty
Call Today!: (302) 383-4337

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App