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
| Plymouth, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Plymouth, Litchfield, Connecticut
Displaying 1 to 10 of 32 Properties (0 foreclosures)
Todd M Carusillo RE, LLC
$1,200,000
--
bd /
0
ba /
7,088
sqft
272 Main Street
Plymouth
,
Connecticut
06786
Better Homes and Gardens Real Estate Bannon & Hebert
$569,900
4
bd /
2
ba /
2,183
sqft
456 Preston Road
Plymouth
,
Connecticut
06786
Stone Crest Realty LLC
$434,000
4
bd /
2
ba /
2,942
sqft
74 Minor Road
Plymouth
,
Connecticut
06786
Showcase Realty, Inc.
$429,900
2
bd /
1
ba /
1,598
sqft
268 Lake Plymouth Boulevard
Plymouth
,
Connecticut
06782
Fercodini Properties, Inc.
$426,000
3
bd /
1
ba /
1,624
sqft
248 South Eagle Street
Plymouth
,
Connecticut
06786
Stone Crest Realty LLC
$425,000
3
bd /
1
ba /
1,531
sqft
217 Lake Plymouth Boulevard
Plymouth
,
Connecticut
06782
eXp Realty
$399,900
3
bd /
1
ba /
1,022
sqft
91 Fall Mountain Lake Road
Plymouth
,
Connecticut
06786
Select Realty Associates, LLC
$379,900
3
bd /
2
ba /
1,497
sqft
45 South Eagle Street
Plymouth
,
Connecticut
06786
KW Legacy Partners
$375,000
3
bd /
2
ba /
2,268
sqft
41 Todd Hollow Road
Plymouth
,
Connecticut
06782
KW Legacy Partners
$375,000
4
bd /
2
ba /
1,720
sqft
6 Christine Road
Plymouth
,
Connecticut
06786
«
‹
1
2
3
›
»
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
plymouth
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => litchfield [3] => CT [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: litchfield State: CT Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: litchfield State: CT Experttype: lender 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 = '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;
Jennifer Moye NMLS#820151
ASCII
Mortgage Loan Officer Professional
work
Call Today!
:
(203) 819-1789
I'm interested in properties in LITCHFIELD, CT
1847320
1847320
0
Contact Me
USHUD.com on the Go!