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


Mulineta Okuma Big Bomber Spod 8000S

Mulineta Okuma Big Bomber Spod 8000S

bbs-8000s
Stoc epuizat

369,00Lei

VOBLER RAPALA BX BRAT BIG 7 cm 21 g CBN

VOBLER RAPALA BX BRAT BIG 7 cm 21 g CBN

bxbb06 cbn
Stoc epuizat

69,00Lei

Carlige Wizard Big Eye Micro 2 5buc/plic

Carlige Wizard Big Eye Micro 2 5buc/plic

46515002
Stoc epuizat

6,50Lei

Carlige Wizard Big Eye Twister nr 2 5buc/plic

Carlige Wizard Big Eye Twister nr 2 5buc/plic

46510002
Stoc epuizat

6,50Lei

VOBLER RAPALA BX BRAT BIG 7 cm 21 g BGH

VOBLER RAPALA BX BRAT BIG 7 cm 21 g BGH

bxbb06 bgh
Stoc epuizat

69,00Lei

Intinzator Linii Varga STONFO 147 Kriss Winder Anchor, Big Size, 12buc/pac

Intinzator Linii Varga STONFO 147 Kriss Winder Anchor, Big Size, 12buc/pac

8028651001476
Stoc epuizat

7,50Lei

Carlige Wizard Big Eye Twister nr 6 5buc/plic

Carlige Wizard Big Eye Twister nr 6 5buc/plic

46510006
Stoc epuizat

6,50Lei

BAC NADA CORMORAN BIG-B 30X20CM

BAC NADA CORMORAN BIG-B 30X20CM

a8.65.20200
Stoc epuizat

66,39Lei

GEANTA SAVAGE GEAR BIG BAG XL 83L

GEANTA SAVAGE GEAR BIG BAG XL 83L

a8.sg.74255
Stoc epuizat

102,49Lei

NADA SENSAS BIG BAG HALIBUT/HEMP 2KG -8%

NADA SENSAS BIG BAG HALIBUT/HEMP 2KG

a0.s54233
Stoc epuizat

61,18Lei(-8%) 56,00Lei

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

cz5935
Stoc epuizat

241,00Lei

Suport Delphin feeder EVA Big BEND

Suport Delphin feeder EVA Big BEND

101001467
Stoc epuizat

75,01Lei

Grub Big Hammer Salt Shaker Worm Watermelon Red, 12.5cm, 10buc/plic

Grub Big Hammer Salt Shaker Worm Watermelon Red, 12.5cm, 10buc/plic

ssw50215
Stoc epuizat

23,00Lei

Grub Big Hammer Salt Shaker Worms 4" Pumpkin Red, 10cm, 6buc/pac

Grub Big Hammer Salt Shaker Worms 4" Pumpkin Red, 10cm, 6buc/pac

ssw40225
Stoc epuizat

16,01Lei

Fir Monofilament Berkley Trilene Big Game Verde 40kg 0.75mm 600m

Fir Monofilament Berkley Trilene Big Game Verde 40kg 0.75mm 600m

1342712
Stoc epuizat

103,05Lei

Fir Monofilament Berkley Trilene Big Game Verde 50.0kg 0.90mm 600m

Fir Monofilament Berkley Trilene Big Game Verde 50.0kg 0.90mm 600m

1342713
Stoc epuizat

103,05Lei

Mulineta Okuma Big Bomber Spod 7000S -10%

Mulineta Okuma Big Bomber Spod 7000S

bbs-7000s
Stoc epuizat

399,00Lei(-10%) 359,09Lei

LANSETA KORUM BIG WATER 3.65M 2.50LBS 2seg

LANSETA KORUM BIG WATER 3.65M 2.50LBS 2seg

k0330041
Stoc epuizat

674,96Lei

LANSETA KORUM BIG WATER 3.95M 2.75LBS 3seg

LANSETA KORUM BIG WATER 3.95M 2.75LBS 3seg

k0330044
Stoc epuizat

719,96Lei

LANSETA KORUM BIG WATER 3.95M 2.75LBS 2seg

LANSETA KORUM BIG WATER 3.95M 2.75LBS 2seg

k0330043
Stoc epuizat

719,96Lei

Afişare 441 - 460 din 555 (28 pagini)
Queries: 9, Total time: 16.886 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '7f61dd3d239bfeaee85e8ff277'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (13.770)
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('+big' 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 (2.318)
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 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.103)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.077)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.119)
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