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


Vobler Palms Alexandra Flutter AL196 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter AL196 5cm 3.2g 1buc/plic

ax-50fs/al196
Livrare 48-72ore

70,00Lei

Vobler Palms Alexandra Flutter MAL51 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter MAL51 5cm 3.2g 1buc/plic

ax-50fs/mal51
Livrare 48-72ore

70,00Lei

Vobler Palms Alexandra Flutter ABS 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter ABS 5cm 3.2g 1buc/plic

ax-50fs/abs
Livrare 48-72ore

70,00Lei

VOBLER PALMS BEATRICE AL519 SINKING 8CM 18G
Exclusiv online!

VOBLER PALMS BEATRICE AL519 SINKING 8CM 18G

bt-80s/al-519
Livrare 48-72ore

75,01Lei

VOBLER PALMS BEATRICE AL545 SINKING 8CM 18G
Exclusiv online!

VOBLER PALMS BEATRICE AL545 SINKING 8CM 18G

bt-80s/al-545
Livrare 48-72ore

75,01Lei

Vobler Salmo Rattlin' Slider Sinking - Red Wake, 11cm, 47g

Vobler Salmo Rattlin' Slider Sinking - Red Wake, 11cm, 47g

qrn021
Livrare imediată!

76,46Lei

Vobler Palms Alexandra Flutter A79 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter A79 5cm 3.2g 1buc/plic

ax-50fs/a79
Livrare 48-72ore

70,00Lei

Vobler Palms Alexandra Flutter MG328 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter MG328 5cm 3.2g 1buc/plic

ax-50fs/mg328
Livrare 48-72ore

70,00Lei

Vobler Salmo Slider 16S Limited Edition Black Shadow 16cm
Exclusiv online!

Vobler Salmo Slider 16S Limited Edition Black Shadow 16cm

qsd427
Livrare 7-14 zile

179,96Lei

Vobler Salmo Sweeper 17S Limited Edition Holo Smelt 17cm, 97g
Exclusiv online!

Vobler Salmo Sweeper 17S Limited Edition Holo Smelt 17cm, 97g

qse048
Livrare 7-14 zile

116,97Lei

Vobler Salmo Sweeper Sinking Real Roach 14cm, 50g
Exclusiv online!

Vobler Salmo Sweeper Sinking Real Roach 14cm, 50g

qse042
Livrare 7-14 zile

74,21Lei

Vobler DUO Spearhead Ryuki Quattro 70S, GDA4068 Yamame Red Belly, 7cm 5.7g
Exclusiv online!

Vobler DUO Spearhead Ryuki Quattro 70S, GDA4068 Yamame Red Belly, 7cm 5.7g

duo41752
Livrare 48-72 ore

107,00Lei

VOBLER PALMS ALEXANDRA SINKING MG328 6.3CM 6.6G
Exclusiv online!

VOBLER PALMS ALEXANDRA SINKING MG328 6.3CM 6.6G

ax-63hw/mg328
Livrare 48-72ore

70,00Lei

Vobler Salmo Sweeper Sinking Mat Tiger 14cm, 50g
Exclusiv online!

Vobler Salmo Sweeper Sinking Mat Tiger 14cm, 50g

qse043
Livrare 7-14 zile

74,21Lei

Vobler Strike King Pro-Model Series 1XS Floating, Fire Tiger, 5.5cm, 10.6g -34%

Vobler Strike King Pro-Model Series 1XS Floating, Fire Tiger, 5.5cm, 10.6g

hc1xs-513
Livrare imediată!

26,97Lei(-34%) 17,90Lei

Vobler Tiemco Laks 50S, 020 Green Highlander, 5cm, 4.1g
Exclusiv online!

Vobler Tiemco Laks 50S, 020 Green Highlander, 5cm, 4.1g

310512350020
Livrare 48-72 ore

77,00Lei

Vobler DUO Ryuki 50S 5cm 4.5g CRA3061 Komochi Wakasagi S
Exclusiv online!

Vobler DUO Ryuki 50S 5cm 4.5g CRA3061 Komochi Wakasagi S

duo97806
Livrare 48-72 ore

66,00Lei

Vobler DUO Ryuki 70S SW 7cm 9g DDH0365 Bleeding Sardine S
Exclusiv online!

Vobler DUO Ryuki 70S SW 7cm 9g DDH0365 Bleeding Sardine S

duo23734
Livrare 48-72 ore

72,00Lei

Vobler Palms Alexandra Flutter HMSS 5cm 3.2g 1buc/plic
Exclusiv online!

Vobler Palms Alexandra Flutter HMSS 5cm 3.2g 1buc/plic

ax-50fs/hmss
Livrare 48-72ore

70,00Lei

Vobler Salmo Fatso Sinking 14S Limited Edition Mat Tiger 14cm, 115g

Vobler Salmo Fatso Sinking 14S Limited Edition Mat Tiger 14cm, 115g

qfa081
Livrare imediată!

107,96Lei

Afişare 2841 - 2860 din 4137 (207 pagini)
Queries: 13, Total time: 625.361 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '5e9336c69e0284795911cbdd69'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (623.976)
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 (pd.tag LIKE "%voblere%sinking%") 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:724
4 (0.201)
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
5 (0.109)
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
6 (0.127)
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.102)
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
8 (0.093)
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
9 (0.090)
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
10 (0.090)
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
11 (0.122)
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
12 (0.140)
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
13 (0.131)
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