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 ('nwhud','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 = 'nwhud', 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 ('nwhud','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 = 'nwhud', 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 ('nwhud','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 = 'nwhud', 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
| Limington, Maine
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Limington, York, Maine
Displaying 1 to 10 of 15 Properties (0 foreclosures)
EXP Realty
$89,900
--
bd /
0
ba /
--
sqft
Lot 1 Tucker Road
Limington
,
Maine
04049
Keller Williams - Greater Portland
$79,000
--
bd /
0
ba /
--
sqft
430 Ossipee Trail
Limington
,
Maine
04049
Keller Williams Realty
$79,000
--
bd /
0
ba /
--
sqft
430 Ossipee Trail
Limington
,
Maine
04049
EXP Realty
$749,000
4
bd /
1
ba /
1,600
sqft
824 Cape Road
Limington
,
Maine
04049
Better Homes and Gardens Real Estate The Masiello Group
$74,000
3
bd /
1
ba /
980
sqft
24 Maplewood Drive
Limington
,
Maine
04049
Town & Shore Real Estate
$699,000
3
bd /
2
ba /
2,097
sqft
86 Tucker Road
Limington
,
Maine
04049
Keller Williams - Greater Portland
$429,000
3
bd /
2
ba /
1,680
sqft
9 Cold Bowling Spring Lane
Limington
,
Maine
04049
Maine Real Estate Co
$32,000
--
bd /
0
ba /
--
sqft
13 Airport Drive
Limington
,
Maine
04049
Signature Homes Real Estate Group, LLC
$174,900
3
bd /
2
ba /
1,280
sqft
4 Maplewood Drive
Limington
,
Maine
04049
Signature Homes Real Estate Group, LLC
$144,500
2
bd /
2
ba /
880
sqft
3 Birchwood Drive
Limington
,
Maine
04049
«
‹
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
limington
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 ('nwhud','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 = 'nwhud', 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!