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] => 2965 [1] => WHITMAN [2] => WA [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2965 LocID: WHITMAN Region: WA State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2965 Igate: njhud LocID: 2965 Region: WHITMAN State: WA 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 = 2965 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2965 [1] => WHITMAN [2] => WA [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2965 LocID: WHITMAN Region: WA State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2965 Igate: njhud LocID: 2965 Region: WHITMAN State: WA 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 = 2965 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2965 [1] => WHITMAN [2] => WA [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2965 LocID: WHITMAN Region: WA State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2965 Igate: njhud LocID: 2965 Region: WHITMAN State: WA 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 = 2965 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Washington (WA) Foreclosure Listings
|
Whitman
| Colfax, Washington
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Colfax, Whitman, Washington
Displaying 1 to 10 of 23 Properties (0 foreclosures)
Woodbridge Real Estate
$975,000
5
bd /
2
ba /
4,835
sqft
3202 S Palouse River Road
Colfax
,
Washington
99111
United Country Real Estate - Team Washington
$675,000
3
bd /
2
ba /
1,725
sqft
204 Red Tail Ridge Rd
Colfax
,
Washington
99111
Woodbridge Real Estate
$535,000
5
bd /
2
ba /
3,450
sqft
1751 Sr 23
Colfax
,
Washington
99111
Woodbridge Real Estate
$489,000
--
bd /
0
ba /
--
sqft
Tbd Cherry St
Colfax
,
Washington
99111
Woodbridge Real Estate
$469,000
4
bd /
1
ba /
3,162
sqft
107 W Fairview St
Colfax
,
Washington
99111-1512
United Country Real Estate - Team Washington
$450,000
5
bd /
1
ba /
1,947
sqft
708 S Crestview St
Colfax
,
Washington
99111
Woodbridge Real Estate
$430,000
5
bd /
3
ba /
2,907
sqft
904 S Mill St.
Colfax
,
Washington
99111
Woodbridge Real Estate
$425,000
5
bd /
0
ba /
4,626
sqft
1002 S Mill St
Colfax
,
Washington
99163
United Country Real Estate - Team Washington
$418,500
4
bd /
2
ba /
2,688
sqft
809 S Mill St
Colfax
,
Washington
99111
Latah Realty, LLC
$369,000
3
bd /
2
ba /
1,622
sqft
914 S Meadow
Colfax
,
Washington
99111
«
‹
1
2
3
›
»
Cities In WHITMAN, WA
Albion
Belmont
Colfax
Colton
Endicott
Farmington
Garfield
Hay
Hooper
Lacrosse
Lamont
Malden
Oakesdale
Palouse
Pullman
Rosalia
Saint John
Steptoe
Tekoa
Thornton
Uniontown
colfax
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => whitman [3] => WA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: whitman State: WA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: whitman State: WA 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 = 2965 AND i.igate IN ('wahud','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 = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jordan Vorderbrueggen
ASCII
Woodbridge Real Estate
work
Call Today!
:
(509) 288-0082
I'm interested in properties in WHITMAN, WA
1845879
1845879
0
Contact Me
USHUD.com on the Go!