Notice: A non well formed numeric value encountered in /home/silkbou3/public_html/include/functions.php on line 825
Fri, 10th Feb 2012 04:56 am
(Opening Hours: 9am to 6pm Monday to Friday)
Get Well Fruit Baskets are the traditional gift for someone who has been in hospital for a while, but they can be used for Fathers Day, Mothers Day, Moving House gifts and many more occasions.
At www.silkbouquets.co.uk we make artificial fruit baskets that look completely natural – good enough to eat.They can sit in the middle of a table and look great for months on end without going rotten.Their bright colours help to cheer up any dark corner and only need a light dusting to keep them looking good.
So, why not send an artificial Fruit Basket next time you are stuck for a gift, visit us now and browse through our beautiful selection of silk flower and artificial arrangements and find what you have been searching for.
Free Book - How to Plan a Wedding Free Wedding Planner Guide! Limited to only 100 being given away FREE on all orders from any item in the Wedding Section over £35 Read More
Select live_chat from sb_admin where admin_uid = 'admin' Table 'silkbou3_silkbouquets.sb_admin' doesn't exist
PAY BY TELEPHONE
PAY BY CHEQUE
PAY BY CREDIT CARD
We accept payment by
Debit Cards, Switch, Maestro, MasterCard & Visa No surcharges on any cards We accept BACS, Wire Transfer, cheque or cash
Select is_active_ebook from sb_admin where admin_uid = 'admin' Table 'silkbou3_silkbouquets.sb_admin' doesn't exist
Select live_catalogue from sb_admin where admin_uid = 'admin' Table 'silkbou3_silkbouquets.sb_admin' doesn't exist
SELECT
p.product_id,p.product_name,p.product_page_name,p.product_discount,
s.product_price,s.product_weight,s.size_ref_id,
sz.size_title,
c1.category_title as pTitle,
c2.category_title as cTitle,
i.image_name,i.image_alt,
i.color_ref_id
FROM
sb_product_master as p
LEFT JOIN sb_price_master as s ON s.product_ref_id = p.product_id
LEFT JOIN sb_category_master c1 ON c1.category_id = p.category_ref_id
LEFT JOIN sb_category_master c2 ON c2.category_id = p.subcat_ref_id
LEFT JOIN sb_image_master i ON i.product_ref_id = p.product_id
LEFT JOIN sb_color_master c ON i.color_ref_id = c.color_id
LEFT JOIN sb_size_master sz ON sz.size_id = s.size_ref_id
WHERE
p.is_active = 'Y' AND p.is_footer = 'Y' and is_ebook = 'N'
GROUP BY
p.product_id
ORDER BY
p.added_on DESC Table 'silkbou3_silkbouquets.sb_product_master' doesn't exist