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','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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
| Cranston, Rhode Island
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Cranston, Providence, Rhode Island
Displaying 1 to 10 of 64 Properties (0 foreclosures)
RE/MAX Preferred
$949,900
4
bd /
2
ba /
3,586
sqft
35 Falcon Lane
Cranston
,
Rhode Island
02921
HERE Realty
$899,900
4
bd /
4
ba /
6,753
sqft
224 Armington Street
Cranston
,
Rhode Island
02905
HomeSmart Professionals
$774,900
4
bd /
3
ba /
3,412
sqft
74 Mountain Laurel Drive
Cranston
,
Rhode Island
02920
Compass
$719,900
3
bd /
2
ba /
2,594
sqft
11 West Blue Ridge Road
Cranston
,
Rhode Island
02920
RE/MAX 1st Choice
$689,900
3
bd /
2
ba /
2,475
sqft
331 Hope Road
Cranston
,
Rhode Island
02921
Westcott Properties
$629,900
3
bd /
3
ba /
1,685
sqft
2 Perpali Lane
Cranston
,
Rhode Island
02920
Your Home Sold Guaranteed Realty, The Nathan Clark Team
$599,900
5
bd /
2
ba /
2,986
sqft
295 Main Street
Cranston
,
Rhode Island
02831
Residential Properties Ltd.
$599,000
4
bd /
1
ba /
1,578
sqft
2038 Broad Street
Cranston
,
Rhode Island
02905
Your Home Sold Guaranteed Realty, The Nathan Clark Team
$599,000
3
bd /
1
ba /
2,190
sqft
21 Strawberry Lane
Cranston
,
Rhode Island
02921
RE/MAX Properties
$569,900
5
bd /
2
ba /
2,224
sqft
62 Canonchet Trail
Cranston
,
Rhode Island
02921
«
‹
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
cranston
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','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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!