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


Minciog Prologic C-series Black 1.80m 1seg -16%

Minciog Prologic C-series Black 1.80m 1seg

svs65033
Livrare imediată!

218,37Lei(-16%) 184,00Lei

Minciog Prologic C3 Ridgid Framed Camo Rubber 1seg 120cm -22%

Minciog Prologic C3 Ridgid Framed Camo Rubber 1seg 120cm

a2.pro.64999
Livrare imediată!

385,20Lei(-22%) 299,00Lei

Minciog Prologic Commander 180m 2seg -20%

Minciog Prologic Commander 180m 2seg

a2.pro.70845
Livrare imediată!

215,74Lei(-20%) 172,59Lei

Minciog Rapture Rubba Tele 180cm -6%

Minciog Rapture Rubba Tele 180cm

084-50-150
Livrare imediată!

125,00Lei(-6%) 117,91Lei

Minciog Scierra Salmon 65x70cm -40%
Exclusiv online!

Minciog Scierra Salmon 65x70cm

a2.sie.48920
Livrare 24-48 ore

236,43Lei(-40%) 142,76Lei

Minciog Telescopic Cormoran 150cm, 50x50cm -30%
Exclusiv online!

Minciog Telescopic Cormoran 150cm, 50x50cm

a2.62.42152
Livrare 24-48 ore

114,30Lei(-30%) 80,02Lei

Mini Clipper Rapala 7cm -49%
Exclusiv online!

Mini Clipper Rapala 7cm

rcdmc
Livrare 48-72ore

39,00Lei(-49%) 20,00Lei

Mini Croseta Spro Concurs -20%

Mini Croseta Spro Concurs

004720-00900-00100
Livrare imediată!

14,90Lei(-20%) 11,90Lei

Mini Swinger Fox Black Label Black -24%

Mini Swinger Fox Black Label Black

csi072
Livrare imediată!

107,94Lei(-24%) 81,78Lei

Mini Swinger Fox Black Label Blue -24%

Mini Swinger Fox Black Label Blue

csi071
Livrare imediată!

107,94Lei(-24%) 81,78Lei

Mini Swinger Fox Black Label Green -24%

Mini Swinger Fox Black Label Green

csi070
Livrare imediată!

107,94Lei(-24%) 81,78Lei

Mini Swinger Fox Black Label Orange -24%

Mini Swinger Fox Black Label Orange

csi069
Livrare imediată!

107,94Lei(-24%) 81,78Lei

Mini Swinger Fox Black Label Purple -17%

Mini Swinger Fox Black Label Purple

csi073
Livrare imediată!

107,94Lei(-17%) 89,99Lei

Mini Swinger Fox Black Label Red -17%

Mini Swinger Fox Black Label Red

csi068
Livrare imediată!

107,94Lei(-17%) 89,99Lei

Mini Swinger Fox Black Label White -24%

Mini Swinger Fox Black Label White

csi074
Livrare imediată!

107,94Lei(-24%) 81,78Lei

Momeala Artificiala Berkley Gulp Alive Hlfp Nereis 6 Camo -21%

Momeala Artificiala Berkley Gulp Alive Hlfp Nereis 6 Camo

1309095
Livrare imediată!

89,96Lei(-21%) 70,90Lei

Momeala Artificiala Berkley Gulp Alive Hlfp Nereis 6 Natural -21%

Momeala Artificiala Berkley Gulp Alive Hlfp Nereis 6 Natural

1309096
Livrare imediată!

89,96Lei(-21%) 70,90Lei

Momitor Carp Zoom Feeder Picatura 10gr -24%

Momitor Carp Zoom Feeder Picatura 10gr

cz9426
Livrare imediată!

5,50Lei(-24%) 4,20Lei

Momitor Carp Zoom Method Feeder Flat 20g -17%
Exclusiv online!

Momitor Carp Zoom Method Feeder Flat 20g

cz9743
Livrare 48-72 ore

11,50Lei(-17%) 9,50Lei

Momitor Carp Zoom Method Feeder Flat 30g -17%

Momitor Carp Zoom Method Feeder Flat 30g

cz9750
Livrare imediată!

12,00Lei(-17%) 9,90Lei

Afişare 6321 - 6340 din 9028 (452 pagini)
Queries: 6, Total time: 561.977 ms [By time] [By id] [By file]
1 (0.069)
SELECT data
FROM `oc_session`
WHERE session_id = '530f13d960e07a0d6bda7b0001'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (265.240)
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 = '3' 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 (296.270)
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 = '3' 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 6320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.181)
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
6 (0.127)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37