Title Page Background
DEBUG FN args: Array ( [0] => 3382 [1] => [2] => [3] => agent ) BEFORE: Site: 3382 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3382 Igate: njhud LocID: 3382 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 = 3382 AND i.igate IN ('mnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3382 [1] => [2] => [3] => lender ) BEFORE: Site: 3382 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3382 Igate: njhud LocID: 3382 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 = 3382 AND i.igate IN ('mnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3382 [1] => [2] => [3] => other ) BEFORE: Site: 3382 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3382 Igate: njhud LocID: 3382 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 = 3382 AND i.igate IN ('mnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

288 Sweeping Mist Circle
Frederica, DE 19946

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 4
Baths:
Status: Active
SqFt: 2291 Square Feet
Agency: Keller Williams Realty Central-Delaware

Map Details Show Map | Show StreetView




House Features

Architectural Style: Colonial
Construction Materials: Vinyl Siding
Cooling: Central A/C
Heating: Central Furnace
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Parking Features: Driveway

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Dickinson Creek

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Welcome to the vibrant community of Dickinson Creek! This 4-bed, 2.5-bath home offers an array of features that cater to your lifestyle needs. Upon entering, you'll be greeted by luxurious LVP floors that seamlessly flow throughout the downstairs. The flexible front room can be transformed into a formal dining area, a cozy sitting space, or a lively playroom—whatever suits your needs.<br /> <br /> The open floor plan promotes togetherness while providing ample space for relaxation and entertainment. The expansive living room accommodates various styles and functions perfectly for gatherings of any size. The kitchen is a culinary dream, equipped with stainless steel appliances, a gas stove, 42-inch kitchen cabinets, sleek corian countertops, and a generously sized pantry—ideal for whipping up your favorite dishes or baking that delightful banana bread.<br /> <br /> Ascending the stairs, you'll discover generously sized bedrooms and a spacious hallway that exudes comfort and tranquility. The primary bedroom is a sanctuary in itself, featuring a palatial walk-in closet and a lavish ensuite bathroom with both a walk-in shower and a indulgent soaker tub—perfect for unwinding after a long day.<br /> <br /> Step outside onto the recently installed deck and into the serenity of the private wooded backyard—a haven for relaxation and outdoor enjoyment. Dickinson Creek is more than just a neighborhood; it's a vibrant community that caters to all stages of life. Don't miss your chance to be a part of this exceptional community—schedule a showing today!
MlsNumber: --


Listing Provided By: Keller Williams Realty Central-Delaware, original listing
Phone: (302) 677-0020
Office Phone: (302) 677-0020
Agent Name: Adam D'Alessandro
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => kent-south [3] => DE [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: kent-south State: DE Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: kent-south State: DE 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 = 3382 AND i.igate IN ('mnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Jackie McMaster
Jackie McMaster
ASCIIWeichert Realtors Beach Bound
Call Today!: (703) 727-6302

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App