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] => 3120 [1] => COOS [2] => NH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3120 LocID: COOS Region: NH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3120 Igate: njhud LocID: 3120 Region: COOS State: NH 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 = 3120 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3120 [1] => COOS [2] => NH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3120 LocID: COOS Region: NH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3120 Igate: njhud LocID: 3120 Region: COOS State: NH 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 = 3120 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3120 [1] => COOS [2] => NH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3120 LocID: COOS Region: NH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3120 Igate: njhud LocID: 3120 Region: COOS State: NH 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 = 3120 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Hampshire (NH) Foreclosure Listings
|
Coos
| Whitefield, New Hampshire
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Whitefield, Coos, New Hampshire
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Caron's Gateway Real Estate
$75,000
--
bd /
0
ba /
--
sqft
Littleton Road
Whitefield
,
New Hampshire
03598
Lisa Hampton Real Estate
$67,500
--
bd /
0
ba /
--
sqft
142 Mirror Lake Estates Drive
Whitefield
,
New Hampshire
03598
Northwind Realty
$65,000
--
bd /
0
ba /
--
sqft
25 Alley Lane
Whitefield
,
New Hampshire
03598
Northwind Realty
$504,900
3
bd /
1
ba /
1,688
sqft
468 Littleton Road
Whitefield
,
New Hampshire
03598
Peter W. Powell Real Estate
$449,000
5
bd /
3
ba /
2,700
sqft
996 Jefferson Road
Whitefield
,
New Hampshire
03598
Badger Peabody & Smith Realty
$399,000
--
bd /
0
ba /
--
sqft
00 Lancaster Road
Whitefield
,
New Hampshire
03598
Badger Peabody & Smith Realty
$399,000
6
bd /
2
ba /
2,733
sqft
183 Mountain View Road
Whitefield
,
New Hampshire
03598
Northwind Realty
$39,900
--
bd /
0
ba /
--
sqft
0 Dylan Court
Whitefield
,
New Hampshire
03598
Lisa Hampton Real Estate
$349,000
--
bd /
0
ba /
--
sqft
152 Littleton Road
Whitefield
,
New Hampshire
03598
Northwind Realty
$269,900
3
bd /
2
ba /
960
sqft
28 Huron Street
Whitefield
,
New Hampshire
03598
Cities In COOS, NH
Berlin
Bretton Woods
Colebrook
Errol
Gorham
Groveton
Jefferson
Lancaster
Milan
Mount Washington
North Stratford
Pittsburg
Randolph
Twin Mountain
West Stewartstown
Whitefield
whitefield
USHUD.com on the Go!