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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


VIERMISORI CARP EXPERT DE SILICON MIERE

VIERMISORI CARP EXPERT DE SILICON MIERE

79400103
Stoc epuizat

5,50Lei

Viermi Artificiali Berkley Gulp Alive Honey Worms 2.5cm, 25buc -36%

Viermi Artificiali Berkley Gulp Alive Honey Worms 2.5cm, 25buc

1157022
Stoc epuizat

49,94Lei(-36%) 31,99Lei

Viermi Baracuda Baohua rosii comuni breadworms 30g

Viermi Baracuda Baohua rosii comuni breadworms 30g

viermi rosii comuni breadworm
Stoc epuizat

14,90Lei

Viermi Artificiali LIBRA KUKOLKA 2.7cm 020 Cheese 15buc

Viermi Artificiali LIBRA KUKOLKA 2.7cm 020 Cheese 15buc

kukolka27-020
Stoc epuizat

29,50Lei

COLANT SENSAS PENTRU VIERMI 350G

COLANT SENSAS PENTRU VIERMI 350G

a0.s15041
Stoc epuizat

40,92Lei

Viermi Artificiali Worm Libra Largo 3.5cm 026 Cheese 10buc/borcan

Viermi Artificiali Worm Libra Largo 3.5cm 026 Cheese 10buc/borcan

largo35-026
Stoc epuizat

29,50Lei

Viermi Artificiali Worm Libra Larva 3.5cm 006 Cheese 12buc/borcan

Viermi Artificiali Worm Libra Larva 3.5cm 006 Cheese 12buc/borcan

larva35-006
Stoc epuizat

29,50Lei

Viermi Relax Bass Worm 006 16cm 10buc/plic

Viermi Relax Bass Worm 006 16cm 10buc/plic

bw16-006
Stoc epuizat

10,00Lei

VIERMI ARTIFICIALI FLOTANTI ENTERPRISE ALB L

VIERMI ARTIFICIALI FLOTANTI ENTERPRISE ALB L

et18lmw
Stoc epuizat

18,00Lei

VIERMI ARTIFICIALI FLOTANTI ENTERPRISE TACKLE IMITATION MAGGOTS Galben 20BUC/PLIC
Viermi Berkley Powerbait Power Honey Yellow, Garlic, 2.5cm, 55buc/borcan

Viermi Berkley Powerbait Power Honey Yellow, Garlic, 2.5cm, 55buc/borcan

1345790
Livrare imediată!

26,97Lei

Afişare 61 - 71 din 71 (4 pagini)
Queries: 11, Total time: 1,199.490 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'fe9ad51f99eacbc6ae1e7d1ce4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.135)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,198.186)
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 = '3' AND (pd.tag LIKE "%viermi%") 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:724
4 (0.203)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.136)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.082)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.146)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"SENZOR PLANET NOU"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.199)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38