Knifemule.com offers top brand name tents and outdoor survival equipment. If you are looking for quality camping gear at discount prices Knife Mule has what you need at prices below retail.
SELECT id, product_name, price_retail, price_list, price_map, part_number, image_url, variant_name FROM product_cat WHERE status = 1 AND (categories LIKE '%Tents%') and status='1' LIMIT 0,15