Hotel in numana :11
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 OR id_name = 'relais_valcastagno')
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
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
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
Le Grange Hotel a Numana
The Le Grange del Conero Country House is located in Numana in a panoramic, strategic and unique position: it’s very close to the sea and the town, it has a swimming pool and it’s within the confines of the enchanting Natural Conero’s Park. It is just 550 meters from the beach, from the beautiful promenade of the Conero Riviera, which can also be reached by foot or bicycle.It is a typical Marche’s farmhouse with outbuildings, recently ren... 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
Valcastagno Hotel, Residence a Sirolo
Valcastagno, historically named by the abundance of horse chestnut in the area, is a peaceful and relaxing oasis between Numana and Sirolo, along the Conero Riviera, about two kilometres from the sea. Valcastagno, dipped in the Conero Regional Park, consists of an Apartment Hotel, obtained by an ancient tithe barn of the 8th century �Villa Virginia� and an Hotel, Valcastagno Relais, built in a farm-house whose property is of �Nembrini Gonza... 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
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
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
Murè Hotel a Numana
Numana è un borgo affascinante e senza tempo, nell’aria leggera si perdono con la salsedine i racconti dei marinai e dei pescatori.Storie di avventure, di imbarchi, di fughe a remi a cercar riparo sottomonte, di pescate leggendarie, di giornate a tirar la Sciabega, la storica rete da pesca tipica del Conero.Storie dei Murè, i piccoli mozzi appassionati di mare, che imparavano il mestiere in coperta, sotto il sole e la pioggia, bagnati dalle o... 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