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;

804 Quinn Court
New Castle, DE 19720
Megan Aitken with Keller Williams Realty, original listing - (302) 360-0300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $930,000
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 4530 Square Feet
Agency: Keller Williams Realty
Agency Phone: (302) 360-0300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Welcome to 804 Quinn Ct, the dream home that's been waiting for you to call it yours. Located in the luxury Toll Brothers community of Highpointe at St. Georges, this Ellsworth II model home is nestled on a quiet street and a large lot that is meticulously landscaped to accent the classic colonial exterior and brick skirting. The curb appeal is greatened by the welcoming front porch and modern black accents. Entering through the front door, the hardwood floors that greet you will exceed expectations, and the lovely dining room and office that flank the foyer are only a glimpse of the wonderful attributes this home offers. A grande and lavish staircase is the focal point of the two-story entry, with the catwalk from the hall above open to below. Notice a main floor flex space, currently being used as the perfect playroom, on your left with double doors before entering the enormous two-story family room. Your eye will immediately be drawn to the floor to ceiling stone fireplace that is flanked with a wall of windows that allow natural light to flow through the home, and a stunning chandelier that elevates the space. In the kitchen, functionality meets aesthetic design, with stunning white cabinetry with crown molding, custom tile backsplash, center island, built-in wall oven and microwave, modern black fixtures, and so much more. French doors lead to an enormous rear Trex deck with modern grey and black aesthetic, with steps down to the rear yard and playground - the perfect location for evening get togethers or coffee in the morning. Even the main floor laundry is custom designed, boasting tile flooring and half-wall large subway tile. Up the stunning staircase, you'll find stunning views of the main floor as you cross the landing to find a full hall bathroom with updated tile shower, double vanity, and its own linen closet. You will pass another generously sized bedroom as you head to the primary suite - and what a suite indeed. The sprawling room is complete with double doors, walk-in closets, and it's very own workout or bonus room directly off the primary bedroom. The attached full bathroom has been renovated to the nines, with stunning marble tile shower with built-in shelving for toiletries, glass enclosure, double vanity with updated fixtures and hardware, tiled corner tub, and the cherry on top of the already pristine bath - HEATED FLOORS! The living space doesn't stop there - you will find the finished basement of your DREAMS down two levels, where hardwood flooring, fireplace feature wall, custom doors, and moody grey paint create a cozy modern space for your family to enjoy as a game room, man cave, gathering space - the possibilities are endless. The basement has it's own powder room with board and batten trim. Behind a custom TRACKLESS sliding door, a top of the line theater room with a built-in wet bar with sink and wine fridge, granite countertops, built-in and backlit wine storage, and tray ceiling detail that is also backlit to create the ambiance one would expect from a theater of this significance. Even with all of the expansive living space, the basement offers plenty of storage - also fit with hardwood flooring! The owned solar panels offer immense value, keeping your monthly utility costs significantly lower than most, and the irrigation in the yard keeps the lawn looking top quality. Every inch of this home has been customized and the design so carefully curated, you will be hard-pressed to find a home quite like this one, and the community full of amenities like large community pool, clubhouse, and fitness center make this incredibly sweet opportunity that much sweeter. Schedule your tour today!
MlsNumber: --
ListingId: DENC2068148


Listing Provided By: Keller Williams Realty, original listing
Phone: (302) 360-0300
Office Phone: (302) 360-0300
Agent Name: Megan Aitken
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