select GROUP_CONCAT(psa.advertiser_id) from wp_pods_advertiser advertiser inner join wp_podsrel_advertiser_product_service_advertiser psa ON (psa.advertiser_id = advertiser.id) inner join wp_podsrel_advertiser_product_service_service_type cat_type ON (cat_type.advertiser_product_service_id = psa.advertiser_product_service_id and cat_type.service_type_id='180') inner join wp_pods_product_service_type cat ON (cat.id = cat_type.service_type_id) where advertiser.active=1 AND advertiser.product_services_supplier=1
“When fine taste and elegance meet efficiency” Born from a passion for the ‘Arts de la Table,’ Boutsen Design provides a comprehensive, professional and personalised interior decorating service for private jets, yachts and homes. Working with over 140 of the world’s most accomplished manufacturers and brands for tableware, comfort items and amenities, Boutsen Design has the knowledge to select the world’s most refined custom-made accessories to suit all tastes.
Freestream Aircraft is an aggressive international marketer for the upper echelon aircraft owner. Our global reach is the result of over 7 decades of combined international experience and over billion in aircraft sales. Freestream is strategically positioned by both our international offices and tightly networked contacts overseas. In order to complete a high retail transaction, Freestream uses its offices and contacts in the UK, China, New Delhi, Russia and Mexico to locate the best buyer for your aircraft. Whether your next transaction is an upgrade or an acquisition, Freestream has the staff and expertise to meet your needs. Our programs and specialized services are tailored to meet your requirements.
Our patented designs allow the user to sleep in the type of comfort expected from their bed at home or a fine hotel. The JetBed is completely flat with absolutely no hard spots. It is uniform in feeling and firmness over the entire surface. The bed is created to the standards required of hospital beds used for burn victims, which need especially even weight distribution to achieve proper healing. This also makes for a VERY comfortable bed, especially in flight!