risultati: 1

Cerca e prenota
un alloggio
a osimo

Hotel in osimo :1

SELECT id, nome, id_name, prezzi, nascosto, servizi, json_extract( posizione, '$.paese' ) as paese, json_extract( posizione, '$.mare' ) as mare, json_extract( prezzi, '$.min' ) as prezzo, json_extract( foto, '$.foto[0].img' ) as img, json_extract( tipo, '$.tipologia' ) as tipologia, json_extract( tipo, '$.stelle' ) as stelle, json_extract( info, '$.en.desc' ) as desc, json_extract( info, '$.en.costo' ) as costo from hotels Where nascosto = 0 And paese = 'osimo' COLLATE NOCASE Order by random() array(1) { ["c"]=> string(5) "osimo" } array(5) { ["t"]=> string(1) "0" ["s"]=> int(0) ["c"]=> string(5) "osimo" ["m"]=> string(1) "0" ["o"]=> string(1) "#" }
  
Palace del Conero Hotel a Osimo

... Show more

Half board per person per day
min 58
max 96
Distance from the sea: 13.000 mt