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


Vobler Savage Gear Gravity Crank MR Blue Chrome 5.8cm 9g -40%
Exclusiv online!

Vobler Savage Gear Gravity Crank MR Blue Chrome 5.8cm 9g

sg.71679
Livrare 24-48 ore

41,83Lei(-40%) 25,10Lei

Vobler Savage Gear 3D Goby Crank SR Blue Silver 4cm 3g
Exclusiv online!

Vobler Savage Gear 3D Goby Crank SR Blue Silver 4cm 3g

sg.71728
Livrare 24-48 ore

42,05Lei

SHAD LAKE FORK SICKLE TAIL BABY SHAD 2.25 INCH.BLUE GILL 15/PAC

SHAD LAKE FORK SICKLE TAIL BABY SHAD 2.25 INCH.BLUE GILL 15/PAC

01-2600-772
Livrare imediată!

21,50Lei

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G BLUE PEARL 5BUC/PLIC -40%
Exclusiv online!

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G BLUE PEARL 5BUC/PLIC

f1.sg.72412
Livrare 24-48 ore

36,85Lei(-40%) 22,11Lei

Creatura Strike King Rage Ned Bug, Blue Craw, 6.5cm, 9buc/plic -34%

Creatura Strike King Rage Ned Bug, Blue Craw, 6.5cm, 9buc/plic

rgnbug-108
Livrare imediată!

31,46Lei(-34%) 20,90Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC -40%
Exclusiv online!

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC

f1.sg.72406
Livrare 24-48 ore

34,90Lei(-40%) 20,94Lei

BLUZA, DAIWA, D-VEC, BLUE, MARIME, XL, d.18299.340, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa -30%
Exclusiv online!

BLUZA, DAIWA, D-VEC, BLUE, MARIME, XL, d.18299.340, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18299.340
Livrare 24-48 ore

300,33Lei(-30%) 210,23Lei

Spinnertail Jackall Deracoup Tail Spinner Hl Bluegill, 14g

Spinnertail Jackall Deracoup Tail Spinner Hl Bluegill, 14g

ja.807102994
Livrare imediată!

74,20Lei

BLUZA, DAIWA, D-VEC, BLUE, MARIME, L, d.18299.330, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa
Exclusiv online!

BLUZA, DAIWA, D-VEC, BLUE, MARIME, L, d.18299.330, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18299.330
Livrare 24-48 ore

240,26Lei

BASS ASSASSIN ELITE SHINER 10CM BLUEGILL FLASH 8buc/plic

BASS ASSASSIN ELITE SHINER 10CM BLUEGILL FLASH 8buc/plic

bsawes50461
Livrare imediată!

29,00Lei

Vobler Jackall Tricoroll GT 56MD-F Flash Blue Back 5.6cm 4.3g -20%
Exclusiv online!

Vobler Jackall Tricoroll GT 56MD-F Flash Blue Back 5.6cm 4.3g

ja.418099341
Livrare 24-48 ore

79,63Lei(-20%) 63,71Lei

SHAD, SAVAGE, GEAR, CRAFT, 10CM, 6G, BLUE, PEARL, 5BUC/PLIC, f1.sg.72418, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%
Exclusiv online!

SHAD, SAVAGE, GEAR, CRAFT, 10CM, 6G, BLUE, PEARL, 5BUC/PLIC, f1.sg.72418, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.72418
Livrare 24-48 ore

38,73Lei(-40%) 23,24Lei

Fir Textil Varivas AVANI LIGHT GAME PE X4 150m 0.070mm 5lb Natural Blue
Exclusiv online!

Fir Textil Varivas AVANI LIGHT GAME PE X4 150m 0.070mm 5lb Natural Blue

v1915002
Livrare 48-72 ore

278,00Lei

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME S -20%
Exclusiv online!

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME S

a8.sg.73669
Livrare 24-48 ore

158,67Lei(-20%) 126,94Lei

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME XXL -20%
Exclusiv online!

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME XXL

a8.sg.73673
Livrare 24-48 ore

158,67Lei(-20%) 126,94Lei

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME L -20%
Exclusiv online!

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME L

a8.sg.73671
Livrare 24-48 ore

158,67Lei(-20%) 126,94Lei

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME M -20%
Exclusiv online!

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME M

a8.sg.73670
Livrare 24-48 ore

158,67Lei(-20%) 126,94Lei

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME XL -20%
Exclusiv online!

TRICOU SAVAGE GEAR MARINE UV SEA BLUE MARIME XL

a8.sg.73672
Livrare 24-48 ore

158,67Lei(-20%) 126,94Lei

Creatura Strike King Rage Tail Chunk, Blue Craw, 7.5cm, 7buc/plic -34%

Creatura Strike King Rage Tail Chunk, Blue Craw, 7.5cm, 7buc/plic

rgchk-108
Livrare imediată!

31,46Lei(-34%) 20,90Lei

Mulineta Penn Rival Blue 6000LC

Mulineta Penn Rival Blue 6000LC

1524489
Livrare imediată!

494,96Lei

Afişare 41 - 60 din 1296 (65 pagini)
Queries: 8, Total time: 241.985 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'a34247da919cff335c72e76a0f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
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 (235.841)
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 "%blue%") 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:698
5 (5.477)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.118)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.122)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.121)
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