Customer Service 1-800-328-9090

Every Order Helps Improve a Life.  Lives Improved: 19,578
 
SPECIAL!
FREE SHIPPING on orders over $49

Hairspray

Hairspray

3 item(s) were found

Showing 1-3 of 3 results

  1. 1
  1. LA Hold, Hair Spritz, 2 fl oz
    Giovanni Hair Care Products

    LA Hold, Hair Spritz, 2 fl oz

    2 Fluid Ounce

    $3.19
  2. Medium Hold Hair Spray, 8 fl oz (237 ml)
    Alba Botanica

    Medium Hold Hair Spray, 8 fl oz (237 ml)

    8 Fluid Ounce

    Retail Price: $9.95

    You Save: $3.37

    getIdSuffix() != '-upsell' && $this->getIdSuffix() != '-related' ) : ?>

    Our Price: $6.58

    You Save: 34% ($3.37)34% Off
  3. Magnetic Attraction Styling Gel, 6.8 fl oz (200 ml)
    Giovanni Hair Care Products

    Magnetic Attraction Styling Gel, 6.8 fl oz (200 ml)

    6.8 Fluid Ounce

    Retail Price: $8.99

    You Save: $2.51

    getIdSuffix() != '-upsell' && $this->getIdSuffix() != '-related' ) : ?>

    Our Price: $6.48

    You Save: 28% ($2.51)28% Off

Showing 1-3 of 3 results

  1. 1
McAfee SECURE sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
TRUSTe online privacy certification
[profiler]
Memory usage: real: 10485760, emalloc: 9392848
Code ProfilerTimeCntEmallocRealMem
Executed 91 queries in 0.13370299339294 seconds
Average query length: 0.0014692636636587 seconds
Queries per second: 680.61303408935
Longest query length: 0.016924858093262
Longest query:
SELECT `e`.*, IF(_table_is_active.value_id>0, _table_is_active.value, _table_is_active_default.value) AS `is_active`, IF(_table_include_in_menu.value_id>0, _table_include_in_menu.value, _table_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `_table_is_active_default` ON (_table_is_active_default.entity_id = e.entity_id) AND (_table_is_active_default.attribute_id='34') AND _table_is_active_default.store_id=0 LEFT JOIN `catalog_category_entity_int` AS `_table_is_active` ON (_table_is_active.entity_id = e.entity_id) AND (_table_is_active.attribute_id='34') AND (_table_is_active.store_id='1') INNER JOIN `catalog_category_entity_int` AS `_table_include_in_menu_default` ON (_table_include_in_menu_default.entity_id = e.entity_id) AND (_table_include_in_menu_default.attribute_id='105') AND _table_include_in_menu_default.store_id=0 LEFT JOIN `catalog_category_entity_int` AS `_table_include_in_menu` ON (_table_include_in_menu.entity_id = e.entity_id) AND (_table_include_in_menu.attribute_id='105') AND (_table_include_in_menu.store_id='1') LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.product_id IS NULL AND core_url_rewrite.store_id="1" AND id_path LIKE "category/%") WHERE (e.entity_type_id = '3') AND (e.entity_id in ('5', '389', '111', '382', '383', '11', '15', '112', '114', '115', '117', '116', '16', '119', '120', '391', '17', '121', '122', '123', '124', '125', '126', '127', '128', '129', '12', '397', '131', '132', '130', '133', '134', '135', '436', '136', '137', '409', '138', '405', '139', '140', '141', '142', '147', '143', '144', '145', '146', '149', '148', '150', '151', '152', '18', '401', '153', '154', '155', '156', '245', '157', '158', '113', '160', '159', '161', '385', '162', '164', '22', '165', '166', '167', '168', '169', '170', '171', '172', '174', '21', '402', '175', '176', '177', '179', '178', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '173', '190', '191', '192', '194', '39', '437', '195', '196', '197', '13', '198', '199', '200', '201', '202', '203', '204', '205', '206', '23', '208', '209', '210', '211', '395', '24', '212', '213', '214', '215', '216', '217', '218', '25', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '26', '233', '404', '234', '235', '236', '237', '238', '410', '239', '240', '241', '242', '243', '244', '248', '249', '250', '251', '252', '253', '254', '255', '256', '257', '406', '28', '258', '259', '260', '261', '393', '262', '264', '265', '267', '268', '269', '3', '270', '29', '392', '272', '273', '274', '403', '275', '276', '277', '278', '30', '279', '280', '281', '282', '283', '284', '31', '285', '286', '388', '287', '288', '394', '193', '289', '290', '434', '291', '292', '293', '294', '295', '296', '297', '163', '299', '300', '301', '399', '304', '302', '32', '303', '247', '306', '298', '307', '266', '309', '310', '311', '312', '313', '396', '314', '34', '315', '316', '317', '318', '319', '320', '398', '321', '322', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '83', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '435', '350', '351', '352', '353', '354', '355', '438', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '369', '370', '371', '372', '373', '374', '375', '376', '400', '377', '378', '379', '380', '381', '408', '7', '413', '411', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '8', '40', '41', '43', '44', '45', '46', '91', '47', '48', '49', '64', '50', '95', '94', '93', '107', '51', '52', '53', '54', '55', '56', '96', '57', '58', '59', '60', '61', '62', '92', '70', '71', '98', '65', '66', '99', '100', '72', '108', '390', '73', '84', '101', '74', '75', '102', '103', '76', '77', '104', '78', '79', '97', '105', '80', '81', '82', '109', '85', '86', '87', '88', '110', '89', '106', '90', '9', '10')) AND (IF(_table_is_active.value_id>0, _table_is_active.value, _table_is_active_default.value) = '1') AND (IF(_table_include_in_menu.value_id>0, _table_include_in_menu.value, _table_include_in_menu_default.value) = '1')