SELECT pf.qty as free_qty, pf.product_id as free_main_id, visible, required, p.soldout_new , p.force_avaibility_text, p.market_send, p.activ_price_catalog, p.force_avaibility_end_date, pcomp.cmup, p.blog_post, p.products_etat, p.products_family, p.stock_mini, p.products_bundle, p.products_bancdessai, p.products_id, p.products_barcode, p.products_quantity, p.products_zone, p.port_offert, p.in_360, p.products_video, p.products_cost, p.products_status, p.products_on_order, p.products_tax_class_id, p.products_date_available, p.fx_qty, m.on_order as brand_on_order, p.packaging, p.products_image , p.last_cost_price_ht, p.fx_price_ht, p.fx_regular_price_ht, pw.id as product_website_id,p.zone_store, pw.description, pw.name, pw.meta_title, pw.meta_description, pw.meta_keywords, pw.permalink, pw.sku, pw.website_id, IF( m.on_order IS NULL , p.products_on_order, m.on_order ) as special_on_order, pw.flash_price_ht, pw.flash_start_at, pw.flash_end_at, pw.flash_status, pw.promo_price_ht, pw.promo_start_at, pw.promo_end_at, pw.promo_status, pw.sale_price_ht, pw.sale_start_at, pw.sale_end_at, pw.sale_status, pw.regular_price_ht, pw.status, pw.created_at, now() as now, p.products_date_added, rdc.vp_price , rdc.vp_qty, rdc.vp_show_mini_price, rdc.vp_active, p.fx_id, p.products_model_manufacturers, p.manufacturers_id, p.products_pdfupload, m.manufacturers_name, p.products_weight,p.custom_rate_id,p.tracking_inventory, p.serial_regex, pcomp.cost_price_ht, p.products_image_xl_1, p.products_image_xl_2, p.products_image_xl_3, p.products_image_xl_4, p.products_image_xl_5, p.products_image_xl_6, p.products_image_xl_7, p.products_model2, p.products_model3, p.products_longueur, p.products_largeur, p.products_hauteur, p.products_realweight, p.gros_colis, p.is_dangerous, p.property_set_id, pw.youtube_code, approved, pwa.qty, pwa.zone, pw.discount_qty_rate_1, pw.discount_qty_rate_2, pw.discount_qty_1, pw.discount_qty_2, pw.import_code FROM products p INNER JOIN products_websites pw ON (pw.product_id = p.products_id ) LEFT JOIN products_warehouses pwa ON (pwa.product_id = p.products_id AND pwa.warehouse_id = 1 ) LEFT JOIN products_rdc rdc ON (rdc.product_id = p.products_id) LEFT JOIN manufacturers m ON (m.manufacturers_id = p.manufacturers_id) LEFT JOIN products_companies pcomp ON (pcomp.product_id = p.products_id AND pcomp.company_id = 1 ) INNER JOIN products_free pf ON (pf.free_id = p.products_id) WHERE pf.product_id= 14613 AND visible='1' GROUP BY p.products_id ORDER BY pw.sku LIMIT 0,60

Servo Treuil HS-785HB

-3%
VENTE FLASH
Autres vues du produit :
Autres vues du produit
Servo HS-785HB Caractéristiques HS-785HB : - Couple : 11 kg/cm (4,8 V) et 13,2 kg/cm (6 V) - Vitesse : 1,68 sec/360° (4,8 V) et 1,38 sec/360° (6 V) - Fonctionne en 4,8 V et 6 V - Pignons Karbonite sur roulements à billes - Rotation : 3,5 tours - Prises : Hitec/JR - Futaba - Application : bateaux       ...
Lire la suite >
Promotion :
36,00 €
34,90 €
En rupture de stock
Livraison en 24/48h
Livraison Fxmodel en 24/48h
Les engagements fx model
Frais de port
Frais de port à partir de 6€
Frais de port
CB débitée à l'expédition
Frais de port
Paiement sécurisé


Servo HS-785HB

