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] => 1809 [1] => OTERO [2] => NM [3] => agent [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1809 LocID: OTERO Region: NM State: agent Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1809 Region: OTERO 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 = 1809 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1809 [1] => OTERO [2] => NM [3] => lender [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1809 LocID: OTERO Region: NM State: lender Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1809 Region: OTERO 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 = 1809 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
DEBUG FN args: Array ( [0] => 1809 [1] => OTERO [2] => NM [3] => other [4] => 1 [5] => 1 [6] => [7] => 2 ) BEFORE: Site: 1809 LocID: OTERO Region: NM State: other Experttype: 1 Expertnum: 1 ProcessOverride: SearchNearby: 2 DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1809 Region: OTERO 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 = 1809 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;
<< Go Back
|
All Foreclosures
|
New Mexico (NM) Foreclosure Listings
|
Otero
| Tularosa, New Mexico
×
Contact an Expert!
Don't do it on your own, let our experts help!
Your Name:
Email:
Phone:
Message:
Send Email
Tularosa, Otero, New Mexico
Displaying 1 to 10 of 10 Properties (0 foreclosures)
Future Real Estate
$90,000
--
bd /
0
ba /
--
sqft
12 Mirasol Ln
Tularosa
,
New Mexico
88352
Cripple Creek Realty, LLC
$650,000
--
bd /
0
ba /
--
sqft
63 S Bookout Road
Tularosa
,
New Mexico
88352
Keller Williams Realty
$460,000
2
bd /
1
ba /
1,680
sqft
1350 Higuera Avenue
Tularosa
,
New Mexico
88352
Future Real Estate
$375,000
4
bd /
2
ba /
2,093
sqft
10 Estancia Rd
Tularosa
,
New Mexico
88352
Future Real Estate
$270,000
3
bd /
2
ba /
1,442
sqft
600 Calle Del Flor
Tularosa
,
New Mexico
88352
Future Real Estate
$206,300
3
bd /
2
ba /
1,568
sqft
49 Angel Ln
Tularosa
,
New Mexico
88352
Future Real Estate
$184,900
--
bd /
0
ba /
--
sqft
0000 Us Hwy 54/70
Tularosa
,
New Mexico
88352
Future Real Estate
$179,000
--
bd /
0
ba /
1,032
sqft
7703 Us Hwy 70
Tularosa
,
New Mexico
88352
Cripple Creek Realty, LLC
$159,900
3
bd /
2
ba /
1,400
sqft
1101 Lawrence Drive
Tularosa
,
New Mexico
88352
Future Real Estate
$146,000
3
bd /
1
ba /
1,281
sqft
212 Sierra Blanca Ave
Tularosa
,
New Mexico
88352
Cities In OTERO, NM
Alamogordo
Bent
Cloudcroft
High Rolls Mountain Park
Holloman Air Force Base
La Luz
Mayhill
Mescalero
Orogrande
Pinon
Sacramento
Sunspot
Timberon
Tularosa
Weed
tularosa
USHUD.com on the Go!