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

506 Overlook Park Drive
Oxon Hill, MD 20745
Stacy Delisle with IMPACT Maryland Real Estate, original listing - (240) 815-0890

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,997
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3369 Square Feet
Agency: IMPACT Maryland Real Estate
Agency Phone: (240) 815-0890

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2012
Notes: Renowned designer Coco Chanel once said, “In order to be irreplaceable, one must always be different.” <br /> <br /> Welcome home to 506 Overlook Park Drive in the prestigious Potomac Overlook community… a rare gem featuring unparalleled design and finishes, catered to the most refined taste. It, truly, is one of its kind.<br /> <br /> Situated within a gated community, facing green space, and with panoramic views of the National Harbor and DC skyline, you’ll be dazzled by all four finished levels of this incredible home. <br /> <br /> As you step inside and make your way to the main living level, you’ll be immediately impressed by the Brazillian Koa hardwood floors, designer-inspired paint and light fixtures, and the flexibility of the floorplan. Large windows flood the home with natural light and provide incredible views! Upgraded throughout, the kitchen is the perfect place to prepare a home-cooked meal, and is sure to satisfy the most savvy of chefs. State-of-the-art stainless steel appliances… including double wall ovens and upgraded refrigerator… a large island, and plenty of cabinetry make this kitchen a true masterpiece. Tucked inside this space is room for a table, perfect for entertaining a crowd or enjoying a more intimate meal.Opposite the kitchen sits a large family room/dining area. The custom accent wall and light fixtures add a touch of flair to this space, bringing a uniqueness that’s sure to shine! <br /> <br /> Heading up one level, discover a primary suite that has it all! Custom paint, spa-like bathroom featuring both a soaking tub and a shower, a walk-in closet with a full Elfa closet system… this has it all to make elevated living a breeze! Tucked down the hall is a laundry closet with a front loading washer and dryer. At the end of the hall, opposite the primary suite, awaits a tastefully appointed secondary bedroom with an ensuite bath. <br /> <br /> The upper level is the peak of perfection in this home! A full wet bar featuring built ins, sink, dishwasher, and fridge… a double sided fireplace… and a rooftop terrace with jaw dropping views of National Harbor and the Washington, DC skyline (even the Washington Monument!). An additional bedroom with ensuite bath completes this level, making it the perfect space for overnight guests.<br /> <br /> On the lower level, on-trend slate flooring abounds throughout a bright home office and hall bath. The rear-loading attached garage offers added convenience to keep cars out of the elements and making parking a breeze. Additional added features throughout the home include Sonos music system throughout the home (including the rooftop deck!), garage ceiling storage racks, and a home security system. <br /> <br /> Situated in the heart of National Harbor, with just a short walk to shops, restaurants, entertainment, exploring the Potomac River and more… yet a peaceful retreat in a gated community when you want a more relaxed atmosphere. Truly the best of both worlds wrapped into one irreplaceable gem. Welcome to 506 Overlook Park Drive… welcome HOME!
MlsNumber: --
ListingId: MDPG2137086


Listing Provided By: IMPACT Maryland Real Estate, original listing
Phone: (240) 815-0890
Office Phone: (240) 815-0890
Agent Name: Stacy Delisle
Disclaimer: Copyright © 2025 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 = 3451 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 Karen Kennard
Karen Kennard
ASCIIeXp Realty
Call Today!: (972) 281-9986

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App