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 ('nyhud','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 = 'nyhud', 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 ('nyhud','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 = 'nyhud', 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 ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
Litchfield
| Goshen, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Goshen, Litchfield, Connecticut
Displaying 1 to 10 of 23 Properties (0 foreclosures)
J. Thomas Mettling
$4,450,000
--
bd /
0
ba /
--
sqft
0 Reservoir Rd And Pie Hill Rd Road
Goshen
,
Connecticut
06756
William Pitt Sotheby's Int'l
$2,095,000
4
bd /
3
ba /
3,364
sqft
197 West Hyerdale Drive
Goshen
,
Connecticut
06756
William Pitt Sotheby's Int'l
$1,575,000
5
bd /
3
ba /
4,184
sqft
42 Pond Ridge Road
Goshen
,
Connecticut
06756
Marrin Santore Realty LLC
$1,400,000
4
bd /
3
ba /
1,989
sqft
187 Sherbrook Drive
Goshen
,
Connecticut
06756
Real Estate Advisory Group LLC
$899,999
3
bd /
1
ba /
1,076
sqft
19 Tyler Lake Heights Extension
Goshen
,
Connecticut
06756
E.J. Murphy Realty
$895,000
3
bd /
2
ba /
2,238
sqft
109 East Street North
Goshen
,
Connecticut
06756
E.J. Murphy Realty
$760,000
4
bd /
2
ba /
3,560
sqft
2 Whispering Pines Lane
Goshen
,
Connecticut
06756
E.J. Murphy Realty
$749,000
3
bd /
3
ba /
3,402
sqft
21 Bexley Court
Goshen
,
Connecticut
06756
William Pitt Sotheby's Int'l
$697,000
3
bd /
1
ba /
1,847
sqft
196 East Street North
Goshen
,
Connecticut
06756
E.J. Murphy Realty
$685,000
4
bd /
3
ba /
2,736
sqft
434 East Hyerdale Drive
Goshen
,
Connecticut
06756
«
‹
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
goshen
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 ('nyhud','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 = 'nyhud', 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!