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;

38792 Wilson Avenue
Selbyville, DE 19975

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,990
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2016 Square Feet
Agency: Berkshire Hathaway HomeServices PenFed Realty - OP
Agency Phone: (410) 208-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Welcome to this stunning luxury waterfront home, perfectly situated to offer breathtaking bay views. This exquisite 3-bedroom, 2.5-bathroom residence is designed for the discerning homeowner who values comfort, elegance, and the ultimate waterfront lifestyle. The home is located in one of the most sought-after waterfront communities in southern Delaware. This luxury home offers the serenity of waterfront living and the convenience of city amenities. Enjoy the panoramic bay views and unique inverted design to maximize breathtaking views from every window. Watch the fireworks from your balconies every Sunday evening displayed from Northside Park. This home is located just one mile from Fenwick Island and Ocean City beaches. Only minutes from open water on the Assawoman bay. This impeccably maintained home has high end finishes from floor to ceiling, like plantation shutters, custom window treatments and upgraded trim package. Two well-appointed bedrooms provide ample space for family and guests on the first floor with canal views and a full bath. Melt your cares away and unwind in the hot tub overlooking the tranquil waters on the first floor deck on those cool summer evenings. Enter the ELEVATOR or take the stairs to the second floor which is dedicated to the stylish and functional primary suite with a private balcony, spa-like bathroom, and walk-in closet situated at the rear of the home so that you can wake up to stunning canal/bay views from every window in the owners suite. The heart of this home is its gourmet kitchen, featuring top-of-the-line appliances, custom cabinetry, and a spacious island perfect for entertaining and family gatherings. The main living area, situated on the top floor, provides unobstructed panoramic water views, open-concept living and dining areas with stunning water views and a cozy fireplace. Expansive vaulted ceilings in the main living areas create an airy, open atmosphere. There are balconies on each level, perfect for entertaining and relaxing while enjoying the scenery. The top level deck has a powered awning for those hot summer days. Private, high-capacity 10,000 lb boat lift installed in 2020 and a dedicated 1500 lb. lift for jet ski, make it easy to enjoy water sports at a moment’s notice. The crawl space has a vapor barrier and dehumidifier to keep the space dry and clean. A massive under deck storage area is perfect for keeping your fishing gear, kayaks, surfboards, and beach supplies safe from the elements. The property offers the opportunity for expansion on this 50' X 85' lot, to add a garage, addition or customization to meet your needs. The utility garage will house a small vehicle, motorcycle, or golf cart. This gorgeous coastal gem is in close proximity to fine dining, shopping, and entertainment and easy access to the best beaches and recreational activities in Delaware. Don't miss the opportunity to own this magnificent waterfront home. Contact us today to schedule a private tour and experience luxury living at its finest. One year home warranty included for buyer!
MlsNumber: --
ListingId: DESU2064576


Listing Provided By: Berkshire Hathaway HomeServices PenFed Realty - OP, original listing
Phone: (410) 208-3500
Office Phone: (410) 208-3500
Agent Name: Amy Coy
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