-- Table structure for table `promotiongexhotdeal`
--

CREATE TABLE `promotiongexhotdeal` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `priority` int(10) NOT NULL DEFAULT '0',
  `offer_1` varchar(200) NOT NULL,
  `offer_2` varchar(200) NOT NULL,
  `from_price` varchar(20) NOT NULL,
  `was_price` varchar(200) NOT NULL,
  `save_percent` varchar(200) NOT NULL,
  `overlay_1` varchar(200) NOT NULL,
  `overlay_2` varchar(200) NOT NULL,
  `bullet_1` text NOT NULL,
  `bullet_2` text NOT NULL,
  `bullet_3` text NOT NULL,
  `enquire_now` text NOT NULL,
  `main_image` varchar(200) NOT NULL,
  `travel_start_dt` date NOT NULL,
  `travel_end_dt` date NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotiongexhotdeal`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotiongexhotdeal` VALUES (11,0,'Mantra Amphora','3 Nights accommodation\r\nDaily buffet breakfast for two adults\r\nDining discounts & Bonuses!','449','835','46','3 Nights','Palm Cove','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','','main_image-2017-10-12-15-13-34.jpg','2017-10-12','2018-02-01',1927),(10,1,'Kupu Kupu Barong Villas and Tree Spa','Daily Breakfast for two adults\r\nDaily Lunch for two adults\r\nSpa treatment by Lâ€™OCCITANE + bonuses!','378','939','561','2 nights','Bali','<p>\r\n	Set over 3 hectares of lush tropical greenery, this resort delivers luxury and the quintessential Ayung Valley experience</p>\r\n<p>\r\n	<span>These small group of private and luxurious pool villas is served by private butlers, epitomising the beauty and elegance of Balinese architecture; thatched roofs, redwood walls, teak and coconut shell paneling and sumptuous local fabrics weave a spell of exotic refinement. Engage with art, connect with culture, pursue pampering, seek enlightenment or simply listen to the rice grow.</span></p>\r\n<p>\r\n	<span>Kupu Kupu Barong Villas and Tree Spa by L&rsquo;OCCITANE is located in Ubud. It offers a well-appointed spa, restaurant and spacious villas with sweeping views of the tropical landscape. It also has an outdoor pool and provides free WiFi, free parking, and free daily afternoon tea.</span></p>\r\n<p>\r\n	<span>The luxurious villas at Kupu Kupu Barong Villas and Tree Spa by L&rsquo;OCCITANE come with traditional Balinese d&eacute;cor. Each spacious villa is fitted with a TV and DVD player. Select villas have private plunge pools.</span></p>\r\n<p>\r\n	<span>La View Restaurant serves local dishes and features sweeping views of the Ayung River. Light snacks and refreshing beverages are available at the Pool Bar.</span></p>\r\n','<h3 class=\"style_inclusionsHeading__1h2fi\">\r\n	6 bonus inclusions:</h3>\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Breakfast for two adults</li>\r\n	<li>\r\n		Daily Lunch for two adults</li>\r\n	<li>\r\n		1 x Spa treatment (60 mins) by L&rsquo;OCCITANE with spectacular views overlooking the Ayung valley.</li>\r\n	<li>\r\n		Daily afternoon tea at La view Bar 3-5 pm</li>\r\n	<li>\r\n		1 x Cocktail per adult per stay</li>\r\n	<li>\r\n		Free cancellations permitted outside 14 days of travel</li>\r\n</ul>\r\n<hr />\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Bedding</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<span>1 x Double bed</span></li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Extra Guests</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<span>Package is valid for two adults</span></li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Features</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<p>\r\n						<span>Room size: 55 m&sup2;</span></p>\r\n				</li>\r\n				<li>\r\n					<p>\r\n						<span>Room facilities: Balcony, Pool view, TV, Telephone, Satellite Channels, Flat-screen TV, Safety Deposit Box, Air conditioning, Desk, Wardrobe/Closet, Shower, Bath, Hairdryer, Bathrobe, Free toiletries, Toilet, Bathroom, Slippers, Minibar, Electric kettle, Wake-up service, Towels</span></p>\r\n				</li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018</span></p>\r\n<p>\r\n	<span>Strictly subject to availability.</span></p>\r\n<p>\r\n	<span>Please note: Payment will not be charged until the resort has confirmed your stay.</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and Peak Season Surcharge: 24 December 2017 - 5 January 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n<p>\r\n	<span>Compulsory New Year&rsquo;s Eve dinner on 31 December 2017 - Surcharge of $90 per person is payable direct to resort.</span></p>\r\n<p>\r\n	<span>Check-in or Check-out on 31 December 2017 is not permitted.</span></p>\r\n<p>\r\n	<span>Once confirmed, any cancellations, early check-out or no-shows within 14 days of travel are non-refundable and full cancellation penalties will apply. Travel date amendments are permitted subject to availability and approval by resort management.</span></p>\r\n<p>\r\n	<span>Two Bedroom Villa package is valid for four guests, however, can accommodate up to five guests</span></p>\r\n<p>\r\n	<span>Please refer to Extra Guest Policy under room terms and conditions. Any type of extra bed is upon request and needs to be confirmed by management.</span></p>\r\n<p>\r\n	<span>Extra guest supplements are not calculated automatically in the total costs and will have to be paid for separately during your stay.</span></p>\r\n','','main_image-2017-09-29-09-25-56.jpg','2017-09-29','2017-12-31',1892),(9,2,'Agata Resort Nusa Dua','7 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','847','2411','65','7 NIGHTS','Bali','<h2>\r\n	Luxurious, Tranquil and Stylish Villas Nusa Dua</h2>\r\n<p dir=\"ltr\">\r\n	<span>The stunning 5 star resort offers an elegance and comfort tropical accommodation at the elite location of Nusa Dua Bali. The minimalist modern stylist concept is designed smartly to peace of mind your living and holidays. The villas are built on the cliff hill with open area which those are direct view at parcel of green fantastic trees. The experience and atmosphere brings the truly paradise, reflected from our 5 star facilities and personalized service.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily breakfast served in the privacy of your own villa with over 15 menu choices</li>\r\n	<li>\r\n		VIP round trip airport transfers in a private vehicle</li>\r\n	<li>\r\n		2 x 60-minute Balinese massage per adult</li>\r\n	<li>\r\n		1 x Full Day Tour for two adults</li>\r\n	<li>\r\n		Daily afternoon High Tea at The Sky Bar</li>\r\n	<li>\r\n		Welcome drink, fresh fruit and cold towels upon arrival</li>\r\n	<li>\r\n		20% off spa treatments to amp up the indulgence</li>\r\n	<li>\r\n		20% off food and beverages across the resort</li>\r\n	<li>\r\n		Complimentary unlimited wireless internet (at Resort Area)</li>\r\n	<li>\r\n		Complimentary drop-off transportation to BTDC Nusa Dua , Geger White sand Beach area</li>\r\n	<li>\r\n		Early check-in and late check-out (subject to availability)</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018.</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and Peak Season Surcharge: 20 December 2017 - 5 January 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n','','main_image-2017-09-25-16-02-19.jpg','2017-09-21','2017-09-21',1883),(8,2,'Manathai Koh Samui','3 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','261','525','50','3 NIGHTS','Thailand','<p class=\"Hotel_overviewLead__z_QL9\">\r\n	An elegant sanctuary set on the serene sands of Lamai Beach defined by its history, soft colonial elegance and world-class service</p>\r\n<p>\r\n	<span>Set on the sand of Lamai Beach within a peaceful enclave of coconut trees, Manathai Koh Samui Hotel feels a world away from everyday life, while positioning guests within easy reach of the island&rsquo;s best shopping and dining attractions.</span></p>\r\n<p>\r\n	<span><span>Manathai </span>Koh Samui continues to be the ideal choice for travelers to Thailand&rsquo;s most delightful island destination. Wander into an oasis of old-world charm where walls adorned in cheerful yellow jasmine hues are complimented with soft white details to frame a vision of a bygone Thai era.</span></p>\r\n<p>\r\n	<span>The resort channels colonial elegance to create an oasis of gardens, courtyards, polished teak hallways and guest quarters that echo old world charm. Weary travelers recline in the shade of swaying palm fronds while lapping waves offer a soothing lullaby fit to induce an indulgent afternoon nap.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Buffet Breakfast</li>\r\n	<li>\r\n		Welcome cocktail per adult</li>\r\n	<li>\r\n		1 x Lunch or Dinner at Pad Thai Restaurant for up to two guests</li>\r\n	<li>\r\n		Free Wi-Fi</li>\r\n	<li>\r\n		Free cancellations until 14 days prior to travel (low seasons)</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018</span></p>\r\n<p>\r\n	<span>Black-out dates (period not valid): 24 December 2017 - 6 January 2018</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and 7 January - 31 March 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n','','main_image-2017-09-25-15-46-02.jpg','2017-09-21','2017-09-21',1882),(7,2,'Beyond Resort Khaolak','7 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','900','3899','77','7 NIGHTS','Bali','<p>\r\n	<span>Award winning Adults-Only villa resort with a gorgeous setting on the white sands of Pakweep Beach.</span></p>\r\n<p>\r\n	<span>This property is 3 minutes walk from the beach. This luxurious resort enjoys a prime beachfront location and only a short drive to many popular attractions. Beyond Resort provides elegant villas, an outdoor pool, and a fitness center.</span></p>\r\n<p>\r\n	<span>Nestled away in a jungle landscape, the villas have an air of privacy and seclusion, and excursions to nearby islands or the extensive national parklands of Khaolak can be arranged.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Full Breakfast</li>\r\n	<li>\r\n		Return Airport Transfers from Phuket International Airport</li>\r\n	<li>\r\n		2 x Dinners per person per stay</li>\r\n	<li>\r\n		14 credit-vouchers (30 Mins) Thai Massage per room for 2 persons</li>\r\n	<li>\r\n		1 Mini Thai Cooking Class per person</li>\r\n	<li>\r\n		1 Invite to Management Cocktail per person</li>\r\n	<li>\r\n		45 Minutes of Thai Lesson with 1 Mai Tai Cocktail per person</li>\r\n	<li>\r\n		Free Wi-Fi, Free&nbsp;In&nbsp;room&nbsp;refreshments, Discount&nbsp;with&nbsp;10%&nbsp;discount&nbsp;on&nbsp;Food and Beverages&nbsp;and&nbsp;20%&nbsp;discount&nbsp;on&nbsp;Spa&nbsp;treatments</li>\r\n	<li>\r\n		Free cancellations permitted outside 21 days from travel</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays 1 October 2017 until 31 October 2018.</span></p>\r\n<p>\r\n	<span>This package is valid for two adults (18 years and over). No children are permitted at the resort</span></p>\r\n<p>\r\n	<span>Strictly subject to availability.</span></p>\r\n','','main_image-2017-09-25-15-17-32.jpg','2017-10-01','2018-10-31',1881),(6,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nDaily buffet breakfast\r\nPlus Bonuses!','1899','100','100','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','','main_image-2017-09-22-14-55-02.png','2017-09-21','2017-09-21',1880),(5,1,'Maharaja Villas Seminyak','5 Nights accommodation\r\nDaily breakfast\r\nDining discounts & Bonuses!','888','1771','50','5 NIGHTS','Bali','Nestled in the heart of Seminyak Area,&nbsp; Maharaja Villas &amp; Spa Seminyak will delight you with its Private Seminyak Villas designed by renowned architect that values Balinese royal heritage.<br />\r\n<br />\r\nSwimming pool, royal garden and all necessary home comforts are available in each Villa, along with the legendary Balinese royal treatment.<br />\r\n<br />\r\nMaharaja Villas and Spa Seminyak is the place where you can explore your senses. Let us imagining for a while. From the smell of beautiful flower garden to delicious Balinese tropical fruits and meals, From the smooth sands to beautiful sunset, From the fresh air from the mountain breeze to the lush green Padi fields, From the beautiful sound of traditional music instruments to the Royal treatments, all of them are available for you to celebrate.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Breakfast Daily</li>\r\n	<li>\r\n		Return Airport Transfers</li>\r\n	<li>\r\n		1 x 60 minute massage per person per stay</li>\r\n	<li>\r\n		1 x Half Day Tour for two guests</li>\r\n	<li>\r\n		Welcome drink and fruit basket on arrival</li>\r\n	<li>\r\n		Free unlimited Wi-Fi</li>\r\n	<li>\r\n		Daily afternoon tea</li>\r\n	<li>\r\n		20% Discount on all Spa treatments during stay</li>\r\n	<li>\r\n		20% Discount on all food purchased during stay (excluding beverages)</li>\r\n	<li>\r\n		Daily shuttle service around Seminyak and Kuta areas (subject to shuttle schedule)</li>\r\n</ul>\r\n','<span>Valid for stays until 23 December 2018.</span>\r\n<p>\r\n	<span>Subject to availability.</span></p>\r\n','','main_image-2017-09-22-15-07-00.jpg','2017-09-21','2017-09-21',1879),(4,0,'Novotel Phuket Kata Avista Resort and Spa','5 Nights accommodation\r\nDaily buffet breakfast for two adults\r\nDining discounts & Bonuses!','649','100','60','5 NIGHTS','Thailand','<p class=\"Hotel_overviewLead__z_QL9\">\r\n	Novotel Phuket Kata Avista Resort and Spa overlooks the aquamarine Andaman Sea and pristine white sands of Kata Beach in Southern Phuket, Thailand. Whether you are travelling individually, or with your loved one or as a family, you will find a gloriously relaxing and tranquil beach getaway experience in our spa resort.<br />\r\n	<br />\r\n	Chill, indulge and enjoy our celebrated spa, two generous meandering swimming pools, five star amenities and the magical views from your private balconies.</p>\r\n<div>\r\n	<p>\r\n		<span>This resort is a 5 minutes walk from the beach. Located on Kata Beach, Novotel Phuket Kata Avista Resort and Spa is set among green hills and offers sweeping sea views. The luxurious accommodation features spacious rooms with a balcony or terrace.</span></p>\r\n	<p>\r\n		<span>Guests can enjoy a massage and body treatment at Sukko Spa or have a relaxing swim in the infinity pool. Kids can play at the Kids Club while adults take it easy at the putting green or go on a hiking adventure.</span></p>\r\n	<p>\r\n		<span>Fresh seafood, Thai, Asian and international dishes are served at the Avista&#39;s cafe. An extensive beverage list is available at the Wine Lounge. Room service and a breakfast buffet are offered.</span></p>\r\n</div>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights accommodation<br />\r\n&bull; Every room offers private balcony<br />\r\n&bull; Welcome drink<br />\r\n&bull; Free Wi-Fi<br />\r\n&bull; 10% discount at hotel restaurant and bar and 15% discount for all spa treatments<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; 1 x Thai-set Dinner for two adults (one evening of stay)','<strong>Travel Dates:</strong><br />\r\n<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n<br />\r\n<strong>High Season Surcharges:</strong><br />\r\n','','main_image-2017-09-29-09-52-34.jpg','2017-09-21','2017-09-21',1878),(3,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nBuffet breakfast daily\r\nPlus Bonuses!','1899','xxxx','xx','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','','main_image-2017-09-21-13-13-23.png','2017-09-21','2017-09-21',1877),(2,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nDaily buffet breakfast\r\nPlus Bonuses!','1899','100','100','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','<p class=\"title\">\r\n	Need extra nights?</p>\r\nVoucher is for a consecutive stay of 3, 5 or 7 Nights. Please note: extra nights are subject to availability until confirmation of your voucher. Extra nights may be arranged by contacting email or calling <a href=\"tel:1300886779\">1300 886 779</a>.<br />\r\n<br />\r\n<strong>How to Redeem</strong><br />\r\n<ul>\r\n	<li>\r\n		Can travel to: 15 Dec 2017</li>\r\n	<li>\r\n		Must book by: 30 Sep 2017</li>\r\n	<li>\r\n		Purchase your voucher and book online via <a href=\"http://globalexplorer.com.au\">globalexplorer.com.au</a></li>\r\n	<li>\r\n		If you received your voucher as a gift, sign in or register for an account then click on the &#39;BOOK A GIFT&#39; button</li>\r\n	<li>\r\n		Select date of booking and enter details</li>\r\n	<li>\r\n		You&#39;ll receive an email to confirm reservation details</li>\r\n</ul>\r\n','main_image-2017-09-22-14-55-02.png','2017-09-21','2017-09-21',1875),(1,0,'9 Nights Paradise in Thailand','1 Night in Phuket\r\n8 Nights at Paradise Koh Yao\r\nAirport + Flights & Transfers','4999','1000','40','12 Nights','Thailand','The Experience','What you get','Booking Info','<p class=\"title\">\r\n	Need extra nights?</p>\r\nVoucher is for a consecutive stay of 3, 5 or 7 Nights. Please note: extra nights are subject to availability until confirmation of your voucher. Extra nights may be arranged.<br />\r\n<br />\r\n<strong>How to Redeem</strong><br />\r\n<ul>\r\n	<li>\r\n		Can travel to: 15 Dec 2017</li>\r\n	<li>\r\n		Must book by: 30 Sep 2017</li>\r\n	<li>\r\n		Purchase your voucher and book online via <a href=\"http://globalexplorer.com.au\">globalexplorer.com.au</a></li>\r\n	<li>\r\n		If you received your voucher as a gift, sign in or register for an account then click on the &#39;BOOK A GIFT&#39; button</li>\r\n	<li>\r\n		Select date of booking and enter details</li>\r\n	<li>\r\n		You&#39;ll receive an email to confirm reservation details</li>\r\n</ul>\r\n','','2017-09-13','2017-09-30',1869);

--
-- Table structure for table `promotionhotdeal`
--

CREATE TABLE `promotionhotdeal` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_1` varchar(200) NOT NULL,
  `offer_2` varchar(200) NOT NULL,
  `terms` varchar(200) NOT NULL,
  `terms_conditions` text NOT NULL,
  `image_text` varchar(200) NOT NULL,
  `from_price` varchar(20) NOT NULL,
  `from_price_type` enum('Night','Person','Room') NOT NULL DEFAULT 'Night',
  `value` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bullet_1` text NOT NULL,
  `bullet_2` text NOT NULL,
  `bullet_3` text NOT NULL,
  `travel_start_dt` date NOT NULL,
  `travel_end_dt` date NOT NULL,
  `large_tile` enum('Yes','No') NOT NULL DEFAULT 'No',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2123 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionhotdeal`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionhotdeal` VALUES (2122,'7 Nights','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only), Bottle of sparkling wine on arrival & a midday check out (Subject to availability)','Travel between 11 August 2020 to 13 June 2021 (subject to availability)<p>','1. This special is available for purchase until 5.00pm (AEST) Tuesday 25 August 2020.<br />\r\n2. Valid for travel from 11 August 2020 to 13 June 2021. Low season travel dates: 11 Aug - 09 Sep, 11 Oct - 22 Dec 20, 07 Jan - 01 Apr, 06 Apr - 13 Jun 2021. Surcharges apply for High season travel dates: 23 Dec 2020 - 06 Jan 2021.<br />\r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 &amp; 02 - 05 Apr 2021.<br />\r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.<br />\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.<br />\r\n6. A voucher will be sent to you by email on confirmation of payment.<br />\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view &amp; 4 people in a 2 Bedroom LUXE Pool Deck.<br />\r\n8. Maximum room capacity is 4 people.<br />\r\n9. Extra nights may be purchased at time of booking.<br />\r\n10. Full payment is required at time of booking.<br />\r\n11. Changes are permitted up to 33 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.<br />\r\n12. Cancellations are permitted up to 33 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.<br />\r\n13. We recommend taking out a travel insurance policy at the point of booking.<br />\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.<br />\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.<br />\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n17. A 2.5% booking fee applies','','1279.00','Night',3986.00,'<span style=\"color:#0000ff;\"><strong>Includes:&nbsp;</strong></span><br />\r\n* Bottle of sparkling wine on arrival&nbsp;<br />\r\n* Midday check out (Subject to availability)&nbsp;<br />\r\n* 1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)&nbsp;','Located on the corner of the Esplanade and Mowbray Streets and offers spacious fully self-contained apartments for guests wanting a beachside holiday location.','Located right on Four Mile Beach at Port Douglas','2020-08-11','2021-06-13','No',21946),(2121,'2 Nights ','Whale Watch Tour Discount, Bottle of Wine & Whale Watching Gift Pack!','Valid for travel up to 11 October 2020','1. Book by 5:00pm (AEST) Wed 30 Sep 2020.<br />\r\n2. Valid for travel: 03/08/2020-11/10/2020.&nbsp;&nbsp;<br />\r\n3. Subject to availability at time of booking.<br />\r\n4. 2 night minimum stay applies.<br />\r\n5. Surcharge applies Fri &amp; Sat nights.<br />\r\n6. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n7. A 2.5% booking fee applies.','','117.00','Night',139.00,'<span style=\"color: rgb(0, 0, 255);\"><strong>WHALE WATCH PACKAGE INCLUDES:&nbsp;</strong></span><br />\r\n* <strong>10% discount off a Whale Watching tour</strong>&nbsp;<em>(with Mantra&#39;s preferred tour operator.)<br />\r\n*&nbsp;</em>A <strong>Bottle of Wine </strong>on Arrival!<br />\r\n* A <strong>Whale Watching Gift Pack</strong>!<br />\r\n<br />\r\n','Stunning Marina Views&nbsp;<br />\r\n<br />\r\n','Located close to Hervey Bay&#39;s Esplanade&nbsp;<br />\r\n<br />\r\n','2020-08-03','2020-10-11','No',21945),(2120,'2 Nights ','Whale Watch Tour Discount, Bottle of Wine & Whale Watching Gift Pack!','Valid for travel up to 11 October 2020','1. Book by 5:00pm (AEST) Wed 30 Sep 2020.<br />\r\n2. Valid for travel: 03/08/2020-11/10/2020.&nbsp;&nbsp;<br />\r\n3. Subject to availability at time of booking.<br />\r\n4. 2 night minimum stay applies.<br />\r\n5. Surcharge applies Fri &amp; Sat nights.<br />\r\n6. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n7. A 2.5% booking fee applies.','','117.00','Night',139.00,'<strong style=\"color: rgb(0, 0, 255);\">WHALE WATCH PACKAGE INCLUDES:&nbsp;</strong><br />\r\n* <strong>10% discount off a Whale Watching Tour</strong> <em>(with Mantra&#39;s preferred tour operator.)<br />\r\n*&nbsp;</em>A <strong>Bottle of Wine</strong> on Arrival!<br />\r\n* A <strong>Whale Watching Gift Pack</strong>!<br />\r\n','Stunning Marina Views&nbsp;<br />\r\n','Located close to Hervey Bay&#39;s Esplanade&nbsp;<br />\r\n','2020-08-03','2020-10-11','No',21944),(2119,'1 Night','Unlimited Entry to Sea World, Movie World, Wet\'n\'Wild & Paradise Country, Free Breakfast for 4 + More!','Travel between 6 August - 11 December 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 11 December 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.</div>\r\n<div>\r\n	3. Full payment required at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Dates may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 4 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission which is payable direct to Sea World Resort.<br />\r\n	8.&nbsp;A two night minimum stay may apply on some dates.</div>\r\n<div>\r\n	9. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	10. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','236','Night',1063.00,'<strong><span>&middot; </span>Unlimited Entry to&nbsp;Sea World, Movie World, Wet&#39;n&#39;Wild &amp; Paradise Country<br />\r\n<span>&middot;&nbsp;</span>Grab &#39;n&#39; Go Breakfast</strong> for 4 people daily&nbsp;<br />\r\n<strong><span>&middot; </span>Bottle of Wine</strong>&nbsp;on Arrival<br />\r\n','<strong><span>&middot; </span>School Holidays Availability</strong>&nbsp;during September/October for $75 surcharge per night<br />\r\n<strong><span>&middot; </span>Flexible Booking Conditions </strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;<br />\r\n<br />\r\n','Travelling with more than 4 people? Please call us for details.','2020-08-06','2020-12-11','Yes',21943),(2118,'1 Night','Unlimited Entry to Sea World, Movie World, Wet\'n\'Wild & Paradise Country, Free Breakfast for 4 + More!','Travel between 6 August - 11 December 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 11 December 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.</div>\r\n<div>\r\n	3. Full payment required at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Dates may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 4 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission which is payable direct to Sea World Resort.<br />\r\n	8.&nbsp;A two night minimum stay may apply on some dates.</div>\r\n<div>\r\n	9. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	10. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','259','Night',1063.00,'<strong><span>&middot; </span>Unlimited Entry to&nbsp;Sea World, Movie World, Wet&#39;n&#39;Wild &amp; Paradise Country</strong><br />\r\n<strong>&middot; Includes 4 Guests!&nbsp;</strong><br />\r\n<strong><span>&middot;&nbsp;</span>Grab &#39;n&#39; Go Breakfast</strong> for 4 people daily&nbsp;<br />\r\n<strong><span>&middot; </span>Bottle of Wine</strong>&nbsp;on Arrival<br />\r\n<br />\r\n','<strong><span>&middot; </span>School Holidays Availability</strong>&nbsp;during September/October for $75 surcharge per night<br />\r\n<strong><span>&middot; </span>Flexible Booking Conditions -</strong> cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;<br />\r\n<br />\r\n','Travelling with more than 4 people? Please call us for details.','2020-08-06','2020-12-11','Yes',21942),(2117,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020 (Studios not available).</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a Studio or 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom or 8 people in a 4 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','122','Night',200.00,'Perfectly situated on the beachfront at the southern end of Palm Cove with direct beach access\r\n<p>\r\n</p>\r\n','<p>\r\n	<span style=\"color: rgb(255, 0, 0);\">Stay 4 Pay 3, Swim-Out, Penthouse &amp; High Season discounts also available - please enquire for details.</span></p>\r\n','<br />\r\n<p>\r\n</p>\r\n','2020-08-04','2020-10-15','No',21939),(2116,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020 (Studios not available).</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a Studio or 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom or 8 people in a 4 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','143','Night',200.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly situated on the beachfront at the southern end of Palm Cove with direct beach access','<span style=\"color:#ff0000;\">Stay 4 Pay 3, Swim-Out, Penthouse &amp; High Season discounts also available - please enquire for details.</span>','2020-08-04','2020-10-15','Yes',21938),(2115,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','250','Night',410.00,'Perfectly located on the secluded beachfront of Four Mile Beach and only a short distance from the heart of Port Douglas.','<p>\r\n	<span style=\"color: rgb(255, 0, 0);\">Stay 4 Pay 3, Swim-Out, Plunge Pool, Penthouse &amp; High Season discounts also available - please enquire for details.</span></p>\r\n','<br />\r\n<p>\r\n</p>\r\n','2020-08-04','2020-10-15','No',21937),(2114,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','293','Night',410.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly located on the secluded beachfront of Four Mile Beach and only a short distance from the heart of Port Douglas.','<span style=\"color:#ff0000;\">Stay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available - please enquire for details.</span>','2020-08-04','2020-10-15','Yes',21936),(2113,'1 Night','Includes Admission to Sea World & Paradise Country','Travel between 1 August - 31 August 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 31 August 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights.&nbsp;</div>\r\n<div>\r\n	3. Payment required in full by credit card at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Date may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 2 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. Extra person rate is $25 per person including theme park admission.</div>\r\n<div>\r\n	8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.</div>\r\n<div>\r\n	9. A 2 night minimum stay may apply on some dates.</div>\r\n<div>\r\n	10. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	11. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','136','Night',551.00,'<strong>&middot;&nbsp;Unlimited Entry to Sea World &amp; Paradise Country<br />\r\n&middot; Welcome Gift Pack on Arrival</strong>&nbsp;','<strong>&middot;&nbsp;Flexible Booking Conditions&nbsp;</strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong>&middot;&nbsp;Stay Over a Saturday</strong>&nbsp;for only $30 surcharge&nbsp;','','2020-08-01','2020-08-31','Yes',21935),(2112,'1 Night','Includes Admission to Sea World & Paradise Country','Travel between 1 August - 31 August 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 31 August 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights.&nbsp;</div>\r\n<div>\r\n	3. Payment required in full by credit card at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Date may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 2 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. Extra person rate is $25 per person including theme park admission.</div>\r\n<div>\r\n	8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.</div>\r\n<div>\r\n	9. A 2 night minimum stay may apply on some dates.</div>\r\n<div>\r\n	10. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	11. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','149','Night',551.00,'<strong><span>&middot; </span>Unlimited Entry to Sea World &amp; Paradise Country<br />\r\n<span>&middot; Welcome Gift Pack on Arrival</span></strong>&nbsp;<br />\r\n<br />\r\n<br />\r\n','<strong><span>&middot; </span>Flexible Booking Conditions </strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;','','2020-08-01','2020-08-31','Yes',21933),(2111,'3 Nights','Absolute Beachfront with Stunning Views','Valid for travel up to 17 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 19/07/2020-30/07/2020, 03/08/2020-18/09/2020, 11/10/2020-15/10/2020, 19/10/2020-29/10/2020, 02/11/2020-11/12/2020, 27/01/2021-11/02/2021, 14/02/2021-03/03/2021, 08/03/2021-25/03/2021, 29/03/2021-01/04/2021, 18/04/2021-17/06/2021, 21/06/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 2 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','126','Night',149.00,'Relaxing, beachfront tropical style resort on the stunning Northern NSW Coast.','<p>\r\n	Fantastic range of family activities including outdoor rock pool with slide, children&#39;s pool and mini putt putt golf.</p>\r\n','','2020-07-19','2021-09-17','No',21929),(2110,'3 Nights','Located right opposite the beach','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-01/10/2020, 05/10/2020-22/10/2020, 24/10/2020-17/12/2020, 01/02/2021-01/04/2021, 06/04/2021-22/04/2021, 26/04/2021-14/05/2021, 16/05/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','141','Night',221.00,'Located in the beautiful beachside town of Ettalong and right opposite the beach','Resort style Pool, Spa, Ettalong Diggers Gym &amp; Swim, Advanced Skin Spa','','2020-07-19','2021-09-30','No',21928),(2109,'3 Nights','Featuring stunning ocean and river views','Valid for travel up to 16 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 20/07/2020-23/07/2020, 27/07/2020-10/09/2020, 15/09/2020-24/09/2020, 12/10/2020-17/12/2020, 01/02/2021-17/02/2021, 22/02/2021-31/03/2021, 19/04/2021-22/04/2021, 27/04/2021-30/04/2021, 03/05/2021-05/05/2021, 11/05/2021-10/06/2021, 14/06/2021-24/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Fri &amp; Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','141','Night',229.00,'Featuring stunning ocean and river views and winner of multiple tourism awards','<p>\r\n	Positioned across the road from Port Macquarie&rsquo;s main beach and just 400 metres from the town centre</p>\r\n','<p>\r\n	Indoor Heated Pool &amp; Spa, Sauna, Barbecue Area &amp; Bike Hire</p>\r\n','2020-07-19','2021-09-16','No',21927),(2108,'3 Nights','Relaxing Beachside Escape','Valid for travel up to 17 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 24/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','132','Night',175.00,'Central location in Salt Village on the beachfront<br />\r\n<p>\r\n</p>\r\n','<p>\r\n	Close to Salt Village restaurants and bars</p>\r\n','Large Lagoon Style Pool, Children&#39;s Wading Pool, Tennis Courts, Spa &amp; Bike Hire','2020-07-22','2021-09-17','No',21926),(2107,'3 Nights','Gorgeous Coral Sea Views','Valid for travel up to 18 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-16/07/2020, 26/07/2020-05/08/2020, 23/08/2020-27/08/2020, 31/08/2020-02/09/2020, 08/09/2020-18/09/2020, 11/10/2020-04/11/2020, 08/11/2020-20/11/2020, 29/11/2020-18/12/2020, 10/01/2021-01/04/2021, 07/04/2021-25/06/2021, 11/07/2021-08/08/2021, 22/08/2021-18/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','209','Night',293.00,'','Perfectly situated right on the Port of Airlie Marina\r\n<p>\r\n</p>\r\n','Facilities include swimming pool and sundeck, tennis court, barbeque area plus children&rsquo;s playground','2020-07-22','2021-09-18','No',21925),(2106,'3 Nights','5 Star Island Escape','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-26/08/2020, 03/09/2020-24/12/2020, 05/01/2021-01/04/2021, 06/04/2021-02/09/2021, 09/09/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',295.00,'','Elegantly laid out at the water&rsquo;s edge overlooking the Coral Sea and private marina\r\n<p>\r\n</p>\r\n','Two Swimming Pools, Bike Hire, Restaurant, Day Spa &amp; WiFi','2020-07-22','2021-09-30','No',21924),(2105,'3 Nights','Luxury in Tropical Palm Cove ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','212','Night',387.00,'','Iconic North Queensland resort, with lush green gardens, a rainforest rock pool and lagoon pool with sandy beaches\r\n<p>\r\n</p>\r\n','Day Spa, Lime &amp; Pepper Restaurant, Tennis Club House with Gym Facilities','2020-07-22','2021-09-30','No',21923),(2104,'3 Nights','Right in the heart of Cairns CBD','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',260.00,'','Located right on Cairns Esplanade overlooking the waterfront\r\n<p>\r\n</p>\r\n','Relax on the pool deck, cook up a barbeque or have an invigorating workout at the gym.','2020-07-22','2021-09-30','No',21922),(2103,'3 Nights','Fantastic Resort Facilities','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',189.00,'','Explore the nearby Daintree Rainforest or take a boat ride out to the magnificent Great Barrier Reef\r\n<p>\r\n</p>\r\n','Lagoon Pool, Plunge Pool, Tennis Courts, Waterslide, Fitness Room, Barbecue Area','2020-07-22','2021-09-30','No',21921),(2102,'3 Nights','Perfect for Couples & Families','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','136','Night',189.00,'','Located in the heart of Port Douglas close to restaurants &amp; cafes\r\n<p>\r\n</p>\r\n','4 Outdoor Lagoon Pools, Spas, Barbecue Area','2020-07-22','2021-09-30','No',21920),(2101,'3 Nights','Tropical Waterfront Getaway ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',235.00,'','Waterfront resort with gorgeous lagoon-style pool, spa and restaurant\r\n<p>\r\n</p>\r\n','Close to The Esplanade with its range of restaurants, bars and bistros','2020-07-22','2021-09-30','No',21919),(2100,'3 Nights','Lavish Hotel in the heart of Surfers Paradise ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','128','Night',195.00,'','<p>\r\n	Luxury Resort in the heart of Surfers Paradise</p>\r\n','Enjoy a great location near the Iconic Beaches&nbsp;','2020-07-22','2021-09-17','No',21918),(2099,'3 Nights','Hervey Bay\'s only absolute waterfront resort','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-17/09/2020, 11/10/2020-17/12/2020, 10/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-06/07/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','87','Night',119.00,'','<p>\r\n	Hervey Bay&#39;s only absolute waterfront resort located right next to the marina and beach</p>\r\n','Enjoy uninterrupted ocean or marina views from your balcony or patio','2020-07-22','2021-09-17','No',21917),(2098,'3 Nights ','Right on the Esplanade','Valid for travel up to 23 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-11/09/2020, 14/09/2020-24/09/2020, 11/10/2020-17/12/2020, 10/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-23/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',210.00,'','<p>\r\n	Luxury Beachfront Getaway right on Mooloolaba Esplanade</p>\r\n','<p>\r\n	Facilities include an observation deck, outdoor pool, indoor heated pool, spa and gym</p>\r\n','2020-07-06','2021-09-23','No',21916),(2097,'3 Nights ','Noosa Escape on Hastings St','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-03/08/2020, 17/08/2020-02/09/2020, 06/09/2020-10/09/2020, 15/09/2020-17/09/2020, 25/10/2020-29/10/2020, 02/11/2020-04/11/2020, 09/11/2020-19/11/2020, 24/11/2020-04/12/2020, 24/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-13/05/2021, 17/05/2021-25/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','158','Night',261.00,'','<p>\r\n	Conveniently Located for a Relaxing Family Getaway!</p>\r\n','<p>\r\n	Heated Lagoon Pool, Children&#39;s Wading Pool, Heated Spas, Barbecue Area &amp; Complimentary Parking</p>\r\n','2020-07-06','2021-09-16','No',21915),(2096,'3 Nights ','Close to Family Friendly Restaurants & Cafes','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 17/08/2020-10/09/2020, 11/10/2020-29/10/2020, 03/11/2020-10/12/2020, 24/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','108','Night',181.00,'','<p>\r\n	Perfectly positioned directly opposite a patrolled beach &amp; just metres from family friendly restaurants &amp; cafes.</p>\r\n','<p>\r\n	<span style=\"font-size: 16px;\">Two heated tropical lagoon pools &amp; spas, kids waterslide, gymnasium, children&#39;s playground &amp; barbeque area.</span></p>\r\n','2020-07-06','2021-09-16','No',21914),(2095,'3 Nights ','Luxury in the Heart of Surfers Paradise','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 29/08/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','249','Night',308.00,'','<p>\r\n	Stay Connected to Loved Ones with WiFi</p>\r\n','<p>\r\n	Enjoy Free Parking &amp; Daily Servicing</p>\r\n','2020-07-06','2021-09-17','No',21913),(2094,'3 Nights ','5 Star Broadbeach Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','167','Night',255.00,'','<p>\r\n	Located in the heart of Broadbeach surrounded by restaurants&nbsp;</p>\r\n','<p>\r\n	Resort facilities include Tai Chi lawn, Zen Gardens, Teppanyaki Barbecue, Heated Pool, Spa &amp; more!</p>\r\n','2020-07-06','2021-09-17','No',21912),(2093,'3 Nights ','Amazing Broadbeach Family Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','128','Night',209.00,'','<p>\r\n	Popular resort for families in a relaxed, friendly atmosphere</p>\r\n','<p>\r\n	Kids will love the two large lagoon pools, wading pool, shaded playground and games room</p>\r\n','2020-07-06','2021-09-17','No',21911),(2092,'3 Nights ','Studio, 1 & 2 Bedroom Ocean Apartments','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-11/12/2020, 24/01/2021-16/03/2021, 28/03/2021-01/04/2021, 18/04/2021-23/04/2021, 03/05/2021-09/06/2021, 14/06/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','146','Night',248.00,'','<p>\r\n	Beachfront Coolangatta Resort</p>\r\n','Swimming Pool, Spa, Sauna, Tennis Courts, Gym &amp; Barbecue Area','2020-07-06','2021-09-17','No',21910),(2091,'3 Nights ','Great Value Gold Coast Escape','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',225.00,'','<p>\r\n	Iconic Surfers Paradise Beach just across the road</p>\r\n','<p>\r\n	Easy walking distance to shops, restaurants and famous Cavill Avenue</p>\r\n','2020-07-06','2021-09-17','No',21909),(2090,'3 Nights ','Amazing Ocean Views! ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',215.00,'','<p>\r\n	Spectacular location across the road from the beach</p>\r\n','<p>\r\n	Resort facilities include indoor and outdoor heated pools, tennis court, spa and sauna</p>\r\n','2020-07-06','2021-09-17','No',21908),(2089,'3 Nights','Located right opposite the beach','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-01/10/2020, 05/10/2020-22/10/2020, 24/10/2020-17/12/2020, 01/02/2021-01/04/2021, 06/04/2021-22/04/2021, 26/04/2021-14/05/2021, 16/05/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','149','Night',221.00,'Located in the beautiful beachside town of Ettalong and right opposite the beach','Resort style Pool, Spa, Ettalong Diggers Gym &amp; Swim, Advanced Skin Spa','','2020-07-19','2021-09-30','No',21905),(2088,'3 Nights','Featuring stunning ocean and river views','Valid for travel up to 16 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 20/07/2020-23/07/2020, 27/07/2020-10/09/2020, 15/09/2020-24/09/2020, 12/10/2020-17/12/2020, 01/02/2021-17/02/2021, 22/02/2021-31/03/2021, 19/04/2021-22/04/2021, 27/04/2021-30/04/2021, 03/05/2021-05/05/2021, 11/05/2021-10/06/2021, 14/06/2021-24/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Fri &amp; Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','149','Night',229.00,'Featuring stunning ocean and river views and winner of multiple tourism awards','<p>\r\n	Positioned across the road from Port Macquarie&rsquo;s main beach and just 400 metres from the town centre</p>\r\n','<p>\r\n	Indoor Heated Pool &amp; Spa, Sauna, Barbecue Area &amp; Bike Hire</p>\r\n','2020-07-19','2021-09-16','No',21904),(2087,'3 Nights','Relaxing Beachside Escape','Valid for travel up to 17 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 24/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','140','Night',175.00,'Central location in Salt Village on the beachfront<br />\r\n<p>\r\n</p>\r\n','<p>\r\n	Close to Salt Village restaurants and bars</p>\r\n','Large Lagoon Style Pool, Children&#39;s Wading Pool, Tennis Courts, Spa &amp; Bike Hire','2020-07-22','2021-09-17','No',21903),(2086,'3 Nights','Gorgeous Coral Sea Views','Valid for travel up to 18 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-16/07/2020, 26/07/2020-05/08/2020, 23/08/2020-27/08/2020, 31/08/2020-02/09/2020, 08/09/2020-18/09/2020, 11/10/2020-04/11/2020, 08/11/2020-20/11/2020, 29/11/2020-18/12/2020, 10/01/2021-01/04/2021, 07/04/2021-25/06/2021, 11/07/2021-08/08/2021, 22/08/2021-18/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','229','Night',293.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Perfectly situated right on the Port of Airlie Marina\r\n<p>\r\n</p>\r\n','Facilities include swimming pool and sundeck, tennis court, barbeque area plus children&rsquo;s playground','2020-07-22','2021-09-18','No',21902),(2085,'3 Nights','5 Star Island Escape','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-26/08/2020, 03/09/2020-24/12/2020, 05/01/2021-01/04/2021, 06/04/2021-02/09/2021, 09/09/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','233','Night',295.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Elegantly laid out at the water&rsquo;s edge overlooking the Coral Sea and private marina\r\n<p>\r\n</p>\r\n','Two Swimming Pools, Bike Hire, Restaurant, Day Spa &amp; WiFi','2020-07-22','2021-09-30','No',21901),(2084,'3 Nights','Luxury in Tropical Palm Cove ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','233','Night',387.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Iconic North Queensland resort, with lush green gardens, a rainforest rock pool and lagoon pool with sandy beaches\r\n<p>\r\n</p>\r\n','Day Spa, Lime &amp; Pepper Restaurant, Tennis Club House with Gym Facilities','2020-07-22','2021-09-30','No',21900),(2083,'3 Nights','Right in the heart of Cairns CBD','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',260.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Located right on Cairns Esplanade overlooking the waterfront\r\n<p>\r\n</p>\r\n','Relax on the pool deck, cook up a barbeque or have an invigorating workout at the gym.','2020-07-22','2021-09-30','No',21899),(2082,'3 Nights','Fantastic Resort Facilities','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',189.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Explore the nearby Daintree Rainforest or take a boat ride out to the magnificent Great Barrier Reef\r\n<p>\r\n</p>\r\n','Lagoon Pool, Plunge Pool, Tennis Courts, Waterslide, Fitness Room, Barbecue Area','2020-07-22','2021-09-30','No',21898),(2081,'3 Nights','Perfect for Couples & Families','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','150','Night',189.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Located in the heart of Port Douglas close to restaurants &amp; cafes\r\n<p>\r\n</p>\r\n','4 Outdoor Lagoon Pools, Spas, Barbecue Area','2020-07-22','2021-09-30','No',21897),(2080,'3 Nights','Tropical Waterfront Getaway ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',235.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Waterfront resort with gorgeous lagoon-style pool, spa and restaurant\r\n<p>\r\n</p>\r\n','Close to The Esplanade with its range of restaurants, bars and bistros','2020-07-22','2021-09-30','No',21896),(2079,'3 Nights','Hervey Bay\'s only absolute waterfront resort','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-17/09/2020, 11/10/2020-17/12/2020, 10/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-06/07/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','95','Night',119.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card (valued at $199)&nbsp;&amp; enjoy up to 50% off dining, attractions, gift cards, movie tickets &amp; more including:<br />\r\n<p>\r\n	- 20% Off Reef World Admission&nbsp;<br />\r\n	- 10% Off Whale Watching&nbsp;<br />\r\n	- 10% Off Half Day Fraser Island Beach &amp; BBQ Cruise&nbsp;</p>\r\n','Hervey Bay&#39;s only absolute waterfront resort located right next to the marina and beach\r\n<p>\r\n</p>\r\n','Enjoy uninterrupted ocean or marina views from your balcony or patio','2020-07-22','2021-09-17','No',21895),(2078,'3 Nights ','Right on the Esplanade','Valid for travel up to 23 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-11/09/2020, 14/09/2020-24/09/2020, 11/10/2020-17/12/2020, 10/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-23/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',210.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Luxury Beachfront Getaway right on Mooloolaba Esplanade</p>\r\n','<p>\r\n	Facilities include an observation deck, outdoor pool, indoor heated pool, spa and gym</p>\r\n','2020-07-06','2021-09-23','No',21894),(2077,'3 Nights ','Noosa Escape on Hastings St','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-03/08/2020, 17/08/2020-02/09/2020, 06/09/2020-10/09/2020, 15/09/2020-17/09/2020, 25/10/2020-29/10/2020, 02/11/2020-04/11/2020, 09/11/2020-19/11/2020, 24/11/2020-04/12/2020, 24/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-13/05/2021, 17/05/2021-25/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','173','Night',261.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Conveniently Located for a Relaxing Family Getaway!</p>\r\n','<p>\r\n	Heated Lagoon Pool, Children&#39;s Wading Pool, Heated Spas, Barbecue Area &amp; Complimentary Parking</p>\r\n','2020-07-06','2021-09-16','No',21893),(2076,'3 Nights ','Close to Family Friendly Restaurants & Cafes','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 17/08/2020-10/09/2020, 11/10/2020-29/10/2020, 03/11/2020-10/12/2020, 24/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','119','Night',181.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly positioned directly opposite a patrolled beach &amp; just metres from family friendly restaurants &amp; cafes.\r\n','<span style=\"font-size: 16px;\">Two heated tropical lagoon pools &amp; spas, kids waterslide, gymnasium, children&#39;s playground &amp; barbeque area.</span>\r\n','2020-07-06','2021-09-16','No',21892),(2075,'3 Nights ','Luxury in the Heart of Surfers Paradise','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 29/08/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','273','Night',308.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Stay Connected to Loved Ones with WiFi</p>\r\n','<p>\r\n	Enjoy Free Parking &amp; Daily Servicing</p>\r\n','2020-07-06','2021-09-17','No',21891),(2074,'3 Nights ','5 Star Broadbeach Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','183','Night',255.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Located in the heart of Broadbeach surrounded by restaurants&nbsp;</p>\r\n','<p>\r\n	Resort facilities include Tai Chi lawn, Zen Gardens, Teppanyaki Barbecue, Heated Pool, Spa &amp; more!</p>\r\n','2020-07-06','2021-09-17','No',21890),(2073,'3 Nights ','Amazing Broadbeach Family Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','140','Night',209.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Popular resort for families in a relaxed, friendly atmosphere</p>\r\n','<p>\r\n	Kids will love the two large lagoon pools, wading pool, shaded playground and games room</p>\r\n','2020-07-06','2021-09-17','No',21889);

--
-- Table structure for table `promotionhotdealrates`
--

CREATE TABLE `promotionhotdealrates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `RoomIntro` text NOT NULL,
  `room_id` int(10) NOT NULL DEFAULT '0',
  `num_nights` varchar(200) NOT NULL DEFAULT '0',
  `normally` decimal(10,2) NOT NULL DEFAULT '0.00',
  `you_pay` decimal(10,2) NOT NULL DEFAULT '0.00',
  `action` enum('Enquire','Book After Hours','Book Only','Book and Enquire') NOT NULL DEFAULT 'Enquire',
  `property_id` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22536 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionhotdealrates`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionhotdealrates` VALUES (22535,'',66735,'7',4060.00,2169.00,'Enquire',9392,21946),(22534,'',66733,'7',4100.00,1599.00,'Enquire',9392,21946),(22533,'',66734,'7',3946.00,1999.00,'Enquire',9392,21946),(22532,'',66732,'7',3986.00,1439.00,'Enquire',9392,21946),(22531,'',44216,'2',474.00,396.00,'Enquire',3022,21945),(22530,'',44215,'2',354.00,277.00,'Enquire',3022,21945),(22529,'',44214,'2',306.00,250.00,'Enquire',3022,21945),(22528,'',44213,'2',277.00,213.00,'Enquire',3022,21945),(22506,'',44216,'2',474.00,434.00,'Enquire',3022,21944),(22505,'',44215,'2',354.00,304.00,'Enquire',3022,21944),(22504,'',44214,'2',306.00,274.00,'Enquire',3022,21944),(22503,'',44213,'2',277.00,234.00,'Enquire',3022,21944),(22498,'',2,'2',2.00,0.00,'Enquire',2,21943),(22497,'',2,'2',2.00,0.00,'Enquire',2,21943),(22496,'',0,'B',0.00,0.00,'Enquire',0,21943),(22495,'',3,'3',3.00,0.00,'Enquire',3,21943),(22494,'',1,'1',1.00,0.00,'Enquire',1,21943),(22493,'',1,'1',1.00,0.00,'Enquire',1,21943),(22492,'',6,'6',6.00,0.00,'Enquire',6,21943),(22491,'',0,'',0.00,0.00,'Enquire',0,21943),(22490,'',2,'2',2.00,0.00,'Enquire',2,21943),(22489,'',66663,'1',1138.00,334.00,'Book and Enquire',254,21942),(22488,'',66662,'1',1113.00,309.00,'Book and Enquire',254,21942),(22487,'',66661,'1',1113.00,309.00,'Book and Enquire',254,21942),(22486,'',66660,'1',1088.00,284.00,'Book and Enquire',254,21942),(22485,'',66659,'1',1088.00,284.00,'Book and Enquire',254,21942),(22484,'',66658,'1',1063.00,259.00,'Book and Enquire',254,21942),(22483,'',66526,'7',1239.00,679.00,'Book and Enquire',3891,21887),(22482,'',66362,'3',675.00,399.00,'Book and Enquire',3891,21887),(22481,'',66525,'7',1239.00,679.00,'Book and Enquire',3891,21887),(22480,'',66361,'3',675.00,399.00,'Book and Enquire',3891,21887),(22479,'',44319,'Stay 7 Pay 5',3150.00,2250.00,'Enquire',115,21938),(22478,'',44315,'Stay 7 Pay 5',2730.00,1950.00,'Enquire',115,21938),(22477,'',44311,'Stay 7 Pay 5',2380.00,1700.00,'Enquire',115,21938),(22476,'',44310,'Stay 7 Pay 5',1400.00,1000.00,'Enquire',115,21938),(22471,'',44072,'Stay 7 Pay 5',4130.00,2950.00,'Enquire',114,21936),(22470,'',44068,'Stay 7 Pay 5',3430.00,2450.00,'Enquire',114,21936),(22469,'',44064,'Stay 7 Pay 5',2870.00,2050.00,'Enquire',114,21936),(22468,'',66613,'7',2751.00,2002.00,'Book and Enquire',3720,21901),(22467,'',66469,'3',1287.00,999.00,'Book and Enquire',3720,21901),(22466,'',66612,'7',2352.00,1666.00,'Book and Enquire',3720,21901),(22465,'',66468,'3',1095.00,829.00,'Book and Enquire',3720,21901),(22464,'',66611,'7',2233.00,1596.00,'Book and Enquire',3720,21901),(22463,'',66503,'3',1035.00,799.00,'Book and Enquire',3720,21901),(22462,'',66610,'7',1918.00,1400.00,'Book and Enquire',3720,21901),(22461,'',66466,'3',885.00,699.00,'Book and Enquire',3720,21901),(22460,'',66507,'7',1687.00,1400.00,'Enquire',3005,21879),(22459,'',66506,'3',699.00,675.00,'Enquire',3005,21879),(22458,'',66505,'7',1071.00,875.00,'Enquire',3005,21879),(22457,'',66631,'3',447.00,399.00,'Enquire',3005,21879);

--
-- Table structure for table `promotionmystery`
--

CREATE TABLE `promotionmystery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `content_middle` text NOT NULL,
  `content_bottom` text NOT NULL,
  `property_details` enum('Yes','No') NOT NULL DEFAULT 'No',
  `separator` int(10) NOT NULL DEFAULT '10',
  `colour` varchar(6) NOT NULL,
  `url_type` int(10) NOT NULL DEFAULT '1',
  `url_custom` varchar(200) NOT NULL,
  `image_1` varchar(200) NOT NULL,
  `image_2` varchar(200) NOT NULL,
  `input_1` text NOT NULL,
  `input_2` text NOT NULL,
  `input_3` text NOT NULL,
  `input_4` text NOT NULL,
  `input_5` text NOT NULL,
  `input_6` text NOT NULL,
  `input_7` text NOT NULL,
  `input_8` text NOT NULL,
  `input_9` text NOT NULL,
  `input_10` text NOT NULL,
  `bg_colour` varchar(6) NOT NULL,
  `padding` int(10) NOT NULL DEFAULT '0',
  `margin_btm` int(10) NOT NULL DEFAULT '0',
  `room_id` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  `block_type` int(10) NOT NULL DEFAULT '0',
  `show_on_website` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1384 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionmystery`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionmystery` VALUES (1382,'','','','No',10,'',1,'','image-1-2019-07-29-09-55-20.jpg','','','','','','','','','','','','',0,0,0,21408,2,'No',0),(1381,'','','','No',10,'',1,'','image-1-2017-02-21-13-22-27.jpg','','','','','','','','','','','','',1,1,0,1510,2,'Yes',0),(1379,'','','','No',10,'',1,'','','','2 Nights + Breakfast ','Hinterland View Room ','For 2 People (Kids 0-14 Stay Free)','Sale Price','$529','Normally $966','Save $436','200','','','ffffff',4,1,45517,1510,4,'Yes',3),(1378,'<span style=\"font-size:12px;\"><strong>Booking Terms &amp; Conditions</strong></span><br />\r\n<div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		1. This special is available for purchase until 5.00pm (AEST) Tuesday 28 February 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		2. Valid for travel from 22 February to 15 December 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		3. The travel period has black-out dates: 24 Feb, 18 - 19 Mar, 22 - 23 Mar, 10 - 18 Apr, 22 Apr, 17 May, 23 - 25 May, 9 - 10 Jun &amp; 30 Jun - 2 Jul, 18 Sep, 23 Sep, 14 Oct, 20 - 23 Oct &amp; 11 Nov 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		4. Bookings are essential and subject to availability. To book your stay call us on 1300 788 553.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		5. An email will be sent to you on confirmation of payment.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		6. The special is valid for up to 2 people in a Hinterland View Room.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		7. Maximum room capacity is 3 adults or 2 adults &amp; 2 children (0-14 years).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		8. Extra person charge is $40 per night room only or $80 per night including breakfast. Up to 2 children (0-14 years) stay free of charge using existing bedding (room only).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		9. Extra nights may be purchased at time of booking at the same per night price</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		10. Bookings are non-refundable, non-exchangeable and no cancellations or amendments under ANY circumstances. We strongly recommend taking out a travel insurance policy at the point of booking.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		11. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		12. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		13. A 2.5% booking fee applies to phone bookings only.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		14. Please note height restrictions apply to childrens use of the resort waterslide.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n	</div>\r\n</div>\r\n<p>\r\n</p>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','ffffff',0,1,0,1510,1,'Yes',12),(1373,'*Subject to availability &amp; black-out dates apply. Phone bookings attract a 2.5% booking fee. Extra person permitted for extra charge and you can purchase extra nights when booking. Refer full terms &amp; conditions below.<br />\r\n<br />\r\n<span style=\"color:#155896;\"><span style=\"font-size: 18px;\">We&#39;re here to help you find the perfect holiday!</span></span><br />\r\n<span style=\"color: #ff7f00; font-size: 22px;\">Call us 1300 788 553</span>','','','No',10,'',2,'','','','','','','','','','','','','','ffffff',3,0,0,1510,7,'Yes',5),(1372,'<p align=\"center\">\r\n	<span style=\"color:#ff8c00;\"><span style=\"font-size:24px;\"><strong>CALL US OR BOOK ONLINE NOW</strong></span><br />\r\n	<span style=\"font-size:18px;\"><strong>AND SECURE YOUR HOLIDAY DATES TODAY!</strong></span></span><br />\r\n	<br />\r\n	<span style=\"font-size:24px;\"><strong>Sale ends strictly 5pm Tuesday and is valid for travel between 22 February 2017 - 15 December 2017*</strong></span></p>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','ffffff',0,1,0,1510,1,'Yes',4),(1371,'','','','No',10,'',1,'','','','2 Nights','Hinterland View Room','For 2 People (Kids 0-14 Stay Free)','Sale Price','$449','Normally $714','Save $264','200','','','ffffff',4,1,45516,1510,4,'Yes',2),(1369,'','','','No',0,'',1,'','image-1-2017-02-21-13-00-31.jpg','','','','','','','','','','','','2371b9',1,1,45516,1510,2,'Yes',0),(1368,'<span style=\"font-size: 16px;\">Escape to one of the most popular luxury resorts on the Gold Coast with our Ultimate Mystery 5 Star Getaway! Indulge with a cocktail by the lavish lagoon pool, be pampered with a facial &amp; massage at the spa &amp; dine at the most famous restaurants in Surfers Paradise &ndash; all without leaving the resort!&nbsp;</span>\r\n<p>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:18px;color:#fa6b0e;\"><strong>This amazing offer includes:</strong></span></p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','','','No',10,'',1,'','','','<strong>2 Nights in a Spacious Hinterland View Room</strong>&nbsp;with a private balcony offering spectacular Gold Coast &amp; waterway views.&nbsp;','<strong>Delicious Full Buffet Breakfast Daily</strong> for Two People when you upgrade to the Breakfast Package <span style=\"font-size:12px;\">(valued at $168)</span>','<span style=\"font-size:16px;\"><strong>Luxurious Resort Facilities</strong> including renowned salt water lagoon pool, waterslide, spas, poolside cabanas, sauna, gym, day spa, tennis court, daily room servicing, kids club &amp; more!&nbsp;</span>\r\n','<span style=\"font-size:16px;\">Enjoy&nbsp;<strong>Award-Winning Dining</strong> without leaving the resort including pool bar, lounge &amp; tapas bar, 2 world-class restaurants &amp; room service!&nbsp;</span>\r\n','<b>Complimentary Car Parking&nbsp;</b><span style=\"font-size: 12px;\">(valued at $30)</span>','<strong>Bottle of Wine&nbsp;</strong>on arrival to kick start your induldgent holiday<span style=\"font-size: 12px;\">&nbsp;(valued at $38)</span>','<b>Unlimited In-Room Movies&nbsp;</b>to enjoy&nbsp;<span style=\"font-size: 12px;\">(valued at $14.95 each)</span>','<strong>Kids Stay FREE!</strong>&nbsp;Rooms accommodate up to 2 adults &amp; 2 children<span style=\"font-size:12px;\"> (under 14 years using existing bedding in a Double Room).</span>','<b>Stay Extra Nights for the Same Per Night Price!&nbsp;</b><span style=\"font-size:12px;\">Plus 1 Night Packages also available.</span>','','ffffff',0,1,0,1510,3,'Yes',1);

--
-- Table structure for table `promotionnewsletter`
--

CREATE TABLE `promotionnewsletter` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `content_middle` text NOT NULL,
  `content_bottom` text NOT NULL,
  `property_details` enum('Yes','No') NOT NULL DEFAULT 'No',
  `separator` int(10) NOT NULL DEFAULT '10',
  `colour` varchar(6) NOT NULL,
  `url_type` int(10) NOT NULL DEFAULT '1',
  `url_custom` varchar(200) NOT NULL,
  `image_1` varchar(200) NOT NULL,
  `image_2` varchar(200) NOT NULL,
  `input_1` text NOT NULL,
  `input_2` text NOT NULL,
  `input_3` text NOT NULL,
  `input_4` text NOT NULL,
  `input_5` text NOT NULL,
  `input_6` text NOT NULL,
  `input_7` text NOT NULL,
  `input_8` text NOT NULL,
  `input_9` text NOT NULL,
  `input_10` text NOT NULL,
  `input_11` text NOT NULL,
  `input_12` text NOT NULL,
  `room_id` int(10) NOT NULL DEFAULT '0',
  `bg_colour` varchar(6) NOT NULL,
  `padding` int(10) NOT NULL DEFAULT '0',
  `margin_btm` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  `block_type` int(10) NOT NULL DEFAULT '0',
  `show_on_website` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5248 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionnewsletter`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionnewsletter` VALUES (5245,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/cruise/pando-cruises-program-release-2021','image-1-2020-01-07-12-31-06.jpg','','','','','','','','','','','','','',0,'',1,0,21549,2,'No',2),(5244,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/burleigh-heads/boardwalk-burleigh-beach','image-1-2020-01-07-09-39-51.jpg','','','Boardwalk Burleigh Beach','Burleigh Heads, Gold Coast','7 Nights','From','$180pn','','','','','','',0,'',1,0,21549,20,'No',4),(5243,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/broadbeach/qube-broadbeach','image-1-2020-01-06-13-32-14.jpg','','','Qube Broadbeach','Broadbeach, Gold Coast','7 Nights','From','$173pn','','','','','','',0,'',1,0,21549,20,'No',3),(5242,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/surfers-paradise/artique-resort-apartments','image-1-2020-01-06-15-16-31.jpg','','The ULTIMATE Gold Coast Theme Park Holiday','Artique Resort','Surfers Paradise, Gold Coast','3 Nights','','$749','2 Bedroom Apartment','','','','','',0,'',0,0,21549,20,'No',5),(5240,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">BRISBANE</span></span> ','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'No',4),(5239,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">WHITSUNDAYS</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',13),(5238,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">TROPICAL NORTH QLD</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',10),(5237,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">SUNSHINE COAST</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',7),(5234,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mirage-whitsundays.php','image-1-2019-12-31-10-28-25.jpg','','Mirage Whitsundays','Airlie Beach, Whitsundays','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',15),(5232,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$2xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/sea-temple-port-douglas.php','image-1-2019-12-31-10-26-17.jpg','','Sea Temple Private Apartments','Port Douglas, Tropical North QLD','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',12),(5231,' \r\n<div style=\"text-align: center;\">\r\n	<span style=\"color:#007889;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\">We&#39;re here to help you find your perfect getaway today</span>!</span></span><br />\r\n	<a href=\"tel:1300769765\" style=\"font-size:26px;color:#ff8c00;text-decoration:none;\">Call us 1300 769 765</a></div>\r\n','','','No',10,'',2,'','','','','','','','','','','','','','','',0,'ffffff',0,0,21607,7,'Yes',23),(5229,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/rolling-surf.php','image-1-2019-12-31-10-22-35.jpg','','Rolling Surf Resort','Caloundra, Sunshine Coast','x Bedroom Deluxe','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',9),(5228,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">GOLD COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',1),(5227,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-crown-towers.php','image-1-2019-12-31-10-11-45.jpg','','Mantra Crown Towers','Surfers Paradise, Gold Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',3),(5226,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xpn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes</span></span></span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/treasury-brisbane.php','image-1-2019-12-31-10-18-59.jpg','','Treasury Brisbane','Brisbane CBD','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'No',6),(5225,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'','image-1-2019-12-31-10-10-42.jpg','','Oaks Gold Coast Hotel','Surfers Paradise, Gold Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',2),(5223,'','','','No',10,'',0,'','image-1-2019-12-31-10-07-25.jpg','','','','','','','','','','','','','',0,'',1,0,21607,2,'No',0),(5221,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/next-hotel-brisbane.php','image-1-2019-12-31-10-17-54.jpg','','NEXT Hotel Brisbane','Queen Street, Brisbane','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'No',5),(5220,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-alexandra-beach.php','image-1-2019-12-31-10-20-20.jpg','','BreakFree Alexandra Beach','Alexandra Headland, Sunshine Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',8),(5218,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/fitzroy-island-resort.php','image-1-2019-12-31-10-23-48.jpg','','Fitzroy Island Resort','Fitzroy Island, Via Cairns`','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',11),(5217,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/daydream-island-resort.php','image-1-2019-12-31-10-27-25.jpg','','Daydream Island Resort & Spa','Daydream Island, Whitsundays','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',14),(5215,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">SYDNEY CBD</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',20),(5214,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">PERTH CBD</span></span> ','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',22),(5213,'<span style=\"font-size:18px; color:#ee4421;\">1 Nights from <span style=\"font-size:30px;\">$169pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast &amp; Late Checkout</span></span></span><br />\r\n(Min. Spend $244)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-on-hay.php','image-1-2019-12-23-15-03-42.jpg','','Mantra on Hay','Perth CBD, Western Australia','1 Bedroom Apartment','Central CBD Location with Great Facilities','','','','','','','','',0,'',0,0,21605,5,'No',23),(5212,'<span style=\"font-size:18px; color:#ee4421;\">1 Nights from <span style=\"font-size:30px;\">$179pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $179)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-2-bond-street.php','image-1-2019-12-23-15-01-54.jpg','','Mantra 2 Bond Street','Sydney CBD, NSW','Executive Studio','Central Location','','','','','','','','',0,'',0,0,21605,5,'No',21),(5211,'','','','No',10,'',0,'','image-1-2019-12-23-14-58-03.jpg','','','','','','','','','','','','','',0,'',1,0,21605,2,'No',19),(5210,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">FRASER COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',14),(5209,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$81pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $162)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-hervey-bay.php','image-1-2019-12-23-14-51-09.jpg','','Mantra Hervey Bay','Hervey Bay, Fraser Coast','Hotel Room','Stunning Marina Location!','','','','','','','','',0,'',0,0,21605,5,'No',15),(5208,'','','','No',10,'',0,'','image-1-2019-12-24-14-50-33.jpg','','','','','','','','','','','','','',0,'',1,0,21605,2,'No',0),(5207,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">WHITSUNDAYS</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',12),(5206,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">TROPICAL NORTH QLD</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',8),(5205,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">SUNSHINE COAST</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',5),(5204,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$122pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Buffet Breakfast Daily!</span></span></span><br />\r\n(Min. Spend $244)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-aanuka-beach-resort.php','image-1-2019-12-23-14-55-28.jpg','','BreakFree Aanuka Beach','Coffs Harbour, NSW','Hotel Room','Absolute Beachfront with Stunning Views!','','','','','','','','',0,'',0,0,21605,5,'Yes',18),(5203,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$108pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $217)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-club-croc.php','image-1-2019-12-23-14-43-54.jpg','','Mantra Club Croc','Airlie Beach, Whitsundays','Garden Deluxe Room','Freshly Renovated & Centrally Located!','','','','','','','','',0,'',0,0,21605,5,'Yes',13),(5202,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$200pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast, WiFi &amp; Spa Discounts!</span></span></span><br />\r\n(Min. Spend $400)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/peppers-beach-club-spa-palm-cove.php','image-1-2019-12-23-14-38-53.jpg','','Peppers Beach Club & Spa','Palm Cove, Tropical North QLD','Resort Spa','Indulgent 5 Star Bliss','','','','','','','','',0,'',0,0,21605,5,'Yes',10),(5200,' \r\n<div style=\"text-align: center;\">\r\n	<span style=\"color:#007889;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\">We&#39;re here to help you find your perfect getaway today</span>!</span></span><br />\r\n	<a href=\"tel:1300769765\" style=\"font-size:26px;color:#ff8c00;text-decoration:none;\">Call us 1300 769 765</a></div>\r\n','','','No',10,'',2,'','','','','','','','','','','','','','','',0,'ffffff',0,0,21605,7,'Yes',24),(5199,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$136pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast, In-Room Movies &amp; Dining Discounts!</span></span></span><br />\r\n(Min. Spend $272)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/peppers-blue-on-blue.php','image-1-2019-12-23-14-40-37.jpg','','Peppers Blue on Blue','Magnetic Island, Tropical North QLD','Hotel Room','Idyllic Island Escape','','','','','','','','',0,'',0,0,21605,5,'Yes',11),(5198,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$181pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $363)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-french-quarter.php','image-1-2019-12-23-14-35-17.jpg','','Mantra French Quarter','Noosa, Sunshine Coast','1 Bedroom Deluxe','Prime Location in the Heart of Noosa!','','','','','','','','',0,'',0,0,21605,5,'Yes',7),(5197,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">GOLD COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',1),(5196,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$145pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $290)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-circle-on-cavill.php','image-1-2019-12-23-14-25-30.jpg','','Mantra Circle on Cavill','Surfers Paradise, Gold Coast','1 Bedroom ','Luxury in Paradise','','','','','','','','',0,'',0,0,21605,5,'Yes',3),(5195,'<span style=\"font-size:18px; color:#ee4421;\">3 Nights from <span style=\"font-size:30px;\">$112pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $336)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-moroccan.php','image-1-2019-12-23-14-16-35.jpg','','BreakFree Moroccan','Surfers Paradise, Gold Coast','1 Bedroom Apartment','Great for Families, Great Value & Close to Everything!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',2),(5194,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$112pn</span></span><br />\r\n<span style=\"font-size: 14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Dining Discounts &amp; Parking!</span></span></span><br />\r\n(Min. Spend $225)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-on-salt-beach.php','image-1-2019-12-23-14-54-14.jpg','','Mantra on Salt Beach','Kingscliff, NSW','Hotel Room','Beachfront Bliss, Untouched Paradise','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',17),(5192,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">NORTHERN NSW</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',16),(5191,'<span style=\"font-size:18px; color:#ee4421;\">3 Nights from <span style=\"font-size:30px;\">$118pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $353)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-grand-pacific.php','image-1-2019-12-23-14-32-52.jpg','','BreakFree Grand Pacific','Caloundra, Sunshine Coast','1 Bedroom Garden View','Absolute Beachfront Bliss!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',6),(5190,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$99pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $189)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-amphora.php','image-1-2019-12-23-14-37-08.jpg','','Mantra Amphora','Palm Cove, Tropical North QLD','Hotel Spa Room','Palm Cove Tropical Bliss!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',9),(5189,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$263pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Parking &amp; WiFi!</span></span></span><br />\r\n(Min. Spend $527)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/soul-surfers.php','image-1-2019-12-23-14-27-01.jpg','','Peppers Soul','Surfers Paradise, Gold Coast','1 Bedroom Ocean View','Redefines World-Class Luxury','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',4),(5187,'','','','No',0,'',3,'http://www.discoverqueensland.com.au/giftvouchers/','2-image-1-2018-12-10-13-08-25.jpg','','','','','','','','','','','','','',0,'',1,0,21576,2,'No',0),(5186,'<div style=\"text-align: center;\">\r\n	<font face=\"arial, helvetica, sans-serif\"><span style=\"font-size: 24px;\"><b>Unlimited Dining &amp; Kids Club Await on your Cruise</b></span></font></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',8),(5185,'<div style=\"text-align: center;\">\r\n	<span style=\"font-family:arial,helvetica,sans-serif;\"><span style=\"font-size: 24px;\"><b>Indulge in a Brisbane City Retreat</b></span></span></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',4),(5184,'<div style=\"text-align: center;\">\r\n	<span style=\"font-family:arial,helvetica,sans-serif;\"><span style=\"font-size: 24px;\"><b>Escape to the Gold Coast for Family Fun</b></span></span></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',1);

--
-- Table structure for table `promotionsms`
--

CREATE TABLE `promotionsms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `from` varchar(200) NOT NULL,
  `sms_start_dt` datetime NOT NULL,
  `content` text NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionsms`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionsms` VALUES (4,'','2020-02-04 00:00:59','',21666),(3,'','2017-07-06 00:00:59','',1742),(2,'','2015-12-16 00:00:59','',842),(1,'MyHightide','2013-12-26 09:00:59','Testing again',4);

--
-- Table structure for table `promotionsocial`
--

CREATE TABLE `promotionsocial` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `repeat_ad` int(10) NOT NULL DEFAULT '0',
  `frequency` enum('NA','Daily','Weekly') NOT NULL DEFAULT 'NA',
  `repeat_end_dt` datetime NOT NULL,
  `message` text NOT NULL,
  `use_exact` enum('Yes','No') NOT NULL DEFAULT 'No',
  `keywords` text NOT NULL,
  `explanation` text NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionsocial`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionsocial` VALUES (2,0,'NA','2015-12-16 00:00:59','','No','','',842),(1,0,'NA','2013-12-25 00:00:59','Message','Yes','gold coast\r\nfamily','First you get the money.',4);

--
-- Table structure for table `promotiontracking`
--

CREATE TABLE `promotiontracking` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `src` varchar(40) NOT NULL,
  `suffix` varchar(200) NOT NULL,
  `comment` varchar(200) NOT NULL,
  `code` varchar(200) NOT NULL,
  `promotion_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotiontracking`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotiontracking` VALUES (95,'SM','','','5cTEXg',21955),(94,'FB','','','2WLrIg',21955),(93,'NL','','','jNZgoV',21955),(92,'GA','','','mK3z1I',21955),(91,'SM','','','rS0fF7',21779),(90,'FB','','','ZzTwF3',21779),(89,'NL','','','pb69r4',21779),(88,'GA','','','mYafVr',21779),(87,'SM','','','kseb8T',21843),(86,'FB','','','jcl6Iw',21843),(85,'NL','','','lRgH4q',21843),(84,'GA','','','3Mm14v',21843),(83,'SM','','','2oTbqM',21767),(82,'FB','','','PW4mjC',21767),(81,'NL','','','gjYnLQ',21767),(80,'GA','','','sw3WFC',21767),(79,'SM','','','MNXPI7',21623),(78,'FB','','','nPQqc3',21623),(77,'NL','','','bC9Paf',21623),(76,'GA','','','KA1Sdo',21623),(75,'SM','','','E6AjG3',21492),(74,'FB','','','cdW3jU',21492),(73,'NL','','','G8e5RY',21492),(72,'GA','','','lAQ5Fp',21492),(71,'SM','','','4lFDw9',21449),(70,'FB','','asdf','JWQXOy',21449),(69,'NL','','','TtEaoK',21449),(68,'GA','','','veFmJK',21449),(67,'SM','','','mCKzSF',21459),(66,'FB','','','cuYZgP',21459),(65,'NL','','','OMAd26',21459),(64,'GA','','','2Ck4xI',21459),(63,'SM','','','6NO7FG',21464),(62,'FB','','','l2MZvF',21464),(61,'NL','','','A37GKN',21464),(60,'GA','','','BWdo7n',21464),(59,'SM','','','eATZIU',21039),(58,'FB','','','dQPnxc',21039),(57,'NL','','','tLVJcG',21039),(56,'GA','','','xabIMp',21039),(55,'SM','','','ZuJqwC',20829),(54,'FB','','','RTHtLW',20829),(53,'NL','','','9tJ1X7',20829),(52,'GA','','','5tU7Or',20829),(51,'SM','','','5EP2vr',20655),(50,'FB','','','K347rY',20655),(49,'NL','','','4aPuJr',20655),(48,'GA','','','14L8HE',20655),(47,'SM','','','YF6azy',20627),(46,'FB','','','6aXlt0',20627);

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ClientsID` int(10) unsigned NOT NULL DEFAULT '0',
  `meta_title` varchar(200) NOT NULL,
  `meta_descr` text NOT NULL,
  `Name` varchar(100) NOT NULL DEFAULT '',
  `DisplayName` varchar(100) NOT NULL,
  `FileName` varchar(100) DEFAULT NULL,
  `Description` text NOT NULL,
  `RoomIntro` text NOT NULL,
  `sdib_teaser` text NOT NULL,
  `sdib_intro` text NOT NULL,
  `SchooliesDescription` text NOT NULL,
  `SchooliesMarketing` text NOT NULL,
  `GSWDescription` text NOT NULL,
  `GSWMarketing` text NOT NULL,
  `Reception` text NOT NULL,
  `ArrivalInfo` text NOT NULL,
  `Photo` varchar(100) NOT NULL DEFAULT '',
  `ResizedPhoto` varchar(200) NOT NULL,
  `Address` varchar(100) NOT NULL DEFAULT '',
  `StatesID` int(11) NOT NULL,
  `State` varchar(100) NOT NULL DEFAULT '',
  `CountriesID` int(10) unsigned NOT NULL DEFAULT '0',
  `RegionsID` int(11) NOT NULL,
  `Phone` varchar(45) NOT NULL DEFAULT '',
  `PropPhone` varchar(45) NOT NULL,
  `Fax` varchar(45) NOT NULL DEFAULT '',
  `Email` varchar(50) DEFAULT NULL,
  `SecondaryEmail` varchar(50) NOT NULL,
  `RemitEmail` varchar(50) NOT NULL,
  `RemittanceDays` int(10) NOT NULL DEFAULT '14',
  `ArrivalEmail` varchar(50) NOT NULL,
  `Website` varchar(100) NOT NULL DEFAULT '',
  `BrandName` varchar(100) NOT NULL DEFAULT '',
  `BrandCode` varchar(45) NOT NULL DEFAULT '',
  `HotelCode` varchar(45) NOT NULL DEFAULT '',
  `SDescription` text NOT NULL,
  `SchooliesSDescription` text NOT NULL,
  `GSWSDescription` text NOT NULL,
  `Start` date NOT NULL DEFAULT '0000-00-00',
  `WhenBuilt` date NOT NULL DEFAULT '0000-00-00',
  `Status` enum('open','closed') NOT NULL DEFAULT 'open',
  `LanguageCode` varchar(45) NOT NULL DEFAULT '',
  `Currency` varchar(4) NOT NULL,
  `Approved` int(1) NOT NULL DEFAULT '1',
  `Facilities` text,
  `OFacilities` text NOT NULL,
  `Categories` text NOT NULL,
  `AccomTypes` text NOT NULL,
  `SubRegionsID` int(11) unsigned DEFAULT NULL,
  `CheckIn` varchar(250) DEFAULT ' ',
  `CheckOut` varchar(250) DEFAULT ' ',
  `ExtraGuests` text,
  `ChildAge` int(10) NOT NULL DEFAULT '14',
  `InfantAge` int(10) NOT NULL DEFAULT '2',
  `TermsAndConditions` text,
  `ShowTermsAndConditions` enum('Y','N') NOT NULL DEFAULT 'N',
  `MysteryTermsAndConditions` text NOT NULL,
  `CRSComments` text NOT NULL,
  `StarRating` decimal(2,1) DEFAULT '1.0',
  `RatingType` enum('AAA','Self Rated') NOT NULL DEFAULT 'AAA',
  `LCRating` decimal(2,1) NOT NULL,
  `CarParking` text,
  `SecurityAmount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `SecurityType` enum('Per Person','Per Room') NOT NULL DEFAULT 'Per Person',
  `Bond` decimal(10,2) NOT NULL DEFAULT '0.00',
  `SchooliesOveride` enum('Yes','No') NOT NULL DEFAULT 'No',
  `Location` text,
  `DistanceTo` varchar(250) NOT NULL,
  `DistanceInfo` text NOT NULL,
  `Postcode` varchar(50) DEFAULT NULL,
  `Latitude` decimal(11,7) DEFAULT NULL,
  `Longitude` decimal(11,7) DEFAULT NULL,
  `FromPrice` decimal(10,2) DEFAULT '0.00',
  `FromPercent` decimal(10,2) NOT NULL DEFAULT '0.00',
  `PriceRange` int(1) NOT NULL DEFAULT '2',
  `UpdateFromPrice` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `IsHotProperty` enum('Y','N') DEFAULT 'N',
  `IsFeatured` enum('Y','N') DEFAULT 'N',
  `ShowRates` enum('Y','N') DEFAULT 'N',
  `AssociatedTo` varchar(200) NOT NULL,
  `LCRank` int(10) NOT NULL,
  `RemainderDays` int(10) NOT NULL DEFAULT '0',
  `dq_video` text NOT NULL,
  `ht_video` text NOT NULL,
  `levart_username` varchar(200) NOT NULL,
  `levart_password` varchar(200) NOT NULL,
  `resonline_username` varchar(200) NOT NULL,
  `resonline_password` varchar(200) NOT NULL,
  `siteminder_hotelcode` varchar(200) NOT NULL,
  `derbysoft_hotelcode` varchar(200) NOT NULL,
  `ratetiger_hotelcode` varchar(50) NOT NULL,
  `newbook_code` varchar(200) NOT NULL,
  `newbook_password` varchar(200) NOT NULL,
  `travelclick_username` varchar(100) NOT NULL,
  `rms_hotelcode` varchar(50) NOT NULL,
  `rms_chaincode` varchar(50) NOT NULL,
  `SchooliesOrder` int(10) NOT NULL DEFAULT '0',
  `GSWOrder` int(10) NOT NULL DEFAULT '0',
  `DateCallback` datetime NOT NULL,
  `CallbackID` int(10) NOT NULL DEFAULT '0',
  `AllowHTML` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  PRIMARY KEY (`id`),
  KEY `CountriesID` (`CountriesID`),
  KEY `SubRegionsID` (`SubRegionsID`),
  KEY `StatesID` (`StatesID`),
  KEY `RegionsID` (`RegionsID`),
  KEY `ClientsID` (`ClientsID`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=14707 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `properties`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `properties` VALUES (14706,545,'','','Discovery Parks Boat Harbour Drive, Hervey Bay (TAAP)','Discovery Parks Boat Harbour Drive, Hervey Bay (TAAP)','discovery-parks-boat-harbour-drive,-hervey-bay-(taap)','','','','','','','','','','','','','295 Boat Harbour Dr, Scarness, Hervey Bay QLD',1,'',1,5,'0741282762','0741282762','','bookings@leisurecom.com','','bookings@leisurecom.com',14,'bookings@leisurecom.com','','','','','','','','0000-00-00','0000-00-00','open','','AUD',1,'','','','',21,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'','N','','',4.0,'Self Rated',0.0,'Free Car Parking',0.00,'Per Person',0.00,'No','.','','','4655',0.0000000,0.0000000,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14705,545,'','','Northpoint Apartments (TAAP)','Northpoint Apartments (TAAP)','northpoint-apartments-(TAAP)','','','','','','','','','','','','','2 Murray St, Port Macquarie',2,'',1,11,'1800210222','1800210222','','bookings@leisurecom.com','','bookings@leisurecom.com',14,'bookings@leisurecom.com','','','','','Northpoint Apartments offers you the best in Port Macquarie accommodation at one of the best locations available. Whether you\'re planning a much needed Port Macquarie holiday, a relaxing sun filled beach escape, or combining family & business - Northpoint Apartments is the place to stay during your trip. Take advantage of our many facilities & enjoy everything that Port Macquarie has to offer at your doorstep.','','','0000-00-00','0000-00-00','open','','AUD',1,'','','','',44,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'','N','','',1.0,'AAA',0.0,'',0.00,'Per Person',0.00,'No','Northpoint Apartments is in the heart of the Port Macquarie CBD and only a few minutes walk to Town beach. No matter what kind of Port Macquarie Holiday you are after, Northpoint\'s facilities and location provide great access to everything.','','','2444',0.0000000,0.0000000,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14704,545,'','','Catalina Resort (TAAP)','Catalina Resort (TAAP)','catalina-resort-(taap)','','','','','','','','','','','','','47 Sixth Avenue, Maroochydore, QLD',1,'',1,6,'(07) 5443 8666','(07) 5443 8666','','bookings@leisure.com.au','','bookings@leisure.com.au',14,'bookings@leisure.com.au','','','','','','','','0000-00-00','0000-00-00','open','','AUD',1,'','','','',11,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'','N','','',1.0,'AAA',0.0,'',0.00,'Per Person',0.00,'No','.','','','4558',0.0000000,0.0000000,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14703,545,'','','The Horatio Mudgee (TAAP)','The Horatio Mudgee (TAAP)','the-horatio-mudgee-(taap)','','','','','','','','','','','','','15 Horatio St, Mudgee NSW',2,'',1,62,'0263727727','0263727727','','bookings@leisurecom.com','','bookings@leisurecom.com',14,'bookings@leisurecom.com','','','','','','','','0000-00-00','0000-00-00','open','','AUD',1,'','','','',618,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'','N','','',3.5,'Self Rated',0.0,'Free Car Parking',0.00,'Per Person',0.00,'No','.','','','2850',0.0000000,0.0000000,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14702,545,'','','Mantra Quayside (TAAP)','Mantra Quayside (TAAP)','mantra-quayside','<p>\r\n	Ideally located on the Hastings River Broadwater, Mantra Quayside offers quality self contained accommodation right in the heart of Port Macquarie. Only a short stroll from the dynamic Horton Street, Mantra Quayside provides easy access to the street&rsquo;s shopping and dining precinct featuring an abundance of cafes, restaurants, boutique stores and cinemas.</p>\r\n<p>\r\n	Consisting of 42 fully equipped studio rooms, one and two bedroom apartments, many rooms offer stunning waterfront views. All rooms feature air conditioning and a home theatre system including dvd player, cd player and a flat screen tv panel, perfect for winding down after a day exploring the surrounding township.</p>\r\n<p>\r\n	Port Macquarie, affectionately known as &lsquo;Port&rsquo; to the locals, is an eclectic mix of the old and new, offering a wide variety of attractions, historic sites, national park, beaches and heritage areas. Only one hour&rsquo;s flight from Sydney and accessible by train through Wauchope, Port Macquarie is a must-see destination with Mantra Quayside the perfect base to explore the area.</p>\r\n','','','','','','','','','','image-2018-06-18-15-53-17.jpg','medium-image-2018-06-18-15-53-17.jpg','Cnr William and Short Streets, Port Macquarie NSW',2,'',1,11,'02 6588 4000','02 6588 4000','02 6584 4784','bookings@leisurecom.com','','bookings@leisurecom.com',14,'bookings@leisurecom.com','www.mantraquayside.com.au','','','','Ideally located on the Hastings River Broadwater, Mantra Quayside offers quality self contained accommodation right in the heart of Port Macquarie. Only a short stroll from the dynamic Horton Street, Mantra Quayside provides easy access to the street\'s shopping and dining precinct.','','','0000-00-00','0000-00-00','open','','AUD',1,'','4,58,12,16,17,62,71,60,24,63','4','Apartment',44,'2.00pm','10.00am','Extra guests allowed at additional charge',14,2,'','N','','',4.5,'Self Rated',0.0,'Free car parking',0.00,'Per Person',0.00,'No','Located on the Hastings River Broadwater in the heart of Port Macquarie CBD and only a short stroll to the shopping and dining precinct featuring an abundance of cafï¿½s, restaurants, boutique stores and cinemas.','','','2555',-31.4311420,152.9068480,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14701,742,'','','The Sands at Broadbeach','The Sands at Broadbeach','the-sands-at-broadbeach','The Sands is the perfect holiday home for a family getaway that is within a stone&rsquo;s throw away of everything Broadbeach has to offer. The Sands is a delightful property providing both an indoor and outdoor lifestyle that will have you feeling relaxed and at home from the moment you walk through the door.<br />\r\n<br />\r\nDownstairs you will find an outside covered entertaining area featuring a barbecue and outdoor dining. Three double bedrooms, one with ensuite and the fifth bedroom is perfect for children and teenagers with two double bunk beds, sofabed, TV, DVD, Foxtel and Playstation 3. Upstairs, the entire floor is dedicated to the master bedroom with ensuite.<br />\r\n<br />\r\nEntertainment is available for both the young and old. The mineral swimming pool is heated up to 27 degrees year round or relax in the outdoor heated Jacuzzi. Enjoy spectacular sunsets by the pool with a book in the afternoon or challenge yourself on the Playstation. For active family members, keep yourself entertained by using the complimentary kayaks on the waterfront canal, go fishing off your very own private beach or take off on an adventure on the supplied mountain bikes.<br />\r\n<br />\r\nA short walk will take you to all the attractions Broadbeach has on offer, from the best bars and restaurants to iconic Gold Coast beaches. On the way you will pass The Star Casino and the Gold Coast Convention Centre. A perfect choice for you to have fun, relax and make the most of your Gold Coast vacation.<br />\r\n','','','','','','','','','You will be personally greeted upon your arrival and given a tour of The Sands at Broadbeach and its facilities. ','','','17 Maureen Court, Broadbeach Waters, QLD',1,'',1,8,'0499 555 279','0499 555 279','','bookings@vogueholidayhomes.com','','bookings@vogueholidayhomes.com',14,'bookings@vogueholidayhomes.com','www.vogueholidayhomes.com','','','','In the heart of Broadbeach, you are surrounded by the iconic Gold Coast canals. From your holiday home you can walk to everything that Broadbeach is famous for â€“ from the world class beaches, local cafes, Pacific Fair Shopping Centre and the Star Casino.','','','0000-00-00','0000-00-00','open','','AUD',1,'<ul>\r\n<li>Kayaks</li>\r\n<li>Fishing Rods</li>\r\n<li>Mountain Bikes</li>\r\n<ul>','4,196,27,107','2,18,10','Holiday Houses',3,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'<ul>\r\n	<li>\r\n		Bookings are not accepted from guests under the age of 24.</li>\r\n	<li>\r\n		Holiday homes are located in quiet neighbourhoods. A strict No Party policy applies.</li>\r\n	<li>\r\n		Holiday homes are strictly Smoke Free. No smoking is permitted inside the house.</li>\r\n	<li>\r\n		Linen is provided. The property will not be serviced during your stay unless requested (fee applies).</li>\r\n</ul>\r\n','Y','','<strong>PRIOR TO ARRIVAL</strong><br />\r\n<strong>Booking Form</strong><br />\r\nThe registered guest must complete a Booking Form within 24 hours after booking confirmation. This form requires guest information, a list of all occupants who will be staying and Booking Terms &amp; Conditions.&nbsp;<br />\r\n&nbsp;<br />\r\n<strong>Security Bond / Linen &amp; Cleaning Fee:</strong><br />\r\nA pre-authorised payment of $1483 ($1000 Security Bond and $483 non-refundable Linen &amp; Cleaning Fee) will be made on guest&#39;s nominated credit card at least 2 days prior to arrival at the property. Funds must be available for this transaction. The security bond will only be used in full or in part depending on recovery of any incidental items as soon as practical after departure once the property has been inspected.<br />\r\n&nbsp;<br />\r\n<strong>CHECK-IN PROCEDURE</strong><br />\r\n<strong>Arrival Time</strong>&nbsp;is 2:00pm<br />\r\n<strong>Departure Time</strong>&nbsp;is 10:00am.<br />\r\nGuests are to provide their arrival time as they will be personally greeted by the property manager upon arrival and given a tour of the house and its facilities.<br />\r\n&nbsp;<br />\r\n<strong>GENERAL INFO</strong>\r\n<ul>\r\n	<li>\r\n		Bookings are not accepted from guests under the age of 24.</li>\r\n	<li>\r\n		Holiday homes are located in quiet neighbourhoods. A strict No Party policy applies.</li>\r\n	<li>\r\n		Holiday homes are strictly Smoke Free. No smoking is permitted inside the house.</li>\r\n	<li>\r\n		Linen is provided. The property will not be serviced during your stay unless requested (fee applies).&nbsp;</li>\r\n</ul>\r\n',4.0,'AAA',0.0,'Off-Street parking',0.00,'Per Person',0.00,'No','In the heart of Broadbeach, you can walk to everything that Broadbeach is famous for â€“ from the world class beaches, local cafes, Pacific Fair Shopping Centre and the Star Casino.','','Nearest Airport (Gold Coast): 19km\r\nNearest Beach (Kurrawa Beach): 2km\r\nNearest Public Transport: 490m ','4218',-28.0335890,153.4215470,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','vogue-sands','14701','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14700,545,'','','Oaks Redcliffe Mon Komo Suites (TAAP)','Oaks Redcliffe Mon Komo Suites (TAAP)','oaks-mon-komo','<p class=\"larger highlight\">\r\n	Mon Komo &ldquo;My Dream Place&rdquo; on the beach at Redcliffe is the newest resort style accommodation located only 35 minutes from Brisbane&rsquo;s CBD precinct and close to Brisbane Domestic &amp; International airports.</p>\r\n<p>\r\n	Surrounded by restaurants, cafes, shopping, entertainment, recreational activities and only moments to the beach there is plenty to see and do whilst staying at Oaks Redcliffe Mon Komo Suites. Make the most of the resort facilities which include a gymnasium and swimming pool.</p>\r\n<p>\r\n	With all the facilities of a beachfront resort you can be sure to enjoy the luxury of spacious hotel rooms and fully self contained apartments, most with spectacular ocean views over Moreton Bay. Spacious apartments complemented by contemporary coastal d&eacute;cor and luxuriously appointed kitchens with stainless steel appliances and full laundry facilities.</p>\r\n','','','','','','','','Sunday to Thursday:  6:00am - 10:30pm\r\nFriday & Saturday:  24 hours\r\nIf you are arriving outside these times, please advise so after hours check-in arrangements may be made.','A valid credit card pre-authorisation will be required on arrival and will be used to cover incidental items. Cash is not an acceptable form of bond when staying with Oaks Hotels & Resorts.','image-2018-05-08-13-49-05.jpg','medium-image-2018-05-08-13-49-05.jpg','99 Marine Parade, Redcliffe QLD',1,'',1,7,'07 3283 9300','07 3283 9300','','bookings@leisurecom.com','','bookings@leisurecom.com',14,'bookings@leisurecom.com','','','','','Oaks Redcliffe Mon Komo Suites on the beach at Redcliffe is located only 35 minutes from Brisbane\'s CBD and close to Brisbane Airports. Surrounded by cafes, restaurants, shopping, entertainment, recreational activities and only moments to the beach.','','','0000-00-00','0000-00-00','open','','AUD',1,'','4,9,12,17,62,59,21,63,107','10','Apartment,Resort',117,'2:00pm','10:00am','Extra guests allowed at additional charge',14,2,'<p>\r\n	<strong>SPECIALS</strong><br />\r\n	No changes or cancellations are permitted to &ldquo;<strong>Promo</strong>&rdquo; room types, &quot;<strong>No Refund</strong>&quot; room types and &quot;<strong>Stay Save</strong>&quot; room types.</p>\r\n','Y','','',4.5,'AAA',0.0,'Free car parking',0.00,'Per Person',0.00,'No','Situated on the beach at Redcliffe, just 35 minutes from Brisbane\'s CBD','','Nearest Airport (Brisbane):  30km\r\nNearest Beach (Calm Water):  230m\r\nNearest Public Transport:  200m\r\nCity Centre (Brisbane CBD):  36km','4020',-27.2319350,153.1163000,0.00,25.00,2,'Yes','N','Y','Y','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14699,746,'','','Rydges Kensington London','Rydges Kensington London',NULL,'The newly-refurbished Rydges Kensington London hotel offers guests a design-inspired boutique hotel located in the heart of Kensington and Chelsea.\r\n\r\nDiscretely settled on one of London’s historic tree-lined avenues, this Kensington hotel is a clever combination of Georgian proportion, with high ceilings and decorative plasterwork, alongside imaginatively chosen contemporary works of art and interior styling.\r\n\r\nRydges Kensington London is just a minute’s walk from Gloucester Road tube station and within easy reach of London’s financial and business centre. The hotel is surrounded by some of London\'s finest bars, restaurants and cafes and just a short stroll from the city’s Royal Parks.','','','','','','','','','','','','61 Gloucester Road London 0',122,'',3,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000551','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14698,746,'','','Rumours Luxury Villas and Spa','Rumours Luxury Villas and Spa',NULL,'Rarotonga\'s premium accommodation and multi award winning Spa - set amongst the palms on the tranquil white sandy beach at the beginning of the famous Muri Beach Lagoon.\r\nAll Villas have marble tiles throughout with quality fittings and attention to detail. All contain two bedrooms, fully equipped modern kitchens, private courtyards with swimming pool, air-conditioning, 450 in house movies and CD\'s, tropical gardens with waterfalls and most have private Jacuzzi\'s\r\nA perfect place to start you adventure or relax and unwind! \r\nBookings for this property are available 30 days in advance.\r\n\r\nProperty features: * World class luxury in the Cook Islands * Absolute beachfront locations * Private pools all villas * Waterfalls, courtyards, tropical gardens * Spa pools – beachfront villas * VIP attention, service and inclusions * Multi Award Winning WATERFALL SPA FACILITY * Preferential Spa rates for guests','','','','','','','','','','','','Muri Beach  ',116,'',53,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001941','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14697,746,'','','Aitutaki Lagoon Resort & Spa','Aitutaki Lagoon Resort & Spa',NULL,'ADULTS ONLY RESORT (for guests aged 16yrs + over)\r\nAs the only resort directly on the world\'s most beautiful lagoon, The Aitutaki Lagoon Resort & Spa is truly blessed. This exclusive all-bungalow resort is one-of-a-kind in many other respects also. It is the only private island resort in the Cook Islands. It is the only Cook Islands resort to offer that invention of incurable romantics ~ the Overwater Bungalow. Plus it is the only resort on Aitutaki with a truly Polynesian flavour, so you can truly savour what the South Pacific is famous for.\r\n\r\nInclusions with standard rates are:\r\n- Welcome drinking coconut, tropical fruit juice & island fruits\r\n- Complimentary Daily Tropical Breakfast\r\n- FREE Daily Activities including stand-up paddleboarding, snorkelling, snorkelling lessons, snorkelling safaris, fish feeding, crab hunting, crab racing, kayaking , Polynesian canoe ‘Vaka’ lessons, wind surfing, beach volleyball, lessons on island (hula) dancing, pareu (sarong)\r\ntying, palm-frond weaving, flower garland (ei) making, coconut climbing and husking show, giant chess, board games & guest library\r\n- Complimentary use of stand-up paddleboards, hammocks, sunlounges, beach towels, snorkelling gear, kayaks, gym, bicycles.\r\n- Invitation to the Resort Manager’s Sunset Cocktail Party\r\n- Daily turndown service','','','','','','','','','','','','Akitua Island  ',116,'',53,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001775','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14696,746,'','','The Hammock Samui Beach Resort','The Hammock Samui Beach Resort',NULL,'The Hammock Samui Beach Resort is a newly build resort located on the sandy beach in Mae Nam, Koh Samui. The resort is the perfect place to spend your holiday while exploring the island. The resort has fantastic views of Koh Phangan Island in the near distance.\r\n\r\nThe interiors of our Koh Samui hotel rooms are sleek and contemporary with a minimalist design and modern amenities.  They offer quality accommodation with 22 bungalows and 4 upper floor rooms with dashing view of Maenam Beach.\r\n\r\nAll rooms are equipped with a flat screen TV, DVD player, Telephone, Safe, Tea and Coffee Maker, Mini-bar, Hair Dryer, Beach Bag with Beach Towels, Hot and cold shower and vanity sink.\r\n\r\nLocal and International dishes are served at the open-air restaurant fronting the sea over looking the neighbouring island Koh Phangan where all meals are prepared with fresh ingredients.','','','','','','','','','','','','82/13 Moo 1 T. Maenam Koh Samui 84330',0,'',213,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001325','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14695,746,'','','Lady Hamilton Hotel','Lady Hamilton Hotel',NULL,'Lady Hamilton Hotel is the ideal relaxation retreat after a day of sightseeing. It is situated in the South African city of Cape Town. The hotel offers dining on the terrace, and features rooms with views of the city or Table Mountain. Sunbathe on one of the lounges surrounding the pool, or relax in the comfort of your individually furnished, spacious room.\n\n','','','','','','','','','','','','10 Union Street, Gardens Cape Town 8001',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000932','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14694,746,'','','The Farmhouse Hotel','The Farmhouse Hotel',NULL,'Overlooking the tranquil Langebaan lagoon, The Farmhouse Hotel is an experience to be savoured. Celebrated for our pleasant staff and West Coast warmth, The Farmhouse offers guests an authentic coastal farmstead encounter. Alluring to nature lovers, Langebaan offers vivid shows of spring flowers, birdlife and an untamed coastline. Explore the lagoon, hike the neighbouring Nature Reserve or simply relax and enjoy the sunset. The kitchen bakes fresh bread and other produce daily for the popular restaurant, that serves up hearty meals infused with West Coast culture.\r\n\r\nOur guest suites, some with their own fireplace and sweeping views of the lagoon, lead to a private poolside garden. The Farmstead is a spacious room with sweeping views, and the separate dual level Cottage is perfect for family getaways.\r\n\r\nThe Farmhouse Restaurant serves traditional Cape cuisine with a variety of seafood complemented by a carefully selected wine list. Food is robust and hearty, filled with the spirit of the West Coast.','','','','','','','','','','','','5 Egret Street Langebaan 7357',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000828','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14693,746,'','','Harbour House Hotel','Harbour House Hotel',NULL,'Situated in the heart of the historical village, Harbour House Hotel has been modelled after its original architecture, a thatched roof seaside manor house built in 1920. Being perfectly located above the Old Harbour, the hotel’s understated luxury is offset by the soothing surrounds of the ocean. The magnificent Lookout Terrace invites guests to relax around the infinity pool overlooking the ocean and savour a sundowner from the pool bar in the Pavilion.\r\n\r\nRooms are luxuriously appointed, with sophisticated modern décor and breathtaking views, all within easy walking distance of the town’s top attractions, whale watching sites, markets, restaurants, street cafés and an abundance of reserved natural splendour.\r\n','','','','','','','','','','','','22 Harbour Road Hermanus 7200',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000827','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14692,746,'','','Coopmanhuijs Boutique Hotel and Spa','Coopmanhuijs Boutique Hotel and Spa',NULL,'Built in 1713 as one of the first grand residences in Stellenbosch, the iconic Coopmanhuijs at 33 Church Street underwent three years\' painstaking renovation before emerging as the Coopmanhuijs Boutique Hotel and Spa in 2010.\r\n\r\nThe 16 guest rooms are air-conditioned and feature extra-length king size or twin single beds and en-suite Victorian bathrooms with underfloor heating. Six guest rooms have their own private balconies. The courtyard encloses a tranquil swimming-pool and discreet health spa.','','','','','','','','','','','','33 Church Street Stellenbosch 7600',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000812','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14691,746,'','','Fancourt','Fancourt',NULL,'Fancourt, 197’s premier leisure and business resort is situated in the heart of the Garden Route.  Ideally located just seven kilometres from the George airport and the historic town, the resort is superbly landscaped on 613 hectares of lush countryside with the majestic Outeniqua mountains as the perfect backdrop.\r\n\r\nThe Fancourt Hotel is a fine blend of modern luxury and classic elegance which offers accommodation that caters to every taste. Luxurious bedrooms and suites are all fully equipped with everything you need to make your stay as comfortable and unforgettable as possible.\r\n\r\nFancourt offers three originally designed Gary Player golf courses. The Links, Montagu & Outeniqua golf courses are all ranked in the Top 20 in 197.','','','','','','','','','','','','Montagu Street Blanco 6529',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000807','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14690,746,'','','The Stellenbosch Hotel','The Stellenbosch Hotel',NULL,'Enjoy warm hospitality in a vibrant, central location. The Stellenbosch hotel was built on land granted by Governor Simon van der Stel between 1692 and 1701. The building was restored in 1987 and has been declared a National Monument.\r\n\r\nThe Stellenbosch Hotel offers a range of accommodation choices. Room types include Petite, Classic, Cape Dutch and Luxury. They also offer several Studio and Two-Bedroom self-catering apartments.\r\n','','','','','','','','','','','','Cnr Dorp and Andringa Streets Stellenbosch 7600',0,'',197,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000805','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14689,746,'','','Ramada by Wyndham Singapore At Zhongshan Park','Ramada by Wyndham Singapore At Zhongshan Park',NULL,'Discover the vibrant energy of Singapore at this four-star hotel in the Balestier/Novena district, voted the Best Mid-Range Hotel by travel professionals in the 25th Annual TTG Travel Awards 2014. \r\n\r\nThe Ramada Singapore hotel offers contemporary amenities, modern event venues and a unique hotel-by-the-park experience. The property exudes international appeal for both business and leisure travellers. From dining to scenic views of the park, you can rest, revive and restore in this charming hotel, minutes away from the city\'s bustle yet close enough to modern conveniences.\r\n\r\nPlease note that prices for hotels in Singapore are subject to additional charges of 18% including a service charge and taxes. This is not calculated in the room cost and will be added by the hotel directly.\r\n','','','','','','','','','','','','16 Ah Hood Road <NA> 329982',0,'',192,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001300','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14688,746,'','','Days Hotel by Wyndham Singapore At Zhongshan Park','Days Hotel by Wyndham Singapore At Zhongshan Park',NULL,'Days Hotel by Wyndham Singapore At Zhongshan Park offers fully appointed accommodation, with modern amenities, including free high-speed Internet access, premium Serta mattress, TV with cable channels and more smart basics. \r\n\r\nThe hotel\'s location in the heart of the Novena district is known as Singapore\'s food haven and just a 15-minute car ride to the Central Business District. Situated right next to a convenience mall with a supermarket and eateries, and flanked by the charming Zhongshan Park.\r\n \r\nThe all-day dining restaurant, 21 on Rajah, is halal-certified and serves breakfast, lunch and dinner buffets. Take advantage of the complimentary shuttle to the Novena MRT (Mass Rapid Transit) station and Orchard Road shopping belt.\r\n\r\nPlease note that prices for hotels in Singapore are subject to additional charges of 18% including a service charge and taxes. This is not calculated in the room cost and will be added by the hotel directly.\r\n\r\n***Renovation notice: 21 On Rajah Restaurant will be closed from Friday, 30 June 2017 to Friday, 7 July 2017 for a soft refurbishment program. An alternative breakfast venue has been arranged at the Flavours At Zhongshan Park which is located at the Ramada Singapore At Zhongshan Park (1 minute walk across the Zhongshan Park). Please note that Halal buffet breakfast option will be temporarily unavailable during this period. Business will resume from Saturday, 8 July 2017 onwards***','','','','','','','','','','','','1 Jalan Rajah <NA> 329133',0,'',192,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001299','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14687,746,'','','Angsana Ihuru','Angsana Ihuru',NULL,'Step onto an island where nature beckons, and plush comforts await. Let your eye wander across the endless stretch of the deep blue sea, rich with dazzling marine life. Feel the excitement in the air seep into your veins and flow through your being. Ease back and rock in your private garden’s Maldivian swing. Gently kick the crystalline waters and watch them ripple out toward the Indian Ocean. Dive the famed Rannamaari wreck and sip cocktails at our oceanfront bar in the company of graceful dolphins. At Angsana Ihuru Island resort, the island is yours. \r\n\r\nPlease note a green tax of US$6 per person per night will be charged upon arrival as an extra charge.','','','','','','','','','','','','North Male Atoll  ',0,'',134,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001846','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14686,746,'','','Grand Hyatt Jakarta','Grand Hyatt Jakarta',NULL,'Grand Hyatt Jakarta is a 5 star luxury hotel located in the heart of the business district. The hotel is adjacent to Indonesia\'s most comprehensive and sophisticated shopping mall, Plaza Indonesia, and enjoys convenient access to government offices, museums and cultural attractions. The hotel  is just 40 minutes by car from Soekarno Hatta International Airport (CGK).\r\n\r\nGrand Hyatt Jakarta features 427 hotel rooms and suites, as well as function and conference rooms. The hotel also hosts  Club Olympus Fitness Centre, a comprehensive fitness studio complemented by a 43-metre lagoon-shaped outdoor pool, tennis courts, a 480-metre jogging track, whirlpool baths, sauna and steam rooms. ','','','','','','','','','','','','Jalan MH Thamrin Kav 28-30 Jakarta  10350',0,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001201','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14685,746,'','','Tanoa Skylodge Hotel, Nadi, Fiji','Tanoa Skylodge Hotel, Nadi, Fiji',NULL,'Fun, friendly, affordable accommodation located just five minutes from the airport.  Tanoa Skylodge Hotel provides casual, clean, comfortable and secure accommodation near Nadi International Airport – and its exceptional value.\r\n\r\nThis 3 star hotel offers 55 well-appointed rooms, suitable for a range of budgets. Ideal for families, groups or holiday makers – we can cater to your every need with dining, leisure activities and conference and event facilities. Nestled in more than four hectares of fully-maintained, landscaped gardens, this is a perfect venue for small conferences and special events.','','','','','','','','','','','','Queens Highway Nadi ',0,'',74,0,'','','','bookings@leisurecom.com','','',14,'','','','','7002130','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14684,746,'','','Tanoa International Hotel, Nadi','Tanoa International Hotel, Nadi',NULL,'Tanoa International Hotel offers airport accommodation set amidst lush tropical gardens, with sensational facilities for leisure, conference, corporate and wedding guests.\r\n\r\nLocated just three minutes from Nadi International Airport, with 148 rooms in a peaceful tropical setting, Tanoa International Hotel can be used as your hub to get around the island. With extensive conference facilities, a range of dining options, and free high-speed internet in every room, this is the place to be.','','','','','','','','','','','','Votualevu Road, Namaka Nadi ',0,'',74,0,'','','','bookings@leisurecom.com','','',14,'','','','','7002128','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14683,746,'','','First Landing Beach Resort & Villas','First Landing Beach Resort & Villas',NULL,'First Landing Resort is set on the white sands of Nalamu Beach at Vuda Point, and looks across Nadi Bay towards the famous Mamanuca Islands. Each night you’ll be amazed by the amazing sunsets and cold drinks at Nalamu Bar.\r\nThe accommodation ranges from affordable private “Bures” (villas) to private beachfront spa bures. They even have a private beach villa and our Oceanview Apartments.\r\nIf you’re looking to find something with self-catering they can help! There’s plenty of local fresh food and vegetables available so feel free to enquire about our self-catering options.\r\n\r\n\r\nDates of construction:\r\n 10th January, 2017 to December 20, 2017\r\nWhen will be done: (Everyday/weekdays/weekends)\r\n Monday to Saturday, NO Work on Sundays\r\nDuring Business Hours\r\n 8am - 5pm\r\n','','','','','','','','','','','','Nalamu Beach Vuda Point ',0,'',74,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001968','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14682,746,'','','Adina Apartment Hotel Copenhagen','Adina Apartment Hotel Copenhagen',NULL,'Adina Apartment Hotel Copenhagen makes it easy for you to experience the delights of this exciting city, superbly located in Copenhagen\'s fast growing Nordhavn area.\r\n\r\nAdina Apartment Hotel Copenhagen offers easy access to a range of dining, shopping, theatre and entertainment options. This stylish apartment hotel is set near the water, adjacent to Copenhagen’s new ferry terminal and is only five minutes from the city. The Opera House, National Arena and the Little Mermaid are only minutes away.\r\n\r\nAnd at the end of your day, return to Adina Apartment Hotel Copenhagen and relax in the hotel sauna, take a dip in the indoor heated swimming pool or work out in the fully equipped fitness centre. Or you can choose to simply relax and recline in the comfort of your own Adina apartment.','','','','','','','','','','','','Amerika Plads 7, DK 2100  ',0,'',60,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000534','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14681,746,'','','Yasawa Island Resort & Spa','Yasawa Island Resort & Spa',NULL,'There are 15 words in the Fijian language meaning Heaven and \'Yasawa\' is the first. Yasawa Island Resort and Spa is an exclusive all-inclusive resort on one of the most remote and unspoiled islands of Fiji. Just 18 luxury bungalows are hidden among the palms, each just a few steps from a pristine white beach. Swim in crystal clear waters, explore any of our 10 private beaches, dive on vividly colored corals, connect with an ancient culture or indulge in Fiji\'s first beachfront spa. Whatever you choose to do at Yasawa, you\'ll do it in complete seclusion.\r\n\r\nFAMILY WEEKS:\r\nChildren aged 16 years and over are welcome at the resort all year round. Children 15 years old and\r\nunder are welcome during our Family Weeks, which are:\r\nFamily time is:\r\n• 13th April to 28th April, 2019.\r\n• 6th July to 21st July, 2019.\r\n• 28th September to 13th October, 2019.\r\n• 20th December, 2019 – 5th January, 2020.\r\n• 20th January – 31st January, 2020.','','','','','','','','','','','','PO Box 9979 Nadi Airport Yasawa Island ',130,'',74,0,'','','','bookings@leisurecom.com','','',14,'','','','','7002113','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14680,746,'','','Mango Bay Resort Fiji','Mango Bay Resort Fiji',NULL,'Nestled within the ‘Dream Water’ (Tadrawai) Valley and set amongst lush tropical landscape, Mango Bay Resort overlooks an enclosed bay of crystal clear water and stunning white beachfront. Boasting affordable accommodation options, days at Mango Bay are filled with action and adventure, while nights are filled with cultural dance shows and many more activities to keep you entertained. Mango Bay Resort accommodates people of all ages with a spirit for adventure, or those looking to switch off from the world for rejuvenation.','','','','','','','','','','','','Queen\'s Highway Namatakula ',130,'',74,0,'','','','bookings@leisurecom.com','','',14,'','','','','7002038','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14679,746,'','','Peppers Seminyak','Peppers Seminyak',NULL,'Peppers Seminyak is conveniently located just 7 kilometres from Denpasar International Airport on the southwest coast of Bali. The area’s famous sunsets and golden beaches are within walking distance as are Bali’s most popular bars, cafes and restaurants. \r\n\r\nSpacious and private accommodation ideal for families and intimate groups, allows you the luxury of being self-contained, but with the services and facilities of a Peppers hotel on call 24 hours a day. Each villa has a private swimming pool and open-air living and dining spaces. All are elegantly furnished, opening out to the beautiful tropical gardens and large poolside Bale traditional Balinese pavilion. \r\n\r\nPeppers Seminyak offers guests tropical gardens, lotus ponds, Bale overlooking the 35 metre rock pool, private swimming pools, The Laneway and Spa at Peppers Seminyak are available for your enjoyment. The Laneway is a Modern, fresh tapas, perfect for sharing, are served in a stylish contemporary setting at Peppers Seminyak. \r\n','','','','','','','','','','','','Jl. Pura Telaga Waja, Petitenget Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001026','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14678,746,'','','C151 Smart Villas','C151 Smart Villas',NULL,'C151 Smart Villas is an exclusive and intimate setting for guests seeking privacy and luxury in the centre of all things uber cool.\r\n\r\nJust steps away from the sandy beaches of the Indian Ocean and located directly in the heart and soul of vibrant Seminyak, C151 Smart Villas rubs shoulders amongst the throng of fashion boutiques, sophisticated nightlife entertainment and fine dining restaurants such as KuDeTa, Hu’U and Living Room where the beautiful people take pleasure in the chilled and laid back environment of Bali’s famed sunset shores.\r\n','','','','','','','','','','','','Jalan Laksmana No. 151  80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000556','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14677,746,'','','Wyndham Dreamland Resort Bali','Wyndham Dreamland Resort Bali',NULL,'Just steps from Dreamland Beach and nestled among luxurious beach clubs and championship golf courses, Wyndham Dreamland Resort Bali is a beautiful sanctuary located in a secluded area of Pecatu. The relaxing resort offers everything you need to unplug and unwind, including three swimming pools, a full-service spa, and wellness centre with a yoga studio. The exquisitely designed rooms and suites offer spectacular ocean views and modern conveniences, while their villas boast extras like private pools, living rooms, and dining areas.\r\n\r\nThe resort also hosts meetings, weddings, and other celebrations. They offer 4 polished event spaces featuring the latest technology and a team of expert planners. ','','','','','','','','','','','','Kawasan Pecatu Indah JI. Dreamland Beach, Pecatu Uluwatu 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7002085','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14676,746,'','','Balquisse Heritage Hotel','Balquisse Heritage Hotel',NULL,'Main buildings built in late 60\'s and renovated over the years by interior decorator & owner Zohra Boukhari, BALQUISSE Heritage Hotel is a charming Boutique Hotel located in the south of the island of Bali close to one of Bali\'s most beautiful beaches and the vibrant fishing market of Jimbaran. This romantic haven, elegantly decorated by the Moroccan interior designer owner, is set amongst an abundant Balinese Garden in the surrounds of an old coconut plantation.','','','','','','','','','','','','Jalan Uluwatu 18X Jimbaran 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001919','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14675,746,'','','Pelangi Bali Hotel and Spa','Pelangi Bali Hotel and Spa',NULL,'Pelangi Bali Hotel is located in beautiful, serene Seminyak with its white sandy beaches and rolling waves are perfect for the keen surfer or those who wish to indulge in the warm sun and outstanding landscape. Not only will you experience a rich culture unlike any other, you will carry memories of people, places, sounds, smells and a fantastic getaway.\r\n\r\nThe beachfront property in peaceful Seminyak Beach on the nothern side of Kuta, with short distance to shopping malls and other tourist attractions. The wide hotel lobby impress a strong Balinese atmosphere and reflect a tastefully balance of local culture and modern architecture. All rooms offer a nice room with marble and international ceramic floor, bathrooms are nicely finished with natural stone. Bathtub is separated with shower booth, completed with bathroom amenities. The beautiful swimming pool and International restaurant are beachfront and offer a superb selection of tasty treats. The Sinta relaxation lounge Spa and Fitness centre will offer you an extensive variety for total relaxation and beautification come to Bali and experience Bali with us to make unforgettable memories with our proffesional service and friendly staff.\r\n\r\nRate inclusive of breakfast, free airport pick up transfer, free Wifi , welcome drink & fresh towel on arrival, free 2 btls of mineral water (replaced daily), use of fitness facilities, scheduled shuttle service to Kuta.\r\n Any special request of room preferences is subject to availability upon arrival.','','','','','','','','','','','','Jl. Camplung Tanduk Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001907','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14674,746,'','','Royal Tulip Springhill Resort - Jimbaran','Royal Tulip Springhill Resort - Jimbaran',NULL,'The Royal Tulip Springhill resort is a new upscale lifestyle destination nestled in the rolling greenery of Jimbaran’s iconic seaside hills.\r\n\r\nThis luxury resort in Bali is surrounded by pristine fresh air and lush vegetation, encompassing approximately 250 hectares. This makes the resort a perfect change from the hustle and bustle of your daily life, to endless days in a tropical paradise. The resort offers spacious rooms and an array of first class amenities, ideal for family getaways and couples’ retreats. Positioned just moments away from Bali’s most scenic beaches, The Royal Tulip Springhill resort is the perfect antidote to a stressful life.\r\n\r\nThe resort’s extensive accommodation starts at an airy 48 sqm. Consisting of 132 luxury resort rooms all outfitted with premium bedding and air conditioning for your comfort. Though the resort is set amidst an unspoiled natural and beautiful setting, you will find the latest technology available. All rooms include free Wi-Fi, flat screen televisions with international channels, and an iPod docking station. Additional amenities range from coffee and tea making facilities to fluffy bathrobes and slippers.\r\n\r\nThis luxury resort provides a complete selection of facilities for your convenience and entertainment. At the Royal Tulip Springhill Resort, you will have access to the swimming pool while the children play to their hearts desire at our kid’s pool and kids club. Guests will have access to the clubhouse that includes a spa, a gym, and in-house yoga sessions. Other facilities at the resort include a meeting room, wedding facilities and services, a unique restaurant concept, and a 24-hour reception service.\r\n\r\nThe Royal Tulip Springhill Resort is just minutes away from the sun kissed Jimbaran and Tegal Wangi beach, Jimbaran’s local seafood market, and a popular tourist destination in South Bali: the Rock Bar. Ngurah Rai International airport is only a 25 minute trip with complimentary airport shuttle services available.\r\nStay and explore the rich Balinese culture Jimbaran has to offer. Or venture further to discover Bali’s most traditional sights such as the Uluwatu temple, Garuda Wisnu Kencana, and the many magnificent beaches spread out across Southern Bali. ','','','','','','','','','','','','Jalan Jepun Jimbaran 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001879','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14673,746,'','','Transera Kamini Legian Hotel','Transera Kamini Legian Hotel',NULL,'Transera Kamini Legian is located in central Legian, including 26 rooms - 9 Superior Rooms, 16 Deluxe Rooms, and 1 Suite Room. Surrounded by tropical gardens, Transera is positioned to offer tranquility and guest privacy. Other hotel facilities include a restaurant, games area, and 24 hour reception and security.\r\n\r\nTransera Kamini Legian combines maximum privacy with luxurious amenities that invite guests to experience the pleasures of tropical living. The gracious Balinese hospitality and modern facilities will enrich the quality of your stay.','','','','','','','','','','','','Jl. Raya Legian, Gg. Troppozone Kuta 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001804','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14672,746,'','','Wyndham Garden Kuta Beach Bali','Wyndham Garden Kuta Beach Bali',NULL,'Enjoy breathtaking views of Kuta Beach from ocean-facing balconies of our spacious guest rooms at Wyndham Garden Kuta Beach. Our beachfront hotel is located a few minutes’ drive from Ngurah Rai International Airport and offers a host of amenities like complimentary Wi-Fi, access to rooftop spa overlooking the sea, airport shuttle and free parking.','','','','','','','','','','','','Jl. Pantai Kuta 99X Kuta ',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001798','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14671,746,'','','Ramada by Wyndham Sunset Road Bali','Ramada by Wyndham Sunset Road Bali',NULL,'Just above the southern tip of Bali, in the midst of downtown Kuta, sits a hidden gem that blends inspired, urban style with the feel of a coastal Indonesian resort. Here, the sands of Kuta Beach wait just down the road, a rooftop pool inspires days spent basking in the Bali sun, and a world-class spa invites serenity and calm. Dine on authentic Indonesian-inspired dishes and Asian fusion cuisine at our lobby lounge restaurant, or sip your favourite drink poolside.\r\n \r\nAccommodations invoke the spirit of the island, with glass-enclosed rain showers and floor-to-ceiling windows that bathe rooms in natural light. Soak up everything there is to see and do, with the sights of Kuta, Seminyak and Legian just beyond our doors, and Bali\'s bustling shops, cultural stops and coastal waters within easy reach.','','','','','','','','','','','','Jl Sunset Road No 9 Kuta 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001796','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14670,746,'','','Bisma Cottages Ubud','Bisma Cottages Ubud',NULL,'Bisma Cottages is for those seeking good quality, reasonably priced accommodation in a peaceful and relaxed retreat in central Ubud.\r\n\r\nLocated on Bisma Street (Jalan Bisma), only a 10 minute walk to the Monkey Forest and 20 minutes to Ubud Town where the Ubud Market and Ubud Palace are located. Bisma Street itself has an abundance of eateries, spas and galleries set amongst rice paddies.\r\n\r\nWhen staying at Bisma Cottages the hustle and bustle of Ubud is here for the taking or if you choose while away the day reading a book or swimming in the pool the tranquility is yours to enjoy.\r\n\r\nBisma Cottages offer two styles of cottage accommodation amongst a nicely landscaped garden adorned with classic Balinese statues and an attractive swimming pool area.\r\n\r\nThe four recently completed wooden Joglo rooms provide a unique accommodation experience whilst still having clean and modern facilities.\r\n\r\nThe two deluxe cottages offer more privacy at the rear of the property. These are larger in size (36m2) and more modern in design. Deluxe Cottages are suited for families as extra beds or baby cots can be provided.','','','','','','','','','','','','Jl. Bisma No. 35 Ubud 80571',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001783','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14669,746,'','','Private Villas of Bali','Private Villas of Bali',NULL,'Private Villas of Bali, featuring two sprawling luxury ocean facing pool villas, is located in an exclusive cliff top estate on Bukit Pandawa, between Nusa Dua and Uluwatu. The villas are set 90 metres above the white sands and pristine waters of Pandawa Beach and offer a wonderful array of luxury facilities, perfect for large family holidays and special occasions.\r\n\r\nEnjoy stunning surrounding ocean views, spectacular private swimming pools, cool breezes, soothing music and the faint sounds of the waves crashing on Pandawa Beach directly below the cliff. \r\n\r\nTwo world class golf courses (Nusa Dua and Pecatu) are only 20 minutes away whilst the adjacent “Bukit Pandawa Golf Course” has just opened. The villas further offer easy access to some of Bali’s best beaches and surf sites and a wide variety of restaurants, hotels and shops in Nusa Dua and Jimbaran, with its famous seafood restaurants. With the new over water Mandara expressway even Seminyak and Sanur are now within easy reach.\r\n\r\nEach villa offers several dining and living rooms, an open kitchen, ocean view terraces and dramatic pool settings and have a variety of king and twin bedded suites and studios, all with full en-suite bathrooms. Complimentary broadband Wi-Fi, cable TV, extensive movie and song libraries, a Play station 4 console and multi zone Bose sound systems are available.\r\n\r\nThese beautiful life style villas are the perfect venues for blissful stays and private escapes, intimate gatherings, celebrations and extended stays or even small corporate gatherings and meetings.\r\n\r\nThe villas can be rented individually or together ( they are only 120 metres apart within the same gated community)  and should there be a need for additional accommodation, arrangements can be made with neighbouring villas. The professionally trained teams, including dedicted villa chefs, prides itself on their warm-hearted, intuitive and pampering services and delicious villa cuisine with homecooked Indonesian, Balinese and International specialties. \r\n\r\nBlissful and relaxing massages, manicure and pedicure treatments  on the private Spa Terrace can be arranged by appointment and we glaldy assist with planning activities of the entire family.\r\n\r\nSpecial rates have been established for 2016 due to the development work taking place on Bukit Pandawa.  A true luxury experience and lasting memories of the magical Island of Bali await you and they look forward to welcoming you to this little paradise on the cliff.\r\n','','','','','','','','','','','','Gapura Vista Residences Bukit Pandawa Jl. Pura Melang Kelod Banjar Pantigiri - Desa Kutuh Nusa Dua 8',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001613','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14668,746,'','','Khayangan Kemenuh Villas','Khayangan Kemenuh Villas',NULL,'The Legend of Khayangan Villas – A collection of 2-bedroom and 3-bedroom villas, surrounded amidst lush greenery rice field and natural hidden river within the neighborhood of the traditional Sukawati village and the famous Tegenungan waterfall. A sanctuary villa with thousand natural touches of wonder.\r\nThis very intimate property has only 6-units private villas and is exclusively with luxury private pool. Each villa is entirely private and self contained, allowing guests total relaxation for their honeymoon or retreat with their family.','','','','','','','','','','','','Jalan Raya Ir. Sutami, Tegenungan, Kemenuh, Gianyar Sukawati Kuta 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001537','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14667,746,'','','Abia Villas Legian','Abia Villas Legian',NULL,'Abia Villas Legian is a stylish complex of just 15 luxury villas designed to bring elegance to one of Bali’s favourite tourism districts. The property is the epitome of tropical sophistication where modern travellers can enjoy a carefree break along with all the privileges of island living.\r\n\r\nThis collection of private villas takes contemporary Balinese design to the next level through original works of local artistry and particular attention to detail. Hospitality at Abia Villas Legian is warm and personalized with all needs taken care of before they are even recognised.\r\n\r\nAbia Villas Legian is a boutique haven that that perfectly suits the privacy needs of honeymoon couples celebrating their love. Family travellers will also appreciate the home comforts of this smart property as well as its relative proximity to the Legian’s famed sunset beach.','','','','','','','','','','','','Jalan Raya Legian II, Gang XX Kuta 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001533','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14666,746,'','','Ossotel Legian','Ossotel Legian',NULL,'OSSOTEL is organic in its conception and operation, stylish but not pretentious. We are modern, we like simple pleasures and design that works. The modern tropical design fuses simplicity and functionality, from the architecture to our tailored service showcasing a new breed of Balinese hospitality amongst Bali modern hotels.\r\n\r\nOSSOTEL sits right in the centre of the iconic Padma Legian beach neighbourhood, a stone\'s throw from the ocean and a short walk to the Island\'s bars, restaurants, and vibrant club scene.\r\n\r\nSoak up the sun in our 88 metre pool and head to \"ROMEOS\" Bar and Grillery for a gastronomic experience of culinary delights and signature cocktails in a relaxed rustic ambience.','','','','','','','','','','','','Jl. Padma Utara, Legian Kuta 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001526','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14665,746,'','','B & B Style Seminyak','B & B Style Seminyak',NULL,'bnb Style Hotel Seminyak is bed & breakfast style hotel in the evolving lifestyle district of Seminyak. It is a smart base catering to the needs of savvy travellers with 35 smart, stylish and simple - appointed rooms along with an array of modern facilities. The property is within easy walking distance to the hip places in Seminyak as well many popular dining and shopping alternative that have made the area so desirable.\r\n','','','','','','','','','','','','Jalan Kunti No 9 Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001518','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14664,746,'','','DOUBLE-SIX LUXURY HOTEL SEMINYAK','DOUBLE-SIX LUXURY HOTEL SEMINYAK',NULL,'How do you define living it all? At DOUBLE-SIX LUXURY HOTEL, Seminyak, a new chapter in stylish eachside living comes to life right in front of your very eyes. \r\n\r\nCreate. Play. Lounge. Splurge.\r\nCelebrate your stylish lifestyle within the pure comfort of a Double-Six suite, your home away from home. Take in the sunset, ask the butler to pop open a bottle of champagne, chat with the chef or do nothing at all. The choice is yours.\r\n\r\nWhen the mood strikes, go for a barefoot walk along the beach or indulge in a playful splash at the edge of our 120-metre pool.\r\nAt Double-Six, you are invited to live it all.\r\n\r\nIntroducing first-class accommodation appointed with professional and personalized service, the new Double-Six, Luxury Hotel, Seminyak features uninterrupted beach frontage overlooking the famous Seminyak coastline; a coveted destination for lifestyle travellers.\r\n\r\nDOUBLE-SIX, LUXURY HOTEL, SEMINYAK is a reinvention of a renowned Balinese destination- the Double Six club. Two years ago a lavish farewell party was held when the doors of the club closed, attracting fans from around the world to its final celebration.','','','','','','','','','','','','No. 66 Double Six Beach Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001515','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14663,746,'','','Blu-Zea Resort by Double-Six','Blu-Zea Resort by Double-Six',NULL,'Located centrally in hip and happening Seminyak, is close to restaurants, boutiques, spas and Bali’s most flamboyant nightlife, yet only a short walk from the beach and magical Seminyak sunsets. \r\nRecently refurbished, the resort’s facilities provide everything that the modern traveler and family expects on their vacation: Internet and cable TV in every room, a kid’s club, two bars, a restaurant serving only the best local and western favourites, a spa centre as well as a list of recreational facilities like the pool that is easily accessed from all rooms that runs the length and breadth of the resort. \r\nHighlighting the resort’s focus on families and the young is the Kids’ Club with its staff of qualified and experienced child minders where guests can leave their children knowing that they will be in the best of hands. And with the many planned activities it leaves parents free to relax and enjoy their holiday. \r\nFor some it’s the perfect opportunity to make use of the spa that offers traditional and Balinese treatments to help you unwind after a busy day of fun in the sun. \r\nThe personal touch, friendliness and hospitality of the staff at Blu-Zea Resort by Double-Six will ensure your stay is a memorable one.','','','','','','','','','','','','Jl. Camplung Tanduk 66 Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001514','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14662,746,'','','Downtown Boutique Villas','Downtown Boutique Villas',NULL,'Nine luxuriously appointed villas in the heart of Seminyak offer Bali\'s most exclusive accommodation for discerning guests.\r\n\r\nPerfectly situated just 2 minutes walk from the heart of Bali\'s trendy & chic district of Seminyak, Downtown\'s nine luxury villas, crafted into 1, 2 and 3 bedroom configurations are stylishly equipped with contemporary art & imported designer furniture & homeware.\r\n\r\nAll villas include a 20m lap pool (private plunge pool for 1 bedroom villas), fully equipped kitchens, broadband internet access and more than 37 cable TV channels delivered via LCD screen technology.\r\n\r\nDowntown\'s Ku de Ta-trained chefs, together with a full room service menu, give total flexibility to suit dining preferences.\r\n\r\nFor those seeking to keep fit whilst on holiday, Downtown\'s fitness centre comes equipped with a multi-gym, cardio workout equipment & more.\r\n\r\nDowntown Villas - Bali\'s first and only luxurious modern contemporary villa resort.','','','','','','','','','','','','Jalan Pura Dalem 9d Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001513','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14661,746,'','','Fare Ti\'I','Fare Ti\'I',NULL,'Conveniently located in the beautiful surf area of Pererenan Village, Fare Ti’I Villas combine traditional Balinese architecture with modern home comfort and convenience. Each villa is separated by a generous exotic garden environment, giving a tropical experience of Bali that will last a lifetime. Just a short drive to Tanah Lot and Canggu Beach, this part of Premier Element by Premier Hospitality Asia’s collection is an exotic place to spend your holiday.\r\n','','','','','','','','','','','','Jl. Pantai Pererenan, Br. Pengembungan, Desa Pererenan Canggu ',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001341','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14660,746,'','','Transera Grand Kancana Villa','Transera Grand Kancana Villa',NULL,'Transera Grand Kancana Resort Villas  is a stylish retreat designed to capture the restful ambience of a traditional Balinese village. A collection of 30 luxury villas are spread across a landscape of tropical greenery in a concept that harmonizes with the surrounding environment.\r\n\r\nThe property truly anticipates the travel needs of honeymooners and couples seeking private villa Seminyak Bali time alone.   \r\n\r\nTransera Grand Kancana Resort Villas is located on the artistic outskirts of the Seminyak. It is just minutes from the island’s best boutiques as well as an excellent wining and dining scene. Seminyak’s stretch of sunset beach is just a short drive away for a day of sun, sea and Bali’s famous surf culture. The property is central to everything and the airport can be reached in 20 minutes.\r\n\r\nThe sheer size of Transera Grand Kancana Resort Villas  makes it the perfect venue for destination weddings and celebrations of the heart. There is ample space to perform a garden ceremony before a gathering of loved ones by the main pool. Teras Bistro restaurant can also host up to 100 guests for an elegant cocktail reception or formal dinner.','','','','','','','','','','','','Jl. Gunung Jayawijaya no 494 Kerobakan, Seminyak ',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001296','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14659,746,'','','Royal Kamuela Ubud','Royal Kamuela Ubud',NULL,'Royal Kameula Ubud – Monkey Forest, is located in the heart of Ubud (about 1 hr from the airport). Monkey Forest is a short 5 min walk from the hotel, as is a wide variety of art shops, temples, rice fields, and traditional Balinese restaurants.\r\n\r\nThis very intimate property has only 6 one bedroom private pool villas, and is exclusively for adults – no children allowed.  Each villa is entirely private and self contained, allowing guests total relaxation for their honeymoon or retreat.\r\n\r\nPlease note: Check in/ check out is not allowed on Balinese Seclusion\'s Day (Nyepi Day) - 28 March 2017.','','','','','','','','','','','','Monkey Forest Ubud ',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001213','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14658,746,'','','Kamuela Villas - Seminyak','Kamuela Villas - Seminyak',NULL,'Kamuela Villas are amongst Bali\'s finest, and have won world wide accolades for their beautiful settings, intriguing design and outstanding service. A blissful stay and a most memorable vacation is guaranteed.\r\n\r\nKamuela Seminyak is located in the trendy southern area of Bali; just north of the Legian and Kuta region.\r\n\r\nKamuela Villas offer one bedroom and two bedroom private pool villas. Each villa is entirely private and self contained, allowing guests total relaxation for a honeymoon or retreat.\r\nOne bedroom villas feature a second floor sun terrace. Two Bedroom villas are one level and come with an open air living and dining area perfect for entertaining.\r\nKamuela Villas - Seminyak is an adults only resort\r\n\r\nPlease note: Check in/ check out is not allowed on Balinese Seclusion\'s Day (Nyepi Day) - 28 March 2017.','','','','','','','','','','','','Jalan Bali Deli No. 88 Seminyak ',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7001212','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes'),(14657,746,'','','eqUILIBRIA SEMINYAK','eqUILIBRIA SEMINYAK',NULL,'Renowned for its creativity and dedication to green issues, eqUILIBRIA SEMINYAK is one of the world’s first hotels to showcase its unique “waterfall” design concept, custom iConcierge iPhone apps, 100% Bamboo Linen and a complete green design concept in its architectural design. It also offers a host of other exclusive services such as full butler services and complimentary access to Bali\'s premier member\'s only country club, Canggu Club.\r\n\r\neqUILIBRIA SEMINYAK is the product of passion. A passion for life, unparalleled services, technology, luxury, wellness and most importantly, the belief that we can all make a difference for a better tomorrow. \r\nIt is not often in life that you get to be part of something special. This property invites you to join them in their quest to redefine luxury.\r\n','','','','','','','','','','','','Jalan Wirasaba No 5, Off Jalan Kayu Aya Seminyak 80361',119,'',104,0,'','','','bookings@leisurecom.com','','',14,'','','','','7000991','','','','0000-00-00','0000-00-00','open','','',1,NULL,'','','',NULL,' ',' ',NULL,14,2,NULL,'N','','',1.0,'AAA',0.0,NULL,0.00,'Per Person',0.00,'No',NULL,'','',NULL,NULL,NULL,0.00,25.00,2,'Yes','N','N','N','',0,0,'','','','','','','','','','','','','','',0,0,'0000-00-00 00:00:00',0,'Yes');

--
-- Table structure for table `propertycomments`
--

CREATE TABLE `propertycomments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `comment` text NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `administrator_id` int(10) NOT NULL DEFAULT '0',
  `created_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertycomments`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertycomments` VALUES (43,'','<strong>From:</strong> The Phoenician Administration &lt;<a href=\"mailto:admin@phoenician.com.au\">admin@phoenician.com.au</a>&gt;<br />\r\n<strong>Sent:</strong> Thursday, 23 July 2020 3:24 PM<br />\r\n<strong>To:</strong> Katrina South &lt;<a href=\"mailto:Katrina.South@leisure.com.au\">Katrina.South@leisure.com.au</a>&gt;<br />\r\n<strong>Subject:</strong> RE: agreement<br />\r\n&nbsp;<br />\r\nHi Katrina,<br />\r\n&nbsp;<br />\r\nThank you for your time on the phone.<br />\r\n&nbsp;<br />\r\nPlease find attached signed copy of agreement.<br />\r\n&nbsp;<br />\r\nLook forward to working with you and the team.<br />\r\n&nbsp;<br />\r\nThanks Katrina<br />\r\n&nbsp;<br />\r\nKind regards,<br />\r\n&nbsp;<br />\r\nIsabelle Lofthouse<br />\r\n<br />\r\n',3076,4,'2020-07-27 13:48:45'),(42,'','27 Jul 2020 - Property reinstated and added to distribution channels',3076,4,'2020-07-27 13:47:23'),(41,'','<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisure.com.au\">mailto:michelle.wyer@leisure.com.au</a>]<br />\r\n<strong>Sent:</strong> Friday, 25 May 2018 10:37 AM<br />\r\n<strong>To:</strong> &#39;reservations@phoenician.com.au&#39;<br />\r\n<strong>Subject:</strong> RE: Leisure Group<br />\r\n<strong>Importance:</strong> High<br />\r\n&nbsp;<br />\r\nHi Renae<br />\r\n&nbsp;<br />\r\nHope you are well.<br />\r\nI just realised that I haven&#39;t terminated you in our system as yet. I will do this now...My apologies.<br />\r\nCould you please advise if you would like to continue working with us?<br />\r\nPhoenician is a very popular product with our customers and it would be fantastic to come to an arrangement that benefits us both.<br />\r\n&nbsp;<br />\r\nKind regards<br />\r\n&nbsp;<br />\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				Michelle Wyer<br />\r\n				Product Executive<br />\r\n				<strong>Leisure Group</strong><br />\r\n				<strong>e: </strong><a href=\"mailto:michelle.wyer@leisure.com.au\">michelle.wyer@leisure.com.au</a><br />\r\n				<strong>t:</strong> 07 5555 1818</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<br />\r\n',3076,4,'2020-07-27 13:46:43'),(40,'','<strong>From:</strong> <a href=\"mailto:reservations@phoenician.com.au\">reservations@phoenician.com.au</a> [<a href=\"mailto:reservations@phoenician.com.au\">mailto:reservations@phoenician.com.au</a>]<br />\r\n<strong>Sent:</strong> Tuesday, 9 January 2018 3:53 PM<br />\r\n<strong>To:</strong> Michelle Wyer<br />\r\n<strong>Subject:</strong> RE: Leisure Group<br />\r\n&nbsp;<br />\r\nHi,<br />\r\n&nbsp;<br />\r\nThank you for your email. I have spoken to Roger and we would like to give notice to terminate the&nbsp; attached contract. We understand that this will take 3 months. We will then look at either a reduction in commission or look at doing another contract with contracted nett rates. Thank you.<br />\r\n&nbsp;<br />\r\n&nbsp;<br />\r\nKind Regards,<br />\r\n&nbsp;<br />\r\n<strong>Renae Ireland </strong><br />\r\n&nbsp;<br />\r\nReservations Manager&nbsp;<br />\r\n<br />\r\n',3076,4,'2020-07-27 13:46:14'),(39,'','21Apr20 - Property disabled as it has gone to residential',13088,4,'2020-04-21 09:15:55'),(38,'','15Apr20 - disabled due to no bookings since 2017 and no rates received or channel manager',8845,4,'2020-04-15 15:51:52'),(37,'','Originally contracted with Dreamtime Resorts',2978,4,'2020-04-09 14:23:37'),(36,'','19Dec19 - Change of management',27,4,'2020-04-09 13:44:13'),(35,'','10Oct2016 - Management changed',3945,4,'2020-04-09 10:37:49'),(34,'','24Jul19 - name change from Coral Sea Resort to Coral Sea Marina Resort',257,4,'2020-04-08 11:38:23'),(33,'','Property removed from distribution channels on 10Sep19 due to bushfire loss',11873,4,'2020-04-08 11:04:47'),(32,'','Property disabled. No bookings since 2015 and no response to contract rate requests.',284,4,'2020-04-08 10:26:55'),(31,'','Property disabled due to management change. Now ibis Styles Port Macqarie.<br />\r\nLast booking made August 2017.',9018,4,'2020-04-08 10:25:37'),(30,'','Property closed from 4 April to 31 May 2020 due to COVID-19',12569,4,'2020-04-08 08:21:01'),(29,'','Property removed from distribution channels as resort closed permanently due to COVID-19.',12269,4,'2020-04-08 08:16:33'),(28,'','21Jul16 - property added via email (no contract)',9564,4,'2020-04-01 09:43:05'),(27,'','21Jul16 - property added via email (no contract)',3917,4,'2020-04-01 09:42:49'),(26,'','21Jul16 - property added via email (no contract)',9563,4,'2020-04-01 09:42:23'),(25,'','9Sep19 - Property closed',211,4,'2020-04-01 09:16:34'),(24,'','Spoke to Jess, confirmed happy for us to go out on Monday the 3rd and the affiliates on tghe 20th (thereablouts) Sep.&nbsp;',9413,5,'2018-08-29 11:22:36'),(23,'','Removed from distribution channels until new contract is received.<br />\r\n<br />\r\nGood afternoon,<br />\r\n<br />\r\nThank you for your support of the Chifley Plaza Townsville. The hotel has re-branded to Madison Plaza Townsville effective immediately.<br />\r\n<br />\r\nIt is our understanding that the new management are keen to continue working with LeisureCom Travel Group and welcoming your travellers to Townsville.&nbsp;<br />\r\n<br />\r\nIf you would like to confirm your contracted rates with the property please contact the hotel directly on the below details:<br />\r\n<br />\r\nSharna Baldonado<br />\r\nMadison Plaza Townsville<br />\r\nPh: 07 4772 1888 E: <a href=\"mailto:manager@madisontownsville.com.au\">manager@madisontownsville.com.au</a><br />\r\n<br />\r\nWe appreciate the support shown to Chifley Plaza Townsville by LeisureCom Travel Group, and we look forward to continuing to work with you across our network of Next Hotels.<br />\r\n<br />\r\nWarm Regards,<br />\r\n<br />\r\nSharon Cauldwell<br />\r\n<a href=\"mailto:sales@nextstory.com\">sales@nextstory.com</a><br />\r\n0416 010 129',9210,4,'2017-08-31 13:24:32'),(22,'','Spoke to Rod sent LC information about reconnecting - Will follow up next week :)',128,5,'2017-03-01 16:03:42'),(21,'','<p>\r\n	<br />\r\n	Hi Sharyon,<br />\r\n	<br />\r\n	Thanks for the quick chat today, as discussed I have temporarily held the date of 27<sup>th</sup> March to run our promotion for Elysium Palm Cove.<br />\r\n	<br />\r\n	The promotion I had in mind was a <strong>HOT DEAL</strong> for both our Retail and Member Program. The deal should run exclusively with LeisureCom for the sale period which would be one week from the 27<sup>th</sup> March.<br />\r\n	<br />\r\n	Deals that typically work are our <strong>&lsquo;Stay Pay&rsquo;</strong> offers and value add deals for example Breakfast included, Late check out, Free Wifi, Spa vouchers etc. If the value of the offer is what we would consider a Catalogy A offer we may be able to run an Property Specific EDM, Deal of the Week or even a 3 Day Sale.<br />\r\n	<br />\r\n	I have also attached our company PDF for your perusal, I am sure Martin went through this with you anyway as well as a marketing Agreement <em><u>please only complete the Specials section as we already have the other details</u></em> J<br />\r\n	<br />\r\n	<br />\r\n	<strong><u>Applicable LeisureCom Brands</u></strong></p>\r\n<p>\r\n</p>\r\n<ul>\r\n	<li>\r\n		Discover Queensland</li>\r\n	<li>\r\n		Hightide Holidays Membership Travel Club (Paid Closed- User Member)</li>\r\n</ul>\r\n<p style=\"margin-left:36.0pt;\">\r\n</p>\r\n<p>\r\n	<strong><u>Promotion Channels</u></strong></p>\r\n<p>\r\n</p>\r\n<p>\r\n	The majority of business will be driven from our Discover Queensland brand, and as a partnered property Hamilton Island will have access to be featured to our loyal customers via:</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Facebook </strong>- 182,000 Followers - &nbsp;<a href=\"www.facebook.com/discoverqueensland\">www.facebook.com/discoverqueensland</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Instagram</strong> - 65,000 Followers - <a href=\"https://www.instagram.com/discoverqueensland/\">https://www.instagram.com/discoverqueensland/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	170,000 <strong>Email Database</strong> - Strong female (35 - 55yrs) &amp; family skew who have signed up to receive premium 4-5 Star Queensland holiday offers</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Hightide Holidays</strong> - 80,000 Email Database with baby-boomer skew and marginal family skew</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong><u>Promotion Opportunities</u></strong></p>\r\n<p>\r\n</p>\r\n<p>\r\n	In additional to year-round business, we also offer the following campaign options to assist with driving base business or to fill gaps as required:</p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Hot Deals (premium website placement): <a href=\"http://www.discoverqueensland.com.au/hot-deals/\">http://www.discoverqueensland.com.au/hot-deals/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- 3 Day Sales (Avg. 1,000 - 2,500 room nights per sale) <a href=\"http://www.discoverqueensland.com.au/offers/979/email/\">http://www.discoverqueensland.com.au/offers/979/email/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Deal of the Week (Avg. 500 - 1,500 room nights per sale) &nbsp;<a href=\"http://www.discoverqueensland.com.au/newsletter/1190/email/\">http://www.discoverqueensland.com.au/newsletter/1190/email/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Monthly featured Hot Deals EDM &nbsp;<a href=\"http://www.discoverqueensland.com.au/newsletter/1186/email/?preview=true\">http://www.discoverqueensland.com.au/newsletter/1186/email/?preview=true</a></p>\r\n<p>\r\n	<br />\r\n	Thanks again Sharyon,</p>\r\n',9641,5,'2017-02-22 14:33:38'),(20,'','<p>\r\n	Hey Mish,</p>\r\n<p>\r\n	Can you please change the e-mail for Ibis Styles Katherine to</p>\r\n<p>\r\n	<a href=\"mailto:h3112-re01@accor.com\">h3112-re01@accor.com</a></p>\r\n<p>\r\n	the one that is currently loaded is for Ibis Styles Alice Springs. Cheers J</p>\r\n<p>\r\n	Kind Regards,<br />\r\n	Dee Riediger</p>\r\n<p>\r\n	<strong>Reservations Consultant </strong><br />\r\n	Email: <a href=\"mailto:dee.riediger@leisurecom.com\">dee.riediger@leisurecom.com</a><br />\r\n	Direct: 07 5581 2409</p>\r\nLevel 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\nPO Box 3419, Australia Fair, QLD 4215<br />\r\nT: +61 7 5555 1800<br />\r\nF: +61 7 5531 1350<br />\r\nW: <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a>',9035,4,'2017-01-12 13:54:58'),(19,'','Property disabled from channels due to closure (see email)',3714,4,'2016-09-20 14:14:00'),(18,'','<p>\r\n	All fixed :)</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Christie [<a href=\"mailto:christie@1800schoolies.com.au\">mailto:christie@1800schoolies.com.au</a>]<br />\r\n	<strong>Sent:</strong> Wednesday, 7 September 2016 1:48 PM<br />\r\n	<strong>To:</strong> Michelle Wyer<br />\r\n	<strong>Subject:</strong> Hilton Week 1, 2016</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					Hey Mish,</p>\r\n				<p>\r\n					<br />\r\n					Can you please update the website for Hilton Week 1 this year 2 Deluxe Residence to available as we have had a lot of cancellation.</p>\r\n				<p>\r\n					If we could please add 10 to the allotment that would be awesome.</p>\r\n				<p>\r\n					Kind Regards,<br />\r\n					Christie Thompson</p>\r\n				<p>\r\n					<strong>Reservations Consultant </strong><br />\r\n					Email: <a href=\"mailto:Christie@1800schoolies.com.au\">Christie@1800schoolies.com.au</a><br />\r\n					Direct: 07 5581 2453</p>\r\n				<p>\r\n					Level 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\n					PO Box 3419, Australia Fair, QLD 4215<br />\r\n					T: +61 7 5555 1800<br />\r\n					F: +61 7 5531 1350<br />\r\n					W: <a href=\"http://www.1800schoolies.com.au\">www.1800schoolies.com.au</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n</p>\r\n',3944,4,'2016-09-07 13:58:27'),(17,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks for sending these through, much appreciated.</p>\r\n<p>\r\n	As requested please find attached our Credit Application form for your completion.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I&rsquo;ll complete your marketing agreements for both 16.17 and 17.18 and get these back to you ASAP.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:16:44'),(16,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	As promised please find attached your completed Marketing Agreement for both 16.17 and 17.18.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I noticed your agreements didn&rsquo;t have any sections to include our bonus offers. Do you have another form for me to complete for these?</p>\r\n<p>\r\n	I&rsquo;m quite interested in looking to promote our upcoming Stay 4, Pay 3 offer to your databases &ndash; the travel period starts 17 October through to 09 December 2016, inclusive.</p>\r\n<p>\r\n	Can you let me know if this will be possible?</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Please let me know if you require any further assistance or information.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:16:09'),(15,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Please find attached our current activities list &ndash; please note that all prices are non-commissionable.<br />\r\n	Also listed in this attachment are a sample of our daily Orpheus Experience tours/activities that are included in our room rates.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Let me know if you have any further queries.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisurecom.com\">mailto:michelle.wyer@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 4:43 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Tammy</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Appreciate your quick reply thanks.</p>\r\n<p>\r\n	I&#39;m wondering if you have a simple list of resort activities?</p>\r\n<p>\r\n	I&#39;ve had a look through your website and your e-brochure etc and the main things I can see are diving, snorkelling, dinghy adventure, research station tour and cruises.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks</p>\r\n<p>\r\n	Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Tammy Baczynski [<a href=\"mailto:Tammy@orpheus.com.au\">mailto:Tammy@orpheus.com.au</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 3:40 PM<br />\r\n	<strong>To:</strong> &#39;Michelle Wyer&#39;<br />\r\n	<strong>Cc:</strong> &#39;Rebecca Tarrant&#39;; &#39;martin.peirone@leisurecom.com&#39;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks for sending these through, much appreciated.</p>\r\n<p>\r\n	As requested please find attached our Credit Application form for your completion.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I&rsquo;ll complete your marketing agreements for both 16.17 and 17.18 and get these back to you ASAP.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisurecom.com\">mailto:michelle.wyer@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 2:56 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Cc:</strong> &#39;Rebecca Tarrant&#39; &lt;<a href=\"mailto:rebecca.tarrant@leisurecom.com\">rebecca.tarrant@leisurecom.com</a>&gt;; <a href=\"mailto:martin.peirone@leisurecom.com\">martin.peirone@leisurecom.com</a><br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Tammy</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Many thanks for sending through the contracts. I have attached the signed copies of each.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For our records, could you please complete and return our 2016/17 Marketing Agreement?</p>\r\n<p>\r\n	Also attached is our remittance process to explain how we pay you.</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Do we need to complete a credit application? If so, please forward it to me and I&#39;ll pass it onto our accounts department.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	If you have any questions, please don&#39;t hesitate to contact me.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Kind regards</p>\r\n<p>\r\n	Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<img alt=\"email footer10.jpg\" border=\"0\" height=\"252\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image001.jpg\" style=\"height:2.625in;width:9.916in;\" width=\"952\" /></p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Rebecca Tarrant [<a href=\"mailto:rebecca.tarrant@leisurecom.com\">mailto:rebecca.tarrant@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Thursday, 1 September 2016 1:43 PM<br />\r\n	<strong>To:</strong> <a href=\"mailto:martin.peirone@leisurecom.com\">martin.peirone@leisurecom.com</a>; &#39;Michelle Wyer&#39;<br />\r\n	<strong>Cc:</strong> <a href=\"mailto:karsha.stewart@leisurecom.com\">karsha.stewart@leisurecom.com</a>; &#39;Dan Berman&#39;<br />\r\n	<strong>Subject:</strong> FW: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Tammy Baczynski [<a href=\"mailto:Tammy@orpheus.com.au\">mailto:Tammy@orpheus.com.au</a>]<br />\r\n	<strong>Sent:</strong> Thursday, September 1, 2016 1:39 PM<br />\r\n	<strong>To:</strong> &#39;Rebecca Tarrant&#39;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Rebecca</p>\r\n<p>\r\n</p>\r\n<p>\r\n	It was great to chat with you the other week and in reviewing this information we would love to work with Leisure.com.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	As this is a new relationship, I have attached 20% commissionable contracts for both the remainder of 2016.17 and 2017.18.</p>\r\n<p>\r\n	We can review this in 12months to discuss a possible change in commission.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For 2016.17 there are 3 x contracts:</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Nightly rates</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pay 3, Stay 4</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orpheus Experience (10% off all year, min 4nts)</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For 2017.18, I have consolidated the contracts into one document (much easier).</p>\r\n<p>\r\n	Can you please review, sign off and return a copy by email to accept?</p>\r\n<p>\r\n	FYI, there is no signature page on the 2016.17 documents, however please print and sign your name and date the front page of each.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	At present our Stay 4, Pay 3 offer kicks in for travel from 18 Oct &ndash; 09 Dec 16. I&rsquo;d be interested in working with you on a campaign for this offer.</p>\r\n<p>\r\n	FYI our domestic avg. booking lead in is 6-8 weeks.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Also here is a <a href=\"https://www.dropbox.com/sh/yorgpt177zvtz93/AABs3dbXdlEYvIoA5SODj3QFa?dl=0\">Dropbox download link</a> to our gorgeous image library for your use, please credit all images to Orpheus Island.</p>\r\n<p>\r\n	It is a requirement to send a proof for sign off to myself before distribution of any of our images.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I have also attached some editorial and here is a link to our <a href=\"http://www.orpheus.com.au/wp-content/uploads/2015/04/Orpheus-E-Brochure.pdf\">Orpheus eBrochure</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	I think I have covered everything to get us started. Please let me know if there is anything else I can help you with.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I look forward to working with you.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	magical Orpheus awaits,</p>\r\n<p>\r\n	Tammy Baczynski</p>\r\n<p>\r\n	Sales &amp; Marketing Manager</p>\r\n<p>\r\n	<strong><img alt=\"Orpheus_logo_Olive small (HR)\" border=\"0\" height=\"116\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image002.jpg\" style=\"height:1.208in;width:2.166in;\" width=\"208\" /></strong></p>\r\n<p>\r\n	Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 (0) 7 4722 2223</p>\r\n<p>\r\n	Email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"mailto:tammy@orpheus.com.au\">tammy@orpheus.com.au</a></p>\r\n<p>\r\n	Web&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http://www.orpheus.com.au/\">www.orpheus.com.au</a></p>\r\n<p>\r\n	Mob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 476 814 865</p>\r\n<p>\r\n	Fax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 (0) 3 8644 4001</p>\r\n<p>\r\n	Mail&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;PO Box 549, Garbutt East QLD Australia 4814</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Rebecca Tarrant [<a href=\"mailto:rebecca.tarrant@leisurecom.com\">mailto:rebecca.tarrant@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Wednesday, 17 August 2016 3:29 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Subject:</strong> LeisureCom<br />\r\n	<strong>Importance:</strong> High</p>\r\n<p>\r\n</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"height:10px;\">\r\n				<p>\r\n					<img alt=\"http://www.leisurecom.com/images/ems/1px-trans.gif\" border=\"0\" height=\"32\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image003.gif\" style=\"height:.333in;width:.333in;\" width=\"32\" /></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					<img alt=\"LeisureCom Group Ltd\" border=\"0\" height=\"179\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image004.jpg\" style=\"height:1.864in;width:4.281in;\" width=\"411\" /></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					Hi Tammy,<br />\r\n					<br />\r\n					Was so lovely speaking with you and I am so excited about working together. Here is the company information and Channel manager form for any properties you have with Siteminder or Levart, we can connect pretty quickly and start sending 365 business. As discussed there may be some upcoming promotions that may suit your resorts. We have our 3 Day Sales these are heavily discounted specials usually up to 505 off with inclusions and we can typically produce around 2000 &ndash; 4000 room nights in the 3 days (depending on the deal). Other options are our Deal of the Week and normal EDM these would suit a lower discounted offer and could produce up to 1000 room nights, again depending on the offer. We have a database of 250,000 in our Discover Queenlsand brand and over 200,000 Closed user in our HighTide Member program, we could also access another 1,000,000 through our partners including Ambassador Card, AGL, NIB and more.<br />\r\n					<br />\r\n					Please check out our retail site <a href=\"http://www.discoverqueensland.com.au\">www.discoverqueensland.com.au</a> &nbsp;also our corporate site <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a><br />\r\n					<br />\r\n					Here is an example of our Marriott Surfers Paradise offer we did in April &ndash; This produced just shy of 2000 room nights<br />\r\n					<br />\r\n					<br />\r\n					EDM&nbsp; <a href=\"http://www.discoverqueensland.com.au/offers/436/email/?source=Newsletter\">http://www.discoverqueensland.com.au/offers/436/email/?source=Newsletter</a> &nbsp;<br />\r\n					<br />\r\n					TVC <a href=\"https://www.youtube.com/watch?v=TzYkQFOiO9k\">https://www.youtube.com/watch?v=TzYkQFOiO9k</a><br />\r\n					<br />\r\n					We typically work off a wholesale 25% for 365 business but can move on this when doing tactical campaigns like the above which would be 20%.<br />\r\n					<br />\r\n					There is no cost to you other than the commissions we make as we pay to promote your resort through our own networks and SEO/SEM.<br />\r\n					<br />\r\n					I think I covered everything if there is anything else please let me know, Thanks again<br />\r\n					<br />\r\n					Kind Regards,<br />\r\n					Rebecca Tarrant<br />\r\n					<br />\r\n					Email: <a href=\"mailto:Rebecca.Tarrant@leisurecom.com\">Rebecca.Tarrant@leisurecom.com</a><br />\r\n					Mobile: 0402 525 968</p>\r\n				<p>\r\n					Level 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\n					PO Box 3419, Australia Fair, QLD 4215<br />\r\n					T: +61 7 5555 1800<br />\r\n					F: +61 7 5531 1350<br />\r\n					W: <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:15:23'),(14,'','<p>\r\n	Hi Everyone,</p>\r\n<p>\r\n	An issue has just been discovered with the swimming pool at Artique Resort which has resulted in the need to drain the pool and instigate emergency repairs effective immediately.</p>\r\n<p>\r\n	At this stage we have been informed that the pool may be out of order up until approximately 9th September 2016, however we will update this site once a date has been confirmed as we hope the repairs will be completed sooner.</p>\r\n<p>\r\n	All other facilities, including our beautiful spa, steam room, sauna, gym, theatre &amp; BBQ area are available for guests to enjoy and we are currently sourcing temporary access for our guests to a pool at a nearby resort and will confirm when determined.</p>\r\n<p>\r\n	We deeply regret any inconvenience to our guests and should you have any questions or ongoing concerns, please do not hesitate to call us on 07 5564 3100. As a gesture of good faith, we have temporarily reduced rates at the resort during this time for new bookings.&nbsp; For existing bookings we are managing this at resort level as guests vary in their requirements however, we would welcome the opportunity to resolve any issues with your clients should there be any concerns.&nbsp;&nbsp;</p>\r\n<p>\r\n	We are very sorry for the inconvenience and appreciate your understanding in this unexpected situation.&nbsp;&nbsp; Could you please advise your who may be staying at Artique during this period and also place a notification on your website to cover guests wishing to <strong>TRAVEL</strong> before 9<sup>th</sup> September, 2016. &nbsp;&nbsp;WE will update you as soon as we are aware of the completion date.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thank you for your co-operation.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Kindest regards</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Steve Brewster&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n<p>\r\n	<strong>Director of Sales &amp; Marketing</strong></p>\r\n<p>\r\n	<strong><img alt=\"Icon jpeg for signature\" height=\"104\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image001.jpg\" style=\"height:1.083in;width:2.239in;\" width=\"215\" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></p>\r\n<p>\r\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n<p>\r\n	<strong>Icon Resort Apartments</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>Mobile:</strong> &nbsp;+61 412 641 203&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />\r\n	<strong>25 Surf Parade&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email:&nbsp;&nbsp; </strong>&nbsp;<u><a href=\"mailto:steve@iconresortapartments.com.au\">steve@iconresortapartments.com.au</a></u><br />\r\n	<strong>Broadbeach QLD 4218&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web:</strong>&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http://www.iconresortapartments.com.au/\">www.iconresortapartments.com.au</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n',30,4,'2016-08-29 09:32:07'),(13,'test','abakljl;jdfl;kjasd;lfkjas',2,4,'2016-08-24 10:00:44'),(12,'','Emailed Karla - Marketing &amp; Sales',130,5,'2015-06-17 12:19:42'),(11,'','new managers come is - GAVIN cb in a couple of weeks',18,5,'2015-05-13 14:05:37'),(10,'','call back week starting 18th as sandra on holidays',3883,5,'2015-05-13 14:03:24'),(9,'','called left msg for Heidi as Australian escapes rates cheaper ',3974,5,'2015-05-13 13:54:31'),(8,'','Spoke to Sandra she received email spending next week to go through and will touch base then :)',3883,5,'2015-04-16 11:37:29'),(7,'','Hi Larry,<br />\r\n<br />\r\nIt was great speaking with you today, we are constantly receiving requests for your resort as it was always very popular amongst our members both Escapes Club &amp; HighTide and would love to be able to send some bookings through. We also have our Retail distribution channel Discover QLD who would love to work with you and run some hot deals.<br />\r\n<br />\r\nI have put together some information about us at <a href=\"http://www.hightidemarketing.com.au\">www.hightidemarketing.com.au</a> as well as attached some info.<br />\r\n<br />\r\nWe are not a typical OTA we facilitate the whole booking including payments and remittances as well as marketing your resort to our members through EDM, website and social media promotions, our Discover QLD has over 120,000 followers on Social Media. We spend money marketing your resort for periods when the occupancy is low to help fill these otherwise empty rooms.<br />\r\n<br />\r\nSome other information that may not be included online is that we have over 250,000 active travelling members and our main demographic are semi-retirees and young families who typically travel in your off peak seasons.<br />\r\n<br />\r\nWe have over 500,000 vouchers in the market place that need to be redeemed.<br />\r\n<br />\r\nAlso you will notice the rates we promote are 3 night packages, we pro-rata extra nights however we do encourage members to use two back to back vouchers (2 x 3 nights) and receive the 7<sup>th</sup> night Free, this is optional however does help push the longer stays.<br />\r\n<br />\r\nWe also work with channel managers to make the reservations process very easy.<br />\r\n<br />\r\nLet me know if you have any questions and I will be in touch with you shortly, If your happy to move forward just send me back the agreement and we can get you loaded into our system and start sending some bookings your way J',18,5,'2015-04-16 11:33:36'),(6,'','Spoke to Larry and sending him information re HIGHTIDE and LC',18,5,'2015-04-16 11:27:09'),(5,'','<p>\r\n	9Jan15 - Restaurant is now being managed by Oaks Hotels &amp; Resorts. Open for breakfast, lunch and dinner 7 days a week with indoor and outdoor dining available.</p>\r\n',190,4,'2015-01-15 11:58:28');

--
-- Table structure for table `propertycontact`
--

CREATE TABLE `propertycontact` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `mobile` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `position` varchar(200) NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertycontact`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertycontact` VALUES (82,'Mr','Craig & Zsofi','Popplewell','07 5448 1955','','info@glenedenresort.com.au','Manager',2949),(81,'Mr','Michael','Goh','07 5538 2099','','info@genesisapartments.com.au','Manager',12851),(80,'Mr','Rob & Carolyne','Moore','07 5471 9800','','holiday@endlesssummerresort.com','Manager',2979),(79,'Ms','Carolyn','Mather','07 5570 1511','','holidays@enderleyresort.com.au','Manager',3909),(78,'Ms','Emma','Taylor','02 4938 8233','','emma@eaglereach.com.au','Manager',289),(77,'Mr','Sting','Pilapil','02 9358 1211','','info@devere.com.au','Manager',3921),(76,'Ms','Rebecca','Rouzbehi','07 5597 9999','','rebecca@courancove.com.au','Sales & Marketing',11930),(75,'Ms','Vicki','Tolhurst','02 4472 6111','','relax@corriganscove.com.au','Manager',287),(74,'Ms','Joscelyn','O\'Keefe','07 4946 2415','','hotel@csmr.com.au','Sales & Marketing',257),(73,'Ms','Cary','Xue','07 5538 7933','','info@chevronpalms.com.au','Manager',8858),(72,'Mr','Tom','Cox','07 5538 9955','','info@centrepointresort.com','Manager',3880),(71,'Ms','Suzi','Cadigan','08 8625 2008','','frontoffice@cednahotel.com.au','Manager',9138),(70,'Mr','Gary','Fitzjohn','07 5592 0011','','info@carmelbythesea.com.au','Manager',67),(69,'Ms','Hannah','Campion','.','0474 447 311','res@caribbeanresort.com.au','Manager',3678),(68,'Ms','Amisha','Jain','07 5538 5877','','info@carltonapartments.com.au','Manager',9071),(67,'Ms','Emma','.','07 4037 0400','','info@cairnsbeachresort.com.au','Other',8801),(66,'Ms','Karla','Haraldstad','07 5535 7188','','karla@burleighresort.com.au','Sales & Marketing',9583),(65,'Mr','Jason','Agnew','07 5589 0000','','gm@blueccoolangatta.com.au','General Manager',2948),(64,'Mr','Leighton','Pitcher','07 5533 3622','','leighton@binnaburralodge.com.au','Sales & Marketing',11873),(63,'Mr','Mark','Small','07 5584 9600','','mark@belairbroadbeach.com','Manager',3019),(62,'Mr','James','Boreham','07 5478 4000','','info@beachsideresort.com.au','Manager',285),(61,'Ms','Sarah','Caton','07 5478 7476','','reception@beachclub.com.au','Manager',3512),(60,'Mr','John & Viv','Tritton','.','0448 508 570','info@bargarablue.com.au','Manager',2963),(59,'Ms','Serena','Chan','07 5527 5933','','info@arubabeach.com.au','Manager',3041),(58,'Ms','Danielle','Oppes','02 6646 8600','','gm@angourieresort.com.au','Manager',39),(57,'Mr','Peter','Gow','07 5592 0966','','info@anacapri.com.au','Manager',9124),(56,'Ms','Kym','Roe','07 4055 6066','','info@amarooresort.com','Manager',340),(55,'Ms','Lorraine','Roughton','08 9754 3311','','stay@amalfiresort.com.au','Manager',206),(54,'Mr','David & Carol','.','07 5444 1600','','info@alexandraonthepacific.com','Manager',37),(53,'Ms','Ruth','Carroll','07 3124 7000','','rom@alexperryhotel.com.au','Manager',11496),(52,'Mr','Jeremy & Christine','Giles','07 4055 6776','','info@trinitybeachclub.com.au','Manager',316),(51,'Ms','Olwyn','Money','07 5584 0700','','info@trilogygoldcoast.com.au','Manager',118),(50,'Ms','Beth','Van Kooten','07 4722 2201','','beth.vankooten@the-ville.com.au','Sales & Marketing',11860),(49,'Mrs','Megan','Zerafa','07 5531 5651','','info@theritzresort.com.au','Other',9675),(48,'Mr','Dan & Nora','Gleeson','07 5448 1922','','info@theretreat.com.au','Manager',3001),(47,'Ms','Carol','Dolling','07 5538 9100','','info@thepenthouses.com.au','Manager',9205),(46,'Ms','Vicki','Scott','07 4053 9400','','gm@thelakescairns.com.au','Manager',236),(45,'Ms','Stacy','Luck','07 5538 8000','','manager@theislandgoldcoast.com.au','Manager',3714),(44,'Mr','Heath','Batterham','02 6639 2138','','heathb@thebyronatbyron.com.au','Sales & Marketing',233),(43,'Ms','Lyn','.','07 5538 5311','','info@thebreakers.com.au','Manager',3761),(42,'Mr','Wade','Bowen','07 4098 5700','','wade@thalabeach.com.au','Sales & Marketing',353),(41,'Ms','Kathryn','Meek','07 6344 3222','','kmeek@tasvillas.com','General Manager',3905),(40,'Ms','Lucy','Tsicalas','07 3637 2141','','contracts@tangalooma.com','Manager',9727),(39,'Mr','Dustin','Allen','07 5538 8863','','info@surfparaderesort.com.au','Manager',337),(38,'Mr','Paul','Kirkpatrick','07 5538 2188','','holidays@silvertonapartments.com.au','Manager',8920),(37,'Mr','Peter','Brown','07 4084 1400','','manager@shantara.com.au','Manager',9146),(36,'Mr','Chuzhang','.','07 5538 7755','','holiday@seacrest.com.au','Manager',2990),(35,'Mr','Simon','Batt','07 4057 5822','','info@seachange-beachfront-apartments.com','Manager',147),(34,'Mr','Garry & Therese','Gray','07 3897 3100','','office@scarboroughbeachresort.com.au','Manager',2991),(33,'Ms','Virginia','Nicolls','07 5534 5077','','enquiries@sansimeon.com.au','Manager',151);

--
-- Table structure for table `propertydocuments`
--

CREATE TABLE `propertydocuments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group_id` int(10) NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `doc_type` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `doc` varchar(200) NOT NULL,
  `promotion_type` varchar(200) NOT NULL,
  `promotion_dt` date NOT NULL,
  `contract_year` varchar(200) NOT NULL,
  `added_dt` date NOT NULL,
  `created_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=784 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertydocuments`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertydocuments` VALUES (783,0,'2020/21 Agreement','Rates','',13379,'document-2020-08-06-14-39-06.docx','3 Day Sale','2020-08-06','2020/21','2020-08-06','2020-08-06 14:39:06'),(782,0,'2020-21 Contract','Rates','',3076,'document-2020-07-27-13-54-56.pdf','3 Day Sale','2020-07-27','2020-21','2020-07-27','2020-07-27 13:54:56'),(781,0,'22Jun20 - Resort Closure Email','Emails','',338,'document-2020-06-25-14-46-38.msg','3 Day Sale','2020-06-25','','2020-06-25','2020-06-25 14:46:38'),(780,153,'1Apr20 - Contract Email','Emails','',9601,'document-2020-05-20-09-42-03.msg','3 Day Sale','2020-05-20','','2020-05-20','2020-05-20 09:42:03'),(779,152,'2020/21 Property Contract','Rates','',9601,'document-2020-05-20-09-41-31.pdf','3 Day Sale','2020-05-20','2020/21','2020-05-20','2020-05-20 09:41:31'),(778,151,'2020-21 Agreement','Rates','',9601,'document-2020-05-20-09-40-58.docx','3 Day Sale','2020-05-20','2020/21','2020-05-20','2020-05-20 09:40:58'),(777,147,'2013/14 Contract','Rates','',316,'document-2020-04-15-16-40-46.pdf','3 Day Sale','2020-04-15','2013/14','2020-04-15','2020-04-15 16:40:46'),(776,146,'2012/13 Contract','Rates','',118,'document-2020-04-15-16-34-05.pdf','3 Day Sale','2020-04-15','2012/13','2020-04-15','2020-04-15 16:34:05'),(775,141,'2017/18 Contract','Rates','',9675,'document-2020-04-15-15-59-14.docx','3 Day Sale','2020-04-15','2017/18','2020-04-15','2020-04-15 15:59:14'),(774,139,'2017/18 Contract','Rates','',3001,'document-2020-04-15-15-53-43.pdf','3 Day Sale','2020-04-15','2017/18','2020-04-15','2020-04-15 15:53:43'),(773,136,'2016/17 New Management Form','General Info','',14,'document-2020-04-15-15-41-55.pdf','3 Day Sale','2020-04-15','','2020-04-15','2020-04-15 15:41:55'),(772,135,'2009/10 Contract','Rates','',233,'document-2020-04-15-15-36-46.doc','3 Day Sale','2020-04-15','2009/10','2020-04-15','2020-04-15 15:36:46'),(771,134,'2011/12 Contract','Rates','',3761,'document-2020-04-15-15-29-02.pdf','3 Day Sale','2020-04-15','2011/12','2020-04-15','2020-04-15 15:29:02'),(770,133,'2010/11 Contract','Rates','',353,'document-2020-04-15-15-08-13.doc','3 Day Sale','2020-04-15','2010/11','2020-04-15','2020-04-15 15:08:13'),(769,108,'2014/15 Rates','Rates','',346,'document-2020-04-09-15-36-38.pdf','3 Day Sale','2020-04-09','2014/15','2020-04-09','2020-04-09 15:36:38'),(768,108,'2013/14 Rates','Rates','',346,'document-2020-04-09-15-36-12.pdf','3 Day Sale','2020-04-09','2013/14','2020-04-09','2020-04-09 15:36:12'),(767,108,'2012/13 Rates','Rates','',346,'document-2020-04-09-15-35-47.pdf','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 15:35:47'),(766,108,'2011/12 Rates','Rates','',346,'document-2020-04-09-15-34-59.pdf','3 Day Sale','2020-04-09','2011/12','2020-04-09','2020-04-09 15:34:59'),(765,108,'2010/11 Rates','Rates','',346,'document-2020-04-09-15-34-26.pdf','3 Day Sale','2020-04-09','2010/11','2020-04-09','2020-04-09 15:34:26'),(764,105,'12Jun13 - Change of Mangement email','Emails','',8835,'document-2020-04-09-15-28-10.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 15:28:10'),(762,101,'18Dec13 - Rate contract email','Emails','',9168,'document-2020-04-09-15-12-32.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 15:12:32'),(761,98,'1Jun12 - Contract email','Emails','',8865,'document-2020-04-09-14-55-29.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 14:55:29'),(760,95,'22Apr15 - New Management email','Emails','',332,'document-2020-04-09-14-39-47.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 14:39:47'),(759,91,'2019/20 Contract','Rates','',9599,'document-2020-04-09-14-22-25.pdf','3 Day Sale','2020-04-09','2019/20','2020-04-09','2020-04-09 14:22:25'),(758,88,'2018-20 Rates','Rates','',27,'document-2020-04-09-11-11-00.pdf','3 Day Sale','2020-04-09','2018-20','2018-06-08','2020-04-09 11:11:00'),(757,88,'2011/12 Rates','Rates','',27,'document-2020-04-09-11-10-15.xls','3 Day Sale','2020-04-09','2011/12','2010-09-17','2020-04-09 11:10:15'),(756,85,'2016/17 Rates','Rates','',9337,'document-2020-04-09-11-05-06.doc','3 Day Sale','2020-04-09','2016/17','2015-06-18','2020-04-09 11:05:06'),(755,85,'2015/16 Rates','Rates','',9337,'document-2020-04-09-11-04-29.doc','3 Day Sale','2020-04-09','2015/16','2015-06-18','2020-04-09 11:04:29'),(754,84,'16Jul15 - Property Contract email','Emails','',9337,'document-2020-04-09-11-03-44.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 11:03:44'),(753,81,'2012/13 Rates','Rates','',3945,'document-2020-04-09-10-40-41.xls','3 Day Sale','2020-04-09','2012/13','2011-08-30','2020-04-09 10:40:41'),(752,81,'2011/12 Rates','Rates','',3945,'document-2020-04-09-10-40-08.xls','3 Day Sale','2020-04-09','2011/12','2011-02-22','2020-04-09 10:40:08'),(751,82,'10Oct16 - Management Change','Emails','',3945,'document-2020-04-09-10-39-24.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 10:39:24'),(750,79,'2012/13 Rate Email','Emails','',8861,'document-2020-04-09-10-17-23.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 10:17:23'),(749,80,'2011/12 Rate Sheet','Rates','',8861,'document-2020-04-09-10-16-37.docx','3 Day Sale','2020-04-09','2011/12','2020-04-09','2020-04-09 10:16:37'),(748,74,'2012/13 Rates','Rates','',247,'document-2020-04-09-09-51-59.xls','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 09:51:59'),(747,73,'2009/10 Contract','Rates','',247,'document-2020-04-09-09-50-05.pdf','3 Day Sale','2020-04-09','2009/10','2020-04-09','2020-04-09 09:50:05'),(746,73,'2008/09 Contract','Rates','',247,'document-2020-04-09-09-49-29.pdf','3 Day Sale','2020-04-09','2008/09','2020-04-09','2020-04-09 09:49:29'),(745,73,'2007/08 Contract','Rates','',247,'document-2020-04-09-09-47-57.pdf','3 Day Sale','2020-04-09','2007/08','2020-04-09','2020-04-09 09:47:57'),(744,71,'2019/20 Contract Email','Emails','',9778,'document-2020-04-09-09-30-11.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:30:11'),(743,70,'2019/20 Contract','Rates','',9778,'document-2020-04-09-09-28-42.pdf','3 Day Sale','2020-04-09','2019/20','2019-03-16','2020-04-09 09:28:42'),(742,70,'2018/19 Contract','Rates','',9778,'document-2020-04-09-09-27-58.pdf','3 Day Sale','2020-04-09','2018/19','2018-04-24','2020-04-09 09:27:58'),(741,69,'2017/18 Contract Email','Emails','',2949,'document-2020-04-09-09-20-14.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:20:14'),(740,68,'2012/13 Contract','Rates','',2949,'document-2020-04-09-09-19-34.doc','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 09:19:34'),(739,68,'2010/11 Contract','Rates','',2949,'document-2020-04-09-09-18-04.pdf','3 Day Sale','2020-04-09','2010/11','2020-04-09','2020-04-09 09:18:04'),(738,67,'2019/20 Contract Email','Emails','',12851,'document-2020-04-09-09-03-57.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:03:57'),(737,66,'2019/20 Contract','Rates','',12851,'document-2020-04-09-09-02-05.pdf','3 Day Sale','2020-04-09','2019/20','2020-04-09','2020-04-09 09:02:05'),(736,64,'2016 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-53-59.pdf','3 Day Sale','2020-04-09','2016','2020-04-09','2020-04-09 08:53:59'),(735,64,'2015 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-53-26.pdf','3 Day Sale','2020-04-09','2015','2020-04-09','2020-04-09 08:53:26'),(734,64,'2014 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-52-37.pdf','3 Day Sale','2020-04-09','2014','2020-04-09','2020-04-09 08:52:37'),(733,64,'2013 Schoolies Agreement','Rates','',3909,'document-2020-04-09-08-51-55.pdf','3 Day Sale','2020-04-09','2013','2020-04-09','2020-04-09 08:51:55');

--
-- Table structure for table `propertydocumentsgroup`
--

CREATE TABLE `propertydocumentsgroup` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL,
  `name` varchar(200) NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertydocumentsgroup`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertydocumentsgroup` VALUES (153,'2020-05-20 09:41:39','EMAILS',9601),(152,'2020-05-20 09:40:12','PROPERTY RATE CONTRACTS',9601),(151,'2020-05-20 09:40:00','LEISURE GROUP CONTRACTS',9601),(150,'2020-04-15 16:44:32','SPECIALS',8834),(149,'2020-04-15 16:44:16','PROPERTY RATE CONTRACTS',8834),(148,'2020-04-15 16:44:02','LEISURE GROUP CONTRACTS',8834),(147,'2020-04-15 16:39:40','LEISURE GROUP CONTRACTS',316),(146,'2020-04-15 16:33:33','LEISURE GROUP CONTRACTS',118),(145,'2020-04-15 16:32:28','LEISURE GROUP CONTRACTS',2998),(144,'2020-04-15 16:28:14','PROPERTY RATE CONTRACTS',11860),(143,'2020-04-15 16:27:35','LEISURE GROUP CONTRACTS',11860),(142,'2020-04-15 16:01:49','LEISURE GROUP CONTRACTS',28),(141,'2020-04-15 15:58:01','LEISURE GROUP CONTRACTS',9675),(140,'2020-04-15 15:55:23','LEISURE GROUP CONTRACTS',12),(139,'2020-04-15 15:53:13','LEISURE GROUP CONTRACTS',3001),(138,'2020-04-15 15:48:06','LEISURE GROUP CONTRACTS',9205),(137,'2020-04-15 15:46:52','LEISURE GROUP CONTRACTS',236),(136,'2020-04-15 15:37:52','LEISURE GROUP CONTRACTS',14),(135,'2020-04-15 15:31:23','LEISURE GROUP CONTRACTS',233),(134,'2020-04-15 15:27:47','LEISURE GROUP CONTRACTS',3761),(133,'2020-04-15 15:07:35','LEISURE GROUP CONTRACTS',353),(132,'2020-04-15 14:47:14','LEISURE GROUP CONTRACTS',337),(131,'2020-04-15 14:38:37','LEISURE GROUP CONTRACTS',217),(130,'2020-04-15 14:34:51','SCHOOLIES CONTRACTS',8920),(129,'2020-04-15 14:34:47','LEISURE GROUP CONTRACTS',8920),(128,'2020-04-15 14:25:08','LEISURE GROUP CONTRACTS',2990),(127,'2020-04-15 14:19:47','LEISURE GROUP CONTRACTS',147),(126,'2020-04-15 13:53:07','LEISURE GROUP CONTRACTS',2991),(125,'2020-04-15 13:51:20','LEISURE GROUP CONTRACTS',151),(124,'2020-04-15 13:48:04','LEISURE GROUP CONTRACTS',213),(123,'2020-04-15 11:59:26','LEISURE GROUP CONTRACTS',9174),(122,'2020-04-15 11:57:42','LEISURE GROUP CONTRACTS',209),(121,'2020-04-15 11:55:02','LEISURE GROUP CONTRACTS',9359),(120,'2020-04-15 11:52:15','LEISURE GROUP CONTRACTS',3974),(119,'2020-04-15 11:35:22','LEISURE GROUP CONTRACTS',258),(118,'2020-04-15 10:44:50','LEISURE GROUP CONTRACTS',11639),(117,'2020-04-15 10:40:03','LEISURE GROUP CONTRACTS',3965),(116,'2020-04-15 10:37:47','EMAILS',17),(115,'2020-04-15 10:37:42','LEISURE GROUP CONTRACTS',17),(114,'2020-04-15 10:03:24','LEISURE GROUP CONTRACTS',11808),(113,'2020-04-15 09:31:38','EMAILS',125),(112,'2020-04-15 09:31:33','SPECIALS',125),(111,'2020-04-15 09:31:27','PROPERTY RATE CONTRACTS',125),(110,'2020-04-15 09:31:19','LEISURE GROUP CONTRACTS',125),(109,'2020-04-09 15:49:48','LEISURE GROUP CONTRACTS',3760),(108,'2020-04-09 15:33:37','PROPERTY RATE CONTRACTS',346),(107,'2020-04-09 15:33:27','LEISURE GROUP CONTRACTS',346),(106,'2020-04-09 15:30:27','LEISURE GROUP CONTRACTS',2984),(105,'2020-04-09 15:26:40','EMAILS',8835),(104,'2020-04-09 15:26:33','LEISURE GROUP CONTRACTS',8835);

--
-- Table structure for table `propertyimages`
--

CREATE TABLE `propertyimages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PropertiesID` int(11) unsigned DEFAULT NULL,
  `Original` varchar(100) DEFAULT NULL,
  `Resized` varchar(100) DEFAULT NULL,
  `Caption` varchar(200) NOT NULL,
  `MembersCaption` varchar(200) NOT NULL,
  `SchooliesCaption` varchar(200) NOT NULL,
  `IsMainImage` enum('Yes','No') NOT NULL DEFAULT 'No',
  `SOrder` int(10) NOT NULL DEFAULT '0',
  `is_changed` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `PropertiesID` (`PropertiesID`),
  KEY `IsMainImage` (`IsMainImage`)
) ENGINE=MyISAM AUTO_INCREMENT=112079 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertyimages`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertyimages` VALUES (112078,3677,'image-2020-08-19-12-24-01.jpg','medium-image-2020-08-19-12-24-01.jpg','1 Bedroom Apartment Living Room','1 Bedroom Apartment Living Room','','No',18,'No'),(112077,3677,'image-2020-08-19-12-23-32.jpg','medium-image-2020-08-19-12-23-32.jpg','2 Bedroom Apartment, Dining and Views','2 Bedroom Apartment, Dining and Views','','No',17,'No'),(112076,3677,'image-2020-08-19-12-22-15.jpg','medium-image-2020-08-19-12-22-15.jpg','3 Bedroom Spa Apartment Balcony Views','3 Bedroom Spa Apartment Balcony Views','','No',16,'No'),(112075,3677,'image-2020-08-19-12-21-58.jpg','medium-image-2020-08-19-12-21-58.jpg','2 Bedroom Apartment Spa Pool','2 Bedroom Apartment Spa Pool','','No',15,'No'),(112074,3677,'image-2020-08-19-12-21-42.jpg','medium-image-2020-08-19-12-21-42.jpg','2 Bedroom Apartment Twin Bedroom','2 Bedroom Apartment Twin Bedroom','','No',14,'No'),(112073,3677,'image-2020-08-19-12-21-32.jpg','medium-image-2020-08-19-12-21-32.jpg','2 Bedroom Apartment Master Bedroom','2 Bedroom Apartment Master Bedroom','','No',13,'No'),(112072,3677,'image-2020-08-19-12-21-16.jpg','medium-image-2020-08-19-12-21-16.jpg','1 Bedroom Apartment','1 Bedroom Apartment','','No',12,'No'),(112071,13391,'image-2020-08-19-11-17-58.jpg','medium-image-2020-08-19-11-17-58.jpg','Entrance','Entrance','','No',19,'No'),(112070,13391,'image-2020-08-19-11-17-25.jpg','medium-image-2020-08-19-11-17-25.jpg','Bathroom','Bathroom','','No',18,'No'),(112069,13391,'image-2020-08-19-11-17-09.jpg','medium-image-2020-08-19-11-17-09.jpg','Swimming Pool','Swimming Pool','','Yes',17,'No'),(112068,13391,'image-2020-08-19-11-16-24.jpg','medium-image-2020-08-19-11-16-24.jpg','Bedroom','Bedroom','','No',16,'No'),(112067,13391,'image-2020-08-19-11-16-18.jpg','medium-image-2020-08-19-11-16-18.jpg','Bedroom','Bedroom','','No',15,'No'),(112066,13391,'image-2020-08-19-11-16-09.jpg','medium-image-2020-08-19-11-16-09.jpg','Bedroom','Bedroom','','No',14,'No'),(112065,13391,'image-2020-08-19-11-15-58.jpg','medium-image-2020-08-19-11-15-58.jpg','Upstairs Living Area','Upstairs Living Area','','No',13,'No'),(112064,13391,'image-2020-08-19-11-15-40.jpg','medium-image-2020-08-19-11-15-40.jpg','Pool Table','Pool Table','','No',12,'No'),(112063,13391,'image-2020-08-19-11-15-31.jpg','medium-image-2020-08-19-11-15-31.jpg','Movie Room','Movie Room','','No',11,'No'),(112062,13391,'image-2020-08-19-11-15-22.jpg','medium-image-2020-08-19-11-15-22.jpg','Kitchen','Kitchen','','No',10,'No'),(112061,13391,'image-2020-08-19-11-15-13.jpg','medium-image-2020-08-19-11-15-13.jpg','Ensutie','Ensutie','','No',9,'No'),(112060,13391,'image-2020-08-19-11-13-38.jpg','medium-image-2020-08-19-11-13-38.jpg','Bedroom','Bedroom','','No',8,'No'),(112059,13391,'image-2020-08-19-11-13-30.jpg','medium-image-2020-08-19-11-13-30.jpg','Canal Side','Canal Side','','No',7,'No'),(112058,13391,'image-2020-08-19-11-13-22.jpg','medium-image-2020-08-19-11-13-22.jpg','Street View','Street View','','No',6,'No'),(112057,13391,'image-2020-08-19-11-12-57.jpg','medium-image-2020-08-19-11-12-57.jpg','BBQ Area','BBQ Area','','No',5,'No'),(112056,13391,'image-2020-08-19-11-12-51.jpg','medium-image-2020-08-19-11-12-51.jpg','Dining Area','Dining Area','','No',4,'No'),(112055,13391,'image-2020-08-19-11-12-32.jpg','medium-image-2020-08-19-11-12-32.jpg','Outside Lounge','Outside Lounge','','No',3,'No'),(112054,13391,'image-2020-08-19-11-12-14.jpg','medium-image-2020-08-19-11-12-14.jpg','Living Area','Living Area','','No',2,'No'),(112053,13391,'image-2020-08-19-11-11-45.jpg','medium-image-2020-08-19-11-11-45.jpg','Swimming Pool','Swimming Pool','','No',1,'No'),(112052,13387,'image-2020-08-19-10-46-30.jpg','medium-image-2020-08-19-10-46-30.jpg','','','','No',21,'No'),(112051,13387,'image-2020-08-19-10-46-23.jpg','medium-image-2020-08-19-10-46-23.jpg','','','','No',20,'No'),(112050,13387,'image-2020-08-19-10-46-16.jpg','medium-image-2020-08-19-10-46-16.jpg','','','','No',19,'No'),(112049,13387,'image-2020-08-19-10-45-15.jpg','medium-image-2020-08-19-10-45-15.jpg','House from the Canal','House from the Canal','','No',18,'No'),(112048,13387,'image-2020-08-19-10-44-58.jpg','medium-image-2020-08-19-10-44-58.jpg','Pool Table','Pool Table','','No',17,'No'),(112047,13387,'image-2020-08-19-10-44-24.jpg','medium-image-2020-08-19-10-44-24.jpg','Street View','Street View','','No',16,'No'),(112046,13387,'image-2020-08-19-10-44-11.jpg','medium-image-2020-08-19-10-44-11.jpg','Table Tennis and Kayaks','Table Tennis and Kayaks','','No',15,'No'),(112045,13387,'image-2020-08-19-10-43-57.jpg','medium-image-2020-08-19-10-43-57.jpg','Bunkbeds','Bunkbeds','','No',14,'No'),(112044,13387,'image-2020-08-19-10-43-44.jpg','medium-image-2020-08-19-10-43-44.jpg','Twin Room','Twin Room','','No',13,'No'),(112043,13387,'image-2020-08-19-10-43-33.jpg','medium-image-2020-08-19-10-43-33.jpg','Terrace','Terrace','','No',12,'No'),(112042,13387,'image-2020-08-19-10-43-16.jpg','medium-image-2020-08-19-10-43-16.jpg','Butlers Pantry','Butlers Pantry','','No',11,'No'),(112041,13387,'image-2020-08-19-10-43-05.jpg','medium-image-2020-08-19-10-43-05.jpg','Bedroom','Bedroom','','No',10,'No'),(112040,13387,'image-2020-08-19-10-42-56.jpg','medium-image-2020-08-19-10-42-56.jpg','Bedroom','Bedroom','','No',9,'No'),(112039,13387,'image-2020-08-19-10-27-19.jpg','medium-image-2020-08-19-10-27-19.jpg','Laundry','Laundry','','No',8,'No'),(112038,13387,'image-2020-08-19-10-26-55.jpg','medium-image-2020-08-19-10-26-55.jpg','Bathroom','Bathroom','','No',7,'No'),(112037,13387,'image-2020-08-19-10-21-23.jpg','medium-image-2020-08-19-10-21-23.jpg','Living Area','Living Area','','No',6,'No'),(112036,13387,'image-2020-08-19-10-20-14.jpg','medium-image-2020-08-19-10-20-14.jpg','Bedroom','Bedroom','','No',5,'No'),(112035,13387,'image-2020-08-19-10-20-01.jpg','medium-image-2020-08-19-10-20-01.jpg','Kitchen','Kitchen','','No',4,'No'),(112034,13387,'image-2020-08-19-10-19-52.jpg','medium-image-2020-08-19-10-19-52.jpg','Swimming Pool','Swimming Pool','','No',3,'No'),(112033,13387,'image-2020-08-19-10-19-40.jpg','medium-image-2020-08-19-10-19-40.jpg','Deck','Deck','','No',2,'No'),(112032,13387,'image-2020-08-19-10-19-03.jpg','medium-image-2020-08-19-10-19-03.jpg','Living and Dining Area','Living and Dining Area','','Yes',1,'No'),(112031,13393,'image-2020-08-19-09-45-33.jpg','medium-image-2020-08-19-09-45-33.jpg','','','','No',14,'No'),(112030,13393,'image-2020-08-19-09-44-32.jpg','medium-image-2020-08-19-09-44-32.jpg','','','','No',13,'No'),(112029,13393,'image-2020-08-19-09-44-23.jpg','medium-image-2020-08-19-09-44-23.jpg','','','','No',12,'No');

--
-- Table structure for table `propertymaintenance`
--

CREATE TABLE `propertymaintenance` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `start_dt` datetime NOT NULL,
  `end_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=317 DEFAULT CHARSET=latin1;

--
