Alberghi e strutture convenzionate con il PIF
premio internazionale della fisarmonica di Castelfidardo :9
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 promo <> ''
Order by random()
array(1) {
["c"]=>
string(3) "pif"
}
array(5) {
["t"]=>
string(1) "0"
["s"]=>
int(0)
["c"]=>
string(3) "pif"
["m"]=>
string(1) "0"
["o"]=>
string(1) "#"
}
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
Emiliana Hotel a Sirolo
Hotel Emiliana is a small nice hotel in the centre of Sirolo. Its central location is stragetic both for the beaches (that you can reach in 10 minutes'walking among the wood) and the trekking excursionsin the Conero natural park. Hotel Emiliana offers to his guests the opportunity of discovering a regenerating holiday with healthy cuisine, sport and relax. With only 12 rooms, you will simply feel at home in a friendly and informal atmosphere. ... Show more
Beatrice Hotel a Sirolo
L'Hotel Beatrice di Sirolo si trova all'interno del Parco del Conero e si presenta completamente ristrutturato. In pochi minuti si pu� comodamente raggiungere le Spiagge San Michele e Sassi Neri a piedi cos� come il centro storico del paese. L' albergo, gestito dalla famiglia Pierini dagli anni �60, dispone di free Wi Fi, parcheggio gratuito, ristorante, terrazza panoramica attrezzata, ascensore, collaborazione con gli stabilimenti ba... Show more
Villa Eva Hotel a Sirolo
Villa Eva takes origin from the desire to create a place of relax, a small spot where you can simply feel at home. And... women are the most cuddled guests. Villa Eva is a small cottage built of white Conero stones which has recently been ristructured. And is today a Guest House for refined tourists. There silence and relax are compulsory and they are assured by the absence of traffic and the reservedness of its garden. Its central location ... Show more
Galassi Hotel a Marcelli di Numana
A few steps from one of the most beautiful beaches of the Riviera del Conero, Hotel Galassi proposes elegant and welcoming environment with care, fresh and bright. Lying on the slopes of the Conero Park, near Loreto (8 miles), Recanati (14 miles), Castelfidardo (8 miles), Osimo (14 miles), and Ancona (19 km), the Hotel is ideally located for Galassi excursions in the inland Marches, rich in natural treasures and natural strorico, lending itsel... 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
Acanto Hotel, Country house a Sirolo
Acanto Country House is a welcoming Relais which has been created within an old farmhouse on the Monte Conero promontory, built of white stone and set on a hillside bathed by sunlight.The view ranges from Sirolo and Numana on the sea to the hills of the Marches. The gaze rests first of all on the Basilica of Loreto and the hills of Recanati, Castelfidardo, Osimo and Camerano, then loses itself in the distance in the Sibilline Mountains and the su... Show more
Il Parco Hotel a Sirolo
Il Parco is a small, comfortable family hotel recently renovated wirh the white stone of Conero. Located in the center of Sirolo and a few steps from the sea it has a private parking and a large garden for breakfast and relax. Thanks to its central location all the beaches of Sirolo can be reached on foot. All rooms have shower, telephone, TV, fan, safe, air conditioning and mini bar.... Show more
Monteconero Hotel a Sirolo
Originally a Camaldolite Abbey, Hotel Monteconero stands at the top of the Conero promontory at an altidude of 550m. In the middle of Conero regional park, the hotel enjoys an enchanting position with a view of the Adriatic sea and the gentle hills of the Marches. Ideal for a relaxing holiday, the hotel also offers the opportunity to make excursions along the Conero Park's nature trails or to play golf . In a few minutes it is possible to r... Show more