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] => 311 [1] => LITCHFIELD [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 311 LocID: LITCHFIELD Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 311 Igate: njhud LocID: 311 Region: LITCHFIELD 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 = 311 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 311 [1] => LITCHFIELD [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 311 LocID: LITCHFIELD Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 311 Igate: njhud LocID: 311 Region: LITCHFIELD 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 = 311 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 311 [1] => LITCHFIELD [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 311 LocID: LITCHFIELD Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 311 Igate: njhud LocID: 311 Region: LITCHFIELD 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 = 311 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
Litchfield
| Thomaston, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Thomaston, Litchfield, Connecticut
Displaying 1 to 10 of 17 Properties (0 foreclosures)
SH Properties
$995
--
bd /
0
ba /
990
sqft
288 South Main Street
Thomaston
,
Connecticut
06787
SH Properties
$960
--
bd /
0
ba /
640
sqft
59 River Street
Thomaston
,
Connecticut
06787
Showcase Realty, Inc.
$700,000
--
bd /
0
ba /
13,093
sqft
14 Park Street
Thomaston
,
Connecticut
06787
Showcase Realty, Inc.
$599,900
4
bd /
3
ba /
3,064
sqft
61 Martha's Way
Thomaston
,
Connecticut
06787
Showcase Realty, Inc.
$589,900
3
bd /
2
ba /
2,292
sqft
44 Ada Drive
Thomaston
,
Connecticut
06787
Stone Crest Realty LLC
$410,000
3
bd /
1
ba /
2,198
sqft
939 Hickory Hill Road
Thomaston
,
Connecticut
06787
Stone Crest Realty LLC
$399,900
2
bd /
2
ba /
1,436
sqft
22 Stevens Boulevard
Thomaston
,
Connecticut
06787
Executive Real Estate Inc.
$399,900
3
bd /
2
ba /
2,000
sqft
76 Hotchkiss Avenue
Thomaston
,
Connecticut
06787
Showcase Realty, Inc.
$380,000
3
bd /
2
ba /
1,816
sqft
110 Grabherr Road
Thomaston
,
Connecticut
06787
Coldwell Banker Premier Real Estate
$335,000
4
bd /
2
ba /
1,782
sqft
80 Woodruff Avenue
Thomaston
,
Connecticut
06787
«
‹
1
2
›
»
Cities In LITCHFIELD, CT
Bantam
Barkhamsted
Bethlehem
Bridgewater
Canaan
Colebrook
Cornwall
Cornwall Bridge
East Canaan
Falls Village
Gaylordsville
Goshen
Harwinton
Kent
Lakeside
Lakeville
Litchfield
Morris
New Hartford
New Milford
New Preston Marble Dale
Norfolk
Northfield
Oakville
Pequabuck
Pine Meadow
Plymouth
Riverton
Roxbury
Salisbury
Sharon
South Kent
Taconic
Terryville
Thomaston
Torrington
Washington
Washington Depot
Watertown
West Cornwall
Winchester Center
Winsted
Woodbury
thomaston
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => litchfield [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: litchfield State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: litchfield 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 = 311 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Scott Bayne
ASCII
Century 21 Bay-Mar Realty Inc
work
Call Today!
:
(860) 582-7404
I'm interested in properties in LITCHFIELD, CT
1842018
1842018
0
Contact Me
USHUD.com on the Go!