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;

1555 Ben Doane Road
Indian Head, MD 20640
Boyd Grainger with Exit Landmark Realty, original listing - (301) 934-2022

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3740 Square Feet
Agency: Exit Landmark Realty
Agency Phone: (301) 934-2022

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1975
Notes: Absolutely one of a kind fantastic 3740 square foot waterfront 4 bedroom 4.5 bath rambler with pool, 250 foot pier, detached garage, with nearly 300 feet of beach on 6.58 acres!!! This house not only checks all the boxes, but creates a few must haves that you may have not known you needed. You absolutely have to tour this property. To build this property out today would be over $3,000,000.00! The house is amazing, custom designer wall paper and paint throughout with new LVP floors and designer light fixtures. Starting with the formal foyer with double doors and custom ceramic tile leading into the expansive dining room with a clear view of the Potomac River. Just off the dining room is the kitchen with custom 42' cabinets, modern appliances, corian countertops, breakfast nook area with river views as well. The parlor room is fantastic with custom built-in cabinets and stone fireplace. Just beyond the parlor is the bonus room that can be another sitting room, home office, exercise or 2nd family room. In addition, there is a very large sunken family room off the dining room that is perfect for large furniture, a huge TV, with plenty of space to relax and entertain family and friends. This is definitely the special occasion, holiday, or wedding hosting house. The bedrooms are large and consistent with the rest of the home. Owner's suite is amazing with views of the pool and river, double walk-in closets, double bowl vanity with ceramic tile and custom lighting. The outside just does not stop. Let's start with the 20' x 40' pool fully equiped with diving board, built-in spa, gazebo and cabana area. The concrete patio spans the entire length of the home as well. The yard is huge and leads to a 250' deepwater dock with 2 jet ski lifts, 2 boat lifts, and 2 ladders for swimming. The 300' beach is to die for perfect for swimming, sea shell hunting, and romantic walks at sunset. Having a 6.58 private Potomac River waterfront lot with a pier and beach is extremely hard to find. The property also has a fenced-in terraced garden, very large chicken coop that is good distance from the house plus a kids playground. The house comes with an attached 3 car oversized garage with bathroom and kitchen area. The detached garage is amazing as well, the structure is 52' x 62' concrete block construction, climate controlled, with 2 oversized 20' x 14' commercial doors for RV and or boats, plus a side garage bay door with a 10,000 pound car lift, full kitchen, full bathroom and additional office. This is a once in a generation chance to own your dream home, please set up a tour as soon as you can.
MlsNumber: --
ListingId: MDCH2036094


Listing Provided By: Exit Landmark Realty, original listing
Phone: (301) 934-2022
Office Phone: (301) 934-2022
Agent Name: Boyd Grainger
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