Single-lever shower faucet Delaware

array ( 0 => 542755, 1 => 542776, 2 => 542777, 3 => 542808, 4 => 542809, 5 => 542810, 6 => 542811, 7 => 542812, 8 => 542813, 9 => 542814, 10 => 542815, 11 => 542816, 12 => 542852, 13 => 542853, 14 => 542875, 15 => 542893, 16 => 542894, 17 => 542895, 18 => 542896, 19 => 544368, 20 => 544393, 21 => 544635, 22 => 547472, 23 => 547480, 24 => 547485, 25 => 547486, 26 => 547493, 27 => 547676, 28 => 549562, 29 => 551085, )
array ( 0 => array ( 'id_product' => '549562', 'id_shop' => '6', 'id_category_default' => '12525', '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:48:21', 'date_upd' => '2025-08-12 17:53:53', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3679148', 'name' => 'Single-lever bathtub set with a shower hand Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe103', 'reference' => '250ni100610', ), 1 => array ( 'id_product' => '551085', 'id_shop' => '6', 'id_category_default' => '12525', '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:50:07', 'date_upd' => '2025-08-12 18:25:43', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3680505', 'name' => 'Single-lever shower mixer with plate Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe686', 'reference' => '250ni102133', ), 2 => array ( 'id_product' => '542755', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:33', 'date_upd' => '2025-08-12 15:30:12', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673067', 'name' => 'Tall, single-lever washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe223', 'reference' => '250ni93803', ), 3 => array ( 'id_product' => '542776', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:35', 'date_upd' => '2025-08-12 15:30:47', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673088', 'name' => 'Single-lever countertop washbasin tap without waste Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe917', 'reference' => '250ni93824', ), 4 => array ( 'id_product' => '542777', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:35', 'date_upd' => '2025-08-12 15:30:48', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673089', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe217', 'reference' => '250ni93825', ), 5 => array ( 'id_product' => '542808', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:36', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673120', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe219', 'reference' => '250ni93856', ), 6 => array ( 'id_product' => '542809', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:38', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673121', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe221', 'reference' => '250ni93857', ), 7 => array ( 'id_product' => '542810', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:40', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673122', 'name' => 'Tall, single-lever washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe222', 'reference' => '250ni93858', ), 8 => array ( 'id_product' => '542811', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:42', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673123', 'name' => 'Single-lever countertop washbasin tap without waste Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe920', 'reference' => '250ni93859', ), 9 => array ( 'id_product' => '542812', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:43', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673124', 'name' => 'Wall-mounted single-lever washbasin tap without stopper Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe956', 'reference' => '250ni93860', ), 10 => array ( 'id_product' => '542813', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:45', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673125', 'name' => 'Tall, single-lever washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe213', 'reference' => '250ni93861', ), 11 => array ( 'id_product' => '542814', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:47', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673126', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe229', 'reference' => '250ni93862', ), 12 => array ( 'id_product' => '542815', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:49', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673127', 'name' => 'Tall, single-lever washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe912', 'reference' => '250ni93863', ), 13 => array ( 'id_product' => '542816', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:37', 'date_upd' => '2025-08-12 15:31:50', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673128', 'name' => 'Wall-mounted single-lever washbasin tap without stopper Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe958', 'reference' => '250ni93864', ), 14 => array ( 'id_product' => '542852', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:49', 'date_upd' => '2025-08-12 15:32:44', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673164', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe210', 'reference' => '250ni93900', ), 15 => array ( 'id_product' => '542853', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:49', 'date_upd' => '2025-08-12 15:32:46', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673165', 'name' => 'Tall, single-lever washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe922', 'reference' => '250ni93901', ), 16 => array ( 'id_product' => '542875', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:51', 'date_upd' => '2025-08-12 15:33:18', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673187', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe211', 'reference' => '250ni93923', ), 17 => array ( 'id_product' => '542893', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:52', 'date_upd' => '2025-08-12 15:33:46', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673204', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe227', 'reference' => '250ni93941', ), 18 => array ( 'id_product' => '542894', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:52', 'date_upd' => '2025-08-12 15:33:47', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673205', 'name' => 'Wall-mounted single-lever washbasin tap with plate Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe258', 'reference' => '250ni93942', ), 19 => array ( 'id_product' => '542895', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:52', 'date_upd' => '2025-08-12 15:33:49', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673206', 'name' => 'Single-lever countertop washbasin tap without waste Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe927', 'reference' => '250ni93943', ), 20 => array ( 'id_product' => '542896', 'id_shop' => '6', 'id_category_default' => '12525', '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:37:52', 'date_upd' => '2025-08-12 15:33:51', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3673207', 'name' => 'Single-lever countertop washbasin tap without waste Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe910', 'reference' => '250ni93944', ), 21 => array ( 'id_product' => '544368', 'id_shop' => '6', 'id_category_default' => '12525', '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:39:26', 'date_upd' => '2025-08-12 16:08:25', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3674656', 'name' => 'Single-lever washbasin faucet Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe220', 'reference' => '250ni95416', ), 22 => array ( 'id_product' => '544393', 'id_shop' => '6', 'id_category_default' => '12525', '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:39:28', 'date_upd' => '2025-08-12 16:08:59', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3674681', 'name' => 'Single-lever countertop washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe212', 'reference' => '250ni95441', ), 23 => array ( 'id_product' => '544635', 'id_shop' => '6', 'id_category_default' => '12525', '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:39:51', 'date_upd' => '2025-08-12 16:13:59', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3674919', 'name' => 'Wall-mounted washbasin tap Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe256', 'reference' => '250ni95683', ), 24 => array ( 'id_product' => '547472', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:01', 'date_upd' => '2025-08-12 17:11:02', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677370', 'name' => 'Countertop bidet faucet with one handle Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe370', 'reference' => '250ni98520', ), 25 => array ( 'id_product' => '547480', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:02', 'date_upd' => '2025-08-12 17:11:15', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677378', 'name' => 'Countertop bidet faucet with one handle Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe311', 'reference' => '250ni98528', ), 26 => array ( 'id_product' => '547485', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:02', 'date_upd' => '2025-08-12 17:11:24', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677383', 'name' => 'Countertop bidet faucet with one handle Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe321', 'reference' => '250ni98533', ), 27 => array ( 'id_product' => '547486', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:02', 'date_upd' => '2025-08-12 17:11:25', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677384', 'name' => 'Countertop bidet faucet with one handle Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe320', 'reference' => '250ni98534', ), 28 => array ( 'id_product' => '547493', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:02', 'date_upd' => '2025-08-12 17:11:36', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677391', 'name' => 'Countertop bidet faucet with one handle Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe360', 'reference' => '250ni98541', ), 29 => array ( 'id_product' => '547676', 'id_shop' => '6', 'id_category_default' => '12525', '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:46:13', 'date_upd' => '2025-08-12 17:16:01', 'pack_stock_type' => '3', 'import' => '1', 'id_image' => '3677574', 'name' => 'Single-lever bidet faucet with swivel spout Delaware', 'link_rewrite' => 'inspired-by-cristina-rubinetterie-queen-criqe310', 'reference' => '250ni98724', ), )
Other products from this collection:
@ Ask a question about product
✈ Express service
PDF

Product description
Importer
Reviews

More info

This is not just an order - this is the beginning of your unique project! ✨

Get inspired, let your imagination run wild and tell us what your dream product should look like. We will take care of the rest and transform your idea into a unique product. However, we inform you that we do not fulfill orders that are faithful reproductions of existing products, especially those protected by copyright or owned by other brands.

💡 Let's create something unique together! Contact us for a quote for your unique product. 🔥

Inspired by Cristina Rubinetterie Queen CRIQE689 (not Cristina Rubinetterie Queen CRIQE689)

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

Inspired by: Cristina Rubinetterie Queen
Original code: CRIQE689

Product description

Queen CRIQE689 - Outdoor wall mounted single lever shower/bath set, metal plate, with mechanical mixing, automatic diverter with 2 outputs. To be completed with the built-in part CRICS535.
Finishes:
ChromeKing and Queen, the series created by Ornella Mainini and Roberto Camisasca, combine elegance and practicality with an elegant, clean and contemporary design. The details that refresh the offer today with the introduction of a new lever make them immediately recognizable. Both series, characterized by the same proportions and stylistic line, are the result of a clear desire to create an "elementary", necessary and instinctive product, albeit with a strong personality.
The shape is round, feminine, soft and delicate, but the spirit is determined and She is strong-willed, just like a queen. What makes the Queen special? Walking and elegance? Sure, but also the awareness that every gesture, even the smallest one, must have a pinch of uniqueness.”