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

110 Riverwatch Drive
Indian Head, MD 20640
Dell Epps with Weichert, REALTORS, original listing - (703) 549-8700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $369,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2160 Square Feet
Agency: Weichert, REALTORS
Agency Phone: (703) 549-8700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Townhouse
Year Built: 2004
Notes: This is the Dream Home that you have been waiting for! Welcome to 110 Riverwatch Drive! With Over 2,100 Square Feet of living Space with your backyard Backing to Trees! This Beautiful End Unit Home has Four Bedrooms, with Three Full Bathrooms. Which includes a Full Bedroom and Bathroom on the Basement Level! Enjoy your very Spacious Living Room with Fireplace. The Kitchen is complete with abundant Counter Space, a Kitchen Island, Dining Room and all Stainless-Steel Appliances and a nice size pantry! And Powered Room. The Entire Home has been Freshly Painted and Brand New Carpet has been installed all throughout the Home. Wow! ****Join us for our Open House on Saturday, December 21st from 1PM to 4PM and Sunday, December 22nd from 2PM to 5PM to see this amazing home in person. ***** You will love the balcony on Main level! The Master Bedroom has an Attached Master Bathroom. Two additional Bedrooms complete the home third level of home with a full bathroom. The Laundry Room is located on the bedroom level for your convivence! With a Newer LG Washer and Dryer. The home basement lower level offers you many options including use of a, Fourth Bedroom and Full Bathroom, Home Entertaining Area, Home Office space or a Game Room. The home has a one Car Garage. Visitor parking is distributed right across from your home. If you are looking for a move in ready home. This is it! Time for a nice walk outside. As you will love the Recently built Community Boardwalk with Walking Trails and views of the Potomac River! Within your Subdivision. It is a commuter’s dream! Conveniently located less than a Mile to Indian Head Naval Base and close to National Harbor, MGM, Andrew Air Force Base, Bolling Air Force Base, Fort Belvoir, Alexandria, Arlington, the Pentagon and Washington D.C. Access to the Indian Head Trail is perfectly located only minutes away. Perfect for hiking and biking with miles of fully paved access that runs from Indian Head to White Plains. Save this home as your Favorite and Preview this Home Today as it will not be Available for long!
MlsNumber: --
ListingId: MDCH2038478


Listing Provided By: Weichert, REALTORS, original listing
Phone: (703) 549-8700
Office Phone: (703) 549-8700
Agent Name: Dell Epps
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 = 1190 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;
Brian Crayton
ASCIICENTURY 21 Envision
Call Today!: (240) 473-3426

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App