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] => 3123 [1] => MERRIMACK (COUNTY) [2] => NH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3123 LocID: MERRIMACK (COUNTY) Region: NH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3123 Igate: njhud LocID: 3123 Region: MERRIMACK (COUNTY) 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 = 3123 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3123 [1] => MERRIMACK (COUNTY) [2] => NH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3123 LocID: MERRIMACK (COUNTY) Region: NH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3123 Igate: njhud LocID: 3123 Region: MERRIMACK (COUNTY) 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 = 3123 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3123 [1] => MERRIMACK (COUNTY) [2] => NH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3123 LocID: MERRIMACK (COUNTY) Region: NH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3123 Igate: njhud LocID: 3123 Region: MERRIMACK (COUNTY) 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 = 3123 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Hampshire (NH) Foreclosure Listings
|
Merrimack (County)
| Newbury, New Hampshire
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Newbury, Merrimack (County), New Hampshire
Displaying 1 to 10 of 18 Properties (0 foreclosures)
Elliot Hansen Associates
$97,500
--
bd /
0
ba /
--
sqft
Lot 13 Richards Road
Newbury
,
New Hampshire
03255
KW Coastal and Lakes & Mountains Realty/N.London
$799,000
4
bd /
2
ba /
2,694
sqft
11 Mountainside Road
Newbury
,
New Hampshire
03255
Elliot Hansen Associates
$77,500
--
bd /
0
ba /
--
sqft
Lot 61 Hilltop Drive
Newbury
,
New Hampshire
03255
Dolan Real Estate
$699,000
3
bd /
1
ba /
2,190
sqft
214 Winding Brook Road
Newbury
,
New Hampshire
03255
Elliot Hansen Associates
$59,500
--
bd /
0
ba /
--
sqft
Lot 89 High Ridge Road
Newbury
,
New Hampshire
03255
Gray Ledges Rentals/Grantham
$5,000
3
bd /
1
ba /
2,384
sqft
14 Edgemont Landing
Newbury
,
New Hampshire
03255
Gray Ledges Rentals/Grantham
$4,450
4
bd /
2
ba /
2,272
sqft
306 Rollins Road
Newbury
,
New Hampshire
03255
Equity Group Real Estate Broker Inc.
$4,200
4
bd /
2
ba /
3,600
sqft
104 Stoney Brook Road
Newbury
,
New Hampshire
03255
NH Home Team
$3,499
2
bd /
1
ba /
1,104
sqft
28 Skytop Drive
Newbury
,
New Hampshire
03255
Coldwell Banker Realty Nashua
$3,200
3
bd /
2
ba /
2,300
sqft
45 Pine Street
Newbury
,
New Hampshire
03255
«
‹
1
2
›
»
Cities In MERRIMACK (COUNTY), NH
Andover
Bow
Bradford
Canterbury
Chichester
Concord
Contoocook
Danbury
Dunbarton
East Andover
Elkins
Epsom
Franklin
Henniker
Hill
Hooksett
Loudon
New London
Newbury
North Sutton
Pittsfield
Salisbury
South Newbury
South Sutton
Suncook
Warner
Wilmot
newbury
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => merrimack-county [3] => NH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: merrimack-county State: NH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: merrimack-county State: NH 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 = 3123 AND i.igate IN ('orhud','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 = 'orhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Alison Scott
ASCII
603 Birch Realty
work
Call Today!
:
(410) 320-3703
I'm interested in properties in MERRIMACK (COUNTY), NH
1839163
1839163
0
Contact Me
USHUD.com on the Go!