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 ('ohhud','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 = 'ohhud', 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 ('ohhud','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 = 'ohhud', 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 ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
Litchfield
| Norfolk, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Norfolk, Litchfield, Connecticut
Displaying 1 to 10 of 13 Properties (0 foreclosures)
Compass Connecticut, LLC
$8,750,000
5
bd /
4
ba /
8,240
sqft
841 Winchester Road
Norfolk
,
Connecticut
06058
William Pitt Sotheby's Int'l
$5,200,000
6
bd /
7
ba /
5,671
sqft
210 Doolittle Drive
Norfolk
,
Connecticut
06058
William Pitt Sotheby's Int'l
$5,000,000
--
bd /
0
ba /
--
sqft
00 Winchester Road
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$1,290,000
--
bd /
0
ba /
--
sqft
00 Greenwoods Road East
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$1,275,000
4
bd /
3
ba /
2,850
sqft
243 Schoolhouse Road
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$549,000
2
bd /
2
ba /
2,304
sqft
7 Beacon Lane
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$450,000
2
bd /
2
ba /
1,344
sqft
321 Litchfield Road
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$285,000
--
bd /
0
ba /
--
sqft
649 Litchfield Road
Norfolk
,
Connecticut
06058
Northwest CT Realty
$225,000
2
bd /
1
ba /
1,032
sqft
226 Greenwoods Road West
Norfolk
,
Connecticut
06058
Elyse Harney Real Estate
$150,000
--
bd /
0
ba /
--
sqft
0 Old Colony Road
Norfolk
,
Connecticut
06058
«
‹
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
norfolk
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 ('ohhud','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 = 'ohhud', 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!