Hotel in numana :8
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 = 'numana' COLLATE NOCASE
Order by random()
array(1) {
["c"]=>
string(6) "numana"
}
array(5) {
["t"]=>
string(1) "0"
["s"]=>
int(0)
["c"]=>
string(6) "numana"
["m"]=>
string(1) "0"
["o"]=>
string(1) "#"
}
Teresa a mare Hotel a Numana
The hotel is located on the beach of Numana Bassa, it has 11 rooms with bathroom, air conditioning and TV (some have a balcony) and it has a large veranda with a bar, a small garden and is managed by the owner. The atmosphere is friendly, the food is homemade and the menu is agreed daily by the guest. The price includes a private beach which is across the street and it has umbrellas and drinks at the table. Next to the hotel there's a pa... Show more
Eden Gigli Hotel a Numana
Situated in an oasis of peace on a sheer drop overlooking the sea, covering a large area of 35000 m� between the green pines of the Mount Conero and the sea. A park inside the Conero park! An enchanting position for a nice and quiet holiday. The hotel has 26 refurbished bedrooms, 14 differently furnished bedrooms with ceiling fan, and 3 small flats. Hotel Eden Gigli, member of the Conero Golf Club, pledges to preserve the environment. T... Show more
Il Conero 2 Hotel, Residence a Numana
Not only sun and beach, but also nature, history, sport and enogastronomia, in the astonishing background of the M. Conero natural park. The Hotel Residence Il Conero 2, open all year round, is only 250 m from the beach and the towncenter of Marcelli, seaside of Numana; also open for groups and conferences. From our position, the beach is easily accessible by foot, also for handycapped; and the farthest Numana, Sirolo and Portonovo one... Show more
Corallo Hotel a Numana
L’Hotel Corallo è una struttura in riva al mare, che sorge proprio sullo storico stabilimento omonimo, con spiaggia attrezzata di ghiaia fine, bar, ristorante e uno spazio giochi dedicato ai bambini. Con le sue 8 nuovissime camere, la maggior parte fronte mare, l’Hotel Corallo si offre ai suoi ospiti con arredi moderni e di design. Ideale per chi ama risvegliarsi con una vista mare ed albe spettacolari sorgere all’orizzonte, l’Hotel Cora... Show more
Scogliera Hotel a Numana
The Hotel, located in a scenic position overlooking the sea, was built in 1968 by the Santinelli family, who still run the facility, making sure everything is perfect and handling its organisation to guarantee top quality services for guests. The Hotel was recently extensively refurbished, including air-conditioning, to meet the needs of its guests. It possesses a large terrace where guests can enjoy a sweeping view of Numana�s bay. Refined, d... Show more
La Spiaggiola Hotel a Numana
Right on the beach, the hotel is located in front of the homonymous beach Numana High-European Blue Flag, in a quiet and a short walk from the town, the hotel offers only bed and breakfast Italian style (B. & B.). The hotel has 21no smoking rooms with modern furnishings, own private parking, garage, heating and air conditioning, the building has no elevator. Groups are accepted, with modalities to be agreed in advance. Property of Ti... Show more
Giardino Suites&Spa Hotel a Numana
Hotel Giardino was set up in 1973 on the green hills close to the Park of Conero, plunged into the silence of nature. It is 800 m far from the centre of Numana, just a little farther from Sirolo and 600 m from the beach that you can reach whenever you want by a private shuttle at clients' disposal. The hotel, which has been recently renovated, is characterized by a cosy atmosphere. It is equipped with 37 bedrooms (all provided with TV with SKY c... Show more
Villa Sirena Hotel a Numana
Hotel Villa Sirena is located in a perfect position, nestled in a corner of blue and green directly overlooking its own private beach with bar service. Since 1967, the family Cremonesi gives the opportunity to taste traditional cuisine rich of fish dishes. The hotel has a small garden, a veranda, terraces, TV room and bar. All rooms have private facilities, telephone, TV, air conditioning and ventilation system. Villa Sirena is locate... Show more