Eastern Helicopters  Your VARIO Helicopters Source In Canada

Canadian vario dealer for scale helicopters

  Home » Catalog » Promotional » 3618 My Account  |  Cart Contents  |  Checkout   

 

The VarioCanada.com store has moved to

http://www.easternhelicopters.com

Click here to go to our new website and online store.
Categories
Pod & Booms
Scale Fuselages
Scale Accessories
Mechanics set
Engines Sets
Radio Systems
Rotor Blades
Replacement Parts
Promotional
Tools
Fueling Station
Turbine Accessories
JetCat Heli Engines
JetCat Jet Engines
Manufacturers
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Bell 47 G III full size heli
Order No. 3618
$28.34 CAN
Highly detailed photographs support the planning phases and your model's construction; incl. building instructions of the specific models.
Format Video-CD
readable on both PC and DVD players.
Reviews
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'variocan_a.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where xp.products_id = '2844' 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.products_id asc limit 30

[TEP STOP]