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

33 Seldon Drive
Smyrna, DE 19977

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3268 Square Feet
Agency: Keller Williams Real Estate - Newark
Agency Phone: (302) 738-2300

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Garbage Disposer, Range - Electric
Architectural Style: Colonial
Construction Materials: Vinyl Siding, Stone
Cooling: Central A/C
Heating: Forced Air
Interior Features: Walk-in Closet(s), Breakfast Area, Formal/Separate Dining Room, Kitchen - Eat-in, Primary Bath(s), Upgraded Countertops
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Parking Features: Driveway
Property Condition: New Construction

Neighborhood/Schools

Elementary School/District: Sunnyside
Middle/Junior High School/District:
High School/District: Smyrna
Subvidision Name: Greene Hill Farm Est

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Eden model- TO BE BUILT. Visit our award-winning Eden model. <br /> <br /> Our most popular floorplan! This floorplan offers 4 Large Bedrooms and 2 ½ Baths. The main bedroom features 2 Walk-In Closets, Sitting Room, Large Owner's Bath with 5' Walk-In Shower and Double Bowl Vanity. Soaking Tub and Freestanding Tub options are available. <br /> <br /> The main level includes Formal Dining Room, Formal Living Room, Study and Laundry Room. The Kitchen features 42" Maple Cabinets by Century Kitchens, 7' Island, Granite Countertops and Stainless Appliances flows into the Breakfast Area and is open to the Family Room. You can add a Sunroom off the Kitchen/Breakfast Area giving you even more space to entertain. This home offers an option for a First Floor In-Law Suite with Private Bath. <br /> <br /> Have an extra vehicle or motorcycle? 3 Car-Garage option is available. The Basement gives you the opportunity to finish it as you like. Need a home gym? Rec room to watch the game with your friends? A spot for the kids to hang out with their friends? You could do all that and more in this large Basement. <br /> <br /> All homes in Greene Hill Farm Estates are on Half Acre+ sites, Public Sewer, Public Water and Natural Gas.<br /> <br /> Please see Community Sales Manager for details. Agent must accompany buyer on first visit or pre-register on builder website.
MlsNumber: --
ListingId: 1000364983


Listing Provided By: Keller Williams Real Estate - Newark, original listing
Phone: (302) 293-1148
Office Phone: (302) 738-2300
Agent Name: Irene Blair
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => bath [3] => KY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: bath State: KY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: bath State: KY 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 = 1003 AND i.igate IN ('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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App