Title Page Background
DEBUG FN args: Array ( [0] => 1771 [1] => [2] => [3] => agent ) BEFORE: Site: 1771 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1771 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 = 1771 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1771 [1] => [2] => [3] => lender ) BEFORE: Site: 1771 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1771 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 = 1771 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1771 [1] => [2] => [3] => other ) BEFORE: Site: 1771 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1771 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 = 1771 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

39724 E Sun Dr #222
Fenwick Island, DE 19944

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $520,000
Beds: 3
Baths: --
Status: Active
SqFt: --
Agency: Salisbury

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential Common Interest-Condominium
Year Built: 1987
Notes: Welcome to your updated coastal haven in Fenwick Island, Delaware! Situated within walking distance to the pristine beaches, this delightful 3-bedroom, 2-bathroom condo spans across two floors, offering a spacious and inviting retreat for beach lovers and coastal enthusiasts alike .Upon entering, you're welcomed into a light-filled open-concept living space, adorned with modern coastal decor and boasting ample room for relaxation and entertainment. The living room features plush seating arrangements and large windows that invite in the sunshine, creating a warm and inviting atmosphere. Adjacent to the living area, the updated kitchen is a chef's delight, equipped with sleek modern appliances, abundant storage space, and a convenient breakfast bar for casual dining. Noteworthy among its features is a wine chiller, perfect for storing your favorite vintages and ensuring they're perfectly chilled for any occasion. Whether you're preparing a seaside feast or enjoying a quick snack, this kitchen is sure to inspire your culinary adventures. The condo's layout spans across two floors, offering privacy and separation between the living and sleeping areas. On the first floor, you'll find one well-appointed bedroom, providing convenience and accessibility. Upstairs, two additional bedrooms await, each offering a tranquil retreat after a day of beachside fun. The master suite boasts a comfortable queen-sized bed, ample closet space, providing the ultimate in relaxation and comfort. The second bedroom upstairs offers cozy accommodations for guests or family members, ensuring everyone has their own space to unwind.Step outside onto the private balcony and take in the salty breeze while enjoying panoramic views of the surrounding area. Whether you're sipping your morning coffee or watching the sunset over the horizon, this outdoor space is the perfect spot for relaxation and rejuvenation. In addition to its prime location and inviting interior, you'll also be able to enjoy: Tranquil Island Atmosphere: Fenwick Island is known for its peaceful and serene atmosphere, making it an ideal destination for those seeking a relaxing getaway. Despite its proximity to popular beach towns like Ocean City, Maryland, Fenwick Island maintains a more laid-back vibe, offering visitors a chance to escape the hustle and bustle of everyday life.Tax-Free Shopping: One of the perks of visiting Fenwick Island and the surrounding area is Delaware's status as a tax-free shopping destination. Visitors can take advantage of tax-free shopping at the numerous boutiques, gift shops, and outlet malls in the area, making it a paradise for shopaholics looking for great deals on everything from clothing to home decor.Experience the ultimate beach lifestyle in Fenwick Island, Delaware, with this charming 3-bedroom, 2-bathroom condo. Whether you're seeking a permanent residence, a vacation getaway, or an investment opportunity, this coastal retreat is sure to exceed your expectations. Don't miss your chance to make seaside living a reality!
MlsNumber: --


Listing Provided By: Salisbury, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Andrew L McBride
Disclaimer: Copyright © 2024 Long & Foster Real Estate. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App