Snake bib Onalaska

array ( 0 => 501709, 1 => 501713, 2 => 501714, 3 => 501717, 4 => 501722, 5 => 501727, 6 => 540102, 7 => 541037, 8 => 541873, 9 => 547057, 10 => 550634, 11 => 550725, 12 => 553170, 13 => 562694, 14 => 562825, 15 => 562851, )
array ( 0 => array ( 'id_product' => '550634', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:49:38', 'date_upd' => '2024-06-11 11:37:46', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3487247', 'name' => '2 Hole Wall Mounted Bathtub Faucet in Chrome Plated Brass with Flexible Hose Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni101682', ), 1 => array ( 'id_product' => '550725', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:49:44', 'date_upd' => '2024-06-11 11:38:08', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3487339', 'name' => '2-hole bathtub faucet in chrome-plated brass with flexible hose Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni101773', ), 2 => array ( 'id_product' => '553170', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:52:26', 'date_upd' => '2024-06-11 11:48:56', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3490012', 'name' => 'Single lever shower mixer in chrome-plated brass with flexible hose Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni104218', ), 3 => array ( 'id_product' => '501709', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:30', 'date_upd' => '2024-06-10 20:45:42', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425109', 'name' => '3-hole kitchen tap in chrome-plated brass with a swivel spout Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52757', ), 4 => array ( 'id_product' => '501713', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:31', 'date_upd' => '2024-06-10 20:45:43', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425113', 'name' => 'Brass countertop kitchen faucet with 1 hole and swivel spout Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52761', ), 5 => array ( 'id_product' => '501714', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:31', 'date_upd' => '2024-06-10 20:45:44', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425114', 'name' => 'Wall-mounted tap in chrome-plated brass with swivel spout Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52762', ), 6 => array ( 'id_product' => '501717', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:31', 'date_upd' => '2024-06-10 20:45:44', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425117', 'name' => 'Countertop kitchen tap, 1-hole, chrome-plated brass, with swivel spout Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52765', ), 7 => array ( 'id_product' => '501722', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:32', 'date_upd' => '2024-06-10 20:45:46', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425122', 'name' => 'Countertop tap in chrome-plated brass with single rosettes Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52770', ), 8 => array ( 'id_product' => '501727', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 13:58:32', 'date_upd' => '2024-06-10 20:45:47', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3425127', 'name' => 'Two-hole, wall-mounted kitchen faucet in chrome-plated brass with a swivel spout Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni52775', ), 9 => array ( 'id_product' => '540102', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:34:48', 'date_upd' => '2024-06-11 10:55:00', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3476504', 'name' => 'Wall-mounted shower panel in chrome-plated brass with hand shower and overhead shower Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni91150', ), 10 => array ( 'id_product' => '541037', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:35:44', 'date_upd' => '2024-06-11 10:59:08', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3477550', 'name' => 'Wall-mounted rain shower in chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni92085', ), 11 => array ( 'id_product' => '541873', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '1', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:36:42', 'date_upd' => '2024-06-11 11:03:17', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3478647', 'name' => 'Wall shower in chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni92921', ), 12 => array ( 'id_product' => '562694', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-17 13:04:47', 'date_upd' => '2024-06-11 12:37:08', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3502126', 'name' => '3-hole countertop washbasin tap in chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni97942', ), 13 => array ( 'id_product' => '562825', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-17 13:04:56', 'date_upd' => '2024-06-11 12:37:42', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3502268', 'name' => 'Wall-mounted washbasin tap with a single handle, made of chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni98073', ), 14 => array ( 'id_product' => '547057', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-16 14:43:51', 'date_upd' => '2024-06-11 11:24:24', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3483965', 'name' => 'Countertop washbasin tap with a single handle, made of chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni98105', ), 15 => array ( 'id_product' => '562851', 'id_shop' => '6', 'id_category_default' => '12914', 'id_tax_rules_group' => '23', 'on_sale' => '0', 'online_only' => '0', 'ecotax' => '0.000000', 'minimal_quantity' => '1', 'price' => '0.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '404', 'id_product_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'condition' => 'new', 'show_price' => '0', 'indexed' => '0', 'visibility' => 'both', 'cache_default_attribute' => '0', 'advanced_stock_management' => '0', 'date_add' => '2023-11-17 13:05:00', 'date_upd' => '2024-06-11 12:37:49', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3502295', 'name' => 'Countertop washbasin tap with 1 hole, chrome-plated brass Onalaska', 'link_rewrite' => 'inspired-by-justime-story', 'reference' => '250ni98127', ), )
Other products from this collection:
@ Ask a question about product
✈ Express service
PDF

Product description
Reviews

More info

Inspired by Justime Story (not Justime Story)

Due to the copyright notice, please note that this product is not a

Inspired by: Justime Story
Original code: 6903-L4-80CP

Product description

Joints and nuts usually appear on the shape of the faucet. HISTORY requires hiding the connecting structure to design a unique product to discriminate the market. Installation and operation have been maintained in the basic tradition to meet the overall requirements. The shape not only reserves the shape of the original Bid faucets and integrates contemporary and fashionable elements through the round body model and cloud-like ceramic handle, but also was manufactured using modern processing equipment to enhance the refinement and beauty.
1.MARUWA ceramic insert, ceramic disc (JAPAN)
2.Fits φ15mm(5/8") hose.
3.The connector can be stably connected to the hose without the use of clamps or a tool.
4. Chrome-plated brass, ASTM-SC2 compliant, passed 96-hour salt spray test.
5. High-pressure molded porcelain handles, resistant to UV radiation and color fading.
6. Thread: G 1/2 7. Casting material meets ISO standard CuZn40Pb
8. Manufactured by CNC machining equipment to improve the roundness of the ball shape and overall surface smoothness.
9. Straight shape without additional connections
10. The hose bib can be used in the garden and in the washing machine, and its cute appearance makes the surroundings more beautiful.