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] => 3122 [1] => HILLSBOROUGH (COUNTY) [2] => NH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3122 LocID: HILLSBOROUGH (COUNTY) Region: NH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3122 Igate: njhud LocID: 3122 Region: HILLSBOROUGH (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 = 3122 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] => 3122 [1] => HILLSBOROUGH (COUNTY) [2] => NH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3122 LocID: HILLSBOROUGH (COUNTY) Region: NH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3122 Igate: njhud LocID: 3122 Region: HILLSBOROUGH (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 = 3122 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] => 3122 [1] => HILLSBOROUGH (COUNTY) [2] => NH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3122 LocID: HILLSBOROUGH (COUNTY) Region: NH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3122 Igate: njhud LocID: 3122 Region: HILLSBOROUGH (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 = 3122 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
|
Hillsborough (County)
| New Boston, New Hampshire
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
New Boston, Hillsborough (County), New Hampshire
Displaying 1 to 10 of 16 Properties (0 foreclosures)
Four Seasons Sotheby's Int'l Realty
$959,000
4
bd /
1
ba /
2,909
sqft
127 Bunker Hill Road
New Boston
,
New Hampshire
03070
Four Seasons Sotheby's Int'l Realty
$949,000
4
bd /
3
ba /
3,893
sqft
51 Lorden Road
New Boston
,
New Hampshire
03070
Keller Williams Realty-Metropolitan
$889,000
4
bd /
2
ba /
2,506
sqft
63 Lorden Road
New Boston
,
New Hampshire
03070
BHHS Verani Amherst
$799,900
4
bd /
1
ba /
2,714
sqft
158 Lyndeborough Road
New Boston
,
New Hampshire
03070
Keller Williams Gateway Realty
$799,900
4
bd /
2
ba /
2,640
sqft
Lot 2-151-1 Tucker Mill Road
New Boston
,
New Hampshire
03070
Four Seasons Sotheby's Int'l Realty
$799,000
4
bd /
1
ba /
2,790
sqft
170 Clark Hill Road
New Boston
,
New Hampshire
03070
Coldwell Banker Realty Nashua
$775,000
3
bd /
2
ba /
2,196
sqft
9 Helena Drive
New Boston
,
New Hampshire
03045
Bedford, New Hampshire
$675,000
4
bd /
3
ba /
3,194
sqft
146 S. Hill Road
New Boston
,
New Hampshire
03070
Bedford, New Hampshire
$650,000
4
bd /
4
ba /
1,888
sqft
93 Bedford Road
New Boston
,
New Hampshire
03070
Four Seasons Sotheby's Int'l Realty
$5,900,000
7
bd /
4
ba /
20,081
sqft
94 Foxberry Drive
New Boston
,
New Hampshire
03070
«
‹
1
2
›
»
Cities In HILLSBOROUGH (COUNTY), NH
Amherst
Antrim
Bedford
Bennington
Brookline
Francestown
Goffstown
Greenfield
Greenville
Hancock
Hillsborough
Hollis
Hudson
Litchfield
Lyndeborough
Manchester
Merrimack
Milford
Mont Vernon
Nashua
New Boston
New Ipswich
Pelham
Peterborough
Temple
Weare
Wilton
new boston
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => hillsborough-county [3] => NH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: hillsborough-county State: NH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: hillsborough-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 = 3122 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 HILLSBOROUGH (COUNTY), NH
1839163
1839163
0
Contact Me
USHUD.com on the Go!