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 = 319 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 = 319 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 = 319 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;

6824 Robin Drive
Seaford, DE 19973
Judy Rhodes with Century 21 Home Team Realty, original listing - (302) 645-1260

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $482,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3066 Square Feet
Agency: Century 21 Home Team Realty
Agency Phone: (302) 645-1260

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Every. Single. Surface. Touched!! That's right—this home has undergone a fabulous makeover. It was a great house before, but now that it's been repaired, refreshed, and rejuvenated, it's even better! This fabulously large home boasts four bedrooms, all upstairs, and two and one-half bathrooms, a brand-new eat-in kitchen, a large living room, and a formal dining room, both with crown molding, a family room with a double-sided fireplace, a screened porch with a ceiling fan, a front porch, an oversized garage, and a HUGE Bonus room! Sincerely, you'll have room for everyone and everything! <br /> The home has an encapsulated crawl space, an updated gravity-fed septic system, geothermal heat, and a new hot water heater. It also has new stainless Steel Kitchen appliances, new countertops and cabinets, and all-new flooring throughout the 3066 square feet that make up this home. The Bonus room upstairs over the garage offers SO MUCH SPACE, and the room could be so many things: an office (with two built-in bookcases!), a playroom (use the shelving for toys), or make it a "man-cave" or a "She Space"! Or divide the room to make two spaces! Or, if nothing else, it's terrific storage space... and who doesn't need more of that? There is a PERMANENT SET OF STAIRS to the partially floored attic (approximately 60% is floored), and it has a fan for temperature control. The garage was revamped with new wood on the back wall, painted throughout, and a new garage door opener with remotes. Outside, a new sidewalk and lamppost, fencing, trees, and overgrowth were removed, and grass seed is growing now! <br /> Located within the well-established development west of Seaford known as Atlanta Estates, this corner lot is near the entrance, making coming and going super easy. With .40 acres, it's the perfect size yard to take care of. See the septic location on the map in the Attachments Section, where you'll also find all the disclosures. Enjoy the beauty of Western Sussex County and love where you live!
MlsNumber: --
ListingId: DESU2064026


Listing Provided By: Century 21 Home Team Realty, original listing
Phone: (800) 447-7711
Office Phone: (302) 645-1260
Agent Name: Judy Rhodes
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 = 319 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