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


SUPORT SPATE CORMORAN TIP CUPA PT.LANSETA 1BUC.

SUPORT SPATE CORMORAN TIP CUPA PT.LANSETA 1BUC.

a6.11.07028
Livrare imediată!

15,65Lei

LANTERNA SPRO CU LED TIP LAMPA 150 LUMENI 3W CREE LED
Exclusiv online!

LANTERNA SPRO CU LED TIP LAMPA 150 LUMENI 3W CREE LED

004708-00500-00000
Livrare 48-72 ore

137,60Lei

Lanseta Carp Expert Junior Double Tip 3.0lbs 3.00m Heavy
Exclusiv online!

Lanseta Carp Expert Junior Double Tip 3.0lbs 3.00m Heavy

13394300
Livrare 24-48 ore

248,00Lei

Agrafe rapide tip cărlig Delphin B 03 BN NR.8

Agrafe rapide tip cărlig Delphin B 03 BN NR.8

969b03008
Livrare imediată!

10,00Lei

Racheta de Nadire Tip Spomb Mostiro 4451 Green, Marime S -20%
Exclusiv online!

Racheta de Nadire Tip Spomb Mostiro 4451 Green, Marime S

nn-4451
Livrare 48-72 ore

15,80Lei(-20%) 12,64Lei

Racheta de Nadire Tip Spomb Mostiro 4445 Green, Marime S

Racheta de Nadire Tip Spomb Mostiro 4445 Green, Marime S

4445
Stoc epuizat

14,70Lei

SWINGER JAXON TIP BAMBINA 18CM

SWINGER JAXON TIP BAMBINA 18CM

aj-sot007
Livrare imediată!

6,00Lei

Cutie ENERGO Fishing Box Duo Tip.370

Cutie ENERGO Fishing Box Duo Tip.370

75072370
Livrare imediată!

31,00Lei

SUPORT SPATE MOSTIRO TIP U

SUPORT SPATE MOSTIRO TIP U

ai-1090
Livrare imediată!

4,80Lei

Blocaj Cralusso pluta culisanta tip One Point 0,9mm 2007

Blocaj Cralusso pluta culisanta tip One Point 0,9mm 2007

79001009
Livrare imediată!

10,00Lei

SWINGER JAXON TIP BAMBINA 25CM

SWINGER JAXON TIP BAMBINA 25CM

aj-sot011
Livrare imediată!

7,00Lei

OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC ROZ/GALBEN
Exclusiv online!

OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC ROZ/GALBEN

a.kflc3
Livrare 24-48 ore

13,90Lei

UMBRELA JAXON TIP CORT CAMOU 250CM

UMBRELA JAXON TIP CORT CAMOU 250CM

ak-kzs046
Livrare imediată!

599,00Lei

PUNGI SOLUBILE CARP ZOOM TIP GLONT CU BANDA 65x190MM

PUNGI SOLUBILE CARP ZOOM TIP GLONT CU BANDA 65x190MM

cz8924
Livrare imediată!

13,99Lei

VALIGETA ENERGOTEAM FISHING BOX MINIKID TIP.315
Exclusiv online!

VALIGETA ENERGOTEAM FISHING BOX MINIKID TIP.315

75074315
Livrare 24-48 ore

34,00Lei

Marker Carp Expert Tip 4202

Marker Carp Expert Tip 4202

79510202
Livrare imediată!

9,50Lei

Varf Carbon Trabucco Ultimate Feeder Tip 4
Exclusiv online!

Varf Carbon Trabucco Ultimate Feeder Tip 4

150-91-140
Livrare 48-72 ore

39,00Lei

Capac Protectie Inele STONFO Model C SBS Tip Saver Tipo C1, Size 1, Art.400

Capac Protectie Inele STONFO Model C SBS Tip Saver Tipo C1, Size 1, Art.400

8028651007201
Livrare imediată!

28,00Lei

Juvelnic Energo Team Tip Sac PT 100 cm
Exclusiv online!

Juvelnic Energo Team Tip Sac PT 100 cm

72010100
Livrare 24-48 ore

17,01Lei

CUREA SINTETICA TIP B1ARROW NEAGRA MAR 2XL
Exclusiv online!

CUREA SINTETICA TIP B1ARROW NEAGRA MAR 2XL

vj.curea.b1.2.2xl
Livrare 24-48 ore

201,94Lei

Afişare 121 - 140 din 420 (21 pagini)
Queries: 4, Total time: 9.189 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '8adb26875b2b78228ab1fafeaf'
/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 (8.882)
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 (MATCH(pd.tag) AGAINST('+tip' 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.139)
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