Genesis Finance Buy Now and Split the Costs with Genesis Finance Options - Limited Companies Only

Jacking & Lifting

Jacking & Lifting Banner Picture
SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '261'OR PC.CatID = '1475'OR PC.CatID = '1476'OR PC.CatID = '260'OR PC.CatID = '268'OR PC.CatID = '895'OR PC.CatID = '1183'OR PC.CatID = '267'OR PC.CatID = '280'OR PC.CatID = '281'OR PC.CatID = '283'OR PC.CatID = '279'OR PC.CatID = '542'OR PC.CatID = '543'OR PC.CatID = '290'OR PC.CatID = '298'OR PC.CatID = '773'OR PC.CatID = '1477'OR PC.CatID = '289'OR PC.CatID = '299'OR PC.CatID = '312'OR PC.CatID = '58'OR PC.CatID = '578'OR PC.CatID = '825'OR PC.CatID = '994'OR PC.CatID = '995'OR PC.CatID = '338'OR PC.CatID = '107'OR PC.CatID = '117'OR PC.CatID = '373'OR PC.CatID = '776'OR PC.CatID = '777'OR PC.CatID = '778'OR PC.CatID = '996'OR PC.CatID = '1005'OR PC.CatID = '116'OR PC.CatID = '1413'OR PC.CatID = '907'OR PC.CatID = '141'OR PC.CatID = '1172'OR PC.CatID = '993'OR PC.CatID = '1449'OR PC.CatID = '681'OR PC.CatID = '1197'OR PC.CatID = '1243'OR PC.CatID = '1196'OR PC.CatID = '906'OR PC.CatID = '1006'OR PC.CatID = '1166'OR PC.CatID = '727'OR PC.CatID = '1470'OR PC.CatID = '751'OR PC.CatID = '1268'OR PC.CatID = '1269'OR PC.CatID = '1267'OR PC.CatID = '1310'OR PC.CatID = '1274') LIMIT 0,9;
Trolley Jack 10tonne European Style

Trolley Jack 10tonne European Style

Transmission Jack 1tonne Floor

Transmission Jack 1tonne Floor

Transmission Jack 1tonne Vertical

Transmission Jack 1tonne Vertical

Transmission Jack 1tonne Vertical

Transmission Jack 1tonne Vertical

Transmission Jack 1tonne Vertical Quick Lift

Transmission Jack 1tonne Vertical Quick Lift

Trolley Jack 1.5tonne Short Chassis

Trolley Jack 1.5tonne Short Chassis

Trolley Jack 2tonne Low Entry Short Chassis - Red

Trolley Jack 2tonne Low Entry Short Chassis - Red

Trolley Jack 2tonne Low Entry Short Chassis - Blue

Trolley Jack 2tonne Low Entry Short Chassis - Blue

Trolley Jack 2tonne Low Entry Short Chassis & Accessories Bag Combo - Red

Trolley Jack 2tonne Low Entry Short Chassis & Accessories Bag Combo - Red

Page 1 of 49 pages