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] => 1993 [1] => CASS [2] => ND [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1993 LocID: CASS Region: ND State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1993 Igate: njhud LocID: 1993 Region: CASS State: ND 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 = 1993 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1993 [1] => CASS [2] => ND [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1993 LocID: CASS Region: ND State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1993 Igate: njhud LocID: 1993 Region: CASS State: ND 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 = 1993 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1993 [1] => CASS [2] => ND [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1993 LocID: CASS Region: ND State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1993 Igate: njhud LocID: 1993 Region: CASS State: ND 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 = 1993 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
North Dakota (ND) Foreclosure Listings
|
Cass
| West Fargo, North Dakota
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
West Fargo, Cass, North Dakota
Displaying 1 to 6 of 6 Properties (0 foreclosures)
Better Homes and Gardens Real Estate Advantage One
$575,000
3
bd /
3
ba /
3,743
sqft
1327 Commander Drive W
West Fargo
,
North Dakota
58078
Better Homes and Gardens Real Estate Advantage One
$525,000
5
bd /
3
ba /
3,328
sqft
151 15th Avenue E
West Fargo
,
North Dakota
58078
Better Homes and Gardens Real Estate Advantage One
$514,900
5
bd /
2
ba /
3,292
sqft
424 47 Avenue W
West Fargo
,
North Dakota
58078
NextHome Legendary Properties
$475,000
4
bd /
2
ba /
2,304
sqft
1036 50th Ave W
West Fargo
,
North Dakota
58078
Better Homes and Gardens Real Estate Advantage One
$350,000
4
bd /
2
ba /
2,238
sqft
1052 39 Avenue W
West Fargo
,
North Dakota
58078
Better Homes and Gardens Real Estate Advantage One
$314,380
3
bd /
2
ba /
1,914
sqft
1144 Marlys Drive W
West Fargo
,
North Dakota
58078
Cities In CASS, ND
Absaraka
Amenia
Argusville
Arthur
Ayr
Buffalo
Casselton
Davenport
Erie
Fargo
Gardner
Grandin
Harwood
Horace
Hunter
Kindred
Leonard
Mapleton
Page
Tower City
West Fargo
Wheatland
west fargo
USHUD.com on the Go!