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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Micro Sd Maxell 4gb Cu Adaptor Sd Class 10 -30%

Micro Sd Maxell 4gb Cu Adaptor Sd Class 10

microsd 4gb
Livrare imediată!

23,00Lei(-30%) 16,15Lei

Minciog Abu Garcia Folding Net Rubber 50x65x40 -19%

Minciog Abu Garcia Folding Net Rubber 50x65x40

1516967
Livrare imediată!

269,96Lei(-19%) 217,49Lei

Minciog Barca Rapala Floating Rubber Net 45x50cm -19%

Minciog Barca Rapala Floating Rubber Net 45x50cm

rnfshn-m
Livrare imediată!

139,00Lei(-19%) 112,75Lei

Minciog Berkley Telescopic Catch And Relase -5%

Minciog Berkley Telescopic Catch And Relase

1275848
Livrare imediată!

297,50Lei(-5%) 281,64Lei

Minciog Carp Spirit Blax X-net 42" 105cm 1.82m -27%
Exclusiv online!

Minciog Carp Spirit Blax X-net 42" 105cm 1.82m

acs490078
Livrare 48-72 ore

249,01Lei(-27%) 181,89Lei

Minciog Carp Zoom Crap Vip Boilie 106x106x100 180cm -23%
Exclusiv online!

Minciog Carp Zoom Crap Vip Boilie 106x106x100 180cm

cz2934
Livrare 48-72 ore

362,00Lei(-23%) 278,49Lei

Minciog Carp Zoom Gamma-n 2 Sectiuni 70x70x250cm -23%
Exclusiv online!

Minciog Carp Zoom Gamma-n 2 Sectiuni 70x70x250cm

cz3699
Livrare 48-72 ore

185,00Lei(-23%) 143,25Lei

Minciog Carp Zoom Predator-z Oplus Tele 40x50/134cm -20%

Minciog Carp Zoom Predator-z Oplus Tele 40x50/134cm

cz3864
Livrare imediată!

167,00Lei(-20%) 134,10Lei

Minciog Cormoran Compact 170cm, 50x50cm -28%
Exclusiv online!

Minciog Cormoran Compact 170cm, 50x50cm

a2.62.45173
Livrare 24-48 ore

176,56Lei(-28%) 126,67Lei

Minciog Crap Fl Coada Carbon Din 2 Seg 180cm -30%
Exclusiv online!

Minciog Crap Fl Coada Carbon Din 2 Seg 180cm

5123184
Livrare 7-14 zile

250,00Lei(-30%) 174,77Lei

Minciog Mivardi Classic Eco 210 -26%

Minciog Mivardi Classic Eco 210

m-poeco21
Livrare imediată!

88,00Lei(-26%) 64,96Lei

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

Minciog Prologic C-series Black 1.80m 1seg

svs65033
Livrare imediată!

218,36Lei(-14%) 188,09Lei

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

Minciog Prologic C3 Ridgid Framed Camo Rubber 1seg 120cm

a2.pro.64999
Livrare imediată!

385,20Lei(-21%) 305,03Lei

Minciog Prologic Commander 180m 2seg -18%

Minciog Prologic Commander 180m 2seg

a2.pro.70845
Livrare imediată!

215,73Lei(-18%) 176,48Lei

Minciog Rapture Rubba Tele 180cm -3%

Minciog Rapture Rubba Tele 180cm

084-50-150
Livrare imediată!

125,01Lei(-3%) 120,88Lei

Mini Clipper Rapala 7cm -43%
Exclusiv online!

Mini Clipper Rapala 7cm

rcdmc
Livrare 48-72 ore

39,00Lei(-43%) 22,25Lei

Mini Croseta Spro Concurs -12%

Mini Croseta Spro Concurs

004720-00900-00100
Livrare imediată!

14,90Lei(-12%) 13,10Lei

Mini Swinger Fox Black Label Black -22%

Mini Swinger Fox Black Label Black

csi072
Livrare imediată!

107,94Lei(-22%) 84,16Lei

Mini Swinger Fox Black Label Blue -22%

Mini Swinger Fox Black Label Blue

csi071
Livrare imediată!

107,94Lei(-22%) 84,16Lei

Mini Swinger Fox Black Label Green -22%

Mini Swinger Fox Black Label Green

csi070
Livrare imediată!

107,94Lei(-22%) 84,16Lei

Afişare 6561 - 6580 din 9198 (460 pagini)
Queries: 5, Total time: 643.117 ms [By time] [By id] [By file]
1 (0.161)
SELECT data
FROM `oc_session`
WHERE session_id = '11cf8baedd1873e4805a1570e8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (307.574)
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 (335.112)
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 6560,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.162)
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