Your browser does not support the video tag.
Knowledge Center
Email Alerts
Mortgage/Credit Help
FAQ
Reviews
Professionals
Search
Refine Search
Beds:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Baths:
Any
1 +
2 +
3 +
4 +
5 +
6 +
7 +
8 +
9 +
10 +
Property Type:
Any
Conventional
Foreclosure
Price Range:
to
Refine
DEBUG FN args: Array ( [0] => 1190 [1] => CHARLES [2] => MD [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1190 LocID: CHARLES Region: MD State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1190 Igate: njhud LocID: 1190 Region: CHARLES State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 ('pahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1190 [1] => CHARLES [2] => MD [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1190 LocID: CHARLES Region: MD State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1190 Igate: njhud LocID: 1190 Region: CHARLES State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 ('pahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1190 [1] => CHARLES [2] => MD [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1190 LocID: CHARLES Region: MD State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1190 Igate: njhud LocID: 1190 Region: CHARLES State: MD Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 2
QUERY: 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 ('pahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Maryland (MD) Foreclosure Listings
|
Charles
| Indian Head, Maryland
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Indian Head, Charles, Maryland
Displaying 1 to 10 of 39 Properties (0 foreclosures)
The Land Group
$967,800
--
bd /
0
ba /
--
sqft
Smallwood Church Rd
Indian Head
,
Maryland
20640
RE/MAX 100
$687,900
4
bd /
2
ba /
3,252
sqft
7810 Hamilton Heights Place
Indian Head
,
Maryland
20640
RE/MAX 100
$679,000
4
bd /
2
ba /
--
sqft
7805 Hamilton Heights Place
Indian Head
,
Maryland
20640
Zar Realty, LLC
$575,000
--
bd /
0
ba /
--
sqft
3360 Livingston Road
Indian Head
,
Maryland
20640
Compass
$550,000
3
bd /
2
ba /
2,220
sqft
5290 Hickory Creek Place
Indian Head
,
Maryland
20640
CENTURY 21 New Millennium
$524,950
3
bd /
2
ba /
2,713
sqft
5425 Indian Head Highway
Indian Head
,
Maryland
20640
Cottage Street Realty LLC
$509,999
4
bd /
3
ba /
2,408
sqft
4040 Doncaster Drive
Indian Head
,
Maryland
20640
Baldus Real Estate, Inc.
$475,000
8
bd /
4
ba /
3,698
sqft
4601 Strauss Avenue
Indian Head
,
Maryland
20640
RE/MAX 100
$450,000
3
bd /
2
ba /
1,716
sqft
7120 Rison Drive
Indian Head
,
Maryland
20640
CENTURY 21 New Millennium
$449,080
4
bd /
4
ba /
3,068
sqft
1103 Murdock Road
Indian Head
,
Maryland
20640
«
‹
1
2
3
›
»
Cities In CHARLES, MD
Bel Alton
Benedict
Bryans Road
Bryantown
Cobb Island
Faulkner
Hughesville
Indian Head
Ironsides
Issue
La Plata
Marbury
Mount Victoria
Nanjemoy
Newburg
Pomfret
Port Tobacco
Rock Point
Southern Md Facility
Waldorf
Welcome
White Plains
indian head
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => charles [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: charles State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: charles State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1
QUERY: 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 ('pahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Carlos Gautier
ASCII
JPAR Professionals
work
Call Today!
:
(301) 399-3519
I'm interested in properties in CHARLES, MD
1846587
1846587
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => charles [3] => MD [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: charles State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: charles State: MD Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1
QUERY: 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 ('pahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Bill Saunders NMLS#455891
ASCII
Guild Mortgage
work
Call Today!
:
(301) 440-9102
I'm interested in properties in CHARLES, MD
1845448
1845448
0
Contact Me
USHUD.com on the Go!