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


LANSETA CARP ZOOM MESH PRO CARP 12ft 3.6m 3.0lb 3 SEGMENTE

LANSETA CARP ZOOM MESH PRO CARP 12ft 3.6m 3.0lb 3 SEGMENTE

cz8854
Stoc epuizat

335,00Lei

LINIE VARGA 3 CARP ZOOM 2GR 8M 0.16MM NR14

LINIE VARGA 3 CARP ZOOM 2GR 8M 0.16MM NR14

cz2201
Stoc epuizat

13,99Lei

Mulineta Carp Zoom Black Ghost BBC Baitrunner 3000

Mulineta Carp Zoom Black Ghost BBC Baitrunner 3000

cz0313
Stoc epuizat

211,00Lei

MARKER CARP ZOOM

MARKER CARP ZOOM

cz1014
Stoc epuizat

25,00Lei

AGRAFA RAPIDA CARP ZOOM L 13.5x5MM

AGRAFA RAPIDA CARP ZOOM L 13.5x5MM

cz1977
Stoc epuizat

12,00Lei

Lanseta Carp Zoom Predator Z Oplus Twitch Cast 2.05m 7-28g

Lanseta Carp Zoom Predator Z Oplus Twitch Cast 2.05m 7-28g

cz0559
Stoc epuizat

281,99Lei

Geanta Carp Zoom pentru Uscat Boilies, 10kg, 45x60cm

Geanta Carp Zoom pentru Uscat Boilies, 10kg, 45x60cm

cz1451
Stoc epuizat

57,00Lei

Scaun Carp Zoom Easy Comfort Armchair

Scaun Carp Zoom Easy Comfort Armchair

cz5790
Stoc epuizat

320,00Lei

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

Afişare 1181 - 1200 din 2138 (107 pagini)
Queries: 5, Total time: 50.386 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '5f450611580d9e49d0a6ddb2c3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.142)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (42.719)
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 (7.272)
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.132)
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