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


Creatura Sakura Zarigani Craw, 114 Watermelon Red Pepper, 78mm, 6.3g, 6buc/pac
Exclusiv online!

Creatura Sakura Zarigani Craw, 114 Watermelon Red Pepper, 78mm, 6.3g, 6buc/pac

131934sapll500778-114
Livrare 48-72 ore

29,46Lei

Grub Biwaa TailGunR 9.0cm, 004 Watermelon Red, 7buc/pac

Grub Biwaa TailGunR 9.0cm, 004 Watermelon Red, 7buc/pac

b002086
Livrare imediată!

31,00Lei

Shad Hide Up Stagger Original 3", 143 Watermelon Black Blue Flake, 7.6cm, 4.5g, 10buc/pac

Shad Hide Up Stagger Original 3", 143 Watermelon Black Blue Flake, 7.6cm, 4.5g, 10buc/pac

hide20858
Livrare imediată!

40,00Lei

Shad Hide Up Stagger Original 2", 143 Watermelon Black Blue Flake, 5.9cm, 8buc/pac

Shad Hide Up Stagger Original 2", 143 Watermelon Black Blue Flake, 5.9cm, 8buc/pac

hide23293
Livrare imediată!

35,00Lei

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm WATERMELON RED -40%

GRUB COLMIC X35 DOUBLE CLAW 3.5" 8.9cm WATERMELON RED

arhkbz02
Livrare imediată!

25,00Lei(-40%) 15,01Lei

Spinnertail Biwaa Divinator, Watermelon Red, 14cm, 22g

Spinnertail Biwaa Divinator, Watermelon Red, 14cm, 22g

b000014
Livrare imediată!

50,00Lei

Shad Lucky John Pro Series Tioga, 7.4cm, PA01 Watermelon, 7buc/pac
Exclusiv online!

Shad Lucky John Pro Series Tioga, 7.4cm, PA01 Watermelon, 7buc/pac

140103-pa01
Livrare 48-72ore

20,00Lei

SHAD SPRO FREESTYLE URBAN PREY SLUG WATERMELON 3.7CM 6BUC PLIC
Exclusiv online!

SHAD SPRO FREESTYLE URBAN PREY SLUG WATERMELON 3.7CM 6BUC PLIC

004695-00504-00000
Livrare 48-72 ore

24,89Lei

CREATURA SPRO FREESTYLE URBAN PREY HOG WATERMELON 5.5CM 5BUC/PLIC

CREATURA SPRO FREESTYLE URBAN PREY HOG WATERMELON 5.5CM 5BUC/PLIC

004695-00304-00000
Livrare imediată!

27,00Lei

Vierme Owner Shiver Tail 115mm 06 Watermelon Green
Exclusiv online!

Vierme Owner Shiver Tail 115mm 06 Watermelon Green

1301375597-06
Livrare 48-72 ore

19,42Lei

SHAD BASS ASSASIN LITL BOSS WB31410 WATERMELON RED 9CM 6 BUC PLIC -37%

SHAD BASS ASSASIN LITL BOSS WB31410 WATERMELON RED 9CM 6 BUC PLIC

091538314103
Livrare imediată!

30,00Lei(-37%) 18,92Lei

Shad Armored Craw 10cm 04 Watermelon Red 6/plic -40%

Shad Armored Craw 10cm 04 Watermelon Red 6/plic

b000447
Livrare imediată!

25,00Lei(-40%) 14,90Lei

CREATURA SPRO FREESTYLE URBAN PREY HOG WATERMELON 7CM 4BUC/PLIC
Exclusiv online!

CREATURA SPRO FREESTYLE URBAN PREY HOG WATERMELON 7CM 4BUC/PLIC

004695-00354-00000
Livrare 48-72 ore

27,00Lei

SHAKY WORM 160mm WATERMELON RED
Exclusiv online!

SHAKY WORM 160mm WATERMELON RED

801020011
Livrare 48-72 ore

27,83Lei

Twister Lunker City Swimming Ribster 4” Grub, 144 Watermelon Red, 10cm, 10buc/blister -27%

Twister Lunker City Swimming Ribster 4” Grub, 144 Watermelon Red, 10cm, 10buc/blister

725442881443
Livrare imediată!

31,50Lei(-27%) 22,90Lei

Creatura Owner Getnet Juster Hog 58mm 02 Watermelon Seed
Exclusiv online!

Creatura Owner Getnet Juster Hog 58mm 02 Watermelon Seed

13013782916-02
Livrare 48-72 ore

33,03Lei

SHAD SPRO FREESTYLE URBAN PREY SLUG WATERMELON 7.3CM 4BUC PLIC
Exclusiv online!

SHAD SPRO FREESTYLE URBAN PREY SLUG WATERMELON 7.3CM 4BUC PLIC

004695-00534-00000
Livrare 48-72 ore

24,89Lei

Shad Biwaa Ultra Hog 7.5cm culoare Watermelon Red -20%

Shad Biwaa Ultra Hog 7.5cm culoare Watermelon Red

b001112
Livrare imediată!

26,00Lei(-20%) 20,80Lei

Shad DAM Effzett Longhorn 110mm 6 g Watermelon

Shad DAM Effzett Longhorn 110mm 6 g Watermelon

80956316
Livrare imediată!

20,18Lei

Shad Lake Fork Live Baby 5.71cm Watermelon Red Pearl

Shad Lake Fork Live Baby 5.71cm Watermelon Red Pearl

01-2500-708
Livrare imediată!

21,52Lei

Afişare 21 - 40 din 114 (6 pagini)
Queries: 11, Total time: 9.884 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = '87c6f7b40bc23af6891bf06efe'
/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:428
3 (5.609)
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('+watermelon' 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.132)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (1.159)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.103)
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.367)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
8 (0.098)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
9 (0.114)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
10 (1.979)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
11 (0.109)
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