Title Page Background
DEBUG FN args: Array ( [0] => 318 [1] => [2] => [3] => agent ) BEFORE: Site: 318 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 318 Igate: njhud LocID: 318 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 318 AND i.igate IN ('dehud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 318 [1] => [2] => [3] => lender ) BEFORE: Site: 318 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 318 Igate: njhud LocID: 318 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 318 AND i.igate IN ('dehud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 318 [1] => [2] => [3] => other ) BEFORE: Site: 318 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 318 Igate: njhud LocID: 318 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 318 AND i.igate IN ('dehud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1702 N Park Dr #25
Wilmington, DE 19806

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $945,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: --
Agency: Greenville

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Construction Materials: Stucco
Cooling: Central A/C
Flooring: Tile, Wood, Hardwood, Tile - Ceramic
Heating: Heat Pump
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Parking Features: Garage, Garage - Attached

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: The Pointe

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential Common Interest-Condominium
Year Built: 2009
Notes: Stunning doesn't accurately describe this exceptional 3-bedroom, 3-bathroom luxury condo in The Pointe! A private, gated community ideally situated on the banks of the Brandywine River, The Pointe is the definition of luxury living. A semi-private elevator takes you to a beautifully appointed private foyer. Inside you are immediately welcomed by gleaming hardwood floors, detailed moldings and an open floor plan. The wall-to-wall windows and sliding glass doors provide a stunning view overlooking the pool, Brandywine River and wooded views of parkland. A large private balcony is truly an extension of the home. The open floor plan features a large living room with electric fireplace and built-in bookshelves. Adjacent to the living room is a beautiful dining area and custom kitchen. The kitchen features custom Paradise Cabinets, SubZero refrigerator, Bosch dishwasher, Elkay undermount sink, Wolf wall oven, cook-top, range hood & microwave. A butler's pantry/laundry area offers additional cabinetry, a double Summit wine refrigerator and washer/dryer. The primary suite is beautifully appointed with a 2nd private balcony, a spacious bathroom with Paradise cabinetry, a custom tiled floor, dual sink vanity, tiled shower with frameless glass shower door, a separate soaking tub plus a large walk-in closet outfitted by Closets by Design. There are 2 additional bedrooms and bathrooms with the 2nd bedroom featuring an en-suite bathroom with grass cloth wall paper, a stall shower and high end fixtures. The 3rd bedroom is beautifully appointed and currently being used as a home office with convenient access to the 3rd full bathroom. The Pointe amenities include concierge service, state of the art fitness center, game room, outdoor pool, 2 deeded parking spaces and 24-hour security. An ideal location close to downtown Wilmington offices and restaurants, the Brandywine Park with wooded trails, local museums and easy access to I-95 and Philadelphia! The Pointe is not within the City limits of Wilmington so there is no city wage tax or city real estate taxes.
MlsNumber: --


Listing Provided By: Greenville, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Cathleen Wilder
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => new-castle-wilmington [3] => DE [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: new-castle-wilmington State: DE Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: new-castle-wilmington State: DE Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 318 AND i.igate IN ('dehud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'dehud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sharon Stewart
Sharon Stewart
ASCIIeXp Realty
Call Today!: (302) 275-4291

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App