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


Mulineta Sunset Sunfire SW 10000 FD

Mulineta Sunset Sunfire SW 10000 FD

30811stsrh710110007
Livrare imediată!

750,79Lei

Carlige Sunset Sunhooks SW 5513BN, nr.3/0, 4buc/plic
Exclusiv online!

Carlige Sunset Sunhooks SW 5513BN, nr.3/0, 4buc/plic

121011stshh45183bn-0300
Livrare 48-72 ore

25,00Lei

Carlige Sunset Sunhooks SW 5513BN, nr.5/0, 3buc/plic
Exclusiv online!

Carlige Sunset Sunhooks SW 5513BN, nr.5/0, 3buc/plic

121011stshh45183bn-0500
Livrare 48-72 ore

25,00Lei

Carlige Sunset Sunhooks SW 5513BN, nr.6/0, 3buc/plic
Exclusiv online!

Carlige Sunset Sunhooks SW 5513BN, nr.6/0, 3buc/plic

121011stshh45183bn-0600
Livrare 48-72 ore

25,00Lei

Carlige Sunset Sunhooks SW 5513BN, nr.1/0, 6buc/plic

Carlige Sunset Sunhooks SW 5513BN, nr.1/0, 6buc/plic

121011stshh45183bn-0100
Livrare imediată!

25,00Lei

Carlige Sunset Sunhooks SW 5513BN, nr.4/0, 4buc/plic

Carlige Sunset Sunhooks SW 5513BN, nr.4/0, 4buc/plic

121011stshh45183bn-0400
Livrare imediată!

25,00Lei

Mulineta Sunset Sundown SW 6500 FD
Exclusiv online!

Mulineta Sunset Sundown SW 6500 FD

30811stsrk79076500
Livrare 48-72 ore

575,81Lei

Mulineta Sunset Sunguard Spin SW 7003 FD

Mulineta Sunset Sunguard Spin SW 7003 FD

30811stsrg76137003
Livrare imediată!

231,93Lei

Carlige Somn VMC 7264BN Cat Spirit, Nr. 9/0, 4buc/pac
Exclusiv online!

Carlige Somn VMC 7264BN Cat Spirit, Nr. 9/0, 4buc/pac

rg6000025
Livrare 48-72ore

29,00Lei

Sunsoft Sunset Octopus 120mm S-0638

Sunsoft Sunset Octopus 120mm S-0638

130111stslg5666120s-0638
Livrare imediată!

13,38Lei

Lanseta Sunset Tamara Power ZXR 2.70m 100-300gr

Lanseta Sunset Tamara Power ZXR 2.70m 100-300gr

20311stsrj8147270-2
Livrare imediată!

209,68Lei

Lanseta Sunset Tamara Power ZXR 2.10m 100-300gr

Lanseta Sunset Tamara Power ZXR 2.10m 100-300gr

20311stsrj8147210-2
Livrare imediată!

183,37Lei

Lanseta Sunset Girelle ZXR 2.10m 60-120gr

Lanseta Sunset Girelle ZXR 2.10m 60-120gr

20311stsrj8149210-2
Livrare imediată!

139,48Lei

Lanseta Sunset Girelle ZXR 2.40m 60-120gr

Lanseta Sunset Girelle ZXR 2.40m 60-120gr

20311stsrj8149240-2
Livrare imediată!

147,74Lei

Clopotel Dublu Sunset Sunbell 22mm 2buc

Clopotel Dublu Sunset Sunbell 22mm 2buc

42111stsak176820d
Livrare imediată!

9,58Lei

Clopotel Sunset Sunbell 22mm 2buc
Exclusiv online!

Clopotel Sunset Sunbell 22mm 2buc

42111stsak176820s
Livrare 48-72 ore

9,58Lei

Carlige Sunset Sunhooks SW 5513BN, nr.2/0, 5buc/plic

Carlige Sunset Sunhooks SW 5513BN, nr.2/0, 5buc/plic

121011stshh45183bn-0200
Stoc epuizat

25,00Lei

Sunsoft Sunset Octopus 120mm S-1101

Sunsoft Sunset Octopus 120mm S-1101

130111stslg5666120s-1101
Stoc epuizat

13,38Lei

Sunsoft Sunset Octopus 120mm S-0075

Sunsoft Sunset Octopus 120mm S-0075

130111stslg5666120s-0075
Stoc epuizat

15,01Lei

Sunsoft Sunset Octopus 120mm S-0414

Sunsoft Sunset Octopus 120mm S-0414

130111stslg5666120s-0414
Stoc epuizat

15,01Lei

Afişare 1 - 20 din 24 (2 pagini)
Queries: 6, Total time: 3.703 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'e2916ca6b973683a6656ad9075'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.927)
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('+somn +sunset' 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.324)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.134)
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.134)
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