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] => 3125 [1] => STRAFFORD (County) [2] => NH [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3125 LocID: STRAFFORD (County) Region: NH State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3125 Igate: njhud LocID: 3125 Region: STRAFFORD (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 = 3125 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3125 [1] => STRAFFORD (County) [2] => NH [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3125 LocID: STRAFFORD (County) Region: NH State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3125 Igate: njhud LocID: 3125 Region: STRAFFORD (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 = 3125 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3125 [1] => STRAFFORD (County) [2] => NH [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3125 LocID: STRAFFORD (County) Region: NH State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3125 Igate: njhud LocID: 3125 Region: STRAFFORD (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 = 3125 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Hampshire (NH) Foreclosure Listings
|
Strafford (County)
| Farmington, New Hampshire
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Farmington, Strafford (County), New Hampshire
Displaying 1 to 10 of 12 Properties (0 foreclosures)
KW Coastal and Lakes & Mountains Realty
$625,000
3
bd /
3
ba /
2,120
sqft
83 Paulson Road
Farmington
,
New Hampshire
03835
KW Coastal and Lakes & Mountains Realty
$598,000
--
bd /
0
ba /
--
sqft
4 Central Street
Farmington
,
New Hampshire
03835
KW Coastal and Lakes & Mountains Realty
$580,000
3
bd /
2
ba /
1,798
sqft
81 Paulson Road
Farmington
,
New Hampshire
03835
Your Next Move Realty LLC
$449,900
4
bd /
1
ba /
1,744
sqft
27 Glen Street
Farmington
,
New Hampshire
03835
REMAX Home Sweet Home
$436,500
3
bd /
2
ba /
1,495
sqft
17 Viviana Drive
Farmington
,
New Hampshire
03835
RE/MAX Shoreline
$339,900
2
bd /
1
ba /
1,074
sqft
40 Summer Street
Farmington
,
New Hampshire
03835
Oceans Edge Real Estate LLC
$297,900
2
bd /
1
ba /
1,280
sqft
3 My Street
Farmington
,
New Hampshire
03835
KW Coastal and Lakes & Mountains Realty/Wolfeboro
$275,000
--
bd /
0
ba /
--
sqft
0 Nh Route 11
Farmington
,
New Hampshire
03835
REAL Broker NH, LLC
$190,000
2
bd /
1
ba /
1,151
sqft
1023 Nh Route 11
Farmington
,
New Hampshire
03835
Century 21 North East
$1,600,000
--
bd /
0
ba /
--
sqft
90.5 Places Crossing Lane
Farmington
,
New Hampshire
03835
«
‹
1
2
›
»
Cities In STRAFFORD (County), NH
Barrington
Center Strafford
Dover
Durham
Farmington
Lee
Madbury
Milton
Milton Mills
New Durham
Newington
Rochester
Rollinsford
Somersworth
Strafford
farmington
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => strafford-county [3] => NH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: strafford-county State: NH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: strafford-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 = 3125 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Anna Richards
ASCII
C21 North East
work
Call Today!
:
(603) 332-9624
I'm interested in properties in STRAFFORD (County), NH
1840963
1840963
0
Contact Me
USHUD.com on the Go!