Pagina 1 - 24 of 232 products

Polastorm

COD: 52.434.00
Elica in alluminio passo 12 1/4 x 9 - 13 denti
Spedizione in 2-4 giorni lavorativi
80.90 € 77.40 €
COD: 52.436.08
Elica in alluminio passo 13 3/4x21 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.441.01
Elica in alluminio passo 8,5 x 6,5 - 12 denti
Spedizione in 2-4 giorni lavorativi
49.90 € 47.50 €
COD: 52.446.02
Elica in alluminio passo 11 1/4 x 10 - 13 denti
Spedizione in 2-4 giorni lavorativi
109.50 € 105.60 €
COD: 52.446.03
Elica in alluminio passo 10 7/8 x 11 - 13 denti
Spedizione in 2-4 giorni lavorativi
109.50 € 105.60 €
COD: 52.446.04
Elica in alluminio passo 10 3/4 x 12 - 13 denti
Spedizione in 2-4 giorni lavorativi
109.50 € 105.60 €
COD: 52.446.06
Elica in alluminio passo 10 1/2 x 13 - 13 denti
Spedizione in 2-4 giorni lavorativi
109.50 € 105.60 €
COD: 52.446.08
Elica in alluminio passo 10 3/8 x 14 - 13 denti
Spedizione in 2-4 giorni lavorativi
109.50 € 105.60 €
COD: 52.447.03
Elica in alluminio passo 14 x 11 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.447.04
Elica in alluminio passo 14 x 13 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.447.05
Elica in alluminio passo 13 7/4 x 15 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.447.06
Elica in alluminio passo 13 1/4 x 17 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.447.07
Elica in alluminio passo 13 x 19 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.447.08
Elica in alluminio passo 12 3/4 x 21 - 15 denti
Spedizione in 2-4 giorni lavorativi
154.50 € 147.80 €
COD: 52.448.03
Elica in alluminio passo 16x13 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.448.05
Elica in alluminio passo 15 1/4x15 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.448.07
Elica in alluminio passo 15x17 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.448.09
Elica in alluminio passo 14 1/2x19 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.448.11
Elica in alluminio passo 14 1/4x21 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.448.13
Elica in alluminio passo 14x23 - 15 denti
Spedizione in 2-4 giorni lavorativi
169.50 € 161.80 €
COD: 52.450.01
Elica in alluminio passo 7 1/2 x 6 - 10 denti
Spedizione in 2-4 giorni lavorativi
40.90 € 38.70 €
COD: 52.450.02
Elica in alluminio passo 7 1/2 x 7 - 10 denti
Spedizione in 2-4 giorni lavorativi
40.90 € 38.70 €
COD: 52.451.05
Elica in alluminio passo 9 1/4 x 11 - 10 denti
Spedizione in 2-4 giorni lavorativi
56.90 € 54.60 €
COD: 52.453.07
Elica in alluminio passo 11 1/4 x 15 - 13 denti
Spedizione in 2-4 giorni lavorativi
80.90 € 77.40 €

Aderisci alla Newsletter

Iscriviti alla nostra newsletter per essere sempre informato sulle ultime novità.

Ordini veloci

Il 90% degli ordini viene spedito in 24H. Vedi subito disponibilità e tempistiche

Professionisti del settore

Lavoriamo e diamo assistenza nautica dal 1982. Troverete personale esperto e gentile nell'assistervi

Pagamenti sicuri

Scegli tra Paypal, Carta di Credito, Postepay e Bonifico Bancario

Imballaggi riciclati

Utilizziamo solamente imballaggi provenienti da materiale riciclato all'interno del nostro stesso negozio

