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


Bocanci Delphin TYRE X, Marime 46

Bocanci Delphin TYRE X, Marime 46

101002896
Stoc epuizat

279,00Lei

BOCANCI JAXON IARNA TRAPPER ZF 44

BOCANCI JAXON IARNA TRAPPER ZF 44

ak-bzf44
Stoc epuizat

545,00Lei

BOCANCI JAXON IARNA TRAPPER ZF 45

BOCANCI JAXON IARNA TRAPPER ZF 45

ak-bzf45
Stoc epuizat

545,00Lei

BOCANCI SAVAGE OFFROAD MAS.44

BOCANCI SAVAGE OFFROAD MAS.44

a8.sg.46812
Stoc epuizat

729,42Lei

Ghete Delphin GATOR Marime 47 Green Black

Ghete Delphin GATOR Marime 47 Green Black

768000047
Stoc epuizat

236,00Lei

Bocanci Carp Zoom Winter Walk 42

Bocanci Carp Zoom Winter Walk 42

cz7282
Stoc epuizat

180,00Lei

GHETE JAXON WADING CU TALPA PROTECTIE DURA SI NITURI 45

GHETE JAXON WADING CU TALPA PROTECTIE DURA SI NITURI 45

ak-bzk45vx
Stoc epuizat

670,01Lei

Pantofi Savage Sport Gear Sneakers MAR. 42

Pantofi Savage Sport Gear Sneakers MAR. 42

a8.sg.62316
Stoc epuizat

180,88Lei

GHETE JAXON WADING CU TALPA PROTECTIE DURA 44

GHETE JAXON WADING CU TALPA PROTECTIE DURA 44

ak-bzk44v
Stoc epuizat

620,00Lei

Pantofi Savage Sport Gear Sneakers MAR. 43 -50%

Pantofi Savage Sport Gear Sneakers MAR. 43

a8.sg.62317
Stoc epuizat

361,75Lei(-50%) 180,88Lei

Bocanci Norfin Snow Green marime 44

Bocanci Norfin Snow Green marime 44

13980-44
Stoc epuizat

235,00Lei

Ghete Delphin GATOR Marime 46 Green Black

Ghete Delphin GATOR Marime 46 Green Black

768000046
Stoc epuizat

236,00Lei

Ghete Delphin GATOR Marime 43 Green Black

Ghete Delphin GATOR Marime 43 Green Black

768000043
Stoc epuizat

236,00Lei

GHETE Fox Camo Khaki nr.43

GHETE Fox Camo Khaki nr.43

cfw152
Stoc epuizat

269,96Lei

Ghete Nash ZT Trail Boots, Marime 42

Ghete Nash ZT Trail Boots, Marime 42

c6113
Stoc epuizat

389,99Lei

Ghete Nash ZT Trail Boots, Marime 46

Ghete Nash ZT Trail Boots, Marime 46

c6117
Stoc epuizat

389,99Lei

Ghete Nash ZT Polar Boots, Marime 45

Ghete Nash ZT Polar Boots, Marime 45

c6122
Stoc epuizat

270,00Lei

Ghete Nash ZT Polar Boots, Marime 46

Ghete Nash ZT Polar Boots, Marime 46

c6123
Stoc epuizat

270,00Lei

GHETE Fox Camo Khaki nr.45

GHETE Fox Camo Khaki nr.45

cfw154
Stoc epuizat

269,96Lei

GHETE Fox Camo Khaki nr.46

GHETE Fox Camo Khaki nr.46

cfw155
Stoc epuizat

269,96Lei

Afişare 121 - 140 din 160 (8 pagini)
Queries: 6, Total time: 6.461 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '30697405f8f8e8f9523e413633'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (5.847)
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 (MATCH(pd.tag) AGAINST('+bocanci' 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 (0.135)
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.129)
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
6 (0.139)
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