FROM t1 LEFT JOIN _marcas m on (t1.marca = m.id) LEFT JOIN _tipos t ON (t1.tipo = t.id) LEFT JOIN _categorias c ON (t.categoria = c.id ), t2 LEFT JOIN _paises p ON (t2.pais = p.id)
WHERE t1.online = 1 AND t1.activar = 1 AND t2.activar = 1 AND t1.es_desguace = '0' AND t2.id=t1.proveedor AND t.categoria = '8' AND t1.tipo = '80' AND t2.Pais = '150' AND t1.es_desguace = '0' AND t2.comprobado=1

373 Results

NEW HOLLAND

2003

Netherlands

21.500 €

MASSEY FERGUSON

--

Netherlands

--

FIAT

1985

Netherlands

--

FIAT

--

Netherlands

--

FIAT

--

Netherlands

6.750 €

MASSEY FERGUSON

--

Netherlands

--

FIAT

--

Netherlands

--

FIAT

1988

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

MASSEY FERGUSON

1992

Netherlands

--

FIAT

--

Netherlands

5.500 €

FIAT

--

Netherlands

5.500 €

MASSEY FERGUSON

--

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

FORD

1987

Netherlands

--

FORD

1991

Netherlands

--

FIAT

1992

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

MASSEY FERGUSON

1988

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

MASSEY FERGUSON

--

Netherlands

--

Refine your search

Advertise free your used equipment, used trucks, trailers or your used farm equipment at MinuteMachine Inc.

Place an advert