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] => 1207 [1] => AROOSTOOK [2] => ME [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1207 LocID: AROOSTOOK Region: ME State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1207 Igate: njhud LocID: 1207 Region: AROOSTOOK 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 = 1207 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] => 1207 [1] => AROOSTOOK [2] => ME [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1207 LocID: AROOSTOOK Region: ME State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1207 Igate: njhud LocID: 1207 Region: AROOSTOOK 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 = 1207 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] => 1207 [1] => AROOSTOOK [2] => ME [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1207 LocID: AROOSTOOK Region: ME State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1207 Igate: njhud LocID: 1207 Region: AROOSTOOK 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 = 1207 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
|
Aroostook
| Houlton, Maine
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Houlton, Aroostook, Maine
Displaying 1 to 10 of 25 Properties (0 foreclosures)
Mooers Realty
$99,500
2
bd /
1
ba /
832
sqft
11 Garrison Road
Houlton
,
Maine
04730
Mooers Realty
$84,500
4
bd /
3
ba /
1,962
sqft
59 Military Street
Houlton
,
Maine
04730
Mooers Realty
$69,900
3
bd /
1
ba /
1,148
sqft
7 Pennington Street
Houlton
,
Maine
04730
www.HomeZu.com
$499,000
4
bd /
2
ba /
2,083
sqft
15 Lilac Lane
Houlton
,
Maine
04730
First Choice Real Estate
$49,900
--
bd /
0
ba /
--
sqft
77 Aviation Drive
Houlton
,
Maine
04730
Northern Maine Realty, Inc.
$475,000
3
bd /
3
ba /
3,103
sqft
325 Bangor Street
Houlton
,
Maine
04730
Northern Maine Realty, Inc.
$430,000
4
bd /
1
ba /
2,632
sqft
86 Court Street
Houlton
,
Maine
04730
First Choice Real Estate
$399,500
10
bd /
4
ba /
6,750
sqft
101 North Street
Houlton
,
Maine
04730
First Choice Real Estate
$349,900
4
bd /
2
ba /
3,969
sqft
8 Charles Street
Houlton
,
Maine
04730
First Choice Real Estate
$339,000
3
bd /
3
ba /
2,700
sqft
606 Smyrna Street
Houlton
,
Maine
04730
«
‹
1
2
3
›
»
Cities In AROOSTOOK, ME
Ashland
Benedicta
Blaine
Bridgewater
Caribou
Clayton Lake
Crouseville
Eagle Lake
Easton
Estcourt Station
Fort Fairfield
Fort Kent
Fort Kent Mills
Frenchville
Grand Isle
Houlton
Island Falls
Limestone
Madawaska
Mapleton
Mars Hill
Monticello
New Limerick
New Sweden
Oakfield
Orient
Oxbow
Perham
Portage
Presque Isle
Saint Agatha
Saint David
Saint Francis
Sheridan
Sherman
Sinclair
Smyrna Mills
Stockholm
Van Buren
Wallagrass
Washburn
Westfield
Wytopitlock
houlton
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => aroostook [3] => ME [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: aroostook State: ME Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: aroostook 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 = 1207 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;
Steve Johnson
ASCII
Northern Star Real Estate, LLC
work
Call Today!
:
(207) 316-5631
I'm interested in properties in AROOSTOOK, ME
1841636
1841636
0
Contact Me
USHUD.com on the Go!