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] => 2312 [1] => PROVIDENCE [2] => RI [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2312 LocID: PROVIDENCE Region: RI State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2312 Igate: njhud LocID: 2312 Region: PROVIDENCE State: RI 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 = 2312 AND i.igate IN ('tnhud','usahud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2312 [1] => PROVIDENCE [2] => RI [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2312 LocID: PROVIDENCE Region: RI State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2312 Igate: njhud LocID: 2312 Region: PROVIDENCE State: RI 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 = 2312 AND i.igate IN ('tnhud','usahud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2312 [1] => PROVIDENCE [2] => RI [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2312 LocID: PROVIDENCE Region: RI State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2312 Igate: njhud LocID: 2312 Region: PROVIDENCE State: RI 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 = 2312 AND i.igate IN ('tnhud','usahud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Rhode Island (RI) Foreclosure Listings
|
Providence
| Woonsocket, Rhode Island
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Woonsocket, Providence, Rhode Island
Displaying 1 to 10 of 25 Properties (0 foreclosures)
Broadway Real Estate Group
$979,900
--
bd /
0
ba /
--
sqft
385 Cumberland Hill Road
Woonsocket
,
Rhode Island
02895
Lila Delman Compass
$849,900
--
bd /
0
ba /
--
sqft
2 Monument Square
Woonsocket
,
Rhode Island
02895
Williams & Stuart Real Estate
$695,000
--
bd /
0
ba /
4,787
sqft
455 Carrington Avenue
Woonsocket
,
Rhode Island
02895
Peace of Mind Prop. Mgmt & R.E
$624,900
3
bd /
2
ba /
2,042
sqft
77 Theresa Marie Avenue
Woonsocket
,
Rhode Island
02895
Peace of Mind Prop. Mgmt & R.E
$525,000
10
bd /
4
ba /
6,562
sqft
198 4th Avenue
Woonsocket
,
Rhode Island
02895
HomeSmart Professionals
$499,900
3
bd /
3
ba /
2,720
sqft
27 Montcalm Street
Woonsocket
,
Rhode Island
02895
Salzberg Real Estate Agency
$489,900
6
bd /
4
ba /
3,254
sqft
362 2nd Avenue
Woonsocket
,
Rhode Island
02895
SkyView Realty
$485,000
8
bd /
4
ba /
4,044
sqft
186 High Street
Woonsocket
,
Rhode Island
02895
VonDeckRealty, LLC
$469,900
3
bd /
2
ba /
1,378
sqft
226 St Louis Avenue
Woonsocket
,
Rhode Island
02895
RE/MAX Properties
$459,000
6
bd /
3
ba /
3,296
sqft
201 High Street
Woonsocket
,
Rhode Island
02895
«
‹
1
2
3
›
»
Cities In PROVIDENCE, RI
Albion
Central Falls
Chepachet
Clayville
Cranston
Cumberland
East Providence
Fiskeville
Forestdale
Foster
Glendale
Greenville
Harmony
Harrisville
Hope
Johnston
Lincoln
Manville
Mapleville
North Providence
North Scituate
North Smithfield
Oakland
Pascoag
Pawtucket
Providence
Riverside
Rumford
Slatersville
Smithfield
Woonsocket
woonsocket
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => providence [3] => RI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: providence State: RI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: providence State: RI 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 = 2312 AND i.igate IN ('tnhud','usahud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jessica Delmonico
ASCII
Cullen Real Estate & Appr Co
work
Call Today!
:
(401) 919-7114
I'm interested in properties in PROVIDENCE, RI
1842618
1842618
0
Contact Me
Local Mortgage Pro
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => providence [3] => RI [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: providence State: RI Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: providence State: RI 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 = 2312 AND i.igate IN ('tnhud','usahud','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 = 'tnhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Daniel E Giroux NMLS#26531
ASCII
Semper Home Loans, Inc
work
Call Today!
:
(401) 578-8929
I'm interested in properties in PROVIDENCE, RI
111105
111105
0
Contact Me
USHUD.com on the Go!