SELECT products.id as products_id, products.products_type_id, products.fk_shop_id as fk_shop_id, art_nr, image, products_prices.special as is_special, products_prices.price as products_price, products_prices.price_deluxe as price_deluxe, products_prices.price_premium as price_premium, products_prices.valentine_price as valentine_price, products_prices.valentine_price_deluxe as valentine_price_deluxe, products_prices.valentine_price_premium as valentine_price_premium, products_prices.special1_price as special1_price, products_prices.special1_price_deluxe as special1_price_deluxe, products_prices.special1_price_premium as special1_price_premium, products_prices.special2_price as special2_price, products_prices.special2_price_deluxe as special2_price_deluxe, products_prices.special2_price_premium as special2_price_premium, products_prices.special3_price as special3_price, products_prices.special3_price_deluxe as special3_price_deluxe, products_prices.special3_price_premium as special3_price_premium, products.date_created, status, products_prices.index, products_prices.image_type ,products_prices.options as options, products_description_en.title AS title, products_description_en.intro AS intro, products_description_en.intro_deluxe AS intro_deluxe, products_description_en.intro_premium AS intro_premium, products_description_en.desc AS description, products_description_en.url AS url FROM ((products LEFT JOIN products_description_en ON products.id=products_description_en.product_id AND products_description_en.shop_id = '94') LEFT JOIN products_prices ON products.id = products_prices.product_id AND products_prices.shop_id = '94') WHERE FIND_IN_SET('56',products_prices.categories)>0 AND products.online AND products.archive = '0' AND (products_prices.price > '0' OR products_prices.price_deluxe > '0' OR products_prices.price_premium > '0') AND products_prices.online > '0' ORDER BY IF(products_prices.price > '0', products_prices.price, IF(products_prices.price_deluxe > '0', products_prices.price_deluxe, products_prices.price_premium)) ASC SELECT products.id as products_id, products.products_type_id, products.fk_shop_id as fk_shop_id, art_nr, image, products_prices.special as is_special, products_prices.price as products_price, products_prices.price_deluxe as price_deluxe, products_prices.price_premium as price_premium, products_prices.valentine_price as valentine_price, products_prices.valentine_price_deluxe as valentine_price_deluxe, products_prices.valentine_price_premium as valentine_price_premium, products_prices.special1_price as special1_price, products_prices.special1_price_deluxe as special1_price_deluxe, products_prices.special1_price_premium as special1_price_premium, products_prices.special2_price as special2_price, products_prices.special2_price_deluxe as special2_price_deluxe, products_prices.special2_price_premium as special2_price_premium, products_prices.special3_price as special3_price, products_prices.special3_price_deluxe as special3_price_deluxe, products_prices.special3_price_premium as special3_price_premium, products.date_created, status, products_prices.index, products_prices.image_type ,products_prices.options as options, products_description_en.title AS title, products_description_en.intro AS intro, products_description_en.intro_deluxe AS intro_deluxe, products_description_en.intro_premium AS intro_premium, products_description_en.desc AS description, products_description_en.url AS url FROM ((products LEFT JOIN products_description_en ON products.id=products_description_en.product_id AND products_description_en.shop_id = '94') LEFT JOIN products_prices ON products.id = products_prices.product_id AND products_prices.shop_id = '94') WHERE 1=1 AND products.online AND products.archive = '0' AND (products_prices.price > '0' OR products_prices.price_deluxe > '0' OR products_prices.price_premium > '0') AND products_prices.online > '0' AND (FIND_IN_SET('59',products_prices.categories)>0 OR FIND_IN_SET('61',products_prices.categories)>0 OR FIND_IN_SET('19',products_prices.categories)>0 OR FIND_IN_SET('41',products_prices.categories)>0 OR FIND_IN_SET('16',products_prices.categories)>0 OR FIND_IN_SET('25',products_prices.categories)>0 OR FIND_IN_SET('40',products_prices.categories)>0 OR FIND_IN_SET('62',products_prices.categories)>0 OR FIND_IN_SET('31',products_prices.categories)>0 OR FIND_IN_SET('60',products_prices.categories)>0 OR FIND_IN_SET('39',products_prices.categories)>0) ORDER BY Rand() /*Limit 12*/ 💐 Cas Grandi Dreamy Delight - Flower Delivery | 12 Mixed Roses | FLOWER DELIVERY CAS GRANDI - ONLINE FLORIST CAS GRANDI
loading

Product Details:

18 Mixed Roses

Delightful mix of Pink, Purple and White Roses. Delight your special person. Vase not included. Please note should purple roses not be available an alternative pink shade of rose will be used.

Cas Grandi flowers  -  Dreamy Delight Flower Bouquet/Arrangement Product Code: BQM113
Image example showing DELUXE-Size

Select Delivery Date

  • Select Your Size

Add to basket    Back

Add a vase

  • Cas Grandi flowers  -  Standard Glass Vase  Flower Delivery plus sign

    Standard Glass Vase

    USD 17.00
  • Cas Grandi flowers  -  Standard Glass Vase  Flower Delivery plus sign

    Medium Glass Vase

    USD 29.00
  • Cas Grandi flowers  -  Standard Glass Vase  Flower Delivery plus sign

    Large Glass Vase

    USD 44.00
  • Cas Grandi flowers  -  Funeral Ribbon   Flower Delivery plus sign

    Printed Ribbon for Funeral 5 words

    USD 22.00
  • Cas Grandi flowers  -  Rectangular Glass Vase  Flower Delivery plus sign

    Standard Rectangular Glass Vase

    USD 25.00
  • Cas Grandi flowers  -  Rectangular Glass Vase  Flower Delivery plus sign

    Medium Rectangular Glass Vase

    USD 39.00
  • Cas Grandi flowers  -  Rectangular Glass Vase  Flower Delivery plus sign

    Large Rectangular Glass Vase

    USD 54.00
 

Other popular flower bouquets for Cas Grandi: