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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Rhode Island (RI) Foreclosure Listings
|
Providence
| North Providence, Rhode Island
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
North Providence, Providence, Rhode Island
Displaying 1 to 10 of 38 Properties (1 foreclosures)
Westcott Properties
FORECLOSURE
$384,900
2
bd /
2
ba /
1,440
sqft
76 Valley Green Court
North Providence
,
Rhode Island
02904
Keller Williams Realty Leading
$979,900
--
bd /
0
ba /
8,853
sqft
1174 Douglas Avenue
North Providence
,
Rhode Island
02904
BHHS Pinnacle Realty
$700
--
bd /
0
ba /
--
sqft
1815 Mineral Spring Avenue
North Providence
,
Rhode Island
02904
BHHS Pinnacle Realty
$699,999
3
bd /
2
ba /
2,184
sqft
24 Carriage Way
North Providence
,
Rhode Island
02904
Keller Williams Realty Leading
$630,000
5
bd /
3
ba /
1,654
sqft
2 Terry Street
North Providence
,
Rhode Island
02904
Keller Williams Realty Leading
$6,000
--
bd /
0
ba /
1,400
sqft
1700 Mineral Spring Avenue
North Providence
,
Rhode Island
02904
Realty ONE Group Executives
$599,000
3
bd /
2
ba /
1,985
sqft
40 Rosner Avenue
North Providence
,
Rhode Island
02904
RE/MAX Professionals
$520,000
3
bd /
2
ba /
1,716
sqft
184 Smithfield Road
North Providence
,
Rhode Island
02904
RE/MAX Preferred
$519,900
3
bd /
2
ba /
1,695
sqft
2 Meadow View Boulevard
North Providence
,
Rhode Island
02904
RE/MAX Professionals
$499,900
2
bd /
2
ba /
1,536
sqft
15 Meadow View Boulevard
North Providence
,
Rhode Island
02904
«
‹
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
north providence
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 ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Dan Saffer
ASCII
PVD Properties
work
Call Today!
:
(401) 954-4811
I'm interested in properties in PROVIDENCE, RI
1837435
1837435
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 ('ilhud','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 = 'ilhud', 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!