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


Mulineta Fox Rage Warrior New 1000

Mulineta Fox Rage Warrior New 1000

nrl025
Livrare imediată!

202,45Lei

Fir Textil Filfishing TITAN CATFISH CAMO X 8 BRAID 0.50 MM 250M 56KG
Exclusiv online!

Fir Textil Filfishing TITAN CATFISH CAMO X 8 BRAID 0.50 MM 250M 56KG

fil7997
Livrare 48-72 ore

92,00Lei

Lanseta Delphin Code X 2.44M 2-8g 2seg -41%
Exclusiv online!

Lanseta Delphin Code X 2.44M 2-8g 2seg

101001314
Livrare 48-72ore

307,00Lei(-41%) 179,90Lei

Mulineta DAM Quick 1 Pink FD3000
Exclusiv online!

Mulineta DAM Quick 1 Pink FD3000

dam.75952
Livrare 24-48 ore

159,09Lei

Mulineta ZEBCO Z-Cast SR 330 -33%

Mulineta ZEBCO Z-Cast SR 330

0402030
Livrare imediată!

150,00Lei(-33%) 99,90Lei

Mulineta Daiwa Revros LT 4000

Mulineta Daiwa Revros LT 4000

d.10221.401
Livrare imediată!

410,80Lei

LANSETA SPINNING DAIWA 2SEG NINJA SF 2.15M 15-50G

LANSETA SPINNING DAIWA 2SEG NINJA SF 2.15M 15-50G

d.11207.215
Livrare imediată!

265,45Lei

MULINETA SAVAGE GEAR SG6 2500H FD 8RUL/150MX020/6,2:1

MULINETA SAVAGE GEAR SG6 2500H FD 8RUL/150MX020/6,2:1

o.sg.74736
Livrare imediată!

416,95Lei

Mulineta Spro Red Arc 2000 Model 2020
Exclusiv online!

Mulineta Spro Red Arc 2000 Model 2020

001329-00200-00000
Livrare 48-72 ore

730,01Lei

Fir Textil Filfishing TITAN CATFISH CAMO X 8 BRAID 0.70 MM 250M 84KG
Exclusiv online!

Fir Textil Filfishing TITAN CATFISH CAMO X 8 BRAID 0.70 MM 250M 84KG

fil8017
Livrare 48-72 ore

92,00Lei

Lanseta Delphin ZANDERA XCS 40T 210cm 3-21g 2seg -20%

Lanseta Delphin ZANDERA XCS 40T 210cm 3-21g 2seg

101001492
Livrare imediată!

425,00Lei(-20%) 339,90Lei

Pasta Magic Trout Trout Bait Taste 50g black Liquorice -46%

Pasta Magic Trout Trout Bait Taste 50g black Liquorice

3986010
Stoc epuizat

31,29Lei(-46%) 17,02Lei

Fir Textil Delphin HERO 8 Galben Fluo, 0.12mm, 8.20kg, 117m

Fir Textil Delphin HERO 8 Galben Fluo, 0.12mm, 8.20kg, 117m

101001743
Livrare imediată!

50,00Lei

Mulineta DAM Quick 2 2000 FD V2 -20%
Exclusiv online!

Mulineta DAM Quick 2 2000 FD V2

dam.75978
Livrare 24-48 ore

191,19Lei(-20%) 152,95Lei

Pasta Magic Trout Bait Taste 50g rosu/alb Candy -36%

Pasta Magic Trout Bait Taste 50g rosu/alb Candy

3987011
Livrare imediată!

31,29Lei(-36%) 19,90Lei

Lanseta Sakura Speciz Spinning SPES 2.13m 10-35g 2seg
Exclusiv online!

Lanseta Sakura Speciz Spinning SPES 2.13m 10-35g 2seg

20434saprj800370-3mh
Livrare 48-72 ore

449,75Lei

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD ROD 220CM 5-20GR -11%

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD ROD 220CM 5-20GR

nrd361
Livrare imediată!

404,96Lei(-11%) 359,90Lei

Mulineta Spro FreeStyle Litz 500 -25%
Exclusiv online!

Mulineta Spro FreeStyle Litz 500

001327-00050-00000
Livrare 48-72 ore

198,00Lei(-25%) 148,50Lei

Lanseta Spinning FL Strategist 2.40M 150G 2Segmente

Lanseta Spinning FL Strategist 2.40M 150G 2Segmente

4311219805000
Livrare imediată!

349,90Lei

Lanseta Zebco Quantum G-Force Shad 2.70m 14-90gr

Lanseta Zebco Quantum G-Force Shad 2.70m 14-90gr

14350271
Livrare imediată!

368,78Lei

Afişare 201 - 220 din 7817 (391 pagini)
Queries: 7, Total time: 267.350 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '3e586257347e2ecc13b4c6e56c'
/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 (236.864)
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('+rapitori' 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 (29.815)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.164)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"MOSS INDISPONIBIL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.125)
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
7 (0.132)
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