articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Bologneza Trabucco Vixia Master 6m, 260g, 6seg

Bologneza Trabucco Vixia Master 6m, 260g, 6seg

120-56-060
Stoc epuizat

499,00Lei

Brat Trabucco GNT X-Connect Ripple Side Rest

Brat Trabucco GNT X-Connect Ripple Side Rest

116-26-030
Stoc epuizat

120,00Lei

LANSETA BOLOGNEZA TRABUCCO ASTORE NRG-LITE 7007, 7.00M

LANSETA BOLOGNEZA TRABUCCO ASTORE NRG-LITE 7007, 7.00M

120-49-370
Stoc epuizat

698,99Lei

Lanseta Trabucco Searider Tekno Squid 1.80m, 120g, 1+1seg

Lanseta Trabucco Searider Tekno Squid 1.80m, 120g, 1+1seg

160-88-040
Stoc epuizat

195,01Lei

Suport Lateral Lansete Trabucco GNT X-Connect

Suport Lateral Lansete Trabucco GNT X-Connect

116-26-260
Stoc epuizat

195,01Lei

Bologneza Trabucco Vixia Master 5m, 210g, 5seg

Bologneza Trabucco Vixia Master 5m, 210g, 5seg

120-56-050
Stoc epuizat

399,00Lei

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 15g, 4seg

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 15g, 4seg

150-35-010
Stoc epuizat

310,00Lei

Bologneza Trabucco Vixia Master 7m, 2370g, 7seg

Bologneza Trabucco Vixia Master 7m, 2370g, 7seg

120-56-070
Stoc epuizat

549,99Lei

Brat Trabucco GNT X-Connect Ripple Cross Long Arm

Brat Trabucco GNT X-Connect Ripple Cross Long Arm

116-26-020
Stoc epuizat

120,00Lei

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 25g, 4seg

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 25g, 4seg

150-35-030
Stoc epuizat

335,00Lei

Lanseta Trabucco Spectrum XTD Dynamic Feeder, 3.30m, M-60g, 2+3seg

Lanseta Trabucco Spectrum XTD Dynamic Feeder, 3.30m, M-60g, 2+3seg

150-83-330
Stoc epuizat

630,00Lei

Bologneza Trabucco Activa Power 4m, 160g, 4seg

Bologneza Trabucco Activa Power 4m, 160g, 4seg

120-51-040
Stoc epuizat

350,00Lei

Bologneza Trabucco Scogliera BLX K-Force 7m, 390g, 7seg

Bologneza Trabucco Scogliera BLX K-Force 7m, 390g, 7seg

121-08-170
Stoc epuizat

1.280,00Lei

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 20g, 4seg

Lanseta Trabucco Activa Tele-Match Allround 4.20m, 20g, 4seg

150-35-020
Stoc epuizat

320,00Lei

Tronson Nr.3 Pentru Bologneza Trabucco Energhia Race-x Competition Bolo

Tronson Nr.3 Pentru Bologneza Trabucco Energhia Race-x Competition Bolo

121-13-350-r03
Stoc epuizat

149,50Lei

Lanseta Trabucco Spectrum XTD Dynamic Feeder 3.30m, 60g

Lanseta Trabucco Spectrum XTD Dynamic Feeder 3.30m, 60g

150-83-300
Stoc epuizat

570,00Lei

Lanseta Trabucco Spectrum XTD Dynamic Feeder, 3.90m, MP-80g, 3+3seg

Lanseta Trabucco Spectrum XTD Dynamic Feeder, 3.90m, MP-80g, 3+3seg

150-83-390
Stoc epuizat

675,00Lei

LANSETA BOLOGNEZA TRABUCCO ASTORE NRG-LITE 6006, 6.00M

LANSETA BOLOGNEZA TRABUCCO ASTORE NRG-LITE 6006, 6.00M

120-49-360
Stoc epuizat

595,00Lei

Lanseta Telescopica Trabucco Frangente X-Force Match 4.80m, 100g, 5seg

Lanseta Telescopica Trabucco Frangente X-Force Match 4.80m, 100g, 5seg

150-36-048
Stoc epuizat

615,00Lei

Bologneza Trabucco Activa Power 5m, 160g, 5seg

Bologneza Trabucco Activa Power 5m, 160g, 5seg

120-51-050
Stoc epuizat

369,99Lei

Afişare 301 - 320 din 363 (19 pagini)
Queries: 4, Total time: 18.283 ms [By time] [By id] [By file]
1 (0.174)
SELECT data
FROM `oc_session`
WHERE session_id = '3fd23a9b0205c786b734d34368'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.847)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+lansete +trabucco' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:725
4 (0.150)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38