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


Plumbi Drop Shot Konger Stick Weight 12g, 3buc/pac

Plumbi Drop Shot Konger Stick Weight 12g, 3buc/pac

40306665030012
Livrare imediată!

5,85Lei

Shad Zeck Dude 6.4cm, 2g, Ayu, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Ayu, 1buc/pac

130105220191
Livrare imediată!

4,00Lei

Shad Zeck Dude 6.4cm, 2g, Black Flake Orange, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Black Flake Orange, 1buc/pac

130105220305
Livrare imediată!

4,00Lei

Shad Zeck Dude 6.4cm, 2g, Blue Ice, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Blue Ice, 1buc/pac

130105220193
Livrare imediată!

4,00Lei

Shad Zeck Dude 6.4cm, 2g, Moor Kiwi, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Moor Kiwi, 1buc/pac

130105220198
Livrare imediată!

4,00Lei

Shad Zeck Dude 6.4cm, 2g, Purple Chartreuse, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Purple Chartreuse, 1buc/pac

130105220303
Livrare imediată!

4,00Lei

Shad Zeck Dude 6.4cm, 2g, Red Silver, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Red Silver, 1buc/pac

130105220302
Livrare imediată!

4,00Lei

Vobler, Jackall, TN50, Trigon,, Noike, Piero,, 5.2cm,, 11.2g, ja.807263855, Voblere Sinking, Voblere Sinking Jackall, Voblere Jackall, Sinking Jackall, Jackall
Vobler, Rapture, Pro, X, Vibe, Sinking,, SMG,, 12g,, 5cm, 180-22-603, Voblere Sinking, Voblere Sinking Rapture, Voblere Rapture, Sinking Rapture, Rapture
Vobler Tiemco Luray 62S, 003 LH Lime Shaft Yamame, 62mm, 4.2g
Exclusiv online!

Vobler Tiemco Luray 62S, 003 LH Lime Shaft Yamame, 62mm, 4.2g

310442362003
Livrare 48-72 ore

82,00Lei

Vobler Tiemco Luray 62S, 006 Lime Back Pearl Yamame, 62mm, 4.2g
Exclusiv online!

Vobler Tiemco Luray 62S, 006 Lime Back Pearl Yamame, 62mm, 4.2g

310442362006
Livrare 48-72 ore

82,00Lei

Broasca Swimy Frog, 55mm, 12g, 92

Broasca Swimy Frog, 55mm, 12g, 92

131935swplg500655-92
Livrare imediată!

35,05Lei

Lanseta Penn Conflict Elite Spinning, 2.13m, 6-32g, 1+1seg
Exclusiv online!

Lanseta Penn Conflict Elite Spinning, 2.13m, 6-32g, 1+1seg

1558337
Livrare 7-14 zile

1.484,96Lei

Lanseta Penn Conflict Elite Spinning, 2.44m, 6-32g, 1+1seg
Exclusiv online!

Lanseta Penn Conflict Elite Spinning, 2.44m, 6-32g, 1+1seg

1558359
Livrare 7-14 zile

1.574,96Lei

LINGURITA OSCILANTA YARIE 704 RINGO MIDI HAMMERED E69 FIRE BLUE 2G
Exclusiv online!

LINGURITA OSCILANTA YARIE 704 RINGO MIDI HAMMERED E69 FIRE BLUE 2G

y70420e69
Livrare 48-72 ore

25,00Lei

Pluta, iBite, River, Balsa,, 2g, 69800002, Plute Stationar, Plute Stationar iBite, Plute iBite, Stationar iBite, iBite
Exclusiv online!

Pluta, iBite, River, Balsa,, 2g, 69800002, Plute Stationar, Plute Stationar iBite, Plute iBite, Stationar iBite, iBite

69800002
Livrare 24-48 ore

34,32Lei

Shad, Hide, Up, Stagger, Original, 2.5", Salt,, S-05, Red, Gold, Red, Flake,, 6.6cm,, 2.2g,, 7buc/pac, hide24481, Shad-uri, Shad-uri Hide Up, Shad-uri Hide Up, Hide Up
Shad Hide Up Stagger Original 2.5", 141 Natural Green Blue, 6.6cm, 2.2g, 7buc/pac

Shad Hide Up Stagger Original 2.5", 141 Natural Green Blue, 6.6cm, 2.2g, 7buc/pac

hide23385
Livrare imediată!

36,00Lei

Shad, Savage, Gear, Craft, Bleak,, Bleack,, 8.5cm,, 4.2g,, 5buc/pac, f1.sg.1609110, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, Green, Pearl, Yellow,, 8.5cm,, 4.2g,, 5buc/pac, f1.sg.1609112, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Afişare 161 - 180 din 803 (41 pagini)
Queries: 14, Total time: 244.720 ms [By time] [By id] [By file]
1 (0.068)
SELECT data
FROM `oc_session`
WHERE session_id = '14f14e06a1f08af459027da328'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.066)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.064)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (221.291)
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 = '0' AND ((pd.tag LIKE '%6%' AND pd.tag LIKE '%2g%')) 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:693
6 (0.202)
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:1547
7 (6.054)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (1.407)
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:1204
9 (0.084)
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:1223
10 (0.310)
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:978
11 (14.795)
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:900
12 (0.132)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.084)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38