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;

64 Kirkcaldy Lane
Middletown, DE 19709
Andrea Harrington with Compass, original listing - (302) 202-9855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $760,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 4500 Square Feet
Agency: Compass
Agency Phone: (302) 202-9855

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Impressive 5-Bedroom, 4-Bathroom Colonial located in the amenity-rich community of the Estates at St Annes. Newly built in 2016, this inviting home is situated in a prime location, in the heart of Middletown. Enter the home into the grand 2-story foyer where you will find a beautiful turned staircase and hardwood floors that flow throughout the majority of the first floor. French doors to your left lead to the private home office, filled with ample sunlight & accented with crown molding. To the right of the center hallway, you will find a formal dining room (currently used as a sitting room). Just through the foyer, you will find a spacious OPEN FLOORPLAN that encompasses the living room, kitchen, and morning room spaces. The living room boasts CATHEDRAL CEILINGS and a gas fireplace – a perfect setup for entertaining with family and friends. The gourmet kitchen features: Granite and Dolomite countertops, soft-close cabinets, an island, stainless steel appliances, a pantry, and tile backsplash. A sunlit “morning room” completes this area, with sliding glass doors leading out to the STAMPED CONCRETE PATIO and well-manicured backyard. The outdoor space offers an ideal setup for outdoor dining and relaxation. Back inside, a generously sized bedroom with a walk-in closet and jack-and-jill access to a full bath complete the main level – a wonderful option to be used as a guest bedroom, IN-LAW SUITE, or 1st floor master. As you make your way upstairs, you will find your private oasis in the primary suite, complete with a sitting area, two WALK-IN CLOSETS, and a 5-piece master bath boasting a walk-in shower, dual vanities and a large soaking tub. This level is rounded out with 3 more spacious bedrooms and a hall bath with double vanity. If you’re looking for more space, you will find it here in the expansive FINISHED BASEMENT. The basement boasts a large recreational room, a full bathroom and a storage room. Other notable features include: recessed lighting throughout, Ring Doorbell & Cameras included, 2-Car Garage, and more! The prestigious Golf Course Community of the Estates at St<br /> Anne's features many amenities, including: community pool (additional membership required), clubhouse,<br /> restaurant, walking trails, basketball courts, volleyball courts, playground & more! Located within the highly<br /> ranked APPOQUINIMINK SCHOOL DISTRICT & conveniently close to major route DE-301, for ease of<br /> commute. Don't wait, call to schedule your tour before it's too late!
MlsNumber: --
ListingId: DENC2067398


Listing Provided By: Compass, original listing
Phone: (302) 383-7575
Office Phone: (302) 202-9855
Agent Name: Andrea Harrington
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