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


Boilies Carp Zoom Xxl Water Insect 30mm 500Gr Amino - Larve - Viermi -30%

Boilies Carp Zoom Xxl Water Insect 30mm 500Gr Amino - Larve - Viermi

cz6265
Stoc epuizat

22,00Lei(-30%) 15,40Lei

Ascutitor Carlige Carp Zoom Pocket Hook Sharpener

Ascutitor Carlige Carp Zoom Pocket Hook Sharpener

cz3361
Stoc epuizat

30,00Lei

Cort Carp Zoom Pop Up Shelter 150x150x180cm

Cort Carp Zoom Pop Up Shelter 150x150x180cm

cz2546
Stoc epuizat

230,00Lei

Surub PENTRU POP-UP CARP ZOOM ELEMENTS 12MM NEGRU

Surub PENTRU POP-UP CARP ZOOM ELEMENTS 12MM NEGRU

cz8526
Stoc epuizat

8,00Lei

CORT CARP ZOOM INSTAQUICK SHELTER 180x180x205cm

CORT CARP ZOOM INSTAQUICK SHELTER 180x180x205cm

cz5196
Stoc epuizat

963,00Lei

Sac De Dormit Carp Zoom Carp Extreme 210x84cm 3.8 Kg

Sac De Dormit Carp Zoom Carp Extreme 210x84cm 3.8 Kg

cz9639
Stoc epuizat

459,99Lei

Mulineta Carp Zoom Black Ghost BBC Baitrunner 4000

Mulineta Carp Zoom Black Ghost BBC Baitrunner 4000

cz0320
Stoc epuizat

304,00Lei

CLIPS MONTURA PLUMB PIERDUT CARP ZOOM

CLIPS MONTURA PLUMB PIERDUT CARP ZOOM

cz7795
Stoc epuizat

20,00Lei

Mulineta Carp Zoom Predator Z Oplus Red-Act 3000 FD -30%

Mulineta Carp Zoom Predator Z Oplus Red-Act 3000 FD

cz0580
Stoc epuizat

265,00Lei(-30%) 186,00Lei

BRANTURI BOCANCI CARP ZOOM 41

BRANTURI BOCANCI CARP ZOOM 41

cz4665
Stoc epuizat

7,50Lei

CUTIE RIGURI CARP ZOOM

CUTIE RIGURI CARP ZOOM

cz2608
Stoc epuizat

30,00Lei

CLIPS MONTURA PLUMB PIERDUT + BLOCAJ VERDE MAT CARP ZOOM

CLIPS MONTURA PLUMB PIERDUT + BLOCAJ VERDE MAT CARP ZOOM

cz1885
Stoc epuizat

16,01Lei

ZIG RIG Carp Zoom FOAM ALIGNER COLOR MIX

ZIG RIG Carp Zoom FOAM ALIGNER COLOR MIX

cz3702
Stoc epuizat

16,51Lei

PISTOL BOILIES CARP ZOOM HEAVY DUTY

PISTOL BOILIES CARP ZOOM HEAVY DUTY

cz0772
Stoc epuizat

119,00Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION 250m 0.15MM 2.9KG -30%

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION 250m 0.15MM 2.9KG

cz5327
Stoc epuizat

16,20Lei(-30%) 11,40Lei

STOPER ADJUSTER CARP ZOOM FEEDER COMPETITION

STOPER ADJUSTER CARP ZOOM FEEDER COMPETITION

cz5402
Stoc epuizat

11,50Lei

Aditiv Carp Zoom Feeder Competition Method Crush 120g -30%

Aditiv Carp Zoom Feeder Competition Method Crush 120g

cz5363
Stoc epuizat

11,00Lei(-30%) 7,70Lei

MOMITOR CARP ZOOM FEEDER PICATURA ECOLOGIC 20gr

MOMITOR CARP ZOOM FEEDER PICATURA ECOLOGIC 20gr

cz9464
Stoc epuizat

7,50Lei

SWINGER CARP ZOOM S1 LUMINO ROSU

SWINGER CARP ZOOM S1 LUMINO ROSU

cz3506
Stoc epuizat

68,00Lei

Banda fixare lanseta Carp Zoom Neopren Rod Band 4x26cm

Banda fixare lanseta Carp Zoom Neopren Rod Band 4x26cm

cz3390
Stoc epuizat

26,00Lei

Afişare 1181 - 1200 din 2132 (107 pagini)
Queries: 5, Total time: 82.346 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '4b932ef1d9da0ba15e6afbcc60'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (73.383)
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('+zoom' 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 (8.672)
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 1180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.122)
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