Title Page Background
DEBUG FN args: Array ( [0] => 3381 [1] => [2] => [3] => agent ) BEFORE: Site: 3381 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3381 Igate: njhud LocID: 3381 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 = 3381 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3381 [1] => [2] => [3] => lender ) BEFORE: Site: 3381 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3381 Igate: njhud LocID: 3381 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 = 3381 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3381 [1] => [2] => [3] => other ) BEFORE: Site: 3381 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3381 Igate: njhud LocID: 3381 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 = 3381 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

802 Chesapeake Court
Newark, DE 19702
Michele Colavecchi Lawless with RE/MAX Associates-Wilmington, original listing - (302) 477-3900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $837,500
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4300 Square Feet
Agency: RE/MAX Associates-Wilmington
Agency Phone: (302) 477-3900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: This spectacular home has it all with a perfect floor plan and all of the space you could dream of with over 4,300 sf, and it is in the Appoquinimink School District!!! As you enter this beautiful home, you will see a two-story open foyer with split staircase, hardwood flooring, crown molding, large formal Living Room and an adjoining Sun Room. The formal Dining Room with crown molding and chair rail is ready for your entertaining along with the awesome eat-in Kitchen with 42" cabinets, undercabinet lighting, built-in microwave, double stainless sinks, breakfast Bar, gas range, double oven, loads of cabinets and counter space, wine rack, dishwasher and beautiful hardwood flooring. The extended (4') two-story open Family Room has convenient Hunter Douglas remote blinds on the top six windows with remotes. This open and circular floor plan and adjoining Family Room and the Kitchen is perfect for parties and super convenient for every day living. There is a Florida Room with access to a huge deck and stunning inground pool with new liner 2021 and pool house. The convenient main floor Office/Play/Hobby Room is such a great feature to this home along with a Laundry Room with sink and Powder Room. The second level has an open Loft area which is perfect for reading or relaxing after a long day. Just wait until you see this grand Main Bedroom Suite with pillars, huge walk-in closet, separate rough-in plumbing for a water line for a coffee bar, separate Main Bedroom Retreat Room with access to the exterior deck. The Main Brm Bathroom has double sinks and vanities, jet tub, separate toilet room, double shower and ceramic tile floor. The remaining bedrooms are spacious with great closet space and a large main hall bathroom. The ready to finish basement has a separate exterior access and black box for exterior landscaping lighting. Some of the other fine features are: alarm system, three ring cameras, three-car garage with electric openers, 220 outlet in garage, two-zones for heating and central air conditioning systems all updated, new Aprilaire steam humidifier 2025, ceiling fans, updated new windows in the back of this home along with the garage and sun room all in 2021 and the list goes on an on!!!
MlsNumber: --
ListingId: DENC2076696


Listing Provided By: RE/MAX Associates-Wilmington, original listing
Phone: (302) 764-2055
Office Phone: (302) 477-3900
Agent Name: Michele Colavecchi Lawless
Disclaimer: Copyright © 2025 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] => new-castle-newark [3] => DE [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: new-castle-newark State: DE Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: new-castle-newark 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 = 3381 AND i.igate IN ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sabri Thompson
Sabri Thompson
ASCIIThompson Realty Group
Call Today!: (302) 561-1717

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App