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;

129 Ayshire Drive
Middletown, DE 19709
Liz Page-Kramer with EXP Realty, LLC, original listing - (888) 543-4829

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $809,990
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4400 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 543-4829

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to Highlands at Back Creek- a small community of only 42 lots. All home sites are a minimum of 3/4 acre to a FULL ACRE. Are you tired of massive developments with no sense of community? This is the place for you;) Check out some of the many standard features- 9' first and second-floor ceilings, crown molding in the living room, dining room, foyer, and second-floor hallway. Shaw hardwood flooring in the foyer, kitchen, dining room, and powder room. Ceramic tile in all full baths and mudroom. Gourmet kitchen with granite countertops, stainless steel appliances, double wall oven, microwave, separate cooktop, and dishwasher. Side entry 3- CAR GARAGE with a garage door opener. Energy-efficient HVAC- LENNOX furnace, LENNOX 14 seer central air conditioning, wifi-thermostat, and Low-E Argon windows.<br /> The Philadelphian Grand is the newest floor plan added to the lineup of stunning homes. BIG and BEAUTIFUL with 4400 sq. ft of living space. This doesn't include a finished basement or any bump-outs. Please note that the square footage is ONLY on the 1st and 2nd floors. The rooms are MASSIVE!!! The front staircase splits the living room and dining room. Everyone loves an open floor plan, and this house doesn't disappoint. The family room is centered in the rear of the house with a marble surround fireplace surrounded by massive windows that make this area bright and sunny. A study is located next to the family room. The mudroom, located off the garage, is a perfect place to add additional built-ins for coats, shoes, book bags, etc. On the second floor are two bedrooms with a Jack and Jill bath and a PRINCESS suite with a full bath and walk-in closet.<br /> Double doors lead to the Owner's Suite, complete with a sitting area, 2 WALK-IN closets, and a DRESSING AREA. The Owner's bath has split vanities, a garden tub, and a large shower. The laundry room with a handy laundry tub is also on this level. There is a long list of STANDARD FEATURES that you'd be hard-pressed to find anywhere else. This community is conveniently located near all main roads, Chesapeake City, and hospitals. It's also located in the award-winning Appoquinimink School District. Use 1500 Bohemia Mill Rd. Middletown for GPS. This is the base price of a to-be-built Philadelphian Grand. HOA has not been established yet. THIS IS A TO-BE-BUILT HOME. County, city, school taxes, assessment value, and square footage are approximate. For additional information about this to-be-built home, visit the model home at 129 Ayshire Dr. Middletown.
MlsNumber: --
ListingId: DENC2028198


Listing Provided By: EXP Realty, LLC, original listing
Phone: (302) 354-6077
Office Phone: (888) 543-4829
Agent Name: Liz Page-Kramer
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;
Real Estate Expert Photo for Javia Campbell
Javia Campbell
ASCIICENTURY 21 Gold Key Realty
Call Today!: (302) 383-4337

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App