Title Page Background
HFQUERY 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 = 1801 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1801 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1801 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

157 Acequia Road
Animas, NM 88020
Keith Brownfield with Better Homes and Gardens Real Estate Steinborn & Associates, original listing - (575) 522-3698

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $687,000
Beds: 3
Baths: Full: 1, ½: 1, ¾: 1
Status: Active
SqFt: 2700 Square Feet
Agency: Better Homes and Gardens Real Estate Steinborn & Associates
Agency Phone: (575) 522-3698

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 252 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: 157 Acequia Road located in Animas, NM with the Cotton City Allotment 400 Acres of BLM, 250 acres of deeded land with a carrying capacity of 84 AUM &/or 7 AYL which includes a 2700+/- square foot home including the downstairs basement, this home has an open floor plan with a country kitchen, tile throughout the home, doors are handicap accessible, brand new refrigerated-air, metal roof, 3 bedroom, 2.5 bathrooms, walk-in shower in the master bedroom, large kitchen with pantry, large laundry room, Shop 40' x 60' metal barn, plumbed for a living area/bathroom (could be an In-law apartment in the Shop). PLUS!!! A large carport 52' x 30' with over hangs 12'x 30' and 11' x 30' along with a hay barn, covered pens/stalls and shed row made out of a Quonset hut and storage/barn south of the house and corrals, with water located in the center of four metal pens, alley and chute, three earthen tanks. The arena has been removed, However, the sellers have spent over $12,000.00 in dirt/sand, the arena has lights.
MlsNumber: --
ListingId: 2401515


Listing Provided By: Better Homes and Gardens Real Estate Steinborn & Associates, original listing
Phone: (575) 640-9395
Office Phone: (575) 522-3698
Agent Name: Keith Brownfield
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App