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] => 316 [1] => WINDHAM [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 316 LocID: WINDHAM Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 316 Igate: njhud LocID: 316 Region: WINDHAM 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 = 316 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 316 [1] => WINDHAM [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 316 LocID: WINDHAM Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 316 Igate: njhud LocID: 316 Region: WINDHAM 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 = 316 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 316 [1] => WINDHAM [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 316 LocID: WINDHAM Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 316 Igate: njhud LocID: 316 Region: WINDHAM 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 = 316 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
Windham
| Pomfret, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Pomfret, Windham, Connecticut
Displaying 1 to 10 of 12 Properties (1 foreclosures)
RE/MAX Bell Park Realty
FORECLOSURE
$205,000
--
bd /
0
ba /
2,725
sqft
500 Hampton Road
Pomfret
,
Connecticut
06230
RE/MAX Bell Park Realty
$1,400,000
4
bd /
4
ba /
7,136
sqft
562 Taft Pond Road
Pomfret
,
Connecticut
06259
CR Premier Properties
$699,000
3
bd /
2
ba /
2,540
sqft
11 Anderson Road
Pomfret
,
Connecticut
06259
CR Premier Properties
$595,000
4
bd /
3
ba /
2,644
sqft
13 Brooklyn Road
Pomfret
,
Connecticut
06259
CR Premier Properties
$549,900
3
bd /
2
ba /
2,686
sqft
7 Margaret Circle
Pomfret
,
Connecticut
06259
Real Broker CT, LLC
$449,900
4
bd /
2
ba /
1,903
sqft
44 Rich Road
Pomfret
,
Connecticut
06230
RE/MAX Bell Park Realty
$300,000
--
bd /
0
ba /
--
sqft
384 Killingly Road
Pomfret
,
Connecticut
06259
RE/MAX Bell Park Realty
$275,000
2
bd /
1
ba /
1,452
sqft
21 Clinic Road
Pomfret
,
Connecticut
06230
Duprey Real Estate, LLC
$250,000
2
bd /
2
ba /
2,240
sqft
338 A Brooklyn Road
Pomfret
,
Connecticut
06259
Century 21 Limitless Prg
$249,900
--
bd /
0
ba /
--
sqft
276 Killingly Road
Pomfret
,
Connecticut
06259
«
‹
1
2
›
»
Cities In WINDHAM, CT
Abington
Ashford
Ballouville
Brooklyn
Canterbury
Central Village
Chaplin
Danielson
Dayville
East Killingly
East Woodstock
Eastford
Fabyan
Grosvenor Dale
Hampton
Moosup
North Grosvenordale
North Windham
Oneco
Plainfield
Pomfret
Pomfret Center
Putnam
Quinebaug
Rogers
Scotland
South Windham
South Woodstock
Sterling
Thompson
Wauregan
Willimantic
Windham
Woodstock
Woodstock Valley
pomfret
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => windham [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: windham State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: windham State: CT 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 = 316 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Leondra Amin
ASCII
Coldwell Banker Realty
work
Call Today
:
(203) 526-1851
I'm interested in properties in WINDHAM, CT
1840301
1840301
0
Contact Me
USHUD.com on the Go!