Hotel in marcelli di numana :7
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 = 'marcelli di numana' COLLATE NOCASE
Order by random()
array(1) {
["c"]=>
string(18) "marcelli di numana"
}
array(5) {
["t"]=>
string(1) "0"
["s"]=>
int(0)
["c"]=>
string(18) "marcelli di numana"
["m"]=>
string(1) "0"
["o"]=>
string(1) "#"
}
Baby Gigli Meuble Hotel a Marcelli di Numana
Meubl� Baby Gigli, located on the sea-side of�the picturesque setting of Mount Conero, is ideal for� a family vacation. � In fact,Marcelli has a clean sea and a ventilated�beach,and it is�spacious and full of entertainment, with bars, live music and outdoor seating where you can enjoy drinks and icecreams. In addition, numerous markets and shops make it an attractive location for both family holidays�and young people. ... Show more
Dama Blu Residence a Marcelli di Numana
Welcome to the Riviera del Conero natural park of the Marche region with its charming bays of Monte Conero and the wide beaches of the coast to enjoy in the comfort of a crystalline sea. The residence Dama Blu is a small, articulated tourist reality dedicated to the pleasures of the holiday, we are facing the beach, surrounded by greenery, with a beautiful and large swimming pool and many proposals for sport, for gourmets to the children. W... Show more
Vila Bahia Hotel a Marcelli di Numana
Vila Bahia is situated on the seafront of Marcelli Numana. Located in a quiet area at 50 meters. the beach and the bathing establishments and a few meters from restaurants, pubs and shopping malls. Managed directly by the owner, offers a cozy and intimate with the characteristic colors of Salvador de Bahia. Double, twin or triple rooms with air-conditioning, minibar, telephone and satellite TV. Private bath for each room with each type of serv... Show more
Marcelli Hotel a Marcelli di Numana
The Hotel Marcelli stands in the centre of Marcelli Lido di Numana and enjoys a splendid situation right on the beach reserved for for patrons. It has 2 fine swimming pools (1 for children) on the beach terrace commanding a panoramic view of Monte Conero, which can also be enjoyed from some of the rooms with balcony and restaurant that serves excellent dishes based on the tipical Marche cuisine. Run directly by the Marcelli family, owners of the ... Show more
K2 Hotel a Marcelli di Numana
Hotel K2, owned by Marchetti family, welcomes its guests in a quiet and comfortable place. After years of experience we know that those who choose the Riviera del Conero seeks above all to move away from the hustle and bustle of the city. At K2 we try to put the customer in terms of relaxation.. We stand out from the streets of traffic in a residential area, still close to the center of the country, you will find the tranquility that our gu... 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
Kon Tiki Hotel a Marcelli di Numana
A garden among the trees and a wide veranda. Bath-room, warm water and telephone in all 31 rooms. All the rooms have conditioned air. A living room with a bar. A minigolf. A ground for children's games. A parking-place. A private, large, wide, thoroughly equipped beach with well spaced beach-umbrellas. Facilities -TV room - Dining room - Restaurant - Bar - Central heating - Private parking - Terrace - Television - Privat... Show more