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 300 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


Rod Pod Carp Spirit Aluminiu BLAX 4 Posturi 3/4 -11%
Exclusiv online!

Rod Pod Carp Spirit Aluminiu BLAX 4 Posturi 3/4

acs370091
Livrare 48-72ore

899,00Lei(-11%) 799,00Lei

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 70/110 cm

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 70/110 cm

72149067
Livrare imediată!

18,00Lei

Suport Genlog Mini Standard Side Rest-Ribber

Suport Genlog Mini Standard Side Rest-Ribber

fma-ssrr
Livrare imediată!

58,30Lei

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR A

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR A

bt-fr06a
Livrare imediată!

31,00Lei

Stoper, Ciupercuta, Flotant, Mini, Mostiro, (10Buc), 4172, Opritoare Porumb Boilies, Opritoare Porumb Boilies Mostiro, Mostiro
Cutie Accesorii Korda Mini Compartment Boxes 16 Compartimente

Cutie Accesorii Korda Mini Compartment Boxes 16 Compartimente

a4.kbox10
Livrare imediată!

53,40Lei

Perna, Energo, Team, STIUCA, MINI, 74016210, Perne Pescuit / Camping, Perne Pescuit / Camping EnergoTeam, EnergoTeam
Exclusiv online!

Perna, Energo, Team, STIUCA, MINI, 74016210, Perne Pescuit / Camping, Perne Pescuit / Camping EnergoTeam, EnergoTeam

74016210
Livrare 24-48 ore

70,00Lei

Burghiu Select Baits Boilie and Nut Drill Mini 1.5mm/3.0cm

Burghiu Select Baits Boilie and Nut Drill Mini 1.5mm/3.0cm

sel-218012
Livrare imediată!

12,99Lei

POP-UP MAINLINE MINI NEW GRANGE 10MM
Exclusiv online!

POP-UP MAINLINE MINI NEW GRANGE 10MM

a0.m.m21021
Livrare 24-48 ore

49,36Lei

Porumb artificial Enterprise Tackle Mini Pop-Up Sweetcorn - Yellow

Porumb artificial Enterprise Tackle Mini Pop-Up Sweetcorn - Yellow

et13myuf
Livrare imediată!

16,01Lei

Vobler, Spro, Trout, Master, Flat, Mini, Crank, 3, Cm, Monkey, Banana, 2Gr, 004916-00401-00000, Voblere Floating, Voblere Floating Spro, Spro
Exclusiv online!

Vobler, Spro, Trout, Master, Flat, Mini, Crank, 3, Cm, Monkey, Banana, 2Gr, 004916-00401-00000, Voblere Floating, Voblere Floating Spro, Spro

004916-00401-00000
Livrare 48-72 ore

32,00Lei

CONURI CARP EXPERT KNOT PROTECTOR SLEEVES MINI 10 BUC/PLIC

CONURI CARP EXPERT KNOT PROTECTOR SLEEVES MINI 10 BUC/PLIC

79032800
Livrare imediată!

6,50Lei

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR C
Exclusiv online!

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR C

bt-fr06c
Livrare 48-72 ore

31,00Lei

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 108-198 CM
Exclusiv online!

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 108-198 CM

006540-00111-00000
Livrare 48-72 ore

90,00Lei

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR E

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR E

bt-fr06e
Livrare imediată!

31,00Lei

TRIPOD CARP ZOOM CANTARIRE ALUMINIU 40kg 159cm
Exclusiv online!

TRIPOD CARP ZOOM CANTARIRE ALUMINIU 40kg 159cm

cz8074
Livrare 48-72 ore

260,00Lei

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC YELLOW
Exclusiv online!

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC YELLOW

ai-rr34-yel
Livrare 48-72 ore

7,79Lei

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR F

BROASCA JAXON MAGIC FISH MINI 2.8CM 3.6GR F

bt-fr06f
Livrare imediată!

31,00Lei

Prastie Supreme Aluminiu

Prastie Supreme Aluminiu

80252350
Livrare imediată!

24,00Lei

Carlig Gemini Wide Gape Beaked Nr 4 Micro Barbed 10Buc/Plic -35%

Carlig Gemini Wide Gape Beaked Nr 4 Micro Barbed 10Buc/Plic

guh14
Livrare imediată!

24,54Lei(-35%) 15,90Lei

Afişare 341 - 360 din 901 (46 pagini)
Queries: 6, Total time: 222.204 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'd4906e3e86214e609c67ae5e90'
/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:427
3 (217.798)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%mini%") 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:698
4 (3.999)
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 340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.104)
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
6 (0.100)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38