Home
About Us
Nationwide Installation
Delivery Times & Costs
Chameleon Price Promise
Customer Feedback
FCS Silver Award Scheme
MPT1362 Code of Practice
Privacy Statement
View Basket
Blog | Tech
Contact Us
LIVE CHAT
Log In
or
Register
Advanced Search
Your cart is empty
Search
Advanced Search
Dash Cams
Reversing Solutions
Handsfree Solutions
Car Trackers
Flashing Beacons
Pet Supplies
Security Solutions
Camera Solutions
Driver Aids
Vehicle Interface Leads SOT / ISO / Audiotocar / Mute
Phone Cradles
Charging Aids
Roof Racks
Vehicle Accessories
European Motoring Kits
Side Steps
Car Covers
Caravan Covers
Caravan Equipment
RV Covers
Installation Services
Specials ...
New Products ...
Featured Products ...
All Products ...
Currencies
GB Pound
US Dollar
Australian Dollar
Euros
There currently are 162 vistors online.
Home
/
Roof Racks
/ Rhino Pipe Tube 2m
Add to Cart:
Rhino Pipe Tube 2m
£170.10
Click to Enlarge
The NEW Rhino Products Universal Pipe Tube Carrier. Modern design manufactured from aluminium tubing for lightness and strength. The end cones are manufactured from glass filled plastic with an integral steel bulkhead for increased strength and security, aerodynamic design lowers wind drag and noise. New locking mechanism improves security and the product has been fully crash tested at 20g. Full TUV approval has been obtained for this product.
Product 2/4
3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'chamele1_direct.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
in:
[select distinct p.products_id, p.products_image, pd.products_name from products_xsell xp, products p, products_description pd where xp.products_id = '1422' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]