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

6605 Osborne Hill Drive
Upper Marlboro, MD 20772
Staci L Mildenstein with Dehanas Real Estate Services, original listing - (301) 870-1717

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,000
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 8115 Square Feet
Agency: Dehanas Real Estate Services
Agency Phone: (301) 870-1717

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: LUXURY & LOCATION! Your retreat is located in the sought after, affluent Windsong Subdivision! You work hard, it's time to reap the rewards! Your new home offers almost 12,000 sq feet, with over 8,000 finish sq ft on 2 acres, set back off the main road, nestled in the trees. Beautifully manicured yard & custom landscaping welcome you to the exquisite French door entrance. As you step into grand foyer, you're greeted by stunning hardwood floors, 2 story ceilings, and the 1st of 3 staircases to the upper level. 2nd staircase accessed from kitch/family rm. Main level features a large library, dual entry. Sunroom/Florida Rm surrounded by natural light lead to the cozy reading/sitting rm. Grand pillars, crown molding, wainscoting and endless table space invite you into the formal dining rm w/ access to the butler's pantry. Enter into the culinary dream kitchen! Endless counter space, 42" upgraded cabinets, oversized island & breakfast bar, large table space, SS appliances including side by side energy efficient refrigerator and dishwasher, in addition to dual ovens, built-in microwave & gas cooktop. Plus, a coffee bar, WI pantry, workstation and recessed lighting. Kitchen has open view into the enormous Florida rm ! Walk outside thru French doors to your almost no maintenance composite deck, and stone patio extending the entire length of the house! Back inside, the family rm boasts, WOW with it’s 2 story ceilings, countless windows for tons of natural light, floor to ceiling stone gas fireplace and welcomes any size furniture! Main level also offers two 1/2 baths, multiple storage/coat closets & laundry rm with utility sink. 3rd staircase leads to the private, separate in-law suite featuring an efficiency kitchen, dining area, full bath, family room, large walk in closet and private bedroom quarters. Perfect for guests or extra income! From the main level foyer/family rm staircase, we ascend to an open, wide hallway that offers space for a sitting area. This level features 4 exceptionally large bedrooms. The primary suite is your own private oasis. Features a two sided marble gas fireplace with views from the enormous sleeping area and the overly large, open primary sitting rm . Includes 2 large walk in closest/dressing rm. The luxurious, primary bath is your own private spa! 2 separate vanities w/ tons of cabinet space, plus dressing station, raised jetted soaking tub surrounded by windows/natural lighting, recessed lights and ceiling fan. The separate oversized shower has multiple shower heads and seating. Primary bath also features separate water closet with bidet and plenty of closet space. Primary bedroom's most amazing feature is the very large, exquisite, private, covered veranda. Spend your evenings unwinding with a good book and cold drink as you overlook your serene wooded lot. Bedrooms 2, 3 & 4 are extremely large, each with the sleeping area, separate, but adjoining sitting rm, ensuite baths and two large WICs. Upper level also features second laundry rm w/ utility sink & lots of closet storage. The approx 3,700 sq foot basement is just waiting on your custom design! There's a rough in for a wet bar and bath. Basement access inside and has it's own exterior entrance, lots of windows offering natural sunlight. Home also features 2 separate oversized, 2 car garages, front loading & side loading plus large storage shed for your outdoor toys/tools! The solar panels reduce utility costs dramatically! Buyer must take over solar panel lease. Other features: Dual zone HVAC, dual water heaters, new roof in 2023! Conveniently located near endless shopping, dining, entertainment! Short commute to DC, VA, National Harbor, Andrews AFB, Bolling AFB, PAX River and Indian Head Naval Base. View the 3D tours! Open House - EVERY SATURDAY from 12:00 to 2:00!
MlsNumber: --
ListingId: MDPG2123456


Listing Provided By: Dehanas Real Estate Services, original listing
Phone: (301) 870-1717
Office Phone: (301) 870-1717
Agent Name: Staci L Mildenstein
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 = 3453 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;
Monique Graham
ASCIITTR Sotheby's International Realty
Call Today!: (202) 909-3917

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 = 3453 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 Michael Smith
Michael Smith
ASCIIGeneric Mortgage
Cell: (555) 505-8652

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App