Caractéristiques HS-785HB :
- Couple : 11 kg/cm (4,8 V) et 13,2 kg/cm (6 V)
- Vitesse : 1,68 sec/360° (4,8 V) et 1,38 sec/360° (6 V)
- Fonctionne en 4,8 V et 6 V
- Pignons Karbonite sur roulements à billes
- Rotation : 3,5 tours
- Prises : Hitec/JR - Futaba
- Application : bateaux

 

 

 

Vous souhaitez laisser un avis sur ce produit, merci d'utiliser les champs ci-dessous.
Adresse e-mail
Nom
Titre
Commentaire :
500 caractères restants
Votre note (sur 5) :
SELECT DISTINCT(p.products_id), p.soldout_new , p.force_avaibility_text, p.market_send, p.activ_price_catalog, p.force_avaibility_end_date, pcomp.cmup, p.blog_post, p.products_etat, p.products_family, p.stock_mini, p.products_bundle, p.products_bancdessai, p.products_id, p.products_barcode, p.products_quantity, p.products_zone, p.port_offert, p.in_360, p.products_video, p.products_cost, p.products_status, p.products_on_order, p.products_tax_class_id, p.products_date_available, p.fx_qty, m.on_order as brand_on_order, p.packaging, p.products_image , p.last_cost_price_ht, p.fx_price_ht, p.fx_regular_price_ht, pw.id as product_website_id,p.zone_store, pw.description, pw.name, pw.meta_title, pw.meta_description, pw.meta_keywords, pw.permalink, pw.sku, pw.website_id, IF( m.on_order IS NULL , p.products_on_order, m.on_order ) as special_on_order, pw.flash_price_ht, pw.flash_start_at, pw.flash_end_at, pw.flash_status, pw.promo_price_ht, pw.promo_start_at, pw.promo_end_at, pw.promo_status, pw.sale_price_ht, pw.sale_start_at, pw.sale_end_at, pw.sale_status, pw.regular_price_ht, pw.status, pw.created_at, now() as now, p.products_date_added, rdc.vp_price , rdc.vp_qty, rdc.vp_show_mini_price, rdc.vp_active, p.fx_id, p.products_model_manufacturers, p.manufacturers_id, p.products_pdfupload, m.manufacturers_name, p.products_weight,p.custom_rate_id,p.tracking_inventory, p.serial_regex, pcomp.cost_price_ht, p.products_image_xl_1, p.products_image_xl_2, p.products_image_xl_3, p.products_image_xl_4, p.products_image_xl_5, p.products_image_xl_6, p.products_image_xl_7, p.products_model2, p.products_model3, p.products_longueur, p.products_largeur, p.products_hauteur, p.products_realweight, p.gros_colis, p.is_dangerous, p.property_set_id, pw.youtube_code, approved, pwa.qty, pwa.zone, pw.discount_qty_rate_1, pw.discount_qty_rate_2, pw.discount_qty_1, pw.discount_qty_2, pw.import_code FROM products p INNER JOIN products_websites pw ON (pw.product_id = p.products_id AND pw.website_id = 17 AND pw.deleted_at IS NULL ) LEFT JOIN products_warehouses pwa ON (pwa.product_id = p.products_id AND pwa.warehouse_id = 1 ) LEFT JOIN products_rdc rdc ON (rdc.product_id = p.products_id) LEFT JOIN manufacturers m ON (m.manufacturers_id = p.manufacturers_id) LEFT JOIN products_companies pcomp ON (pcomp.product_id = p.products_id AND pcomp.company_id = 1 ) INNER JOIN orders_products opb ON (opb.products_id = p.products_id AND opb.products_id != '14613') INNER JOIN orders_products opa ON (opa.orders_id = opb.orders_id AND opa.products_id = '14613' ) INNER JOIN orders o ON ( opb.orders_id = o.orders_id AND o.store_id != 41 AND o.customers_id != 74898) INNER JOIN products_websites pw2 ON (pw2.product_id = p.products_id AND pw2.website_id = 17 AND pw2.status = 1 AND pw2.deleted_at IS NULL ) INNER JOIN products_to_websites ptw2 ON (ptw2.product_id = p.products_id AND ptw2.website_id = 17) WHERE pw.status=1 AND p.products_quantity>0 ORDER BY pw.sku LIMIT 0,10

Les clients ayant acheté cet article ont également acheté:

