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 = 1793 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 = 1793 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 = 1793 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;

801 E Cook Ave
Raton, NM 87740
Jessica Roybal with Willow Springs Realty & Property Management LLC, original listing - (505) 309-1851

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $360,000
Beds: --
Baths: ½: 2
Status: Active
SqFt: 1323 Square Feet
Agency: Willow Springs Realty & Property Management LLC
Agency Phone: (505) 309-1851

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Commercial Sale-Other
Year Built: --
Notes: INCLUDED IN SALE-EQUIPMENT AND TOOL LIST: 4 Camera Surveillance system/ can add 4 more camera's, 1996 Ford F150 125,000 miles shop truck runs Great. Karcher Gas Power Washer, Old School Manuel Bumper Jack works great, 2- 3 Ton Floor Jacks, 30w x 55h Role away too box 3 sections, 6x3/4 Bench Grinder Craftsman 6x3/4 x 1/2 in with light, 66hx77w Role away Tool box full of tools,1 Floor Creeper Snap on-1 craftsman creeper ,cherry picker engine hoist, 30 gallon solvent tank, role away equipment cart, transmission jack, 3 sets of jack stands. fox battery charger, chop saw and stand with metal cut off blades, 30x30 utility fan,Equipment Dolly, Hydraulic Car Lift , Club Car Golf Cart, Snap on Compressor(Little red Convertible) Engine Stand,Metal Cabinet,Oil& Anti Freeze Rack, 7Gallon Hand held Air Tank, Microwave, Fire Place 30x26, Storage Bench, 30x30 Table with 3 chairs/2stools end table.
MlsNumber: --
ListingId: 11382258


Listing Provided By: Willow Springs Realty & Property Management LLC, original listing
Phone: (505) 309-1851
Office Phone: (505) 309-1851
Agent Name: Jessica Roybal
Disclaimer: Copyright © 2024 My State MLS. 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