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] => 1217 [1] => SOMERSET [2] => ME [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1217 LocID: SOMERSET Region: ME State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1217 Igate: njhud LocID: 1217 Region: SOMERSET 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 = 1217 AND i.igate IN ('nwhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1217 [1] => SOMERSET [2] => ME [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1217 LocID: SOMERSET Region: ME State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1217 Igate: njhud LocID: 1217 Region: SOMERSET 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 = 1217 AND i.igate IN ('nwhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1217 [1] => SOMERSET [2] => ME [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1217 LocID: SOMERSET Region: ME State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1217 Igate: njhud LocID: 1217 Region: SOMERSET 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 = 1217 AND i.igate IN ('nwhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Maine (ME) Foreclosure Listings
|
Somerset
| Skowhegan, Maine
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Skowhegan, Somerset, Maine
Displaying 1 to 10 of 32 Properties (0 foreclosures)
Whittemore's Real Estate
$949,900
4
bd /
3
ba /
3,848
sqft
49 Glen View Drive
Skowhegan
,
Maine
04976
Realty of Maine
$80,000
--
bd /
0
ba /
--
sqft
Lot 35-2 Blue Heron Lane
Skowhegan
,
Maine
04976
Whittemore's Real Estate
$500,000
--
bd /
0
ba /
12,453
sqft
228 North Avenue
Skowhegan
,
Maine
04976
Keller Williams - Greater Portland
$480,000
--
bd /
0
ba /
3,280
sqft
221 Eaton Mountain Road
Skowhegan
,
Maine
04976
Keller Williams Realty
$480,000
--
bd /
0
ba /
3,280
sqft
221 Eaton Mountain Road
Skowhegan
,
Maine
04976
Allied Realty
$465,000
--
bd /
6
ba /
2,282
sqft
14 Dinsmore Street
Skowhegan
,
Maine
04976
Your Home Sold Guaranteed Realty
$450,000
4
bd /
2
ba /
3,000
sqft
131 Madison Avenue
Skowhegan
,
Maine
04976
Whittemore's Real Estate
$420,000
4
bd /
2
ba /
2,683
sqft
350 W Front Street
Skowhegan
,
Maine
04976
Coldwell Banker American Heritage
$415,000
3
bd /
1
ba /
2,262
sqft
328 Eaton Mountain Road
Skowhegan
,
Maine
04976
Keller Williams Realty
$40,000
--
bd /
0
ba /
--
sqft
M5l85-3 Canaan Road
Skowhegan
,
Maine
04976
«
‹
1
2
3
›
»
Cities In SOMERSET, ME
Anson
Athens
Bingham
Cambridge
Canaan
Caratunk
Detroit
Fairfield
Harmony
Hartland
Hinckley
Jackman
Madison
New Portland
Norridgewock
North Anson
Palmyra
Pittsfield
Rockwood
Saint Albans
Shawmut
Skowhegan
Smithfield
Solon
West Forks
skowhegan
USHUD.com on the Go!