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] => 1220 [1] => YORK [2] => ME [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1220 LocID: YORK Region: ME State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1220 Igate: njhud LocID: 1220 Region: YORK State: ME 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 = 1220 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1220 [1] => YORK [2] => ME [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1220 LocID: YORK Region: ME State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1220 Igate: njhud LocID: 1220 Region: YORK State: ME 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 = 1220 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1220 [1] => YORK [2] => ME [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1220 LocID: YORK Region: ME State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1220 Igate: njhud LocID: 1220 Region: YORK State: ME 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 = 1220 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Maine (ME) Foreclosure Listings
|
York
| Lebanon, Maine
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Lebanon, York, Maine
Displaying 1 to 10 of 18 Properties (0 foreclosures)
Lakes Region Realty
$749,000
4
bd /
2
ba /
2,484
sqft
30 Upper Cross Road
Lebanon
,
Maine
04027
York, Maine
$70,000
--
bd /
0
ba /
--
sqft
00 Weirs Lane
Lebanon
,
Maine
04027
Lakes Region Realty
$624,900
3
bd /
1
ba /
1,248
sqft
10 Trainor Road
Lebanon
,
Maine
04027
Sanford, Maine
$350,000
--
bd /
0
ba /
--
sqft
82 Shapleigh Road
Lebanon
,
Maine
04027
Sanford, Maine
$349,000
--
bd /
0
ba /
--
sqft
00 Upper Middle Road
Lebanon
,
Maine
04027
Keller Williams - Portsmouth
$315,000
3
bd /
1
ba /
1,200
sqft
79 Blaisdell Corner Road
Lebanon
,
Maine
04027
Sanford, Maine
$295,000
--
bd /
0
ba /
--
sqft
Lot 88 Center Road
Lebanon
,
Maine
04027
Coldwell Banker Realty
$250,000
1
bd /
1
ba /
800
sqft
131 Wilfred Drive
Lebanon
,
Maine
04027
Sanford, Maine
$250,000
--
bd /
0
ba /
--
sqft
84 Shapleigh Road
Lebanon
,
Maine
04027
Sanford, Maine
$210,000
--
bd /
0
ba /
--
sqft
Lot 85 Shapleigh Road
Lebanon
,
Maine
04027
«
‹
1
2
›
»
Cities In YORK, ME
Acton
Alfred
Bar Mills
Berwick
Biddeford
Biddeford Pool
Buxton
Cape Neddick
Cape Porpoise
Cornish
East Parsonsfield
East Waterboro
Eliot
Hollis Center
Kennebunk
Kennebunkport
Kittery
Kittery Point
Lebanon
Limerick
Limington
Moody
Newfield
North Berwick
North Waterboro
Ocean Park
Ogunquit
Old Orchard Beach
Parsonsfield
Saco
Sanford
Shapleigh
South Berwick
Springvale
Waterboro
Wells
West Kennebunk
West Newfield
York
York Beach
York Harbor
lebanon
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => york [3] => ME [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: york State: ME Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: york State: ME 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 = 1220 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Shelley Martin
ASCII
Berkshire Hathaway HomeServices Verani Realty
work
Call Today!
:
(207) 251-5840
I'm interested in properties in YORK, ME
1841584
1841584
0
Contact Me
USHUD.com on the Go!