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


Lanseta Arrow AR-X Spin 1.82, 10-30g, 2seg
Exclusiv online!

Lanseta Arrow AR-X Spin 1.82, 10-30g, 2seg

arr.s110.180
Livrare 24-48 ore

176,82Lei

LANSETA OKUMA HEXANA II SPIN 2.40M 5-20G 2SEG
Exclusiv online!

LANSETA OKUMA HEXANA II SPIN 2.40M 5-20G 2SEG

hxii-s-802l
Livrare 48-72ore

269,09Lei

Spin Momeala Black Fighter Bait Sting, 10mm, 8buc/pac

Spin Momeala Black Fighter Bait Sting, 10mm, 8buc/pac

82203910
Livrare imediată!

7,00Lei

Carlige Legate Benzar Method Fir Textil Bait Sting 12+7mm, Spin, 2buc/pac
Exclusiv online!

Carlige Legate Benzar Method Fir Textil Bait Sting 12+7mm, Spin, 2buc/pac

42877012
Livrare 24-48 ore

10,00Lei

SPIN MOMEALA JAXON HAIR RIG 0.6mm 7mm 10buc/plic

SPIN MOMEALA JAXON HAIR RIG 0.6mm 7mm 10buc/plic

ac-pc166m
Livrare imediată!

8,50Lei

LANSETA FL BLADE LIGHT SPIN 2.08M 2-9G

LANSETA FL BLADE LIGHT SPIN 2.08M 2-9G

64-1648
Livrare imediată!

117,91Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR GYG 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR GYG 2.9G

spw-qr-2.9/gyg
Livrare 48-72ore

38,00Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR SGR 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR SGR 2.9G

spw-qr-2.9/sgr
Livrare 48-72ore

38,00Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR SPI 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR SPI 2.9G

spw-qr-2.9/spi
Livrare 48-72ore

38,00Lei

LANSETA DAIWA TOURNAMENT AGS SPIN ULTRAFAST 2.10M 14-42G
Exclusiv online!

LANSETA DAIWA TOURNAMENT AGS SPIN ULTRAFAST 2.10M 14-42G

d.11118.210
Livrare 24-48 ore

2.273,99Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR SYE 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR SYE 2.9G

spw-qr-2.9/sye
Livrare 48-72ore

38,00Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR BTI 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR BTI 2.9G

spw-qr-2.9/bti
Livrare 48-72ore

38,00Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR GRE 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR GRE 2.9G

spw-qr-2.9/gre
Livrare 48-72ore

38,00Lei

LANSETA FL BLADE LIGHT SPIN 2.35M 2-11G

LANSETA FL BLADE LIGHT SPIN 2.35M 2-11G

64-1649
Livrare imediată!

138,90Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR BMB 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR BMB 2.9G

spw-qr-2.9/bmb
Livrare 48-72ore

38,00Lei

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT

64-1971-40-10
Livrare imediată!

13,90Lei

MONTURA FEEDER FL METHOD FARA TIJA 40G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E G

MONTURA FEEDER FL METHOD FARA TIJA 40G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E G

64-1969-40-6
Livrare imediată!

12,90Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR GBK 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR GBK 2.9G

spw-qr-2.9/gbk
Livrare 48-72ore

38,00Lei

LINGURITA ROTATIVA PALMS SPIN WALK QR GMG 2.9G
Exclusiv online!

LINGURITA ROTATIVA PALMS SPIN WALK QR GMG 2.9G

spw-qr-2.9/gmg
Livrare 48-72ore

38,00Lei

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E G

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E G

64-1972-40-6
Livrare imediată!

13,90Lei

Afişare 201 - 220 din 1803 (91 pagini)
Queries: 14, Total time: 87.204 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '06b71c8fbcd3345e4c3df3c606'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (85.856)
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('+spin' 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.152)
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.123)
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.105)
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.100)
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
8 (0.101)
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.108)
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
10 (0.106)
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
11 (0.091)
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
12 (0.081)
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
13 (0.077)
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
14 (0.086)
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