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


ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL

ANTI TANGLE CORMORAN 25CM PT.FEEDER 3BUC/PL

a.49.53125
Livrare imediată!

5,63Lei

MULINETA CORMORAN CORMAXX BR 4000 2RUL/290M/030MM

MULINETA CORMORAN CORMAXX BR 4000 2RUL/290M/030MM

c.19.81400
Livrare imediată!

148,85Lei

Mulineta NGT Max 60 Carp Runner

Mulineta NGT Max 60 Carp Runner

ngt-frl-max60-line
Livrare imediată!

79,00Lei

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 50

MULINETA TEAM FEEDER BY DOME CARP FIGHTER LCS 50

2503-450
Livrare imediată!

181,00Lei

MULINETA TRABUCCO KRONOS SFX FD 6000

MULINETA TRABUCCO KRONOS SFX FD 6000

034-38-600
Livrare imediată!

235,00Lei

MULINETA TICA RAGE EA 6000 -21%

MULINETA TICA RAGE EA 6000

ea6000
Livrare imediată!

149,00Lei(-21%) 117,81Lei

MULINETA LINEAEFE VIGOR CARP BAITFEEDER 6000
Exclusiv online!

MULINETA LINEAEFE VIGOR CARP BAITFEEDER 6000

l.1287460
Livrare 24-48 ore

85,64Lei

MULINETA OKUMA CEYMAR BF 3000
Exclusiv online!

MULINETA OKUMA CEYMAR BF 3000

cmbf-330
Livrare 48-72ore

215,00Lei

LANSETA OKUMA CEYMAR FEEDER 3.60M 60G 120G 3 3 SEGMENTE
Exclusiv online!

LANSETA OKUMA CEYMAR FEEDER 3.60M 60G 120G 3 3 SEGMENTE

c-f-1203h
Livrare 48-72ore

359,09Lei

Tava laterala Mivardi cu Vas pt picor de scaun 25-36 mm

Tava laterala Mivardi cu Vas pt picor de scaun 25-36 mm

m-sbapab2
Livrare imediată!

159,00Lei

VARF LANSETA TRABUCCO FEEDER PRECISION 3OZ

VARF LANSETA TRABUCCO FEEDER PRECISION 3OZ

152-88-030
Livrare imediată!

38,00Lei

LANSETA CARP EXPERT CXP RIVER FEEDER 3.90M 3SEG 3VARFURI
Exclusiv online!

LANSETA CARP EXPERT CXP RIVER FEEDER 3.90M 3SEG 3VARFURI

12341390
Livrare 24-48 ore

341,99Lei

CARLIG GURU LWGF NR.10 10BUC/PL

CARLIG GURU LWGF NR.10 10BUC/PL

gu.glwgf10
Livrare imediată!

11,57Lei

MINCIOG CARP SPIRIT 100X80CM 180CM -50%
Exclusiv online!

MINCIOG CARP SPIRIT 100X80CM 180CM

acc180000
Livrare 48-72ore

159,00Lei(-50%) 80,00Lei

MULINETA DAIWA EMBLEM BR 25A -23%

MULINETA DAIWA EMBLEM BR 25A

d.10928.025
Livrare imediată!

1.354,28Lei(-23%) 1.041,90Lei

MULINETA LINEAEFFE VIGOR COMMANDO 1RUL/130MX050MM/5,2:1

MULINETA LINEAEFFE VIGOR COMMANDO 1RUL/130MX050MM/5,2:1

l.1286240
Livrare imediată!

86,56Lei

CARLIGE TRABUCCO FEEDER METHOD PLUS NR 10 15BUC

CARLIGE TRABUCCO FEEDER METHOD PLUS NR 10 15BUC

023-51-100
Livrare imediată!

15,01Lei

Matrita Incarcare Nada Preston Quick Release Method Mould, Marime XL
Exclusiv online!

Matrita Incarcare Nada Preston Quick Release Method Mould, Marime XL

p0030014
Livrare 7-14 zile

22,46Lei

Mulineta Team Feeder By Dome MasterCarp LCS Pro 6000

Mulineta Team Feeder By Dome MasterCarp LCS Pro 6000

2511-660
Livrare imediată!

416,00Lei

Scaun Matrix Deluxe Accessory Chair -11%

Scaun Matrix Deluxe Accessory Chair

gbc002
Livrare imediată!

787,46Lei(-11%) 699,99Lei

Afişare 3461 - 3480 din 12497 (625 pagini)
Queries: 8, Total time: 327.635 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'f9df67617c9d393180fd91d5e6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (280.000)
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('+feeder' 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 (46.839)
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 3460, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.205)
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.121)
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
7 (0.121)
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
8 (0.112)
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