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 = 1192 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1192 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1192 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

2828 Haddington Court
Adamstown, MD 21710

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $775,000
Beds: 5
Baths: 6
Status: Pending
SqFt: 3812
Agency: T. F. Sarelas Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: Be prepared to be Wow-ed! This home will check "all the boxes"! Featuring the nearly 6,000 square feet, "Worthington" model by Ausherman Homes. The Worthington is the largest and most desirable home in the subdivision featuring 5 bedrooms and 4 full and 2 half baths. From the moment you approach the property, at the top of a quiet cul-de-sac, the welcoming front porch beckons you in. As you enter this dramatic center hall transitional colonial you will be impressed with the sunlit foyer, sweeping staircase and gleaming hardwood floors that grace part of the main level. Not to mention the large formal living room with built-ins and the banquet sized dining room with hardwood floors. The impressive gourmet kitchen will delight the chef in you! Featuring New GE double wall ovens, New GE cooktop with downdraft, recent GE French door refrigerator, nearly new GE dishwasher, 42 " maple cabinetry, new quartz counters, new deep rectangular sink and faucet with separate purified water faucet, extra-large island and a breakfast bar, convenient work desk and a step-down family room with soaring ceilings and a brick masonry wood burning fireplace. Beyond the kitchen is a sunny breakfast room the opens up to a new deck with stairs. To complete this main level also features a king size bedroom with full bath ensuite, perfect for in-laws, an au pair or home office. Don't miss the mud/laundry room with closet, new utility sink cabinet, 2nd powder room and door to the newly painted 2 car garage. The curved staircase leads you to the bedroom level where you will find a luxurious owners bedroom suite complete with new plank flooring, ceiling fan w/light, sitting area, and a huge walk-in closet. The suite includes a spacious bath with jacuzzi tub, separate new ceramic shower, double sinks and vanity and toilet closet. You are sure to be pleased with the size of the three additional bedrooms. Each featuring brand-new, easy-care plank flooring and large wall closets. Bedrooms three, four and five are conveniently located near the sparkling "Jack & Jill" hall bath with double bowl sink, linen closet and tub/shower. You will fall in love with the spacious bedroom level laundry/craft room -- Yes! The fully finished, walk out lower level is truly unbelievable, with new board plank flooring and plenty of room to entertain friends and family. Whether playing a game of pool (yes, plenty of room to bring your own pool table) or sitting at the custom-built bar enjoying drinks and snacks, you will be impressed! There is also an exercise/ home office room, full bath with dual pedestal sinks, & shower, and a theater room ready to be installed with your super large screen. The home is perfectly positioned on more than 1/2 acre beautifully landscaped lot with a newly built deck overlooking the stone patio with firepit, stone walkway, double door shed and private fenced in rear yard. Honestly, this may be the best lot in the neighborhood! To help offset energy bills, the home has solar panel system. In addition, a whole house water filtration system. So many features and updates to mention here. The entire home has been painted with quality neutral paint (Benjamin Moore) throughout including all ceilings, walls and trim! Newly refinished hardwood flooring, new vinyl plank, and new carpet. Green Hill Manor is a sought-after community offering access to adjacent parks, schools and an old timey downtown grocery store. All within the great commuter location of Adamstown!
MlsNumber: MDFR2047310


Listing Provided By: T. F. Sarelas Company, original listing
Name: T. F. Sarelas Company
Phone: (301) 509-0307
Office Name: T. F. Sarelas Company
Office Phone: (301) 509-0307
Agent Name: Janet Flaherty
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 = 1192 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 Carolyn Hurwitz
Carolyn Hurwitz
ASCIICompass
Call Today!: (301) 706-8446

Local Mortgage Pro

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 = 1192 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 Heritage Mortgage
Heritage Mortgage
Call Today!: (410) 210-7468

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App