Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

-46%

Boiliesuri, Dipuite, De, Carlig, MG, Special, Carp, Miere, 200gr, mg2431, Boiliesuri Tari, Boiliesuri Tari MG Special Carp, MG Special Carp

mg2431

Livrare imediată!

18,00Lei(-46%) 9,66Lei

BENZAR TURBO BOILIE 250G 20MM CAPSUNI

98016013

Livrare imediată!

7,50Lei

BENZAR TURBO BOILIE 250G 16MM SCOICA

98016698

Livrare imediată!

7,50Lei

Benzar Turbo Boilie Bicolor Crab capsuni 250g 16mm

98017111

Livrare imediată!

9,50Lei

Exclusiv online!

BOILIES CARLIG THE ONE GOLD 14/18/20MM 150GR

98036927

Livrare 24-48 ore

24,00Lei

Wafters CPK Critic Echilibrate Feeder Special Fruits, 8mm, 30g

999853

Livrare imediată!

20,00Lei

BENZAR TURBO BOILIE 250G 16MM ANANAS

98016676

Livrare imediată!

7,50Lei

BENZAR TURBO BOILIE 250G 20MM LT FISH

98016064

Livrare imediată!

7,50Lei

Wafters CPK Critic Echilibrate Feeder Krill, 8mm, 30g

999852

Livrare imediată!

20,00Lei

Benzar Turbo Boilie Bicolor Crab capsuni 250g 20mm

98017101

Livrare imediată!

9,50Lei

Benzar Turbo Boilie Bicolor Halibut Usturoi 250g 20mm

98017104

Livrare imediată!

9,50Lei

BOILIES DE CARLIG CPK WAFTER SWEET CORN 10MM SI 14MM 60G

999884

Livrare imediată!

18,00Lei

BOILIES DE CARLIG CPK WAFTER USTUROI 10MM SI 14MM 60G

999883

Livrare imediată!

18,00Lei

BENZAR TURBO BOILIE 250G 20MM SCOICA

98016098

Livrare imediată!

7,50Lei

Boilies CPK High Attract Sweetcorn Tari 16mm 800g

999536

Livrare imediată!

25,00Lei

Benzar Turbo Boilie Bicolor Krill Scopex 250g 16mm

98017115

Livrare imediată!

9,50Lei

Benzar Turbo Boilie Bicolor Peste prune 250g 16mm

98017113

Livrare imediată!

9,50Lei

BENZAR TURBO BOILIE 250G 16MM LT FISH

98016664

Livrare imediată!

7,50Lei

BENZAR TURBO BOILIE 250G 16MM MIERE

98016603

Livrare imediată!

7,50Lei

Boilies Radical Method Marbles Pink Tuna 9mm 75g

9013962105

Livrare imediată!

31,12Lei

Afişare 81 - 100 din 360 (18 pagini)

Queries: 9, Total time: 3,632.269 ms [By time] [By id] [By file]

1 (0.115)

SELECT data
FROM `oc_session`
WHERE session_id = 'c7411572ee83689ad9f4717293'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.230)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.145)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (1,404.295)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%boiliesuri%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 80, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

5 (0.261)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%boiliesuri%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014

6 (2,216.032)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%boiliesuri%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923

7 (10.919)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

8 (0.135)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.137)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare