array(4) {
  [0]=>
  array(15) {
    ["id"]=>
    string(2) "27"
    ["nombre"]=>
    string(6) "Brexit"
    ["titulo"]=>
    string(20) "Brexit flexible rate"
    ["precio"]=>
    string(1) "0"
    ["descuento"]=>
    string(1) "0"
    ["texto_importe"]=>
    string(0) ""
    ["texto"]=>
    string(303) "
We have introduced a prepay flexible rate to protect your holidays from the Brexit outcome. 
You can prepay now, secure your holidays 2019, but if anything happens, you can still cancel and get a full refund up to 30 days before arrival. 
"
    ["url_reserva"]=>
    string(0) ""
    ["friendly_url"]=>
    string(20) "brexit-flexible-rate"
    ["media"]=>
    array(5) {
      ["id"]=>
      string(1) "7"
      ["nombre"]=>
      string(6) "Brexit"
      ["imagen"]=>
      array(1) {
        [0]=>
        array(4) {
          ["original"]=>
          array(3) {
            ["id"]=>
            string(2) "35"
            ["url"]=>
            string(57) "/backoffice/uploadImages/935Slider2_Palmanova_A-w2100.jpg"
            ["nombre"]=>
            string(32) "935Slider2_Palmanova_A-w2100.jpg"
          }
          ["small"]=>
          array(3) {
            ["id"]=>
            string(2) "35"
            ["url"]=>
            string(70) "/backoffice/uploadImages/thumbs/small/935Slider2_Palmanova_A-w2100.jpg"
            ["nombre"]=>
            string(32) "935Slider2_Palmanova_A-w2100.jpg"
          }
          ["medium"]=>
          array(3) {
            ["id"]=>
            string(2) "35"
            ["url"]=>
            string(71) "/backoffice/uploadImages/thumbs/medium/935Slider2_Palmanova_A-w2100.jpg"
            ["nombre"]=>
            string(32) "935Slider2_Palmanova_A-w2100.jpg"
          }
          ["big"]=>
          array(3) {
            ["id"]=>
            string(2) "35"
            ["url"]=>
            string(68) "/backoffice/uploadImages/thumbs/big/935Slider2_Palmanova_A-w2100.jpg"
            ["nombre"]=>
            string(32) "935Slider2_Palmanova_A-w2100.jpg"
          }
        }
      }
      ["pdf"]=>
      array(0) {
      }
      ["embed"]=>
      array(0) {
      }
    }
    ["fecha_ini"]=>
    string(10) "2018-11-07"
    ["fecha_fin"]=>
    string(10) "2019-04-30"
    ["textobreve"]=>
    string(44) "Prepay now and do not worry about the Brexit"
    ["promocode"]=>
    string(0) ""
    ["destacado"]=>
    string(1) "1"
  }
  [1]=>
  array(15) {
    ["id"]=>
    string(2) "21"
    ["nombre"]=>
    string(7) "Tropico"
    ["titulo"]=>
    string(32) "Seaview All Inclusive from €37"
    ["precio"]=>
    string(2) "37"
    ["descuento"]=>
    string(1) "0"
    ["texto_importe"]=>
    string(0) ""
    ["texto"]=>
    string(328) "
Book your Seaview Holidays at Hotel Tropico starting from €37!
All Inclusive holidays right by the Mediterranean Sea and the great Palma Nova beach from only €37!
Early booking discount now available! book now and get the best prices available online. Only at granisla.com
"
    ["url_reserva"]=>
    string(0) ""
    ["friendly_url"]=>
    string(29) "seaview-all-inclusive-from-37"
    ["media"]=>
    array(5) {
      ["id"]=>
      string(1) "6"
      ["nombre"]=>
      string(14) "Oferta Tropico"
      ["imagen"]=>
      array(1) {
        [0]=>
        array(4) {
          ["original"]=>
          array(3) {
            ["id"]=>
            string(3) "111"
            ["url"]=>
            string(41) "/backoffice/uploadImages/509Palmanova.jpg"
            ["nombre"]=>
            string(16) "509Palmanova.jpg"
          }
          ["small"]=>
          array(3) {
            ["id"]=>
            string(3) "111"
            ["url"]=>
            string(54) "/backoffice/uploadImages/thumbs/small/509Palmanova.jpg"
            ["nombre"]=>
            string(16) "509Palmanova.jpg"
          }
          ["medium"]=>
          array(3) {
            ["id"]=>
            string(3) "111"
            ["url"]=>
            string(55) "/backoffice/uploadImages/thumbs/medium/509Palmanova.jpg"
            ["nombre"]=>
            string(16) "509Palmanova.jpg"
          }
          ["big"]=>
          array(3) {
            ["id"]=>
            string(3) "111"
            ["url"]=>
            string(52) "/backoffice/uploadImages/thumbs/big/509Palmanova.jpg"
            ["nombre"]=>
            string(16) "509Palmanova.jpg"
          }
        }
      }
      ["pdf"]=>
      array(0) {
      }
      ["embed"]=>
      array(0) {
      }
    }
    ["fecha_ini"]=>
    string(10) "2018-10-10"
    ["fecha_fin"]=>
    string(10) "2018-12-31"
    ["textobreve"]=>
    string(63) "Early Booking now available! All Inclusive Holidays from €37!"
    ["promocode"]=>
    string(0) ""
    ["destacado"]=>
    string(1) "0"
  }
  [2]=>
  array(15) {
    ["id"]=>
    string(2) "15"
    ["nombre"]=>
    string(13) "OfertaPIrates"
    ["titulo"]=>
    string(49) "Pirates Village Early Booking 2019 available now!"
    ["precio"]=>
    string(2) "53"
    ["descuento"]=>
    string(1) "0"
    ["texto_importe"]=>
    string(0) ""
    ["texto"]=>
    string(274) "Best prices for 2019 now available at Pirates Village. Because we know that a happy child is a happy family!

Book now and get a very special price! All Inclusive from €53 per adult and Self Catering from €68 per family!

The Holidays your children won't forget about..."
    ["url_reserva"]=>
    string(0) ""
    ["friendly_url"]=>
    string(11) "pirates2019"
    ["media"]=>
    array(5) {
      ["id"]=>
      string(1) "3"
      ["nombre"]=>
      string(13) "OfertaPirates"
      ["imagen"]=>
      array(1) {
        [0]=>
        array(4) {
          ["original"]=>
          array(3) {
            ["id"]=>
            string(2) "55"
            ["url"]=>
            string(68) "/backoffice/uploadImages/145Instalaciones_Piscina_infantil-w2100.jpg"
            ["nombre"]=>
            string(43) "145Instalaciones_Piscina_infantil-w2100.jpg"
          }
          ["small"]=>
          array(3) {
            ["id"]=>
            string(2) "55"
            ["url"]=>
            string(81) "/backoffice/uploadImages/thumbs/small/145Instalaciones_Piscina_infantil-w2100.jpg"
            ["nombre"]=>
            string(43) "145Instalaciones_Piscina_infantil-w2100.jpg"
          }
          ["medium"]=>
          array(3) {
            ["id"]=>
            string(2) "55"
            ["url"]=>
            string(82) "/backoffice/uploadImages/thumbs/medium/145Instalaciones_Piscina_infantil-w2100.jpg"
            ["nombre"]=>
            string(43) "145Instalaciones_Piscina_infantil-w2100.jpg"
          }
          ["big"]=>
          array(3) {
            ["id"]=>
            string(2) "55"
            ["url"]=>
            string(79) "/backoffice/uploadImages/thumbs/big/145Instalaciones_Piscina_infantil-w2100.jpg"
            ["nombre"]=>
            string(43) "145Instalaciones_Piscina_infantil-w2100.jpg"
          }
        }
      }
      ["pdf"]=>
      array(0) {
      }
      ["embed"]=>
      array(0) {
      }
    }
    ["fecha_ini"]=>
    string(10) "2018-10-25"
    ["fecha_fin"]=>
    string(10) "2018-12-31"
    ["textobreve"]=>
    string(71) "Book now your 2019 Holidays at Pirates Village All Inclusive from €53"
    ["promocode"]=>
    string(0) ""
    ["destacado"]=>
    string(1) "0"
  }
  [3]=>
  array(15) {
    ["id"]=>
    string(2) "25"
    ["nombre"]=>
    string(15) "Jutlandia offer"
    ["titulo"]=>
    string(30) "Jutlandia 2019 Family Holidays"
    ["precio"]=>
    string(2) "46"
    ["descuento"]=>
    string(1) "0"
    ["texto_importe"]=>
    string(0) ""
    ["texto"]=>
    string(366) "
At the heart on Santa Ponsa, Jutlandia Family Resort includes all the services and facilities you will need to enjoy a superb family holiday. With Water Park, Kids Club, All Inclusive, 2 large pools, daily entertainment, free WIFI, etc. Located only 400m from the beach and from the city center. 

"
    ["url_reserva"]=>
    string(0) ""
    ["friendly_url"]=>
    string(30) "jutlandia-2019-family-holidays"
    ["media"]=>
    array(5) {
      ["id"]=>
      string(1) "4"
      ["nombre"]=>
      string(15) "OfertaJutlandia"
      ["imagen"]=>
      array(1) {
        [0]=>
        array(4) {
          ["original"]=>
          array(3) {
            ["id"]=>
            string(3) "319"
            ["url"]=>
            string(72) "/backoffice/uploadImages/619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
            ["nombre"]=>
            string(47) "619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
          }
          ["small"]=>
          array(3) {
            ["id"]=>
            string(3) "319"
            ["url"]=>
            string(85) "/backoffice/uploadImages/thumbs/small/619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
            ["nombre"]=>
            string(47) "619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
          }
          ["medium"]=>
          array(3) {
            ["id"]=>
            string(3) "319"
            ["url"]=>
            string(86) "/backoffice/uploadImages/thumbs/medium/619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
            ["nombre"]=>
            string(47) "619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
          }
          ["big"]=>
          array(3) {
            ["id"]=>
            string(3) "319"
            ["url"]=>
            string(83) "/backoffice/uploadImages/thumbs/big/619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
            ["nombre"]=>
            string(47) "619Jutlandia_PiscinaKids-Splash-Pool3-w2100.jpg"
          }
        }
      }
      ["pdf"]=>
      array(0) {
      }
      ["embed"]=>
      array(0) {
      }
    }
    ["fecha_ini"]=>
    string(10) "2018-10-29"
    ["fecha_fin"]=>
    string(10) "2019-01-31"
    ["textobreve"]=>
    string(45) "Book now your best family holidays in Majorca"
    ["promocode"]=>
    string(0) ""
    ["destacado"]=>
    string(1) "0"
  }
}
			

  select h.id, h.nombre from hotel as h inner join oferta_hotel as oh on oh.id_hotel =h.id  where oh.id_oferta = 27 

