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;

1504 N Edgewater House Rd #ph04n
Bethany Beach, DE 19930
Leslie Kopp with Bethany, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,399,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: --
Agency: Bethany
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential Common Interest-Condominium
Year Built: 1975
Notes: Simply Stunning! 1504 N. Edgewater House (PH04N) is now being offered to entice the most discerning beach lover who yearns for a spectacular, oceanfront oasis. This stunning penthouse offers the largest 2 bedroom/2 bath floor plan in Sea Colony East and will astound you with its expansive Atlantic Ocean views. This coastal beauty has been remodeled throughout boasting a beautiful seashore pallet, marble patterned tile flooring, and an open kitchen with an oversized island, breakfast bar, white Kraftmaid cabinetry topped with gorgeous neutral Quartz and diagonal backsplash. Stainless steel appliances with attractive cabinet front refrigerator/freezer and dishwasher add class to this amazing kitchen that also features a wine cooler and large storage closet. Feast in the expansive dining area while listening to the ""Story & Clark""� Player Piano! This unique floorplan enables the Living Room to provide open entertaining space while the custom dividing blind allows privacy for sleepover summer guests on the unique Murphy bed that doubles as a desk when not in use! The oceanfront sliders are adorned with custom Hunter Douglas floor to ceiling blinds to allow the beautiful eastern sunlight exposure to fill this incredible beach condominium. Relax on the oversized ocean front balcony after your day at the beach while listening to the waves and seagulls sing. The primary en-suite will dazzle you with the renovated full bath, walk-in shower with marble floor to ceiling tile, multi head shower system, quartz topped vanity, beautiful tile flooring and even a self-cleaning commode! Large walk-in closet offers built-in organizer shelving. When night falls, escape to watch the moon rise on the ocean front balcony through private bedroom slider. Spacious guest bedroom is perfect for multiple visitors accented with fun bunkbeds and a queen. The guest bedroom shares the upgraded hall bath with tub and is decorated with a large vanity and Italian ceramic wash basin. This exquisite ocean front beach house is turn-key and being offered fully furnished. Trane forced air system installed in 2016. Walk the oceanfront promenade to 5 outdoor heated pools and separate kiddie pools. The indoor pool, whirlpool, sauna, and expanded fitness area are unique to the Edgewater House. Prime location close to downtown Bethany Beach. World class amenities include a half-mile of lifeguarded private beach, USTA Award Winning Tennis with an indoor championship tennis center and outdoor tennis courts, 17,000 sq ft fitness center, and indoor/outdoor lap pools. Beach living doesn't get any better than this! Call to schedule your private tour today!
MlsNumber: --
ListingId: DESU2070578


Listing Provided By: Bethany, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Leslie Kopp
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.


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