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

24 Lakewood Circle
Newark, DE 19711
Frank Panunto with EXP Realty, LLC, original listing - (888) 543-4829

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $755,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 4350 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 543-4829

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: This custom built contemporary home is situated on a 1.1 acre picturesque wooded lot with a stream creating stunning sight lines from anywhere in and out of the house. This home features stunning architectural finishes with an open floor plan that includes beautiful custom staircases, Cathedral Ceilings, Skylights, French Doors W/ Paladian Windows , a loft and so much more. The 5-bedroom, 3.5-bath house was designed by Hillcrest with over 4500 square feet of luxurious living. The main floor features a huge living room surrounded by sliding doors that lead to multiple decks. The Living room has 10 foot ceilings, recessed lights, custom arched windows and a wood burning fireplace. The living room is completely visible from the kitchen as they share an oversized breakfast bar. The kitchen is beautifully done with tavertine tile floor, stainless appliances, wine refrigerator, granite counters, ceramic backsplash , undercabinet lighting and a huge picture window. Off of the kitchen is an incredible laundry room with extra storage closets. This is 1 of 2 different laundry areas in the house. There is a first floor owner's suite with vaulted ceilings, sliders to the owner's deck , 2 closets and a magnificent bathroom with marble finishes, double bowl sink, vanity area and tile finishes and walk n shower. The lower level has 3 very large bedrooms with crown molding , large closets and carpeting. There is another stunning full bathroom with double sink and shower and a craft room/ workshop with the second laundry area. The lower level also has a huge family room with high ceilings and sliders that walk out to the back yard. The upper floor has a great loft that can be used for a workout space, home office or another gathering space There is also another bedroom with a full bathroom located on the top floor. The outside is breathtaking. Multiple decks and patios. One deck on the ide of the house has a hot tub recessed in it. The private tree-lined driveway pulling in really gives it that feeling of something special . There is overflow parking space and a 2 car garage. This is a spectacular home!
MlsNumber: --
ListingId: DENC2065168


Listing Provided By: EXP Realty, LLC, original listing
Phone: (302) 598-0515
Office Phone: (888) 543-4829
Agent Name: Frank Panunto
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 = 3381 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;
JAMES JONES
ASCIIeXp Realty
Call Today!: (302) 559-4332

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App