(default) 9 queries took 502 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created` FROM `dbo610494358_stg`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '5dcd4e7991a7570e57d3ef0e027af622' LIMIT 1111
2SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100996' ORDER BY `Category`.`name_it` ASC000
3SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100997' ORDER BY `Category`.`name_it` ASC000
4SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100993' ORDER BY `Category`.`name_it` ASC000
5SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '24005' ORDER BY `Category`.`name_it` ASC000
6SELECT `Category`.`id`, `Category`.`name_it`, `Category`.`name_eng`, `Category`.`name_de`, `Category`.`description_it`, `Category`.`description_eng`, `Category`.`description_de`, `Category`.`html_title_it`, `Category`.`html_meta_it`, `Category`.`html_meta_eng`, `Category`.`html_meta_de`, `Category`.`html_title_eng`, `Category`.`html_title_de`, `Category`.`father`, `Category`.`ebay`, `Category`.`ebay2`, `Category`.`ebay_uk`, `Category`.`ebay_uk2`, `Category`.`ebay_de`, `Category`.`ebay_de2`, `Category`.`ebay_us`, `Category`.`ebay_us2`, `Category`.`ebay_store`, `Category`.`merchant_center`, `Category`.`active`, `Category`.`created`, `Category`.`modified`, `Category`.`brands`, `Category`.`description_short_it`, `Category`.`description_short_eng`, `Category`.`description_short_de`, `Category`.`json_ld_schema_it`, `Category`.`json_ld_schema_eng`, `Category`.`json_ld_schema_de` FROM `dbo610494358_stg`.`categories` AS `Category` WHERE `Category`.`father` = '100999' ORDER BY `Category`.`name_it` ASC000
7SELECT count(*) as count FROM ( SELECT DISTINCT Product.id as product_id, Product.description_it as product_name_it, Product.description_eng as product_name_eng, Product.photo as product_photo, Product.attributes_it as product_attributes_it, Product.attributes_eng as product_attributes_eng, Product.quantity, Product.minimum_quantity, Product.supplier_quantity, Product.always_available, Product.supplier_name, Product.supplier_code, Product.price as price, Product.list_price as list_price, Product.offer_price as offer_price, Product.vat as vat, Serie.id as serie_id, Serie.name_it as serie_name_it, Serie.name_eng as serie_name_eng, Serie.photo as serie_photo, Serie.start_price serie_start_price, Serie.supplier_name serie_supplier_name, Category.id as category_id, Category.name_it as category_name_it, Category.name_eng as category_name_eng, Category.father as category_father FROM products as Product INNER JOIN products_series as ProductSeries ON Product.id = ProductSeries.product_id INNER JOIN series AS Serie ON ProductSeries.series_id = Serie.id INNER JOIN categories AS Category ON (Serie.category_id = Category.id) WHERE Product.category_id IS NULL AND Category.active = 1 AND Serie.active = 1 AND 1=1 AND Product.supplier_name IN ('Polastorm') AND Product.published = 1 UNION ALL SELECT DISTINCT Product.id as product_id, Product.description_it as product_name_it, Product.description_eng as product_name_eng, Product.photo as product_photo, Product.attributes_it as product_attributes_it, Product.attributes_eng as product_attributes_eng, Product.quantity, Product.minimum_quantity, Product.supplier_quantity, Product.always_available, Product.supplier_name, Product.supplier_code, Product.price as price, Product.list_price as list_price, Product.offer_price as offer_price, Product.vat as vat, '', '', '', '', '', '', Category.id as category_id, Category.name_it as category_name_it, Category.name_eng as category_name_eng, Category.father as category_father FROM products as Product INNER JOIN categories AS Category ON (Product.category_id = Category.id) WHERE Product.category_id IS NOT NULL AND 1=1 AND Product.supplier_name IN ('Polastorm') AND Product.published = 1 ) g 11269
8SELECT g.* FROM ( SELECT DISTINCT Product.id as product_id, Product.description_it as product_name_it, Product.description_eng as product_name_eng, Product.photo as product_photo, Product.attributes_it as product_attributes_it, Product.attributes_eng as product_attributes_eng, Product.quantity, Product.minimum_quantity, Product.supplier_quantity, Product.always_available, Product.supplier_name, Product.supplier_code, Product.price as price, Product.list_price as list_price, Product.offer_price as offer_price, Product.vat as vat, Serie.id as serie_id, Serie.name_it as serie_name_it, Serie.name_eng as serie_name_eng, Serie.photo as serie_photo, Serie.start_price serie_start_price, Serie.supplier_name serie_supplier_name, Category.id as category_id, Category.name_it as category_name_it, Category.name_eng as category_name_eng, Category.father as category_father FROM products as Product INNER JOIN products_series as ProductSeries ON Product.id = ProductSeries.product_id INNER JOIN series AS Serie ON ProductSeries.series_id = Serie.id INNER JOIN categories AS Category ON (Serie.category_id = Category.id) WHERE Product.category_id IS NULL AND Category.active = 1 AND Serie.active = 1 AND 1=1 AND Product.supplier_name IN ('Polastorm') AND Product.published = 1 UNION ALL SELECT DISTINCT Product.id as product_id, Product.description_it as product_name_it, Product.description_eng as product_name_eng, Product.photo as product_photo, Product.attributes_it as product_attributes_it, Product.attributes_eng as product_attributes_eng, Product.quantity, Product.minimum_quantity, Product.supplier_quantity, Product.always_available, Product.supplier_name, Product.supplier_code, Product.price as price, Product.list_price as list_price, Product.offer_price as offer_price, Product.vat as vat, '', '', '', '', '', '', Category.id as category_id, Category.name_it as category_name_it, Category.name_eng as category_name_eng, Category.father as category_father FROM products as Product INNER JOIN categories AS Category ON (Product.category_id = Category.id) WHERE Product.category_id IS NOT NULL AND 1=1 AND Product.supplier_name IN ('Polastorm') AND Product.published = 1 ) g LIMIT 0, 242424230
9SELECT * from categories AS Category WHERE id IN ('1','35002','2','12008','07009','4','05004','050001','5','6','34001','7','05003','33006','37','10003','12004','13005','11','100120','30002','100012','100422','13','20806','14','100416','03006','07005','16','07008','06001','03003','31001','31002','31','03004','06002','05001','31023','19','20','31004','21','02002','100206','34002','30003','100420','25','70','26','27','28','08001','29','08002','30','02001','35','100407','12005','33','34','10002','36','05005','05008','05007','05009','05006','40','13002','41','04003','42','07002','07001','44','45','46','47','470000','13001','33007','49','33001','33002','03005','33004','04002','07006','070100','12002','07007','54','55','56','57','58','59','60','10001','63','30008','12009','12003','12007','12001','33005','66','68','69','71','72','32004','100009','06003','100330','34004','100216','30005','31005','33003','04004','220900','221000','220300','220700','220800','P06000','220600','220200','221100','220100')1351352