Hotel in sirolo :18
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 = 'sirolo' COLLATE NOCASE
Order by random()
array(1) {
["c"]=>
string(6) "sirolo"
}
array(5) {
["t"]=>
string(1) "0"
["s"]=>
int(0)
["c"]=>
string(6) "sirolo"
["m"]=>
string(1) "0"
["o"]=>
string(1) "#"
}
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
Novecamere Resort Hotel, Country house a Sirolo
Novecamere Piccolo Resort del Conero Once a characteristic country home, now an intimate and refined hotel situated in the Riviera del Conero, only a few minutes away from the beautiful beaches of Sirolo. For a special holiday amidst the sea and nature. Situated in the Conero National Park only a few minutes from the beautiful beaches of Sirolo, "Novecamere" , once a family home and now transformed into a country hotel by Isabella Fabiani w... Show more
Il Vicolo Affittacamere a Sirolo
Located in a wonderful areas in the middle of Conero�s natural park, Sirolo is a famous tourist destination, awarded the Blu Flag for many years, thanks to the beauty of its sea and the high quality services. Sirolo, built within an ancient castle, gained its importance around the years One Thousand under the domination of Conti Cortesi. During the centuries it has preserved its magnificence and richness thanks to its strategic location. Now... 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
L'Antico Mulino Hotel, Country house a Sirolo
In the Conero Park in Sirolo has been restored an antique farm, built with the typical white rocks. It has been inaugurated in the year 2004: L'Antico Mulino - Country Relais. The antique rural origins have left evident marks in the structure of the farm which is now destinated to be a high-level residence. Thanks to the warm welcome of the owners and their love for details the Country-Relais becomes a magic comfortable place. The Isidory fam... Show more
Conero Camere Hotel a Sirolo
... Show more
Locanda Rocco Hotel a Sirolo
The Locanda was built in 1300 on the town walls, right over the town door, representing the ideal place where to have a rest and find board and lodging for wayfarers and merchants who once travelled along the Conero road. Today ROCCO is a small hotel-restaurant, recently restored in full respect of local tradition, by Giorgio Tridenti, who always offers to his guests a warm and spontaneous reception paying attention to any minimal detail. ... 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
Borgo Rosso Country house a Sirolo
Borgo Rosso Country House is a small hamlet of farmhouses surrounded by lush green lawn, surrounded by silvery green olive groves of oaks and a few steps from the beautiful beaches of Sirolo and Numana. The secluded position with sea views, the spacious park with its lovely lake, the scent of white roses and fruit trees and herbs make it a paradise for relay to spend an unforgettable vacation. Isolated in silence, surrounded by greenery and... 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
Arturo Hotel, Residence a Sirolo
The two stars Hotel Residence Arturo was built in the early Sixties and first opened as a small family-run full board Pensione and newly refurbished in 2006. It now consists of two mini self-contained Suites and four double rooms and it continues to be run by the same family. It is situated in Sirolo in an exclusive position which makes it unique in the Riviera del Conero. Due to the structure located directly on the beach small or la... Show more
Villa Clelia Country house a Sirolo
Villa Clelia is located on a hill among olive trees and oaks, is a beautiful rustic farmhouse to 3.5km from the sea. Villa Clelia is named like the grandmother of the family owner and is ready to offer you its 7 rooms, all with hardwood floors, air conditioning, TV, minibar, safe and handy wireless WI-FI. In addition, the open, you will find a spacious and well cared for in every detail, a large car park and a beautiful pool! And this year, we... Show more
Hotel Stella Hotel a Sirolo
Hotel stella is situated in centre of Sirolo just a few metres from the sea. Rooms are spacious, some with balconies and sea view, all with shower and services. The restaurant, family run, offers daily typical seafood specialties. ... 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
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
Sirolo Hotel a Sirolo
Sirolo Hotel consists of 31 rooms including 3 junior suite, 2 bedrooms featured for holders of handicap and two superior rooms.The 31 rooms offer a bright, elegant and peaceful atmosphere and they are tastefully furnished with wrought iron beds and equipped with all the modern comforts and amenities such as minibar, 26 inch tv lcd, phone, security box, hairdryer, toiletries, Internet connection by the tv and wifi free in the whole hotel.... 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
Le Cave Meuble Hotel a Sirolo
Hotel Le Cave is situated between the infinite expanse of the Adriatic Sea and the gentle wave of the hills of Marche region.The restaurant at Hotel Le Cave Meublè , suspended between sea and mountain, the slopes of the Conero, it is proposed by choice and by vocation, as a festive gathering place for the wedding banquet and social occasions for which style, professionalism, commitment, in the enchanting setting of the landscape and an elegant a... Show more