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


Spinnerbait Bertilure Cu Doua Palete SHALLOW KILLER COLORADO Model COLORADO Culoare FIRE_TIGER 11 gr.

Spinnerbait Bertilure Cu Doua Palete SHALLOW KILLER COLORADO Model COLORADO Culoare FIRE_TIGER 11 gr.

s-03-712
Livrare imediată!

21,40Lei

SPINERBAIT, COLMIC, FLATTER, COMPACT, 1/4oz, 7gr, Waka, Waka, arhkfg04, Spinnerbaits, Spinnerbaits Colmic, Colmic
Exclusiv online!

SPINERBAIT, COLMIC, FLATTER, COMPACT, 1/4oz, 7gr, Waka, Waka, arhkfg04, Spinnerbaits, Spinnerbaits Colmic, Colmic

arhkfg04
Livrare 48-72 ore

37,00Lei

Carlige Trailer Bertilure pentru Spinnerbait 6buc/plic 1/0

Carlige Trailer Bertilure pentru Spinnerbait 6buc/plic 1/0

s-03-902
Livrare imediată!

14,30Lei

Spinnerbait Bertilure Cu Doua Palete SPINNERBAIT CU SKIRT COLORADO Model SALCIE Culoare ALB - NEGRU 14 gr.
NALUCA DAIWA PROREX MICRO SPINNER 3.5G BLACK DEVIL
Exclusiv online!

NALUCA DAIWA PROREX MICRO SPINNER 3.5G BLACK DEVIL

f.d.15426.000
Livrare 24-48 ore

36,82Lei

NALUCA DAIWA PROREX WILLOW SPINNER 7G GREEN CHARTREUSE

NALUCA DAIWA PROREX WILLOW SPINNER 7G GREEN CHARTREUSE

f.d.15426.103
Livrare imediată!

38,68Lei

SPINERBAIT, COLMIC, FLATTER, COMPACT, 1/4oz, 7gr, Killer, Ayu, arhkfg07, Spinnerbaits, Spinnerbaits Colmic, Colmic
Exclusiv online!

SPINERBAIT, COLMIC, FLATTER, COMPACT, 1/4oz, 7gr, Killer, Ayu, arhkfg07, Spinnerbaits, Spinnerbaits Colmic, Colmic

arhkfg07
Livrare 48-72 ore

37,00Lei

SPINNERBAIT COLMIC FLATTER 14GR WAKA WAKA -30%
Exclusiv online!

SPINNERBAIT COLMIC FLATTER 14GR WAKA WAKA

arhkci04
Livrare 48-72 ore

36,00Lei(-30%) 25,20Lei

SPINNERBAIT FOX RAGE 14G Table Rock

SPINNERBAIT FOX RAGE 14G Table Rock

nsa005
Livrare imediată!

44,96Lei

SPINNERBAIT COLMIC FLATTER 21GR CHATREUSE/WHITE -30%

SPINNERBAIT COLMIC FLATTER 21GR CHATREUSE/WHITE

arhkcl03
Livrare imediată!

38,00Lei(-30%) 26,60Lei

Rapture Spiner Blade Single 14Gr
Exclusiv online!

Rapture Spiner Blade Single 14Gr

188-21-101
Livrare 48-72 ore

19,30Lei

SPINERBAIT COLMIC QUAKE 5/8oz 17.5gr Chartreuse/White
Exclusiv online!

SPINERBAIT COLMIC QUAKE 5/8oz 17.5gr Chartreuse/White

arhkfl03
Livrare 48-72 ore

49,00Lei

SPINNERBAIT, BERTILURE, Salcie, nr.2, Salcie, nr.3,, 14gr,Skirt, Siliconic, Lime-Chartreuse, s-03-421, Spinnerbaits, Spinnerbaits Berti, Berti
SPINERBAIT SPRO MICRO SPB 5GR CHARTTREUSE BELLY 8 CM

SPINERBAIT SPRO MICRO SPB 5GR CHARTTREUSE BELLY 8 CM

004861-00405-00000
Livrare imediată!

36,20Lei

NALUCA DAIWA PROREX WILLOW SPINNER 7G GOLD PERCH

NALUCA DAIWA PROREX WILLOW SPINNER 7G GOLD PERCH

f.d.15426.104
Livrare imediată!

39,28Lei

Spinnerbait Bertilure Cu Doua Palete SHALLOW KILLER COLORADO Model SALCIE Culoare Rosu-Chartreuse 11 gr.
SPINNERBAIT COLMIC QUAKE 17.5GR BLACK
Exclusiv online!

SPINNERBAIT COLMIC QUAKE 17.5GR BLACK

arhkfl05
Livrare 48-72 ore

49,00Lei

Spinnerbait Bertilure Cu Doua Palete SHALLOW KILLER COLORADO Model COLORADO Culoare ALB/NEGRU - ROSU 7 gr.
NALUCA DAIWA PROREX WILLOW SPINNER 7G PEARL AYU

NALUCA DAIWA PROREX WILLOW SPINNER 7G PEARL AYU

f.d.15426.101
Livrare imediată!

38,68Lei

SPINERBAIT SPRO MICRO SPB 5GR BLACK GOLD 8 CM
Exclusiv online!

SPINERBAIT SPRO MICRO SPB 5GR BLACK GOLD 8 CM

004861-00404-00000
Livrare 48-72 ore

36,20Lei

Afişare 121 - 140 din 410 (21 pagini)
Queries: 13, Total time: 219.163 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = 'fb580622bbf97a0d1a3bb44545'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (212.737)
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 = '2' AND (pd.tag LIKE "%spinnerbait%") 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:697
5 (0.152)
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
6 (1.679)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.429)
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:1196
8 (0.113)
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:1217
9 (0.158)
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:986
10 (3.284)
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:905
11 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.112)
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