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 Rapala Husky Jerk, Culoare HGH, 10cm, 10g
Exclusiv online!

Vobler Rapala Husky Jerk, Culoare HGH, 10cm, 10g

hj10 hgh
Livrare 48-72ore

45,01Lei

Vobler Rapala X-Rap 12 XR12 HS
Exclusiv online!

Vobler Rapala X-Rap 12 XR12 HS

xr12 hs
Livrare 48-72ore

65,00Lei

Vobler Sakura Swimy Cricket Crank J26, Alb Negru, 2g, 3.7cm
Exclusiv online!

Vobler Sakura Swimy Cricket Crank J26, Alb Negru, 2g, 3.7cm

130235swplg500437-j26
Livrare 48-72 ore

35,50Lei

Vobler Strike Pro Crash 626E, 4.8cm, 5.2g, 1buc/pac -20%
Exclusiv online!

Vobler Strike Pro Crash 626E, 4.8cm, 5.2g, 1buc/pac

sp.eg233.626e
Livrare 24-48 ore

38,71Lei(-20%) 30,98Lei

Vobler Strike Pro Crash SM37F, 4.8cm, 5.2g, 1buc/pac -20%
Exclusiv online!

Vobler Strike Pro Crash SM37F, 4.8cm, 5.2g, 1buc/pac

sp.eg233.sm37f
Livrare 24-48 ore

38,71Lei(-20%) 30,98Lei

Vobler HMKL AIVE BAIT 85 SP, Super Ayaya, 8.5cm, 6.1g
Exclusiv online!

Vobler HMKL AIVE BAIT 85 SP, Super Ayaya, 8.5cm, 6.1g

hmkl-ab85sp-sa
Livrare 48-72ore

110,00Lei

Vobler Rapala Husky Jerk HJ12 PCH
Exclusiv online!

Vobler Rapala Husky Jerk HJ12 PCH

hj12 pch
Livrare 48-72ore

49,00Lei

Vobler Rapala Jointed Shallow Shad Rap JSSR07, 7cm, 11g

Vobler Rapala Jointed Shallow Shad Rap JSSR07, 7cm, 11g

jssr07 sd
Livrare imediată!

45,01Lei

Vobler Strike Pro Intriger 612T, 10.5cm, 15.7g, 1bic/pac
Exclusiv online!

Vobler Strike Pro Intriger 612T, 10.5cm, 15.7g, 1bic/pac

sp.eg194a.612t
Livrare 24-48 ore

42,98Lei

Vobler HMKL AIVE BAIT 85 SP, N/Ghost Wakasgai, 8.5cm, 6.1g
Exclusiv online!

Vobler HMKL AIVE BAIT 85 SP, N/Ghost Wakasgai, 8.5cm, 6.1g

hmkl-ab85sp-ngw
Livrare 48-72ore

110,00Lei

Vobler Owner Bite Marker 28mm 1.7gr 35 Pink Berry Eye 5224 TMT-28SP

Vobler Owner Bite Marker 28mm 1.7gr 35 Pink Berry Eye 5224 TMT-28SP

804020033
Livrare imediată!

98,35Lei

Vobler Strike Pro Crash 539T, 4.8cm, 5.2g, 1buc/pac -20%
Exclusiv online!

Vobler Strike Pro Crash 539T, 4.8cm, 5.2g, 1buc/pac

sp.eg233.539t
Livrare 24-48 ore

38,71Lei(-20%) 30,98Lei

Vobler Strike Pro Crash CA06ES, 4.8cm, 5.2g, 1buc/pac -20%
Exclusiv online!

Vobler Strike Pro Crash CA06ES, 4.8cm, 5.2g, 1buc/pac

sp.eg233.ca06es
Livrare 24-48 ore

38,71Lei(-20%) 30,98Lei

VOBLER DAIWA TN SPIKE 53SP LAZER RED 5.3CM 5G
Exclusiv online!

VOBLER DAIWA TN SPIKE 53SP LAZER RED 5.3CM 5G

f3.d16710.608
Livrare 24-48 ore

75,43Lei

VOBLER DAIWA TN SPIKE 53SP LIME CHART 5.3CM 5G
Exclusiv online!

VOBLER DAIWA TN SPIKE 53SP LIME CHART 5.3CM 5G

f3.d16710.603
Livrare 24-48 ore

72,47Lei

VOBLER DAIWA TN SPIKE 53SP MATT AYU 5.3CM 5G
Exclusiv online!

VOBLER DAIWA TN SPIKE 53SP MATT AYU 5.3CM 5G

f3.d16710.602
Livrare 24-48 ore

73,09Lei

Vobler Daiwa Steez Shad Minnowbait, Akabane Lime, 6cm, 6.3g
Exclusiv online!

Vobler Daiwa Steez Shad Minnowbait, Akabane Lime, 6cm, 6.3g

f3.d17520.005
Livrare 24-48 ore

73,09Lei

Vobler Daiwa Steez Shad Minnowbait, Special Shiner, 6cm, 6.3g
Exclusiv online!

Vobler Daiwa Steez Shad Minnowbait, Special Shiner, 6cm, 6.3g

f3.d17520.003
Livrare 24-48 ore

73,09Lei

Vobler Daiwa Steez Shad Minnowbait, Wakasagi, 6cm, 6.7g
Exclusiv online!

Vobler Daiwa Steez Shad Minnowbait, Wakasagi, 6cm, 6.7g

f3.d17520.102
Livrare 24-48 ore

73,09Lei

Vobler Daiwa Steez Shad Minnowbait, SG Weed Shad, 6cm, 6.3g
Exclusiv online!

Vobler Daiwa Steez Shad Minnowbait, SG Weed Shad, 6cm, 6.3g

f3.d17520.007
Livrare 24-48 ore

73,09Lei

Afişare 381 - 400 din 742 (38 pagini)
Queries: 9, Total time: 27.993 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '2899eb26518f57c5a526f3ff11'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.122)
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('+voblere +suspending' 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.180)
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
5 (0.107)
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.085)
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.075)
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
8 (0.114)
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.119)
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