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] => 3305 [1] => HARTFORD (SOUTHWEST) [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3305 LocID: HARTFORD (SOUTHWEST) Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3305 Region: HARTFORD (SOUTHWEST) State: CT 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 = 3305 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3305 [1] => HARTFORD (SOUTHWEST) [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3305 LocID: HARTFORD (SOUTHWEST) Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3305 Region: HARTFORD (SOUTHWEST) State: CT 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 = 3305 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3305 [1] => HARTFORD (SOUTHWEST) [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3305 LocID: HARTFORD (SOUTHWEST) Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3305 Region: HARTFORD (SOUTHWEST) State: CT 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 = 3305 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
Hartford (Southwest)
| Newington, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Newington, Hartford (Southwest), Connecticut
Displaying 1 to 10 of 27 Properties (1 foreclosures)
eXp Realty
FORECLOSURE
$305,000
3
bd /
1
ba /
1,040
sqft
90 Pickens Drive
Newington
,
Connecticut
06111
Century 21 AllPoints Realty
$999,999
--
bd /
0
ba /
18,000
sqft
28 Costello Place
Newington
,
Connecticut
06111
KW Legacy Partners
$500,000
--
bd /
0
ba /
6,970
sqft
25 Market Square
Newington
,
Connecticut
06111
Candlewood Realty
$470,000
4
bd /
1
ba /
1,812
sqft
217 Harding Avenue
Newington
,
Connecticut
06111
RE/MAX Precision Realty
$399,999
4
bd /
2
ba /
2,582
sqft
61 Ivy Lane
Newington
,
Connecticut
06111
RE/MAX Right Choice
$385,000
3
bd /
2
ba /
1,718
sqft
242 Beacon Street
Newington
,
Connecticut
06111
Century 21 Classic Homes
$379,900
3
bd /
1
ba /
1,182
sqft
60 Frederick Street
Newington
,
Connecticut
06111
KW Legacy Partners
$375,000
4
bd /
2
ba /
2,369
sqft
293 Old Farm Drive
Newington
,
Connecticut
06111
eXp Realty
$372,217
3
bd /
1
ba /
1,452
sqft
134 Candlewyck Drive
Newington
,
Connecticut
06111
Realty 3 CT
$330,000
3
bd /
1
ba /
1,196
sqft
58 Old Musket Drive
Newington
,
Connecticut
06111
«
‹
1
2
3
›
»
Cities In HARTFORD (SOUTHWEST), CT
Avon
Berlin
Bristol
Burlington
East Berlin
East Glastonbury
East Windsor Hill
Farmington
Manchester
New Britain
Newington
Plainville
Plantsville
Poquonock
Southington
Suffield
Unionville
West Hartford
Windsor
newington
USHUD.com on the Go!