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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Costum FOX Rage Winter suit - XXL -16%

Costum FOX Rage Winter suit - XXL

npr414
Livrare imediată!

939,30Lei(-16%) 790,01Lei

Boilies CPK Tare XXL + Sweetcorn, 20mm, 3kg

Boilies CPK Tare XXL + Sweetcorn, 20mm, 3kg

1000901
Livrare imediată!

110,00Lei

Boilies CPK Tare XXL + Sweetcorn, 24mm, 3kg

Boilies CPK Tare XXL + Sweetcorn, 24mm, 3kg

1000913
Livrare imediată!

110,00Lei

COSULET NADIRE FEEDER PRO FL XXL 20G

COSULET NADIRE FEEDER PRO FL XXL 20G

65-25614
Livrare imediată!

6,90Lei

Tava Laterala Rive D36, XXL, 67x51cm
Exclusiv online!

Tava Laterala Rive D36, XXL, 67x51cm

90810103028
Livrare 48-72 ore

651,77Lei

Tricou DAM Madcat Skull Tee XXL -24%

Tricou DAM Madcat Skull Tee XXL

8013160148
Livrare imediată!

68,03Lei(-24%) 51,90Lei

Agrafa Zeck Knotless Connector X-Safe XXL 3buc

Agrafa Zeck Knotless Connector X-Safe XXL 3buc

41415110025
Livrare imediată!

9,78Lei

Bluza Corp Blaser Base Layer Jonar Maro Marime XXL
Exclusiv online!

Bluza Corp Blaser Base Layer Jonar Maro Marime XXL

bl.122032.021.2xl
Livrare 24-48 ore

378,47Lei

Camasa Blaser Charles Brown / Blue Marime XXL -30%
Exclusiv online!

Camasa Blaser Charles Brown / Blue Marime XXL

bl.121060.087.2xl
Livrare 24-48 ore

372,41Lei(-30%) 260,69Lei

Costum De Iarna Quantum black/grey XXL -39%
Exclusiv online!

Costum De Iarna Quantum black/grey XXL

8440005
Livrare 48-72ore

539,78Lei(-39%) 326,73Lei

Picior Extensibil Garbolino Scaun Modular XXL D36 100-140cm
Exclusiv online!

Picior Extensibil Garbolino Scaun Modular XXL D36 100-140cm

90830gomee3970-1000
Livrare 48-72 ore

306,13Lei

Boilies CPK XXL, Belachan & Squid, 14/16mm, 5kg

Boilies CPK XXL, Belachan & Squid, 14/16mm, 5kg

999829
Livrare imediată!

221,00Lei

Boilies Solubil de Carlig CPK XXL, Belachan & Squid, 16/20mm, 250g

Boilies Solubil de Carlig CPK XXL, Belachan & Squid, 16/20mm, 250g

999141
Livrare imediată!

28,00Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XXL -23%

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XXL

d.18865.350
Livrare imediată!

1.020,83Lei(-23%) 785,90Lei

Husa Campingaz Premium XXL 171x62x106cm
Exclusiv online!

Husa Campingaz Premium XXL 171x62x106cm

2000037293
Livrare 24-48 ore

250,00Lei

Costum Impermeabil Preston Celcius Suit, Marime XXL

Costum Impermeabil Preston Celcius Suit, Marime XXL

p0200424
Livrare imediată!

809,96Lei

Costum Termo DAM Xthrem Winther 2 Buc, Marime XXL

Costum Termo DAM Xthrem Winther 2 Buc, Marime XXL

a8.dam.60124
Livrare imediată!

648,34Lei

Salopeta Norfin REBEL PRO PANTS GRAY, Marime 2XL
Exclusiv online!

Salopeta Norfin REBEL PRO PANTS GRAY, Marime 2XL

586005-xxl
Livrare 48-72ore

1.285,00Lei

TRICOU OKUMA T-SHIRT PIKE BLACK MARIME XXL
Exclusiv online!

TRICOU OKUMA T-SHIRT PIKE BLACK MARIME XXL

pa01t042b2l
Livrare 48-72ore

189,00Lei

Camasa Blaser Stretch Harald Beige, Marime XXL
Exclusiv online!

Camasa Blaser Stretch Harald Beige, Marime XXL

bl.121031.087.1.2xl
Livrare 24-48 ore

330,67Lei

Afişare 321 - 340 din 685 (35 pagini)
Queries: 8, Total time: 23.184 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '8107578a1f785a1c7b5783b9a7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.298)
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 = '3' AND (MATCH(pd.tag) AGAINST('+xxl' 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:737
4 (3.189)
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 320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.133)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.121)
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.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.119)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38