Pirates Village

Brexit flexible rate

We have introduced a prepay flexible rate to protect your holidays from the Brexit outcome.

You can prepay now, secure your holidays 2019, but if anything happens, you can still cancel and get a full refund up to 30 days before arrival.

FROM 0^€

BOOK

  select h.id, h.nombre from hotel as h inner join oferta_hotel as oh on oh.id_hotel =h.id  where oh.id_oferta = 21 

Tropico playa

Seaview All Inclusive from €37

Book your Seaview Holidays at Hotel Tropico starting from €37!

All Inclusive holidays right by the Mediterranean Sea and the great Palma Nova beach from only €37!

Early booking discount now available! book now and get the best prices available online. Only at granisla.com

FROM 37^€

BOOK

  select h.id, h.nombre from hotel as h inner join oferta_hotel as oh on oh.id_hotel =h.id  where oh.id_oferta = 15 

Pirates Village

Pirates Village Early Booking 2019 available now!

Best prices for 2019 now available at Pirates Village. Because we know that a happy child is a happy family! Book now and get a very special price! All Inclusive from €53 per adult and Self Catering from €68 per family! The Holidays your children won't forget about...

FROM 53^€

BOOK

  select h.id, h.nombre from hotel as h inner join oferta_hotel as oh on oh.id_hotel =h.id  where oh.id_oferta = 25 

Jutlandia Family

Jutlandia 2019 Family Holidays

At the heart on Santa Ponsa, Jutlandia Family Resort includes all the services and facilities you will need to enjoy a superb family holiday. With Water Park, Kids Club, All Inclusive, 2 large pools, daily entertainment, free WIFI, etc. Located only 400m from the beach and from the city center.

FROM 46^€

BOOK