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] => 312 [1] => MIDDLESEX [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 312 LocID: MIDDLESEX Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: MIDDLESEX 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 = 312 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] => 312 [1] => MIDDLESEX [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 312 LocID: MIDDLESEX Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: MIDDLESEX 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 = 312 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] => 312 [1] => MIDDLESEX [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 312 LocID: MIDDLESEX Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: MIDDLESEX 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 = 312 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
|
Middlesex
| Old Saybrook, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Old Saybrook, Middlesex, Connecticut
Displaying 1 to 10 of 37 Properties (0 foreclosures)
William Pitt Sotheby's Int'l
$3,400,000
4
bd /
3
ba /
4,768
sqft
9 Whisper Cove Road
Old Saybrook
,
Connecticut
06475
Showcase Realty, Inc.
$3,100,000
3
bd /
3
ba /
4,789
sqft
372 Maple Avenue
Old Saybrook
,
Connecticut
06475
JJManning Auctioneers
$2,950,000
--
bd /
0
ba /
--
sqft
220 Middlesex Tpke
Old Saybrook
,
Connecticut
06475
Calcagni Real Estate
$1,895,000
3
bd /
3
ba /
2,500
sqft
2 Old South Cove Road
Old Saybrook
,
Connecticut
06475
Better Homes and Gardens Real Estate Bannon & Hebert
$1,895,000
4
bd /
4
ba /
3,556
sqft
9 Overlook Drive
Old Saybrook
,
Connecticut
06475
William Pitt Sotheby's Int'l
$1,500,000
4
bd /
2
ba /
3,529
sqft
20 Otter Cove Drive
Old Saybrook
,
Connecticut
06475
William Pitt Sotheby's Int'l
$1,299,000
3
bd /
3
ba /
2,132
sqft
15 Buckingham Avenue
Old Saybrook
,
Connecticut
06475
KW Legacy Partners
$1,085,000
2
bd /
2
ba /
1,952
sqft
24 Seabreeze Road
Old Saybrook
,
Connecticut
06475
REMAX Valley Shore
$995,000
--
bd /
0
ba /
3,177
sqft
103 Main Street
Old Saybrook
,
Connecticut
06475
William Pitt Sotheby's Int'l
$895,000
3
bd /
2
ba /
2,424
sqft
11 Crest Road
Old Saybrook
,
Connecticut
06475
«
‹
1
2
3
›
»
Cities In MIDDLESEX, CT
Centerbrook
Chester
Clinton
Cobalt
Cromwell
Deep River
Durham
East Haddam
East Hampton
Essex
Haddam
Higganum
Ivoryton
Killingworth
Middle Haddam
Middlefield
Middletown
Moodus
Old Saybrook
Portland
Rockfall
Westbrook
old saybrook
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => middlesex [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: middlesex State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: middlesex 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 = 312 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;
Claudia O'Connell
ASCII
William Raveis
work
Call Today!
:
(860) 716-0166
I'm interested in properties in MIDDLESEX, CT
1845936
1845936
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => middlesex [3] => CT [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: middlesex State: CT Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: middlesex 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 = 312 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;
Ken Kasek NMLS# 116928
ASCII
Crown Home Mortgage
work
Call Today!
:
(860) 559-8328
I'm interested in properties in MIDDLESEX, CT
1835218
1835218
0
Contact Me
USHUD.com on the Go!