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

2849 Patricia Drive
Waldorf, MD 20603
Lisa Johnson with Cook Real Estate Brokerage, original listing - (410) 849-9008

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,159,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 5020 Square Feet
Agency: Cook Real Estate Brokerage
Agency Phone: (410) 849-9008

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Nestled in the sought-after Friendship Estate community, this custom home was designed and built by Forrest Builders, owner Bill Brozey, with thoughtful upgrades for added space and functionality. <br /> Located at the end of a culdesac , this house offers a large circular driveway. It is set on a nicely landscaped 2 -acre estate, with multiple out buildings including a 2 unit guesthouse. This estate home has a complete brick exterior with a large cathedral open front porch and open rear porch that extends across most of the house. On the main floor this home offers a wing including cathedral ceiling master bedroom with an attached office , 2 walk in closets and a master bathroom that boast 2 lavatory rooms, a double vanity, a shower and a large jetted tub. This wing has it's own heat pump with back up oil fire furnance and it's own hot water tank. The main floor also has a living room with a wood burning fire place, a family room with a wood burning fire place, a formal dining room, a large foyer with cathedral ceilings, and a large breakfast room. The kitchen, located on the main floor, offers new granite counter tops, a large kitchen island, new GE profile 5 burner cook top, new dishwasher, new double wall oven, new second oven with a microwave on top, new refrigerator, floor to ceiling cabinetry, and walk in pantry. There is a full bathroom and laundry room off the kitchen as well. The second floor offers 4 nice size bedrooms, a family room, as well as two full bathrooms. The 2 car side load garage offers a conditioned bonus room with multiple heat sources including a mini split system for heating and air and an electric base board. The 2,948 sq foot unfinished basement is there for the homeowners imagination. The house includes a poured 12 inch foundation with an additional basement wrap installation. Each 2 story guest house unit, with a quaint front porch, includes 1 bedroom, a full bath, kitchen, living room, its own hot water tank, its own heat pump and its own electric panel. It has its own parking and storage shed.
MlsNumber: --
ListingId: MDCH2037568


Listing Provided By: Cook Real Estate Brokerage, original listing
Phone: (410) 849-9008
Office Phone: (410) 849-9008
Agent Name: Lisa Johnson
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 = 1190 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;
Brian Crayton
ASCIICENTURY 21 Envision
Call Today!: (240) 473-3426

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App