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


CARLIGE TRABUCCO WIDE GAPE CARP MICRO BARB 15buc/plic nr.20

CARLIGE TRABUCCO WIDE GAPE CARP MICRO BARB 15buc/plic nr.20

023-69-020
Stoc epuizat

14,49Lei

Jig Rapture Power Jighead Football 15g Nr.4/0 3buc/plic

Jig Rapture Power Jighead Football 15g Nr.4/0 3buc/plic

188-31-540
Stoc epuizat

10,32Lei

Montura Carp Spirit Gravity Ready Leader UHL 90cm Lead Clip 45lbs 3buc/plic -20%

Montura Carp Spirit Gravity Ready Leader UHL 90cm Lead Clip 45lbs 3buc/plic

acs010149
Stoc epuizat

49,00Lei(-20%) 39,00Lei

Shad Savage Gear Fat Minnow T-Tail, White Silver, 7.5cm, 4buc/plic

Shad Savage Gear Fat Minnow T-Tail, White Silver, 7.5cm, 4buc/plic

f1.sg.61810
Stoc epuizat

17,71Lei

CARLIGE TRABUCCO AKURA 535N NR 2 15BUC/PLIC

CARLIGE TRABUCCO AKURA 535N NR 2 15BUC/PLIC

025-45-020
Stoc epuizat

10,00Lei

CARLIGE TRABUCCO WIDE GAPE CARP MICRO BARB 15buc/plic nr.18

CARLIGE TRABUCCO WIDE GAPE CARP MICRO BARB 15buc/plic nr.18

023-69-018
Stoc epuizat

14,49Lei

Jig Rapture Power Jighead Round 5g 3buc/plic Nr.5/0

Jig Rapture Power Jighead Round 5g 3buc/plic Nr.5/0

188-30-150
Stoc epuizat

9,98Lei

Carlige Fudo Round (FDRD-BN) nr.8 BN - Black Nickel 15 buc/plic -20%

Carlige Fudo Round (FDRD-BN) nr.8 BN - Black Nickel 15 buc/plic

2701-8
Stoc epuizat

10,00Lei(-20%) 8,00Lei

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 21g 5buc/plic

PLUMB RAPTURE CILINDRIC TECK SINK STICK SINKER 21g 5buc/plic

188-11-121
Stoc epuizat

19,00Lei

Ancore VMC 7547 Black Nickel Nr.10 5buc/plic

Ancore VMC 7547 Black Nickel Nr.10 5buc/plic

7547 bn10
Stoc epuizat

29,00Lei

SHAD CORMORAN CRAZY FIN 10CM Golden Seed 6G 2BUC/PLIC

SHAD CORMORAN CRAZY FIN 10CM Golden Seed 6G 2BUC/PLIC

f1.51.870410
Stoc epuizat

8,87Lei

Shad Storm Hit Culoare Shiner 10cm 12g 4buc/plic

Shad Storm Hit Culoare Shiner 10cm 12g 4buc/plic

hits04 sh
Stoc epuizat

25,00Lei

CARLIGE TRABUCCO AKURA 220BR NR 1 15BUC/PLIC

CARLIGE TRABUCCO AKURA 220BR NR 1 15BUC/PLIC

025-95-010
Stoc epuizat

8,00Lei

CARLIGE TRABUCCO CARP SPECIALIST BARBLESS EYE 15buc/plic nr.14

CARLIGE TRABUCCO CARP SPECIALIST BARBLESS EYE 15buc/plic nr.14

023-68-014
Stoc epuizat

15,01Lei

Shad Savage Gear Cannibal Shad 12.5cm 3buc/plic Burbot Firetiger

Shad Savage Gear Cannibal Shad 12.5cm 3buc/plic Burbot Firetiger

f1.sg.71535
Stoc epuizat

17,75Lei

CARLIGE TRABUCCO F1 MATCH 15buc/plic nr.16

CARLIGE TRABUCCO F1 MATCH 15buc/plic nr.16

023-64-016
Stoc epuizat

14,49Lei

Shad Savage Gear Bleak Paddle Tail, Firetiger, 8cm, 4buc/pliclic

Shad Savage Gear Bleak Paddle Tail, Firetiger, 8cm, 4buc/pliclic

f1.sg.61828
Stoc epuizat

19,84Lei

Ancore VMC 7547 Black Nickel Nr.6 5buc/plic

Ancore VMC 7547 Black Nickel Nr.6 5buc/plic

7547 bn6
Stoc epuizat

29,00Lei

CARLIGE TRABUCCO WIDE GAPE PELLET BARBLESS 15buc/plic nr.16

CARLIGE TRABUCCO WIDE GAPE PELLET BARBLESS 15buc/plic nr.16

023-67-016
Stoc epuizat

14,49Lei

Shad Pontoon21 Awaruna 418 4 inci (10.2cm) 5 buc/plic

Shad Pontoon21 Awaruna 418 4 inci (10.2cm) 5 buc/plic

4571115386465
Stoc epuizat

24,00Lei

Afişare 9101 - 9120 din 10450 (523 pagini)
Queries: 9, Total time: 627.666 ms [By time] [By id] [By file]
1 (0.071)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7c27b320e20813e0e00481d71'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.065)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (626.650)
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 (pd.tag LIKE "%buc/plic%") 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.212)
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.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
6 (0.132)
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
7 (0.120)
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.127)
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
9 (0.167)
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