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 ('okhud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 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 ('okhud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 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 ('okhud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
North Dakota (ND) Foreclosure Listings
|
Cass
| Fargo, North Dakota
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Fargo, Cass, North Dakota
Displaying 1 to 10 of 38 Properties (0 foreclosures)
Better Homes and Gardens Real Estate Advantage One
$1,499,000
5
bd /
3
ba /
4,798
sqft
4109 66 Street S
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$839,900
6
bd /
4
ba /
4,394
sqft
6035 27th Street S
Fargo
,
North Dakota
58104
NextHome Legendary Properties
$739,050
2
bd /
1
ba /
1,895
sqft
4470 24th Avenue South
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$599,900
4
bd /
3
ba /
3,166
sqft
5891 41st Street S
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$599,000
4
bd /
3
ba /
3,166
sqft
5893 41st Street S
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$489,900
4
bd /
3
ba /
2,429
sqft
5889 41st Street S
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$477,000
4
bd /
4
ba /
3,513
sqft
2902 3rd Street N
Fargo
,
North Dakota
58102
Better Homes and Gardens Real Estate Advantage One
$449,900
3
bd /
3
ba /
2,419
sqft
5889 41 Street S
Fargo
,
North Dakota
58104
Better Homes and Gardens Real Estate Advantage One
$449,000
4
bd /
3
ba /
2,808
sqft
3449 26th Avenue S
Fargo
,
North Dakota
58103
Better Homes and Gardens Real Estate Advantage One
$433,975
4
bd /
3
ba /
2,534
sqft
6669 Belding Dr S
Fargo
,
North Dakota
58104
«
‹
1
2
3
›
»
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
fargo
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cass [3] => ND [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cass State: ND Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cass State: ND 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 = 1993 AND i.igate IN ('okhud','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 = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Barry Gruchow
ASCII
The Gruchow Group by RE/MAX Legacy Realty
work
Call Today!
:
(701) 200-9801
I'm interested in properties in CASS, ND
1842203
1842203
0
Contact Me
USHUD.com on the Go!