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] => 3302 [1] => NEW HAVEN (NORTH) [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3302 LocID: NEW HAVEN (NORTH) Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3302 Igate: njhud LocID: 3302 Region: NEW HAVEN (NORTH) 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 = 3302 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3302 [1] => NEW HAVEN (NORTH) [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3302 LocID: NEW HAVEN (NORTH) Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3302 Igate: njhud LocID: 3302 Region: NEW HAVEN (NORTH) 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 = 3302 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 3302 [1] => NEW HAVEN (NORTH) [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 3302 LocID: NEW HAVEN (NORTH) Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3302 Igate: njhud LocID: 3302 Region: NEW HAVEN (NORTH) 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 = 3302 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
New Haven (North)
| Beacon Falls, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Beacon Falls, New Haven (North), Connecticut
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Stacy Blake Realty LLC
$749,900
4
bd /
3
ba /
4,168
sqft
282 Cook Lane
Beacon Falls
,
Connecticut
06403
KW Legacy Partners
$575,000
2
bd /
2
ba /
2,140
sqft
21 Twin Oak Trail
Beacon Falls
,
Connecticut
06403
KW Legacy Partners
$530,000
2
bd /
2
ba /
1,548
sqft
61 Fieldstone Lane
Beacon Falls
,
Connecticut
06403
Vision Real Estate
$329,900
3
bd /
1
ba /
1,162
sqft
85 Blackberry Hill Road
Beacon Falls
,
Connecticut
06403
Showcase Realty, Inc.
$319,900
3
bd /
1
ba /
936
sqft
45 Summerfield Street
Beacon Falls
,
Connecticut
06770
Dave Jones Realty, LLC
$310,000
2
bd /
2
ba /
950
sqft
149 Highland Avenue
Beacon Falls
,
Connecticut
06403
Houlihan Lawrence WD
$139,900
--
bd /
0
ba /
--
sqft
198 Cook Lane
Beacon Falls
,
Connecticut
06403
RE/MAX RISE
$119,000
1
bd /
1
ba /
608
sqft
12 3rd Street
Beacon Falls
,
Connecticut
06403
RE/MAX RISE
$59,900
1
bd /
1
ba /
468
sqft
8 Second Street
Beacon Falls
,
Connecticut
06403
RE/MAX ONE
$7,750
--
bd /
0
ba /
15,500
sqft
17 Old Turnpike Road Road
Beacon Falls
,
Connecticut
06403
Cities In NEW HAVEN (NORTH), CT
Beacon Falls
Bethany
Cheshire
Hamden
Meriden
Middlebury
Naugatuck
Oxford
Prospect
Southbury
Wallingford
Waterbury
Wolcott
beacon falls
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => new-haven-north [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: new-haven-north State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: new-haven-north 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 = 3302 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
David Hughes
ASCII
Century 21 AllPoints Realty
work
Call Today!
:
(203) 525-7806
I'm interested in properties in NEW HAVEN (NORTH), CT
1846005
1846005
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => new-haven-north [3] => CT [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: new-haven-north State: CT Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: new-haven-north 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 = 3302 AND i.igate IN ('flhud','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 = 'flhud', 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 NEW HAVEN (NORTH), CT
1847320
1847320
0
Contact Me
USHUD.com on the Go!