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


Sac de Dormit JRC Defender Sleeping Bag&Cover, 3 Sezoane -32%

Sac de Dormit JRC Defender Sleeping Bag&Cover, 3 Sezoane

1441639
Livrare imediată!

591,00Lei(-32%) 399,90Lei

Patura Avid Carp Thermafast Sleeping Bag Cover 225x132cm
Exclusiv online!

Patura Avid Carp Thermafast Sleeping Bag Cover 225x132cm

a0450008
Livrare 7-14 zile

449,96Lei

Sac de Dormit COLEMAN Fision 100, 210x82cm
Exclusiv online!

Sac de Dormit COLEMAN Fision 100, 210x82cm

2000028601
Livrare 24-48 ore

360,00Lei

Sac de dormit Coleman Pathfinder
Exclusiv online!

Sac de dormit Coleman Pathfinder

2000015575
Livrare 24-48 ore

560,00Lei

Sac de Dormit JRC Cocoon 5 Season Wide Sleeping Bag, 208x98cm

Sac de Dormit JRC Cocoon 5 Season Wide Sleeping Bag, 208x98cm

1537803
Livrare imediată!

749,95Lei

Sac de Dormit pentru Copii Coleman Lotus S, 165x65cm
Exclusiv online!

Sac de Dormit pentru Copii Coleman Lotus S, 165x65cm

2000038692
Livrare 24-48 ore

270,00Lei

Patura Nash Indulgence Waterproof Bedchair Cover Wide Camo, 232x140cm
Exclusiv online!

Patura Nash Indulgence Waterproof Bedchair Cover Wide Camo, 232x140cm

t9557
Livrare 7-14 zile

636,95Lei

Combo Pat + Sac de Dormit Nash Indulgence All Season Sleep System SS3, 212x83x32cm

Combo Pat + Sac de Dormit Nash Indulgence All Season Sleep System SS3, 212x83x32cm

t9506
Livrare imediată!

2.259,99Lei

Patura Jrc Defender Fleece Sleeping Bag Cover -31%

Patura Jrc Defender Fleece Sleeping Bag Cover

1441638
Livrare imediată!

295,00Lei(-31%) 202,50Lei

Patura Jrc Defender Fleece Sleeping Bag Wide Cover -31%

Patura Jrc Defender Fleece Sleeping Bag Wide Cover

1441637
Livrare imediată!

454,00Lei(-31%) 311,70Lei

Sac de Dormit Coleman Maranta L, 205x85cm
Exclusiv online!

Sac de Dormit Coleman Maranta L, 205x85cm

2000038688
Livrare 24-48 ore

630,00Lei

Sac de Dormit Coleman Maranta XL, 220x100cm
Exclusiv online!

Sac de Dormit Coleman Maranta XL, 220x100cm

2000038687
Livrare 24-48 ore

630,00Lei

Sac de dormit JRC Defender 3 sezoane 210X90 cm

Sac de dormit JRC Defender 3 sezoane 210X90 cm

1441634
Livrare imediată!

399,95Lei

Sac de Dormit JRC Rova 3 Season Sleeping Bag, 220x84cm

Sac de Dormit JRC Rova 3 Season Sleeping Bag, 220x84cm

1537842
Livrare imediată!

649,95Lei

Combo Pat + Sac de Dormit Nash Indulgence All Season Sleep System Compact, 191x75x25cm

Combo Pat + Sac de Dormit Nash Indulgence All Season Sleep System Compact, 191x75x25cm

t9505
Livrare imediată!

1.959,99Lei

Lenjerie Coghlans pentru Sacul de Dormit
Exclusiv online!

Lenjerie Coghlans pentru Sacul de Dormit

c0140
Livrare 24-48 ore

175,00Lei

Patura Nash Indulgence Waterproof Bedchair Cover Standard Camo, 232x120cm
Exclusiv online!

Patura Nash Indulgence Waterproof Bedchair Cover Standard Camo, 232x120cm

t9556
Livrare 7-14 zile

587,96Lei

Sac de dormit Prologic Thermal Cover 5 Season 215X90cm

Sac de dormit Prologic Thermal Cover 5 Season 215X90cm

a8.pro.72832
Livrare imediată!

644,40Lei

Patura Prologic Element Thermal Cover Camo 200x130cm

Patura Prologic Element Thermal Cover Camo 200x130cm

a8.pro.72833
Livrare imediată!

258,00Lei

Sac de Dormit Coleman Lotus L, 205x85cm
Exclusiv online!

Sac de Dormit Coleman Lotus L, 205x85cm

2000038690
Livrare 24-48 ore

299,00Lei

Afişare 41 - 60 din 97 (5 pagini)
Queries: 4, Total time: 3.819 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'ee70c38c09b8d140a0bd4160ce'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3.519)
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('+dormit' 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.100)
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