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 ('mdhud','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 = 'mdhud', 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 ('mdhud','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 = 'mdhud', 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 ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Maryland (MD) Foreclosure Listings
|
Charles
| La Plata, Maryland
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
La Plata, Charles, Maryland
Displaying 21 to 30 of 82 Properties (1 foreclosures)
Greenmark Real Estate
$530,000
--
bd /
0
ba /
--
sqft
Deer Farm Place
La Plata
,
Maryland
20646
Cottage Street Realty LLC
$529,000
5
bd /
3
ba /
4,048
sqft
10771 Tip Hill Court
La Plata
,
Maryland
20646
Fathom Realty MD, LLC
$525,000
3
bd /
3
ba /
3,176
sqft
8992 Hillary Court
La Plata
,
Maryland
20646
Redfin Corp
$500,000
4
bd /
3
ba /
3,256
sqft
1018 Bran Drive
La Plata
,
Maryland
20646
Keller Williams Realty Centre
$500,000
4
bd /
2
ba /
2,633
sqft
10235 Laplata Road
La Plata
,
Maryland
20646
D.R. Horton - Maryland
$499,990
4
bd /
2
ba /
2,169
sqft
534 Woodland Knoll Way
La Plata
,
Maryland
20646
Residential Plus Real Estate Services
$499,000
4
bd /
2
ba /
2,240
sqft
7252 Saint Marys Avenue
La Plata
,
Maryland
20646
Exit Landmark Realty
$485,000
3
bd /
2
ba /
2,490
sqft
1411 Redwood Circle
La Plata
,
Maryland
20646
EXP Realty, LLC
$480,000
6
bd /
3
ba /
1,974
sqft
7548 Sutton Drive
La Plata
,
Maryland
20646
CENTURY 21 New Millennium
$469,900
3
bd /
2
ba /
1,828
sqft
10455 Laplata Road
La Plata
,
Maryland
20646
«
‹
1
2
3
4
5
›
»
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
la plata
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 ('mdhud','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 = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Gerri Ross
ASCII
Long and Foster Real Estate
work
Call Today!
:
(301) 580-8217
I'm interested in properties in CHARLES, MD
1842108
1842108
0
Contact Me
USHUD.com on the Go!