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;

34962 Royal Troon Cir
Dagsboro, DE 19939
Allison Stine with Northrop - Bethany, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: --
Agency: Northrop - Bethany
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Blending the perfect balance of Nantucket design and contemporary style, this custom-built luxury residence in the Cripple Creek Golf and Country Club community is a true masterpiece. Constructed with quality and featuring awe-inspiring amenities, this home is thoughtfully designed to maximize the stunning panoramic views of the community and Indian River Bay. This extraordinary property spans three levels, offering endless lifestyle options, making it a spectacular place for family and friends to gather. Inside, superior craftsmanship is evident with architectural millwork detailing, hardwood flooring, featured lighting, and perfectly designed gathering spaces that epitomize coastal living. The two-story great room, with its open-plan design, is anchored by a stone fireplace and wrapped in picture windows topped by clerestory windows and atrium doors. This bathes the main level living space in natural light and magnificent views, inviting you to explore the expansive wrap-around deck for glorious sunrise or sunset views. The seamless flow continues into the gourmet kitchen, featuring a center island with a sink, dishwasher, and breakfast bar, highlighted by recessed and pendant lighting. Rich sienna-colored, custom-built cabinetry, granite countertops, and a suite of stainless-steel appliances complete this chef's kitchen. Dining options abound, whether it's a casual meal in the breakfast nook, a dinner party in the formal dining room, a summertime cook-out on the adjacent deck, or a quiet coffee in the formal living room. The main level also includes a convenient laundry room with pantry storage, garage access, and a perfect powder bath off the foyer. The luxurious main level primary bedroom suite offers a fireplace, sitting area, and a spa-like bath with a dual sink vanity, glass stall shower, soaking tub, and private water closet. A winding stair off the foyer ascends to the upper-level loft, which offers its own gathering space or office area beneath the soaring great room ceiling, perfect for catching up on emails or relaxing. The upper-level features four elegantly appointed bedrooms, two full baths, and awe-inspiring balconies that offer magnificent views from sunrise to sunset. The fully finished, walk-out lower level boasts high ceilings, full daylight, and an exceptional space plan. This level includes a large family/recreation room, expansive media room, the home's sixth bedroom guest space or in-law suite, an exercise room or office, and a full bath, completing the thoughtful design. Outside, the opportunities are endless: golf, club amenities, exploring the coastline and Holts Landing State Park, kayaking, paddle-boarding, clam-digging, fishing, or venturing onto the bay to dine at local establishments. Membership to the Cripple Creek Golf and Country Club is included in the sale. Don't wait-opportunities like this don't last. Live your best life in this gorgeous home on the Delmarva Peninsula, where every age will enjoy bountiful adventures!
MlsNumber: --
ListingId: DESU2067174


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