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


Lada Frigorifica Igloo 24 HLC -23%

Lada Frigorifica Igloo 24 HLC

00062857
Livrare imediată!

169,00Lei(-23%) 129,90Lei

Geanta Frigorifica Shakespeare Cool Bag
Exclusiv online!

Geanta Frigorifica Shakespeare Cool Bag

1550325
Livrare 7-14 zile

157,46Lei

Lada Frigorifica Igloo Contour Marine, Blue, 23L, 46x30x39cm -5%

Lada Frigorifica Igloo Contour Marine, Blue, 23L, 46x30x39cm

igl00049644
Livrare imediată!

241,90Lei(-5%) 229,90Lei

Geanta Frigorifica Norfin VARDO
Exclusiv online!

Geanta Frigorifica Norfin VARDO

nfl-40106
Livrare 48-72ore

516,00Lei

Lada frigorifica electrica Campingaz Powerbox Plus 36l -7%
Exclusiv online!

Lada frigorifica electrica Campingaz Powerbox Plus 36l

2000024957
Livrare 24-48 ore

749,00Lei(-7%) 698,99Lei

Lada frigorifica Campingaz Icetime Plus 30l

Lada frigorifica Campingaz Icetime Plus 30l

2000024963
Livrare imediată!

229,00Lei

Lada frigorifica Campingaz Icetime Plus 26l
Exclusiv online!

Lada frigorifica Campingaz Icetime Plus 26l

2000024962
Livrare 24-48 ore

189,00Lei

Lada frigorifica Campingaz Icetime 13l
Exclusiv online!

Lada frigorifica Campingaz Icetime 13l

39401
Livrare 24-48 ore

139,00Lei

Lada frigorifica electrica Campingaz Powerbox Plus 28l -8%
Exclusiv online!

Lada frigorifica electrica Campingaz Powerbox Plus 28l

2000024956
Livrare 24-48 ore

649,00Lei(-8%) 599,00Lei

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Polar White

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Polar White

10-01623-123
Livrare imediată!

478,74Lei

Lada Frigorifica Plano Frost 32QT -20%

Lada Frigorifica Plano Frost 32QT

p000083
Livrare imediată!

855,00Lei(-20%) 685,00Lei

Lada Frigorifica STANLEY The Cold-For-Days Outdoor Cooler 28.3L / 30QT, Polar

Lada Frigorifica STANLEY The Cold-For-Days Outdoor Cooler 28.3L / 30QT, Polar

10-01936-039
Livrare imediată!

1.067,89Lei

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023 94

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023 94

2000037402
Livrare imediată!

1.500,00Lei

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Stanley Green

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Stanley Green

10-01623-197
Livrare imediată!

496,46Lei

Lada Frigorifica Electrica 12/230V Campingaz Powerbox Plus 24l
Exclusiv online!

Lada Frigorifica Electrica 12/230V Campingaz Powerbox Plus 24l

2000037453
Livrare 24-48 ore

698,99Lei

Lada Frigorifica Pasiva Coleman Marine Xtreme 2023 66l
Exclusiv online!

Lada Frigorifica Pasiva Coleman Marine Xtreme 2023 66l

2000037401
Livrare 24-48 ore

1.099,00Lei

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023, 47l
Exclusiv online!

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023, 47l

3000005137
Livrare 24-48 ore

999,01Lei

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 6.6L / 7QT, Polar

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 6.6L / 7QT, Polar

10-01622-086
Livrare imediată!

349,80Lei

Lada Frigorifica Pasiva Coleman Xtreme 49l
Exclusiv online!

Lada Frigorifica Pasiva Coleman Xtreme 49l

2000037212
Livrare 24-48 ore

740,00Lei

Lada Frigorifica Campingaz Powerbox Plus 24l
Exclusiv online!

Lada Frigorifica Campingaz Powerbox Plus 24l

2000024955
Livrare 24-48 ore

599,00Lei

Afişare 1 - 20 din 38 (2 pagini)
Queries: 8, Total time: 171.247 ms [By time] [By id] [By file]
1 (0.166)
SELECT data
FROM `oc_session`
WHERE session_id = '8322641ff970763b44d82de5fc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.161)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.196)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (170.204)
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 = '2' AND (pd.tag LIKE "%frigorifica%") 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
5 (0.172)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.122)
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