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 300 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


SUPORT LANSETA ZEBCO

SUPORT LANSETA ZEBCO

1809000
Livrare imediată!

8,78Lei

Baterie Externa Rebelcell Solar Power Rebel 26800 mAh Incarcare Solara
Exclusiv online!

Baterie Externa Rebelcell Solar Power Rebel 26800 mAh Incarcare Solara

pwrrebel26k
Livrare 48-72ore

495,00Lei

SUPORT LANSETA CARPZOOM TUBULAR SLIDE-IN 4.5x31.6cm

SUPORT LANSETA CARPZOOM TUBULAR SLIDE-IN 4.5x31.6cm

cz5379
Livrare imediată!

25,50Lei

SUPORT PT.INCARCARE LANSETA CORMORAN

SUPORT PT.INCARCARE LANSETA CORMORAN

a6.63.63001
Livrare imediată!

57,76Lei

Dispozitiv Aplicare Inel Silicon Nevis Bait Bander + Inele Silicon

Dispozitiv Aplicare Inel Silicon Nevis Bait Bander + Inele Silicon

7337-001
Livrare imediată!

13,90Lei

SUPORT, NEVIS, LANSETA, , 6219-002, Suporturi Incarcare Lansete, Suporturi Incarcare Lansete Nevis, Nevis
Exclusiv online!

SUPORT, NEVIS, LANSETA, , 6219-002, Suporturi Incarcare Lansete, Suporturi Incarcare Lansete Nevis, Nevis

6219-002
Livrare 48-72 ore

20,50Lei

Suport, Lanseta, Kamasaki, Black, Catfish, 85cm, 77050085, Suporturi Incarcare Lansete, Suporturi Incarcare Lansete Kamasaki, Kamasaki
Dispozitiv Aplicare Inel Silicon Mikado Bait Bander

Dispozitiv Aplicare Inel Silicon Mikado Bait Bander

amf-020
Livrare imediată!

19,00Lei

Suport Lansete Rapture Linkbox Tackle System 45+
Exclusiv online!

Suport Lansete Rapture Linkbox Tackle System 45+

113-20-550
Livrare 48-72 ore

120,00Lei

Surub Blocare Spatar NuFish Restabox
Exclusiv online!

Surub Blocare Spatar NuFish Restabox

sp025
Livrare 48-72 ore

24,00Lei

Spray Anti Insect Care PLUS Natural 100ml -20%

Spray Anti Insect Care PLUS Natural 100ml

8714024326238
Livrare imediată!

95,00Lei(-20%) 76,01Lei

Crema Care PLUS After Sun, 100ml -20%

Crema Care PLUS After Sun, 100ml

8714024361574
Livrare imediată!

83,20Lei(-20%) 66,56Lei

Dispozitiv, Aplicare, Inel, Silicon, Jaxon, Bait, Bander, PC068, ac-pc068, Alte Accesorii Monturi, Alte Accesorii Monturi Jaxon, Alte Jaxon, Accesorii Jaxon, Monturi Jaxon, Alte Accesorii Monturi Feeder, Alte Accesorii Monturi Feeder Jaxon, Alte Jaxon, Accesorii Jaxon, Monturi Jaxon, Feeder Jaxon, Jaxon
Extractor Venin Care Plus Venimex -20%

Extractor Venin Care Plus Venimex

8714024387000
Livrare imediată!

166,50Lei(-20%) 133,20Lei

Folie Supravietuire Care PLUS -20%

Folie Supravietuire Care PLUS

8714024382210
Livrare imediată!

29,60Lei(-20%) 23,68Lei

Geanta din Plasa Sonik 10kg SK-Tek Air Dry Bag, XL, 26x20x26cm
Exclusiv online!

Geanta din Plasa Sonik 10kg SK-Tek Air Dry Bag, XL, 26x20x26cm

sktadbxl
Livrare 48-72 ore

109,88Lei

Plasa de Tantari Care Plus Mosquito Head Net Pop Up -20%

Plasa de Tantari Care Plus Mosquito Head Net Pop Up

8714024337029
Livrare imediată!

80,00Lei(-20%) 64,00Lei

Plasa de Tantari Clasica Care Plus Mosquito Head Net -20%

Plasa de Tantari Clasica Care Plus Mosquito Head Net

8714024337036
Livrare imediată!

60,00Lei(-20%) 48,00Lei

Geanta din Plasa Sonik 3kg SK-Tek Air Dry Bag, Medium, 24x10x24cm
Exclusiv online!

Geanta din Plasa Sonik 3kg SK-Tek Air Dry Bag, Medium, 24x10x24cm

sktadbm
Livrare 48-72 ore

71,19Lei

Suport Lateral Rapture Areabox Tackle System Rod Rack
Exclusiv online!

Suport Lateral Rapture Areabox Tackle System Rod Rack

113-20-750
Livrare 48-72 ore

110,00Lei

Afişare 101 - 120 din 185 (10 pagini)
Queries: 9, Total time: 204.834 ms [By time] [By id] [By file]
1 (0.071)
SELECT data
FROM `oc_session`
WHERE session_id = '735c0430f1e0ac8ad550df5cea'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.063)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (203.263)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%care%") 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:698
5 (1.014)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.075)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.070)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.072)
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