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;

3121 Hunting Creek Road
Huntingtown, MD 20639

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,999
Beds: 5
Baths: 5
Status: Active
SqFt: 6233
Agency: Schwartz Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1979
Notes: Extremely rare opportunity to own a truly custom-built property situated on 4+ acres in a highly desirable location with easy commutes to the DC, Annapolis, and Pax River area as well as an excellent school system. Nestled on 4.25 acres, this private and secluded home is surrounded by mature trees and backs up to 117 acres of forest. The main floor offers an open floor plan with plenty of room for family activities in the Great room boosting lots of natural wood, a full dining room, sitting room, home office, butler’s pantry/bar area with built in wine fridge, and a spacious sun room offering fantastic views of the pool and ponds in the backyard. The kitchen is beyond spacious with all new black stainless-steel appliances. There is also 1.5 baths with the full bath leading to the back deck with direct access to the staircase heading straight to the pool deck, and a climate controlled multipurpose room ready to be converted to a garage, used for storage, work shop, turned into a home gym, or anything you might be able to imagine. Upstairs generous offers 5 bedrooms and 2 full baths both of which have been updated. The fully finished basement offers a fully functional in-law studio suite with a full kitchen and it’s own laundry space. If you don’t want to use as an in-law studio suite, use it as a social space to gather near a fireplace. Basement also has a generous game room with a pool table that conveys. Basement walks out into the backyard oasis that has a hot tub, Gunite pool with waterfalls and diving rock, fire pit for cold nights, playground for the kids, custom hardscaping offering full access to the 6, yes 6, fish ponds with it’s own waterfall. The entire pool deck is coated with a cool paint to keep your feet from burning and it is amazing. All this combined with 4 new HVAC systems that have been upgraded to highly efficient systems with air purification and steam humidifiers, new pool pump and filtration system, new roof, and a newly rebuilt shed, and an RV/EV charging port this home has everything needed to become your personal staycation. Look no further and WELCOME TO YOUR NEW HOME!
MlsNumber: MDCA2014764


Listing Provided By: Schwartz Realty, Inc., original listing
Name: Schwartz Realty, Inc.
Phone: (301) 261-9700
Office Name: Schwartz Realty, Inc.
Office Phone: (301) 261-9700
Agent Name: John Tarpley
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;
Gibsy Jones
ASCIIeXp Realty
Call Today!: (202) 330-1829

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App