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


Pluta Cralusso UFO 18g
Exclusiv online!

Pluta Cralusso UFO 18g

61920018
Livrare 24-48 ore

27,00Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 30cm 10kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 30cm 10kg

8610-20002-010
Livrare 48-72 ore

10,00Lei

Fir monofilament Delphin MAMBA Carp camuflaj 0.26mm 11.4lbs 1200m

Fir monofilament Delphin MAMBA Carp camuflaj 0.26mm 11.4lbs 1200m

101001661
Livrare imediată!

108,00Lei

SHAD LUNKER CITY SWIMFISH 3.75 9.5CM 220 BL BACK -33%

SHAD LUNKER CITY SWIMFISH 3.75 9.5CM 220 BL BACK

725442372200
Livrare imediată!

24,10Lei(-33%) 16,07Lei

ANCORE ENERGOTEAM KAMASAKI NR.2/0 3buc/plic
Exclusiv online!

ANCORE ENERGOTEAM KAMASAKI NR.2/0 3buc/plic

49700200
Livrare 24-48 ore

8,20Lei

PLUTA Maver IT SPYRO 2.00gr

PLUTA Maver IT SPYRO 2.00gr

9118200
Livrare imediată!

10,00Lei

HUSA Maver UK MV-R MATCH 6 TUBURI 195x25x15cm
Exclusiv online!

HUSA Maver UK MV-R MATCH 6 TUBURI 195x25x15cm

n1200
Livrare 48-72 ore

511,00Lei

Mulineta Baracuda Excalibur SMV2000

Mulineta Baracuda Excalibur SMV2000

excalibur smv2000
Livrare imediată!

153,11Lei

PLUTE MOSTIRO BOGDAN 1GR 2 BUC

PLUTE MOSTIRO BOGDAN 1GR 2 BUC

2420050210000-2
Livrare imediată!

8,00Lei

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 11 Brown Trout
Exclusiv online!

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 11 Brown Trout

804020092
Livrare 48-72 ore

51,90Lei

LINGURA OSCILANTA DARA KILLER GALBENA SILURO 10GR
Exclusiv online!

LINGURA OSCILANTA DARA KILLER GALBENA SILURO 10GR

1403200201000
Livrare 48-72 ore

16,51Lei

Montura Wolfram EnergoTeam cu Ancora 9 9kg
Exclusiv online!

Montura Wolfram EnergoTeam cu Ancora 9 9kg

82008339
Livrare 24-48 ore

6,00Lei

Pluta Cralusso Genetic 1.5g

Pluta Cralusso Genetic 1.5g

62005150
Livrare imediată!

8,00Lei

SHAD BIG HAMMER SWIMBAIT HPS20013 CULOARE 13 5CM -32%

SHAD BIG HAMMER SWIMBAIT HPS20013 CULOARE 13 5CM

hps20013
Livrare imediată!

20,00Lei(-32%) 13,69Lei

CARLIGE TRABUCCO AKURA 6000 NR 20 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 6000 NR 20 15BUC/PLIC

025-25-200
Livrare 48-72 ore

7,00Lei

ANCORE ENERGOTEAM WIZARD GRIZZLY 974M-1 2X BRONZ NR.2/0 4buc/plic

ANCORE ENERGOTEAM WIZARD GRIZZLY 974M-1 2X BRONZ NR.2/0 4buc/plic

49974200
Livrare imediată!

11,00Lei

Carlige Maruto MSG-01 BN 13buc nr 3
Exclusiv online!

Carlige Maruto MSG-01 BN 13buc nr 3

44112003
Livrare 24-48 ore

21,00Lei

Strune Wizard Wolfram 15-20-25cm 30buc
Exclusiv online!

Strune Wizard Wolfram 15-20-25cm 30buc

82008933
Livrare 24-48 ore

63,00Lei

Carlige Maruto MSG-01 BN 13buc nr 4
Exclusiv online!

Carlige Maruto MSG-01 BN 13buc nr 4

44112004
Livrare 24-48 ore

21,00Lei

CARLIGE ENERGOTEAM EXCALIBUR ROUND FEEDER BARBLESS NR.8

CARLIGE ENERGOTEAM EXCALIBUR ROUND FEEDER BARBLESS NR.8

47200008
Livrare imediată!

9,00Lei

Afişare 2181 - 2200 din 4349 (218 pagini)
Queries: 5, Total time: 689.913 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'b441cc37a048f423f6bffe2037'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (670.724)
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 (pd.tag LIKE "%200%") 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 (18.822)
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 2180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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