SELECT p.soldout_new , p.force_avaibility_text, p.market_send, p.activ_price_catalog, p.force_avaibility_end_date, pcomp.cmup, p.blog_post, p.products_etat, p.products_family, p.stock_mini, p.products_bundle, p.products_bancdessai, p.products_id, p.products_barcode, p.products_quantity, p.products_zone, p.port_offert, p.in_360, p.products_video, p.products_cost, p.products_status, p.products_on_order, p.products_tax_class_id, p.products_date_available, p.fx_qty, m.on_order as brand_on_order, p.packaging, p.products_image , p.last_cost_price_ht, p.fx_price_ht, p.fx_regular_price_ht, pw.id as product_website_id,p.zone_store, pw.description, pw.name, pw.meta_title, pw.meta_description, pw.meta_keywords, pw.permalink, pw.sku, pw.website_id, IF( m.on_order IS NULL , p.products_on_order, m.on_order ) as special_on_order, pw.flash_price_ht, pw.flash_start_at, pw.flash_end_at, pw.flash_status, pw.promo_price_ht, pw.promo_start_at, pw.promo_end_at, pw.promo_status, pw.sale_price_ht, pw.sale_start_at, pw.sale_end_at, pw.sale_status, pw.regular_price_ht, pw.status, pw.created_at, now() as now, p.products_date_added, rdc.vp_price , rdc.vp_qty, rdc.vp_show_mini_price, rdc.vp_active, p.fx_id, p.products_model_manufacturers, p.manufacturers_id, p.products_pdfupload, m.manufacturers_name, p.products_weight,p.custom_rate_id,p.tracking_inventory, p.serial_regex, pcomp.cost_price_ht, p.products_image_xl_1, p.products_image_xl_2, p.products_image_xl_3, p.products_image_xl_4, p.products_image_xl_5, p.products_image_xl_6, p.products_image_xl_7, p.products_model2, p.products_model3, p.products_longueur, p.products_largeur, p.products_hauteur, p.products_realweight, p.gros_colis, p.is_dangerous, p.property_set_id, pw.youtube_code, approved, pwa.qty, pwa.zone, pw.discount_qty_rate_1, pw.discount_qty_rate_2, pw.discount_qty_1, pw.discount_qty_2, pw.import_code FROM products p INNER JOIN products_websites pw ON (pw.product_id = p.products_id AND pw.website_id = 17 AND pw.deleted_at IS NULL ) LEFT JOIN products_warehouses pwa ON (pwa.product_id = p.products_id AND pwa.warehouse_id = 1 ) LEFT JOIN products_rdc rdc ON (rdc.product_id = p.products_id) LEFT JOIN manufacturers m ON (m.manufacturers_id = p.manufacturers_id) LEFT JOIN products_companies pcomp ON (pcomp.product_id = p.products_id AND pcomp.company_id = 1 ) INNER JOIN products_to_websites ptw ON (ptw.product_id = p.products_id AND ptw.website_id = 17) AND ptw.product_id IN (14609,14623,14614,20443,27410,79336,19915,14605,38500,14604,38531,14622,38533,20441,14606,66996,54758,14621,501597,19465,109986,58047,58007,38518,1181,77819,14620,70773,14613,57905,55051,14591,2915,59361,37156,63328,14619,56305,58359,14594,14595,14610,14612,501596,1484,14607,108187,63341,67694,14873,14867,67216,82428,36223,14597,501554,428107,52368,36226,19598) WHERE (p.products_quantity > 0 OR (p.products_date_available > now())) AND pw.status = '1' AND p.products_etat = '0' ORDER BY p.products_date_added desc LIMIT 0,10
Accessoire modelisme - Servo HS-85MG+ - 44-337
Réf. : 44-337
Servo HS-85MG+ - Hitec
40,00 €25,90 €
Modelisme Hitec - Servo HS-82MG - 44-345
Réf. : 44-345
Servo HS-82MG - Hitec
22,00 €19,79 €

Vous êtes actuellement sur la fiche produit modelisme : Servo Treuil HS-785HB

FXModel votre spécialiste modélisme. Le plus grand magasin de modelisme en france. SARL au capital de 426 900.00€

Les avantages Fxmodel