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 Smithfield, Rhode Island
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
North Smithfield, Providence, Rhode Island
Displaying 1 to 10 of 14 Properties (1 foreclosures)
Keller Williams Realty Leading
FORECLOSURE
$825,000
2
bd /
3
ba /
1,620
sqft
2285 Providence Pike
North Smithfield
,
Rhode Island
02896
Lighthouse Real Estate Group
$999,000
4
bd /
2
ba /
3,355
sqft
57 Pond House Road
North Smithfield
,
Rhode Island
02896
Keller Williams Realty Leading
$995,000
--
bd /
0
ba /
10,828
sqft
58 Industrial Drive
North Smithfield
,
Rhode Island
02896
RE/MAX FLAGSHIP, INC.
$799,000
--
bd /
0
ba /
--
sqft
0 Brentwood Drive
North Smithfield
,
Rhode Island
02896
RE/MAX Properties
$699,900
--
bd /
0
ba /
--
sqft
3 Greenville Road
North Smithfield
,
Rhode Island
02896
RE/MAX Properties
$515,000
--
bd /
0
ba /
--
sqft
300 Buxton Road
North Smithfield
,
Rhode Island
02896
SkyView Realty
$479,900
3
bd /
2
ba /
1,170
sqft
209 Greenville Road
North Smithfield
,
Rhode Island
02896
Keller Williams Coastal
$464,900
3
bd /
1
ba /
1,505
sqft
132 Sayles Hill Road
North Smithfield
,
Rhode Island
02896
Keller Williams Realty Leading
$400,000
--
bd /
0
ba /
--
sqft
1003 Victory Highway
North Smithfield
,
Rhode Island
02896
RE/MAX Properties
$399,900
--
bd /
0
ba /
--
sqft
373 Eddie Dowling Highway
North Smithfield
,
Rhode Island
02896
«
‹
1
2
›
»
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 smithfield
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!