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


Tub Silicon Extra Carp, 2.00 mm, 100cm, Verde

Tub Silicon Extra Carp, 2.00 mm, 100cm, Verde

95-2045
Stoc epuizat

8,85Lei

Umbrela Delphin Cu Perete Lateral Extins 250cm Verde -28%

Umbrela Delphin Cu Perete Lateral Extins 250cm Verde

435001zel
Stoc epuizat

319,00Lei(-28%) 230,00Lei

Fir Jaxon Crocodile Marine Verde Fluo, 300m, 0.50mm, 40kg

Fir Jaxon Crocodile Marine Verde Fluo, 300m, 0.50mm, 40kg

zj-crm050b
Stoc epuizat

37,00Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 1G VERDE

AVERTIZOR JAXON XTR CARP SENSITIVE 1G VERDE

aj-sya101g
Stoc epuizat

83,00Lei

PALARIE TONAK VANATOR BRODERIE FAZAN VERDE MARIME 53

PALARIE TONAK VANATOR BRODERIE FAZAN VERDE MARIME 53

t.10086.06.53
Stoc epuizat

389,31Lei

CLIPS MONTURA PLUMB PIERDUT + BLOCAJ VERDE MAT CARP ZOOM

CLIPS MONTURA PLUMB PIERDUT + BLOCAJ VERDE MAT CARP ZOOM

cz1885
Stoc epuizat

16,01Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 0.10MM 4.6KG 300MT

FIR TEXTIL CORMORAN CORASTRONG VERDE 0.10MM 4.6KG 300MT

c.32.030010
Stoc epuizat

90,48Lei

Fir Textil Jaxon Sumato Premium, Verde, 125m, 0.08mm, 5kg

Fir Textil Jaxon Sumato Premium, Verde, 125m, 0.08mm, 5kg

zj-rap008g
Stoc epuizat

77,00Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 2G VERDE

AVERTIZOR JAXON XTR CARP SENSITIVE 2G VERDE

aj-sya102g
Stoc epuizat

99,00Lei

HANGER JAXON CU LUMINA VERDE

HANGER JAXON CU LUMINA VERDE

aj-sys106c
Stoc epuizat

57,00Lei

COSTUM PLOAIE JAXON VERDE XL

COSTUM PLOAIE JAXON VERDE XL

uj-akpxl
Stoc epuizat

167,00Lei

SWINGER FOX MK3 CULOARE VERDE -14%

SWINGER FOX MK3 CULOARE VERDE

csi044
Stoc epuizat

164,21Lei(-14%) 141,13Lei

VARF LANSETA COLMIC NEXT ADVENTURE CARBON VERDE 650mm 4oz

VARF LANSETA COLMIC NEXT ADVENTURE CARBON VERDE 650mm 4oz

catip01e
Stoc epuizat

111,00Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 53 Galben spate verde

Vobler Owner Bug Eye Bait 50mm 6.5gr 53 Galben spate verde

804020206
Stoc epuizat

37,69Lei

Hanger Jaxon cu Lant AJ-SYS108G, Verde

Hanger Jaxon cu Lant AJ-SYS108G, Verde

aj-sys108g
Stoc epuizat

42,00Lei

CLIPS MONTURA PLUMB PIERDUT VERDE MAT CARP ZOOM

CLIPS MONTURA PLUMB PIERDUT VERDE MAT CARP ZOOM

cz1861
Stoc epuizat

4,00Lei

VARF LANSETA COLMIC TAUNUS FEEDER CARBON VERDE

VARF LANSETA COLMIC TAUNUS FEEDER CARBON VERDE

zata01003
Stoc epuizat

64,00Lei

CON ANTITANGLE CARP ZOOM 40MM VERDE

CON ANTITANGLE CARP ZOOM 40MM VERDE

cz3965
Stoc epuizat

15,01Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

c.32.013528
Stoc epuizat

20,96Lei

BILE POP UP FLUO VERDE MAVER

BILE POP UP FLUO VERDE MAVER

75056007
Stoc epuizat

12,99Lei

Afişare 981 - 1000 din 1277 (64 pagini)
Queries: 6, Total time: 57.832 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = '31baf67d738d546c7e95d270d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (48.607)
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('+verde' 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 (8.791)
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 980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.080)
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