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 300 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


RTB Dual Blade Spinnerbait 16g Orange Glitter

RTB Dual Blade Spinnerbait 16g Orange Glitter

rtb8152
Stoc epuizat

15,01Lei

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 300m, 0.20mm, 40lb
Boilies Dynamite Baits CarpTec Chocolate Orange, 20mm, 1,8kg -11%

Boilies Dynamite Baits CarpTec Chocolate Orange, 20mm, 1,8kg

dy1783
Stoc epuizat

69,00Lei(-11%) 61,60Lei

Grub Delalande Sandra 12cm Orange 35

Grub Delalande Sandra 12cm Orange 35

3520519894022
Stoc epuizat

6,50Lei

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 300m, 0.16mm, 25lb -20%

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 300m, 0.16mm, 25lb

cbl020
Stoc epuizat

216,00Lei(-20%) 172,80Lei

Cap Jig Articulat Fanatik Granennyy 6gr Orange 5buc/plic

Cap Jig Articulat Fanatik Granennyy 6gr Orange 5buc/plic

41713cfg02306
Stoc epuizat

7,24Lei

Fir Monofilament PB Products Control, Fluo Orange, 0.38mm, 12.70kg, 1250m

Fir Monofilament PB Products Control, Fluo Orange, 0.38mm, 12.70kg, 1250m

pb11043
Stoc epuizat

149,00Lei

Grub Delalande Sandra 9cm Orange Black Head 96

Grub Delalande Sandra 9cm Orange Black Head 96

3520519894015
Stoc epuizat

4,90Lei

Shad Delalande Shad GT 11cm Orange Black Head 96

Shad Delalande Shad GT 11cm Orange Black Head 96

3520519894060
Stoc epuizat

5,90Lei

Vobler Rapala Shad Rap Elite, 7.5cm, 12g, Gilded Chartreuse Orange Belly

Vobler Rapala Shad Rap Elite, 7.5cm, 12g, Gilded Chartreuse Orange Belly

sre75 gdco
Stoc epuizat

69,00Lei

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 600m, 0.16mm, 25lb -20%

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 600m, 0.16mm, 25lb

cbl021
Stoc epuizat

402,53Lei(-20%) 322,03Lei

Fir Select Baits SilkRay Fluo Matt Orange 0.35/1000m -25%

Fir Select Baits SilkRay Fluo Matt Orange 0.35/1000m

sel-0621261
Stoc epuizat

59,00Lei(-25%) 43,99Lei

Grub Delalande Sandra 12cm Orange Black Head 96

Grub Delalande Sandra 12cm Orange Black Head 96

3520519894039
Stoc epuizat

6,50Lei

Grub Delalande Sandra 16cm Yellow Orange Back 98

Grub Delalande Sandra 16cm Yellow Orange Back 98

3520519886447
Stoc epuizat

12,99Lei

Clips pentru Rame Zeck Worm Clip Hair-Rig, 17mm, 5buc/pac

Clips pentru Rame Zeck Worm Clip Hair-Rig, 17mm, 5buc/pac

41605110232
Stoc epuizat

20,38Lei

Combo Mitchell Colors MX Casting Combo M, Orange, 7-35g, 2.23m, 2seg

Combo Mitchell Colors MX Casting Combo M, Orange, 7-35g, 2.23m, 2seg

1554055
Stoc epuizat

584,96Lei

Grub Delalande Sandra 9cm Orange 35

Grub Delalande Sandra 9cm Orange 35

3520519894008
Stoc epuizat

4,90Lei

Hamac Ticket to the Moon King Size Royal Blue Orange, 320x230cm

Hamac Ticket to the Moon King Size Royal Blue Orange, 320x230cm

tmk3935
Stoc epuizat

369,00Lei

Plumb Feed Orange cu Vartej, 99g

Plumb Feed Orange cu Vartej, 99g

40341lf299
Stoc epuizat

9,50Lei

Shad Delalande Shad GT 13cm Orange Black Head 96

Shad Delalande Shad GT 13cm Orange Black Head 96

3520519894077
Stoc epuizat

12,00Lei

Afişare 1541 - 1560 din 1609 (81 pagini)
Queries: 7, Total time: 236.403 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'ab03b525df79bedbea5d680a49'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (229.443)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%orange%") 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:698
4 (6.422)
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 1540, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.109)
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.095)
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.145)
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