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;

37257 E Stoney Run
Selbyville, DE 19975
TREVOR A. CLARK with 1ST CHOICE PROPERTIES LLC, original listing - (302) 257-5555

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,300,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 4986 Square Feet
Agency: 1ST CHOICE PROPERTIES LLC
Agency Phone: (302) 257-5555

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Built like a castle this home features an open-concept design that provides an illuminated atmosphere throughout. This home has Insulated Concrete Form (ICF) walls which consist of outer layers of foam then concrete and re-bar fill the interior of the interlocking foam system. The exterior walls are a foot thick. This is more than just a construction choice; it's an exceptionally sturdy and sustainable investment for lifelong safety and resilience. The walls offer better insulation (stay warm in winters, cool in summers), fire resistance (increased safety for you and your investment against fire hazards), noise reduction (say goodbye to the groaning noise of passing vehicles or your neighbor’s party) and pest resistance (a safe barrier against annoying pests and rodents). ICF walls showcase structural integrity like none other. This home consists of. 5BD and 4.5 baths. The gourmet kitchen on the main level features stainless-steel appliances, a double oven and two garbage disposals. The kitchen island has additional outlets for all small appliances, such as a toaster, blender, food processor, and more. The nook in the kitchen gives you the chance to follow a recipe from your computer, write down your very own recipes or plan for the week ahead. To amplify the exquisite feeling, you will find Cambria (quartz) countertops in the kitchen and bathrooms. The home was built with a very spacious elevator that will facilitate access to the upstairs / downstairs. Upstairs is a spacious loft with a kitchen and four oversized bedrooms. The kitchen in the loft also has upgraded appliances including a built-in microwave. The house has a wine fridge that will stay so that you can enjoy the finest wines and bubbly with your guests. This house is great for entertainment and sleeps at least 14 people while maintaining their privacy and comfort! Step into the foyer and enjoy the shiny bamboo flooring and freshly cleaned organic carpet. The main level includes an office, a master suite with a sunroom, an extensive laundry room with a full bath, a kitchen, and a living room.The spacious master bedroom offers a walk-in closet and a fireplace and a great view of the canal and creek, perfect for a peaceful night's sleep. The bathrooms offer walk-in showers with safety bars and comfort-height toilets. Also on the premises, a soaking tub will help you relax. The ample storage space throughout the house is remarkable. It should not go unnoticed that the tile in the foyer, laundry room, sunroom and all the bathrooms have their own thermostats, so you don’t have to stand on cold tile during the winter months. The property features two decks with lights and multiple sitting areas to make it even more perfect. You can sit in your boat and access the bay. This property also includes a free-floating kayak dock and a boat dock that was renovated in the spring of 2022. Catch crabs off the dock! The gazebo, which is perfect for entertaining guests, has a fold-down bar at the front. There is a raised bed located at the back of the house for the ones who like to grow their own herbs or flowers. Nothing is missing inside and out, come see for yourself!!! There is an assumable mortgage of around $600,000 with 2.75% interest. The house is located on a very calm and quiet cul-de-sac and offers plenty of privacy. The HOA fee is just $440 a year and the community features: a clubhouse, outdoor pool, shuffleboard court and a boat ramp.
MlsNumber: --
ListingId: DESU2067298


Listing Provided By: 1ST CHOICE PROPERTIES LLC, original listing
Phone: (302) 257-5555
Office Phone: (302) 257-5555
Agent Name: TREVOR A. CLARK
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