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)
| Multiple Cities
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Hartford (Southwest), Connecticut
Displaying 1 to 10 of 413 Properties (8 foreclosures)
eXp Realty
FORECLOSURE
$799,900
5
bd /
4
ba /
5,448
sqft
28 Lincoln Street
Berlin
,
Connecticut
06037
Sullivan Real Estate Inc
FORECLOSURE
$350,000
3
bd /
2
ba /
2,060
sqft
168 Deer Run
Burlington
,
Connecticut
06013
A-Gold Action Realty
FORECLOSURE
$319,900
3
bd /
2
ba /
1,536
sqft
43 Roosevelt Street
New Britain
,
Connecticut
06051
eXp Realty
FORECLOSURE
$305,000
3
bd /
1
ba /
1,040
sqft
90 Pickens Drive
Newington
,
Connecticut
06111
Homes Plus of Connecticut
FORECLOSURE
$229,900
3
bd /
1
ba /
1,093
sqft
28 Talmadge Street
Bristol
,
Connecticut
06010
CENTURY 21 MASELLE & ASSOCIATES
FORECLOSURE
$174,900
1
bd /
1
ba /
488
sqft
85 Peck St
Berlin
,
Connecticut
06037
Coldwell Banker Calabro
FORECLOSURE
$174,900
1
bd /
1
ba /
608
sqft
85 Peck Street
Berlin
,
Connecticut
06037
Century 21 AllPoints Realty
$999,999
--
bd /
0
ba /
18,000
sqft
28 Costello Place
Newington
,
Connecticut
06111
SalCal Real Estate Connections
$999,990
4
bd /
2
ba /
3,191
sqft
44 Bagno Drive
Southington
,
Connecticut
06489
Realty 3 CT
$99,999
--
bd /
0
ba /
--
sqft
672 Arch Street
New Britain
,
Connecticut
06051
«
‹
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
USHUD.com on the Go!