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] => 1200 [1] => SAINT MARY`S [2] => MD [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1200 LocID: SAINT MARY`S Region: MD State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1200 Region: SAINT MARY`S 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 = 1200 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1200 [1] => SAINT MARY`S [2] => MD [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1200 LocID: SAINT MARY`S Region: MD State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1200 Region: SAINT MARY`S 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 = 1200 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1200 [1] => SAINT MARY`S [2] => MD [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1200 LocID: SAINT MARY`S Region: MD State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1200 Region: SAINT MARY`S 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 = 1200 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Maryland (MD) Foreclosure Listings
|
Saint Mary's
| Lexington Park, Maryland
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Lexington Park, Saint Mary's, Maryland
Displaying 1 to 10 of 22 Properties (2 foreclosures)
PENNIE PLATT
FORECLOSURE
$295,000
2
bd /
1
ba /
833
sqft
21933 Spring Valley Dr
Lexington Park
,
Maryland
20653
RE/MAX 100
FORECLOSURE
$295,000
4
bd /
2
ba /
1,632
sqft
21933 Spring Valley Drive
Lexington Park
,
Maryland
20653
Redfin Corporation
$539,900
5
bd /
4
ba /
3,022
sqft
20401 Monte Carlo Lane
Lexington Park
,
Maryland
20653
Century 21 New Millennium
$492,000
3
bd /
2
ba /
1,818
sqft
22652 Excel Court
Lexington Park
,
Maryland
20653
RE/MAX 100
$475,000
3
bd /
3
ba /
2,723
sqft
46485 Hilton Ridge Drive
Lexington Park
,
Maryland
20653
Coldwell Banker Residential Brokerage
$435,000
4
bd /
3
ba /
2,285
sqft
48121 Wingate Place
Lexington Park
,
Maryland
20653
RE/MAX One
$429,000
3
bd /
3
ba /
2,446
sqft
48277 Choptank Place
Lexington Park
,
Maryland
20653
Century 21 New Millennium
$412,000
4
bd /
3
ba /
2,284
sqft
21388 Dayflower Place
Lexington Park
,
Maryland
20653
Exit Landmark Realty
$409,900
4
bd /
3
ba /
2,364
sqft
47403 Topaz Place
Lexington Park
,
Maryland
20653
RE/MAX One
$408,000
5
bd /
2
ba /
1,904
sqft
21488 Morris Drive
Lexington Park
,
Maryland
20653
«
‹
1
2
3
›
»
Cities In SAINT MARY`S, MD
Abell
Avenue
Bushwood
California
Callaway
Chaptico
Charlotte Hall
Clements
Coltons Point
Compton
Dameron
Drayden
Great Mills
Helen
Hollywood
Leonardtown
Lexington Park
Loveville
Mechanicsville
Morganza
Park Hall
Patuxent River
Piney Point
Ridge
Saint Inigoes
Saint Marys City
Scotland
Tall Timbers
Valley Lee
lexington park
USHUD.com on the Go!