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] => 314 [1] => NEW LONDON [2] => CT [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 314 LocID: NEW LONDON Region: CT State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 314 Igate: njhud LocID: 314 Region: NEW LONDON 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 = 314 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 314 [1] => NEW LONDON [2] => CT [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 314 LocID: NEW LONDON Region: CT State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 314 Igate: njhud LocID: 314 Region: NEW LONDON 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 = 314 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 314 [1] => NEW LONDON [2] => CT [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 314 LocID: NEW LONDON Region: CT State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 314 Igate: njhud LocID: 314 Region: NEW LONDON 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 = 314 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Connecticut (CT) Foreclosure Listings
|
New London
| Stonington, Connecticut
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Stonington, New London, Connecticut
Displaying 1 to 10 of 37 Properties (0 foreclosures)
Compass Connecticut, LLC
$3,200,000
5
bd /
4
ba /
2,637
sqft
11 Hancox Street
Stonington
,
Connecticut
06378
RE/MAX ONE
$2,990,000
12
bd /
6
ba /
6,811
sqft
56-58 East Main Street
Stonington
,
Connecticut
06355
RE/MAX Coast and Country
$2,685,000
3
bd /
3
ba /
2,563
sqft
52 Old North Road
Stonington
,
Connecticut
06355
William Pitt Sotheby's Int'l
$1,910,000
3
bd /
3
ba /
2,600
sqft
186 Flanders Road
Stonington
,
Connecticut
06378
Compass Connecticut, LLC
$1,875,000
4
bd /
3
ba /
6,088
sqft
360 New London Turnpike
Stonington
,
Connecticut
06378
Compass Connecticut, LLC
$1,550,000
3
bd /
2
ba /
2,094
sqft
9 Money Point Road
Stonington
,
Connecticut
06355
RE/MAX ONE
$1,200,000
--
bd /
0
ba /
5,665
sqft
132 Liberty Street
Stonington
,
Connecticut
06379
RE/MAX Coast and Country
$1,200,000
4
bd /
4
ba /
4,930
sqft
67 High Ridge Drive
Stonington
,
Connecticut
06379
IMT Realty
$900,000
4
bd /
1
ba /
2,520
sqft
298 Elm Street
Stonington
,
Connecticut
06378
RE/MAX Coast and Country
$890,000
6
bd /
3
ba /
2,133
sqft
218 North Water Street
Stonington
,
Connecticut
06378
«
‹
1
2
3
›
»
Cities In NEW LONDON, CT
Baltic
Bozrah
Colchester
East Lyme
Gales Ferry
Gilman
Groton
Hadlyme
Hanover
Jewett City
Lebanon
Ledyard
Mashantucket
Montville
Mystic
New London
Niantic
North Franklin
North Stonington
North Westchester
Norwich
Oakdale
Old Lyme
Old Mystic
Pawcatuck
Preston
Quaker Hill
Salem
South Lyme
Stonington
Taftville
Uncasville
Versailles
Voluntown
Waterford
West Mystic
Yantic
stonington
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => new-london [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: new-london State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: new-london 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 = 314 AND i.igate IN ('alhud','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 = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jennifer Obrey
ASCII
RE/MAX Legends
work
Call Today!
:
(860) 625-3824
I'm interested in properties in NEW LONDON, CT
1842564
1842564
0
Contact Me
USHUD.com on the Go!