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;

216 Shapley Drive
Smyrna, DE 19977
Shakita Boswell with Brokers Realty Group, LLC, original listing - (717) 554-7430

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4101 Square Feet
Agency: Brokers Realty Group, LLC
Agency Phone: (717) 554-7430

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: YOUR HEARTS DESIRE! This home is truly captivating inside and out. The landscaping is absolutely captivating, alot was done to promote privacy. The builders grade soil was replaced with 4" of mushroom soil and drought tolerant grass. The owners expanded the driveway which leads to the attached 3 car garage. The oversized driveway can now fit 6-8 car comfortably. The walkway to the home as well as the pillars at the entrance of the drive way were carefully crafted by PAVERS. The pillars and walkway light up in the evening, perfect for late nights. Now lets enter into this home and marvel at the 2 story entryway and a two way stair case that graces the center of the home. You will love the spacious rooms, gorgeous custom fixtures and high end finishes that this home offers throughout. The kitchen is complete with a tons of storage cabinets, a center island accented with custom pendant fixtures, granite counter tops and matching granite backsplash. The owners added a matching butlers pantry with a beverage center underneath a perfect finishing touch! You will love the bonus room on the first floor. It is currently used as an office but could easily be a guest or playroom. This room is situated right next to a gorgeous half bath with a vessel vanity sink, custom marble flooring and finishes. The family room boast with 2 story ceilings, a gas fire place and custom motorized blinds. Upstairs you will find 4 nice size bedrooms and a full hallway bathroom. The owners also installed additional recess lights in the hallways and the bedrooms. The hallway bathroom has a double vanity, granted counter tops and polished porcelain floors. The owners suite is its own separate oasis. It is complete with two separate walk in closets a sitting area, a custom built fireplace, double doors that lead to the luxury bath and two linen closets. The owners suite also consist of a soaking tub, oversized walk in shower with seating and polished porcelain floors. The laundry hook up is on the second floor, making laundry day more enjoyable. The basement expands the full length of the home. it is partially finished currently but it is waterproofed and framed for another bedroom and bathroom. plumbing hookups are already available. This is a walkout basement so there is access to the huge rear yard as well. The shed is included with the sale. The owners had this shed custom built to match the home. The electric box was updated and is still under a 10 year warranty with about 5 years left.
MlsNumber: --
ListingId: DEKT2030644


Listing Provided By: Brokers Realty Group, LLC, original listing
Phone: (717) 554-7430
Office Phone: (717) 554-7430
Agent Name: Shakita Boswell
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