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] => 2220 [1] => KLAMATH [2] => OR [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2220 LocID: KLAMATH Region: OR State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2220 Igate: njhud LocID: 2220 Region: KLAMATH State: OR 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 = 2220 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2220 [1] => KLAMATH [2] => OR [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2220 LocID: KLAMATH Region: OR State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2220 Igate: njhud LocID: 2220 Region: KLAMATH State: OR 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 = 2220 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 2220 [1] => KLAMATH [2] => OR [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 2220 LocID: KLAMATH Region: OR State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2220 Igate: njhud LocID: 2220 Region: KLAMATH State: OR 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 = 2220 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
Oregon (OR) Foreclosure Listings
|
Klamath
| Crescent, Oregon
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Crescent, Klamath, Oregon
Displaying 1 to 10 of 15 Properties (0 foreclosures)
Crescent Lake Realty, Inc
$779,000
3
bd /
2
ba /
2,028
sqft
14105 Red Cone Dr
Crescent
,
Oregon
97733
Crescent Lake Realty LLC
$65,900
--
bd /
0
ba /
--
sqft
Hwy 97
Crescent
,
Oregon
97733
Crescent Lake Realty, Inc
$550,000
--
bd /
0
ba /
3,960
sqft
136854 N Highway 97
Crescent
,
Oregon
97733
Crescent Lake Realty LLC
$550,000
--
bd /
0
ba /
--
sqft
136854 Us-97
Crescent
,
Oregon
97733
Dennis Haniford's Cascade Realty
$498,700
3
bd /
2
ba /
1,680
sqft
135 Ozmar Lane
Crescent
,
Oregon
97733
Land and Wildlife LLC - Medford
$4,100,000
--
bd /
0
ba /
--
sqft
21501 East Odell Rd
Crescent
,
Oregon
97733
Crescent Lake Realty LLC
$329,000
2
bd /
1
ba /
1,500
sqft
136556 W Friendly Lane
Crescent
,
Oregon
97733
Crescent Lake Realty, Inc
$329,000
1
bd /
1
ba /
1,500
sqft
136556 W Friendly Ln
Crescent
,
Oregon
97733
Dennis Haniford's Cascade Realty
$285,000
2
bd /
2
ba /
1,512
sqft
1800 Schoonover
Crescent
,
Oregon
97733
eXp Realty, LLC
$279,000
3
bd /
2
ba /
1,440
sqft
136028 Highway 97
Crescent
,
Oregon
97733
«
‹
1
2
›
»
Cities In KLAMATH, OR
Beatty
Bly
Bonanza
Chemult
Chiloquin
Crater Lake
Crescent
Dairy
Fort Klamath
Gilchrist
Keno
Klamath Falls
Malin
Merrill
Midland
Sprague River
crescent
Local Real Estate Expert
DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => klamath [3] => OR [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: klamath State: OR Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: klamath State: OR 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 = 2220 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Elizabeth Eagleton
ASCII
Coldwell Banker Holman Premier Realty
work
Call Today!
:
(541) 891-6393
I'm interested in properties in KLAMATH, OR
1841164
1841164
0
Contact Me
USHUD.com on the Go!