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

7409 White Plains Lane
Brandywine, MD 20613
Aaron Robinson with Keller Williams Preferred Properties, original listing - (240) 737-5000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $820,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5046 Square Feet
Agency: Keller Williams Preferred Properties
Agency Phone: (240) 737-5000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Back on Market (No fault of sellers)! All Offers Welcomed, Highly Motivated Seller! Feel free to reach out and schedule your tour today.<br /> This unique, 4 -level, stone-front traditional home, nestled on a 1/2 acre lot in the highly sought-after neighborhood of Lakeview at Brandywine, is ready for new owners. A charming entry welcomes you into a newly renovated foyer that leads to a beautifully remodeled kitchen. Adjacent to the kitchen is a freshly carpeted family room with a cozy fireplace on one side and a spacious dining and living room on the other. The main level also features 9-foot ceilings, enhanced by sunlight streaming through the rear sunroom, a secluded bonus room, a half bath, and a mud/laundry room accessible from the freshly epoxied side-entry garage.<br /> <br /> The open upper level includes 4 bedrooms and 2 bathrooms, including an en-suite and a spacious primary bedroom with a sitting room and an elegant bathroom. Additionally, this home boasts a loft and a full bathroom that can be used as a guest area or additional recreational space. Descending three stories from the loft, you’ll find a finished basement with an optional laundry room, a full bathroom, recreational space, and a state-of-the-art theater room designed to impress. In total, this home offers over 5000 square feet of interior living space with newly installed windows virtually throughout.<br /> <br /> The property also includes an attached deck and patio, perfect for outdoor gatherings, and is fenced with pristine vinyl. To top it off, the friendly neighborhood offers a community center, gym, park, pool, tennis courts, and walking trails surrounding lively ponds.
MlsNumber: --
ListingId: MDPG2118512


Listing Provided By: Keller Williams Preferred Properties, original listing
Phone: (240) 737-5000
Office Phone: (240) 737-5000
Agent Name: Aaron Robinson
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App