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

Oferte speciale


Ancora Owner St36 Rd Nr.8 -29%

Ancora Owner St36 Rd Nr.8

5636025
Livrare imediată!

30,50Lei(-29%) 21,66Lei

Ancora Owner Stx58 Tn Nr.6 -29%

Ancora Owner Stx58 Tn Nr.6

5658059
Livrare imediată!

58,64Lei(-29%) 41,90Lei

Ancora Tipla Owner St-36rd, Red, Nr.10, 8buc/plic -27%

Ancora Tipla Owner St-36rd, Red, Nr.10, 8buc/plic

5636026
Livrare imediată!

39,81Lei(-27%) 28,91Lei

Ancora Tipla Owner St-36rd, Red, Nr.2, 6buc/plic -27%

Ancora Tipla Owner St-36rd, Red, Nr.2, 6buc/plic

5636022
Livrare imediată!

39,81Lei(-27%) 28,91Lei

Ancora Tipla Owner St-36rd, Red, Nr.4, 7buc/plic -27%

Ancora Tipla Owner St-36rd, Red, Nr.4, 7buc/plic

5636023
Livrare imediată!

39,81Lei(-27%) 28,91Lei

Ancora Varivas Nogales Zero Friction Nr.6 -23%

Ancora Varivas Nogales Zero Friction Nr.6

vca11zf06
Livrare imediată!

31,00Lei(-23%) 23,90Lei

Ancora Vmc X-short 7548 Bn Nr.10 -28%

Ancora Vmc X-short 7548 Bn Nr.10

7548 bn10
Livrare imediată!

29,00Lei(-28%) 20,90Lei

Ancora Zebco Topic Treble Hook Nickel Nr.2 -30%

Ancora Zebco Topic Treble Hook Nickel Nr.2

707220005
Livrare imediată!

10,75Lei(-30%) 7,50Lei

Ancore Mustad Black Nickel Nr.12 -27%

Ancore Mustad Black Nickel Nr.12

m.35647bln.12
Livrare imediată!

20,31Lei(-27%) 14,90Lei

Ancore Triple Delphin Bomb Multihook Nr.10, 6buc/plic -48%

Ancore Triple Delphin Bomb Multihook Nr.10, 6buc/plic

966101010
Livrare imediată!

19,00Lei(-48%) 9,90Lei

Anou Maver 10buc Ovale L -25%
Exclusiv online!

Anou Maver 10buc Ovale L

t323
Livrare 48-72 ore

16,60Lei(-25%) 12,50Lei

Anou Maver 10buc Ovale S -25%
Exclusiv online!

Anou Maver 10buc Ovale S

t322
Livrare 48-72 ore

16,60Lei(-25%) 12,50Lei

Anouri One More Cast Tackle Vitabitz Rig Rings, Marimea L, 3mm, 20buc/pac -20%

Anouri One More Cast Tackle Vitabitz Rig Rings, Marimea L, 3mm, 20buc/pac

omcrr3
Livrare imediată!

23,59Lei(-20%) 18,90Lei

Anouri One More Cast Tackle Vitabitz Rig Rings, Marimea S, 2.5mm, 20buc/pac -20%
Exclusiv online!

Anouri One More Cast Tackle Vitabitz Rig Rings, Marimea S, 2.5mm, 20buc/pac

omcrr25
Livrare 48-72ore

23,59Lei(-20%) 18,90Lei

Anouri Prologic Ovale Rig Connectors -57%
Exclusiv online!

Anouri Prologic Ovale Rig Connectors

a.pro.48409
Livrare 24-48 ore

28,25Lei(-57%) 12,20Lei

Anouri Rotunde Carp Spirit 3.1mm -33%
Exclusiv online!

Anouri Rotunde Carp Spirit 3.1mm

acs290014
Livrare 48-72ore

12,00Lei(-33%) 8,00Lei

Anti Tangle Feeder Delphin Fdr-t 20cm, 5buc/pac -46%

Anti Tangle Feeder Delphin Fdr-t 20cm, 5buc/pac

935002020
Livrare imediată!

11,00Lei(-46%) 5,90Lei

Anti Tangle Feeder Delphin Fdr-t 5buc 22 Cm -51%

Anti Tangle Feeder Delphin Fdr-t 5buc 22 Cm

935002022
Livrare imediată!

10,00Lei(-51%) 4,90Lei

Anti Tangle Prologic 3cm 20buc/pl -31%

Anti Tangle Prologic 3cm 20buc/pl

a.pro.49890
Livrare imediată!

23,09Lei(-31%) 15,90Lei

Aparat Profiblinker Ptr Netezit Struna -26%

Aparat Profiblinker Ptr Netezit Struna

19
Livrare imediată!

59,00Lei(-26%) 43,90Lei

Afişare 3061 - 3080 din 9014 (451 pagini)
Queries: 7, Total time: 660.759 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '43f32f0a8d7bf4d7350d030f10'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.147)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (301.337)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (358.751)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 3060,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.199)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ONE MORE CAST"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.100)
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
7 (0.110)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37