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] => 1807 [1] => MC KINLEY [2] => NM [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1807 LocID: MC KINLEY Region: NM State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1807 Igate: njhud LocID: 1807 Region: MC KINLEY State: NM 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 = 1807 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1807 [1] => MC KINLEY [2] => NM [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1807 LocID: MC KINLEY Region: NM State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1807 Igate: njhud LocID: 1807 Region: MC KINLEY State: NM 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 = 1807 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1807 [1] => MC KINLEY [2] => NM [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1807 LocID: MC KINLEY Region: NM State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1807 Igate: njhud LocID: 1807 Region: MC KINLEY State: NM 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 = 1807 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Mexico (NM) Foreclosure Listings
|
Mc Kinley
| Ramah, New Mexico
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Ramah, Mc Kinley, New Mexico
Displaying 1 to 10 of 128 Properties (0 foreclosures)
Sandia Peak Realty
$85,000
--
bd /
0
ba /
--
sqft
Lot 23 Sunflower Drive
Ramah
,
New Mexico
87321
Sandia Peak Realty
$8,150
--
bd /
0
ba /
--
sqft
Lot 632 Edgewood Drive
Ramah
,
New Mexico
87321
Sandia Peak Realty
$8,150
--
bd /
0
ba /
--
sqft
Lot 632-a Edgewood Drive
Ramah
,
New Mexico
87321
Sandia Peak Realty
$81,312
--
bd /
0
ba /
--
sqft
North Lots - Calls Place
Ramah
,
New Mexico
87321
Berkshire Hathaway NM Prop
$80,500
--
bd /
0
ba /
--
sqft
James Valley Ranch Tract 6
Ramah
,
New Mexico
87321
Sandia Peak Realty
$8,000
--
bd /
0
ba /
--
sqft
Lot 474 Apache Drive
Ramah
,
New Mexico
87321
Sandia Peak Realty
$7,700
--
bd /
0
ba /
--
sqft
Lot 655 Gabe Road
Ramah
,
New Mexico
87321
REAL BROKER LLC
$7,500
--
bd /
0
ba /
--
sqft
353 Shade Tree Flat
Ramah
,
New Mexico
87321
Sandia Peak Realty
$7,500
--
bd /
0
ba /
--
sqft
Lot 592 Betty Lane
Ramah
,
New Mexico
87321
Coldwell Banker Legacy
$7,500
--
bd /
0
ba /
--
sqft
Old Well Road
Ramah
,
New Mexico
87321
«
‹
1
2
3
›
»
Cities In MC KINLEY, NM
Brimhall
Church Rock
Continental Divide
Crownpoint
Fort Wingate
Gallup
Gamerco
Jamestown
Mentmore
Mexican Springs
Navajo
Prewitt
Ramah
Rehoboth
Smith Lake
Thoreau
Tohatchi
Vanderwagen
Yatahey
Zuni
ramah
USHUD.com on the Go!