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 = 317 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 = 317 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 = 317 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;

157 Raven Circle
Camden Wyoming, DE 19934
Ken Pennington with Century 21 Harrington Realty, Inc, original listing - (302) 736-0800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $685,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3753 Square Feet
Agency: Century 21 Harrington Realty, Inc
Agency Phone: (302) 736-0800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Welcome to 157 Raven Circle where luxury abounds in this custom designed home in one of the most prestigious neighborhoods in Kent County, The Village at Wild Quail. Can true quality and luxury really exist in a home today? Yes, in this custom quality built contemporary home in the Caesar Rodney School District. It majestically sits across the street from the 5th fairway of Wild Quail Championship Golf Course, on a .83-acre elevated lot with beautiful Bradford pear trees on each side of the driveway up to the oversized side entry garage with extra built-in storage and an extra space for your Golf Cart! Let me start by saying everything in this home has been updated and/or replaced since they purchased in 2017 and most have been done in the last couple years, including new flooring (24"x12" tiles, and grey LVP) in the whole house, except for the main level beautiful Brazilian Cherry Floors, new light fixtures (add added more), new S.S. appliances, new quartz countertops and Stainless Farmhouse Sink, all new antique bronze lever doorknobs, fresh paint, new HVAC Systems, Upgraded to Tankless Hot Water Heater, new raised toilets. Hopefully I didn't miss anything except for the HUGE 24' X 45' inground saltwater pool (new filter) which we will talk about later. "Staycations" is all you need owning this move-in ready home. With a huge Living/Family room with doubled sided open F.P. (with tile surround) which you can also enjoy in the Sun/Florida Room (with new skylights and ceiling fans), or opt to heat with the new pellet stove in the winter while enjoying the views of the landscaped backyard, the 24'X45" in-ground pool, with new liner, diving board and new slide, tree lined sitting area, and the largest KOI pond & waterfall I have ever seen, enjoying the 3-Season Room complete with tinted tracked vinyl windows and a porch swing, or working on hobbies and crafts in the large 36'X13' Bonus Room (with renovated full bath) over the garage with 2 entrances.... Why would you want to go anywhere? As you walk up the exposed aggregate sidewalk to the brick steps and step through the custom front door, it's WOW Factors everywhere! This floor has a decorative Medalion inlay, and looking up you will see the oak railing on the second floor and some of the custom 2 story Coffer Ceiling which extends into the Living Room. The Brazilian Cherry flooring with inlays is in most of the first-floor rooms with exceptions of the 24"X12" new tiled Kitchen & Florida/Sunroom. The 2-story open L.R. floor plan allows an abundance of natural lighting. The kitchen has all new S.S. Appliances, new quartz countertops, new S.S. farm sink, tiled backsplash, newly painted cabinets. under cabinet lights. There is also a formal D.R. with bay window, and an office (or 5th B.R.) with bay window on the first floor as well as the laundry room with front loading W&D that convey. Also, a utility sink and the controls for the irrigation system are in a closet in this room. The primary B.R. is just down the hall. Has a walk-in closet with pocket door. There is also an atrium door that opens to the Florida/Sunroom and an entrance to the primary custom bath with vaulted ceiling, custom triangle windows, soaking tub, his and her cabinet sinks, walk-in shower with glass door, raised toilet with bi-det, and heated tile flooring. OK, running out of space so just make an appt to see what the upstairs is all about. Upstairs can be accessed by the living room stairway or the solid oak 46" wide stairway off the kitchen area. The walk-in closet off the Bonus Room connects to the walk-in closet off the BR that is now used as another sitting/treadmill room where she spends quiet time with the "kitties". *FYI - Seller will not certify the Septic. They will sell via signing the same docs when they purchased from previous owner in 2017. Septic was Inspected and Pumped in May of this year. This home is completely "Move-In Ready". Seller's moving to Retirement Community.
MlsNumber: --
ListingId: DEKT2031518


Listing Provided By: Century 21 Harrington Realty, Inc, original listing
Phone: (302) 346-4271
Office Phone: (302) 736-0800
Agent Name: Ken Pennington
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 = 317 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 Anthony Lapinsky
Anthony Lapinsky
ASCIIOlson Realty
Call Today!: (302) 399-0546

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App