Blumenstylist #6599

The Flower Stylist is for those who work with precision, but never forgo the creativity that creates true art. Wearing this pair, you navigate raucous urban life like the only one who can tame a wild and overgrown garden. Everything is exactly in its place, but nothing feels rigid-- just like your creativity, which also knows no bounds.

Measurement: 56 ▢ 17-145 // Color: Green

CHF 198.00

incl. 8.1% VAT

location_on Buy in store

chevron_right Swiss Design
chevron_right UV 400 Protection
chevron_right German OBE Hinges
chevron_right CR39 Lenses with anti-reflective Coating
chevron_right Handmade Frames
chevron_right Anti-scratch coated Lenses

Other Variations

Find in stores

Other sizes

Blumenbinder

SELECT `product`.`id` `product_id`, `product`.`product_color_id`, `product`.`product_color_id_2`, `product`.`product_measurement`, `product_group`.`id`, `product_group`.`name` `name_de`, `product_group`.`name_en` `name_en`, `product_group`.`name_fr` `name_fr`, `product_group`.`name_it` `name_it`, `product_group`.`promotion` `group_promotion`, `product_group`.`promotion_euro` `group_promotion_euro`, `product_group`.`measurement`, `product_group`.`product_category_id`, `product_category`.`name_de` `category_de`, `product_category`.`name_en` `category_en`, `product_category`.`name_fr` `category_fr`, `product_category`.`name_it` `category_it`, `product_gender`.`name_de` `gender_de`, `product_gender`.`name_en` `gender_en`, `product_gender`.`name_fr` `gender_fr`, `product_gender`.`name_it` `gender_it`, `reorder_items`.`delivery_date` `next_delivery`, `reorder_items`.`euro_delivery_date` `euro_next_delivery`
FROM (`product`, `product_group`, `product_category`, `product_gender`, `product_fits`)
LEFT JOIN `reorder_items` ON `product`.`id` = `reorder_items`.`product_id`
WHERE `product_group`.`id` = `product`.`product_group_id`
AND `product_group`.`id` = `product_fits`.`fit_group_id`
AND `product`.`online` = 1
AND `product`.`invisible` = 0
AND `product_group`.`online` = 1
AND `product_group`.`invisible` = 0
AND `product_fits`.`product_group_id` = '1302'
AND   (
`product`.`stock` > 0
OR    (
`product`.`stock` = 0
AND `product`.`sold_out` = 1
  )
OR    (
`product`.`stock` <= 0
AND `reorder_items`.`delivery_date` != '0000-00-00'
  )
 )
GROUP BY `product`.`id`
ORDER BY `product`.`is_thumb` DESC