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
| Hughesville, Maryland
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hughesville, Charles, Maryland
Displaying 1 to 10 of 31 Properties (0 foreclosures)
EXP Realty, LLC
$850,000
3
bd /
3
ba /
4,400
sqft
6317 Dusty Trail Place
Hughesville
,
Maryland
20637
Bennett Realty Solutions
$834,999
4
bd /
4
ba /
3,304
sqft
14440 Pathfinder Court
Hughesville
,
Maryland
20637
RE/MAX 100
$811,900
5
bd /
4
ba /
4,946
sqft
16560 Trail Mill Place
Hughesville
,
Maryland
20637
RE/MAX 100
$764,900
5
bd /
3
ba /
3,127
sqft
7100 Bucktown Road
Hughesville
,
Maryland
20637
Baldus Real Estate, Inc.
$75,000
--
bd /
0
ba /
--
sqft
16410 Crown Place
Hughesville
,
Maryland
20637
Exit Landmark Realty
$734,900
5
bd /
2
ba /
2,878
sqft
6610 Boone Place
Hughesville
,
Maryland
20637
Annapolis Fine Homes
$680,000
4
bd /
2
ba /
--
sqft
16870 Bent Oak Pl
Hughesville
,
Maryland
20637
Home Towne Real Estate
$649,900
4
bd /
3
ba /
3,719
sqft
6843 Barlowe Court
Hughesville
,
Maryland
20637
EXP Realty, LLC
$630,000
3
bd /
3
ba /
4,400
sqft
6315 Dusty Trail Place
Hughesville
,
Maryland
20637
Keller Williams Flagship of Maryland
$595,000
4
bd /
2
ba /
2,016
sqft
15570 Prince Frederick Road
Hughesville
,
Maryland
20637
«
‹
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
hughesville
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!