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 Jackall TN38 Trigon, 7.3g, 3.8cm, Psmg
Exclusiv online!

Vobler Jackall TN38 Trigon, 7.3g, 3.8cm, Psmg

ja.807247671
Livrare 24-48 ore

98,46Lei

Vobler Jackall TN60 Trigon, Baba Taku Akakin Laser, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, Baba Taku Akakin Laser, 6cm, 8.5g

ja.807263978
Livrare 24-48 ore

111,24Lei

Vobler Jackall TN60 Trigon, HS Impact Black, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, HS Impact Black, 6cm, 8.5g

ja.807166262
Livrare 24-48 ore

111,24Lei

Vobler Jackall TN60 Trigon, Sk Pearl Shad, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, Sk Pearl Shad, 6cm, 8.5g

ja.807143119
Livrare 24-48 ore

111,24Lei

Vobler Jackall TN70 Trigon, Deadly Pearl Bait, 7cm, 31.5g
Exclusiv online!

Vobler Jackall TN70 Trigon, Deadly Pearl Bait, 7cm, 31.5g

ja.807214598
Livrare 24-48 ore

122,27Lei

Vobler Live Target Golden Shiner Rattlebait, Glow / Blue, 5.0cm, 7.0g -20%
Exclusiv online!

Vobler Live Target Golden Shiner Rattlebait, Glow / Blue, 5.0cm, 7.0g

lt.gs50sk210
Livrare 24-48 ore

38,51Lei(-20%) 30,81Lei

Vobler Live Target Golden Shiner Rattlebait, Metallic / Gloss, 7.0cm, 18.0g

Vobler Live Target Golden Shiner Rattlebait, Metallic / Gloss, 7.0cm, 18.0g

lt.ypr70sk102
Livrare imediată!

43,55Lei

Vobler Mikado Fishunter Kizoku Sinking, D05, 29g, 6cm
Exclusiv online!

Vobler Mikado Fishunter Kizoku Sinking, D05, 29g, 6cm

pwf-ku-6-d05
Livrare 48-72 ore

47,01Lei

Vobler Mustad Vertebrata Sink Pencil, Green Gold, 7.2cm, 10g
Exclusiv online!

Vobler Mustad Vertebrata Sink Pencil, Green Gold, 7.2cm, 10g

f3.mtsp.vtb.grg.70
Livrare 24-48 ore

49,56Lei

Vobler Mustad Vertebrata Sink Pencil, Louminous Magic, 7.2cm, 10g
Exclusiv online!

Vobler Mustad Vertebrata Sink Pencil, Louminous Magic, 7.2cm, 10g

f3.mtsp.vtb.lmmg.70
Livrare 24-48 ore

49,56Lei

Vobler Rapala X-Light Minnow, PCL, 4g, 5cm
Exclusiv online!

Vobler Rapala X-Light Minnow, PCL, 4g, 5cm

fnm05 pcl
Livrare 48-72ore

45,01Lei

Vobler Rapture Pro Vibe Silent 5cm, 14g, HS

Vobler Rapture Pro Vibe Silent 5cm, 14g, HS

180-22-308
Livrare imediată!

34,00Lei

Vobler Rapture Pro X Vibe Sinking, GS, 12g, 5cm

Vobler Rapture Pro X Vibe Sinking, GS, 12g, 5cm

180-22-605
Livrare imediată!

34,00Lei

Vobler Rapture Sniper Max Vibe 70LP SSH, 7cm, 17.3g

Vobler Rapture Sniper Max Vibe 70LP SSH, 7cm, 17.3g

180-42-844
Livrare imediată!

29,00Lei

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

qfa113
Livrare imediată!

58,46Lei

Vobler Salmo Fatso Sinking, Bright Perch, 8cm

Vobler Salmo Fatso Sinking, Bright Perch, 8cm

qfa101
Livrare imediată!

58,00Lei

Vobler Salmo Fatso Sinking, Spotted Brown Perch, 8cm

Vobler Salmo Fatso Sinking, Spotted Brown Perch, 8cm

qfa100
Livrare imediată!

58,00Lei

Vobler Savage Gear Deviator Swim, Slow Sinking, Golden Amb, 10.5cm, 35g
Exclusiv online!

Vobler Savage Gear Deviator Swim, Slow Sinking, Golden Amb, 10.5cm, 35g

sg.69870
Livrare 24-48 ore

52,88Lei

Vobler Savage Gear Deviator Swim, Slow Sinking, Lemon Roach, 10.5cm, 35g
Exclusiv online!

Vobler Savage Gear Deviator Swim, Slow Sinking, Lemon Roach, 10.5cm, 35g

sg.82448
Livrare 24-48 ore

52,88Lei

Vobler Savage Gear Gravity Minnow Pink Head, 5cm, 8g
Exclusiv online!

Vobler Savage Gear Gravity Minnow Pink Head, 5cm, 8g

sg.73519
Livrare 24-48 ore

44,03Lei

Afişare 521 - 540 din 4832 (242 pagini)
Queries: 5, Total time: 144.703 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '0700f9ba10bda0f75d5aa2b4fb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (144.175)
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 = '2' AND (MATCH(pd.tag) AGAINST('+sinking' 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.182)
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.150)
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