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


Carlig Mustad Power Baitholder Forjat, 2 Spini, Bronz, 10buc/plic Nr.10

Carlig Mustad Power Baitholder Forjat, 2 Spini, Bronz, 10buc/plic Nr.10

m.5933br.10
Livrare imediată!

8,76Lei

MONTURA EnergoTeam METHOD CARLIG ROUND CARP SI BAIT STING nr.6 2BUC/PLIC

MONTURA EnergoTeam METHOD CARLIG ROUND CARP SI BAIT STING nr.6 2BUC/PLIC

42870006
Livrare imediată!

8,50Lei

Shad Gunki Peps, Brown Chart, 7cm, 7buc/plic

Shad Gunki Peps, Brown Chart, 7cm, 7buc/plic

f1.spm.33333
Livrare imediată!

17,65Lei

CARLIG GURU SUPER MWG EYED NR.20 10BUC/PLIC
Exclusiv online!

CARLIG GURU SUPER MWG EYED NR.20 10BUC/PLIC

gu.gsmwb20
Livrare 24-48 ore

13,90Lei

CARLIGE LEGATE EXCALIBUR D KILLER BN NR.1 8BUC/PLIC
Exclusiv online!

CARLIGE LEGATE EXCALIBUR D KILLER BN NR.1 8BUC/PLIC

47059001
Livrare 24-48 ore

8,50Lei

MOMITOR JAXON FEEDER OVAL 40GR 32X44mm 10BUC/PLIC
Exclusiv online!

MOMITOR JAXON FEEDER OVAL 40GR 32X44mm 10BUC/PLIC

aw-oc040
Livrare 48-72 ore

112,00Lei

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC BLUE LIME TAIL 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC BLUE LIME TAIL 10CM 10BUC/PLIC

091538302544
Livrare imediată!

33,90Lei

Shad Relax Kopyto 3inch Standard 7.5cm RKBLS3-S032 10 buc/plic

Shad Relax Kopyto 3inch Standard 7.5cm RKBLS3-S032 10 buc/plic

bls3-s032
Livrare imediată!

20,00Lei

CARLIGE TRABUCCO AKURA 525N NR 6 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 525N NR 6 15BUC/PLIC

025-85-060
Livrare 48-72 ore

6,00Lei

Agrafa VMC DuoLock DLSS cu Vartej Black Nickel Nr.8 5buc/plic
Exclusiv online!

Agrafa VMC DuoLock DLSS cu Vartej Black Nickel Nr.8 5buc/plic

dlss#8
Livrare 48-72ore

5,70Lei

L and K MICRO JIG 2412 Nr.6 2g 4buc/plic
Exclusiv online!

L and K MICRO JIG 2412 Nr.6 2g 4buc/plic

59102162
Livrare 24-48 ore

11,00Lei

Ancore Mivardi Yamatsu Treble Nr.6 10buc/plic
Exclusiv online!

Ancore Mivardi Yamatsu Treble Nr.6 10buc/plic

m-ythr06
Livrare 48-72 ore

17,01Lei

Jig Lestat Owner 56978, Nr. 4/0, 8g, 4buc/plic -29%

Jig Lestat Owner 56978, Nr. 4/0, 8g, 4buc/plic

56978450
Livrare imediată!

31,05Lei(-29%) 22,05Lei

Vartej Korda cu Agrafa Rapida Spinner Swivel Nr.11 12buc/plic
Exclusiv online!

Vartej Korda cu Agrafa Rapida Spinner Swivel Nr.11 12buc/plic

a.kspin3
Livrare 24-48 ore

25,51Lei

CARLIGE TRABUCCO AKURA 6000 NR 18 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 6000 NR 18 15BUC/PLIC

025-25-180
Livrare 48-72ore

7,00Lei

Shad Relax Kopyto Laminated, 7.5cm, L272, 4buc/plic
Exclusiv online!

Shad Relax Kopyto Laminated, 7.5cm, L272, 4buc/plic

bls3-l272-b
Livrare 48-72ore

11,00Lei

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic
Exclusiv online!

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic

410340021
Livrare 48-72 ore

9,09Lei

Carlige FUDO CARLIG KOAJI ROUND BN-3601 nr.12 Black Nichel 4 buc/plic -20%

Carlige FUDO CARLIG KOAJI ROUND BN-3601 nr.12 Black Nichel 4 buc/plic

3601-12
Livrare imediată!

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

CARLIGE FUDO SODE NK-1200 Nr. 16 Nickel 14buc/plic -30%

CARLIGE FUDO SODE NK-1200 Nr. 16 Nickel 14buc/plic

1200-16
Livrare imediată!

10,00Lei(-30%) 7,00Lei

L and K MICRO JIG 2316 NR.1 5g 4buc/plic

L and K MICRO JIG 2316 NR.1 5g 4buc/plic

59102015
Livrare imediată!

11,00Lei

Afişare 4241 - 4260 din 10440 (522 pagini)
Queries: 7, Total time: 710.091 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '404c6992626eee5e9b8fb569c3'
/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 (709.434)
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.143)
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.093)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.079)
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.121)
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