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

2732 Queensberry Drive
Huntingtown, MD 20639
Doris Williams with Taylor Properties, original listing - (301) 970-2447

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5204 Square Feet
Agency: Taylor Properties
Agency Phone: (301) 970-2447

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: WOW! BIG PRICE DROP! Motivated Sellers! **Stunning 5-Bedroom Home with Modern Upgrades in Huntington's Beautiful Queensberry Neighborhood**<br /> <br /> Welcome to 2732 Queensberry Dr., Huntington—an exquisite 7,400+ square foot residence, the largest in the prestigious Queensberry community. This fully upgraded 5-bedroom, 4.5-bathroom home offers unparalleled luxury and convenience, perfect for those seeking modern living in a spacious, elegant setting.<br /> <br /> **Key Features:**<br /> <br /> - **Spacious Bedrooms:** All five bedrooms feature walk-in closets, with the upstairs primary suite boasting a luxurious drop-down TV lift (which conveys) and a relaxing jet tub. The two adjoining upstairs bedrooms offer secure thumbprint entry, with each room connected by a full bathroom with individual sinks.<br /> <br /> - **Modern Bathrooms:** All bathrooms are equipped with new toilets and rain head showerheads, providing a spa-like experience in the comfort of your own home.<br /> <br /> - **Advanced Home Technology:** Enjoy the convenience of new Wi-Fi enabled Philips Hue recessed lighting throughout the house, as well as a Wi-Fi enabled Echo Net thermostat. The living room features electric blinds for effortless light control. <br /> <br /> - **Fully Upgraded HVAC:** Two brand new HVAC systems ensure comfort year-round, while a recently pumped septic system and cleaned ductwork add peace of mind.<br /> <br /> - **Gourmet Kitchen & Cozy Living Spaces:** The kitchen and living room are serviced by an owned propane tank (not leased), fueling the stove and the cozy fireplace.<br /> <br /> - **Entertainment & Convenience:** The home is equipped with a permanent outdoor lighting system, so you’ll never need to install Christmas lights again. An outdoor speaker system sets the perfect ambiance for gatherings.<br /> <br /> - **Garage & Home Gym:** The three-car garage includes a single car bay converted into a home gym, complete with rubber mats and a mini split system, which will convey with the property.<br /> <br /> - **Energy Efficiency & Security:** The property features a central vacuum system, new overhead lighting including a striking foyer chandelier, and a 3-4 year old roof. The home is also equipped with a comprehensive irrigation system in both the front and backyard.<br /> <br /> - **Expansive Basement:** A 2,200 square-foot basement, already roughed-in for a bathroom, offers endless possibilities for customization to suit your needs.<br /> <br /> This meticulously maintained and thoughtfully upgraded home is a rare find in the Queensberry neighborhood with beautiful fall views overlooking the creek just beyond the backyard. Don’t miss your chance to own this luxurious property—schedule your private showing today!
MlsNumber: --
ListingId: MDCA2017142


Listing Provided By: Taylor Properties, original listing
Phone: (301) 970-2447
Office Phone: (301) 970-2447
Agent Name: Doris Williams
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 = 1186 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 Tyler Mattingly
Tyler Mattingly
ASCIIColdwell Banker Jay Lilly Real Estate
Call Today!: (443) 569-2796

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App