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 Inox Spro C-Tec Bankstik 40-75cm

Suport Inox Spro C-Tec Bankstik 40-75cm

006540-00302-00000
Livrare imediată!

63,00Lei

Pichet Telescopic Carp Expert Master Inox Stick, 50-80cm
Exclusiv online!

Pichet Telescopic Carp Expert Master Inox Stick, 50-80cm

72151860
Livrare 24-48 ore

154,00Lei

Agrafa Berkley McMahon Ball Bearing Swivels + Vartej cu Rulment, Inox Nr.4, 2buc/plic
Exclusiv online!

Agrafa Berkley McMahon Ball Bearing Swivels + Vartej cu Rulment, Inox Nr.4, 2buc/plic

1280539
Livrare 7-14 zile

21,34Lei

Buzz Bar Carp Expert Master Inox 31cm, 2 Posturi
Exclusiv online!

Buzz Bar Carp Expert Master Inox 31cm, 2 Posturi

77045720
Livrare 24-48 ore

137,04Lei

Suport Umbrela Rive Inox D36, 37cm

Suport Umbrela Rive Inox D36, 37cm

90810104009
Livrare imediată!

302,64Lei

Pichet Telescopic Carp Expert Master Inox Stick, 80-140cm
Exclusiv online!

Pichet Telescopic Carp Expert Master Inox Stick, 80-140cm

72151890
Livrare 24-48 ore

191,89Lei

Pensea Reiva Curbata Inox, 20cm
Exclusiv online!

Pensea Reiva Curbata Inox, 20cm

8430-006
Livrare 48-72 ore

30,90Lei

Cleste Plumbi Preston Stotta Applicator, Inox -15%
Exclusiv online!

Cleste Plumbi Preston Stotta Applicator, Inox

stotta
Livrare 24-48 ore

33,00Lei(-15%) 28,05Lei

Pensea Reiva Curbata Inox, 15cm
Exclusiv online!

Pensea Reiva Curbata Inox, 15cm

8430-004
Livrare 48-72 ore

21,40Lei

Pensea Reiva Curbata Inox, 18cm
Exclusiv online!

Pensea Reiva Curbata Inox, 18cm

8430-005
Livrare 48-72 ore

26,80Lei

Suport Zfish Umbrela Holder Screw, Inox
Exclusiv online!

Suport Zfish Umbrela Holder Screw, Inox

ZF-2548
Livrare 48-72ore

71,55Lei

Set Zfish Baiting Tool 2 In 1 Croseta + Burghiu, Inox

Set Zfish Baiting Tool 2 In 1 Croseta + Burghiu, Inox

zf-2252
Livrare imediată!

11,75Lei

CROSETA MOSTIRO RETRACTABILA INOX DE LUXE
Exclusiv online!

CROSETA MOSTIRO RETRACTABILA INOX DE LUXE

ai-0977
Livrare 48-72 ore

5,30Lei

Suport Avertizor FL inox 50-90Cm

Suport Avertizor FL inox 50-90Cm

8212172717132
Stoc epuizat

11,40Lei

CAP MINCIOG EXTRA CARP PLUS CONECTOR V DIN INOX 105 X 105 X 100 CM

CAP MINCIOG EXTRA CARP PLUS CONECTOR V DIN INOX 105 X 105 X 100 CM

ec0289-42
Stoc epuizat

80,00Lei

PICHET ATTACK INOX 30-50 CM+ADAPTOR PONTON 3 IN 1

PICHET ATTACK INOX 30-50 CM+ADAPTOR PONTON 3 IN 1

ai-bs31a-30-50
Stoc epuizat

49,00Lei

Lama De Schimb Victorinox Pentru Briceag , Inox, Albastru Transparent

Lama De Schimb Victorinox Pentru Briceag , Inox, Albastru Transparent

A.6510.T2
Stoc epuizat

22,00Lei

Suport Spate Zfish S Stell Butt Grip, Inox, 1buc/plic

Suport Spate Zfish S Stell Butt Grip, Inox, 1buc/plic

zf-3283
Stoc epuizat

11,75Lei

Tub Nevis Anti Tangle Inox, 5cm, 3buc/plic

Tub Nevis Anti Tangle Inox, 5cm, 3buc/plic

8100-312
Stoc epuizat

7,60Lei

Breloc Pix Telescopic TRUE Utility TELEPEN, Inox, Argintiu, TU246K

Breloc Pix Telescopic TRUE Utility TELEPEN, Inox, Argintiu, TU246K

TU246K
Stoc epuizat

33,32Lei

Afişare 81 - 100 din 145 (8 pagini)
Queries: 8, Total time: 4.948 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = 'a373438cd4996d0ea4be8a5ea0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (4.032)
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('+inox' 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.174)
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
5 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM 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 '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.132)
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