Select VHOT.idHotel, VHOT.hotelFotoSm, VHOT.Hotel, domicilio, VHOT.hotelFolder, VHOT.DescripcionSm, VHOT.zona, VHOT.promotion, zonaFolder, VHOT.clase, numComentarios as totComs, average as 'promCom', precioNuestro, fechaDe, fechaHasta, precioLabel, idMealPlan From vwHotel VHOT inner join Hotels_ListadoDef HLD on VHOT.idHotel = HLD.idHotel WHERE VHOT.idHotel in ( select CAH.idHotel from Caracteristica_Hotel CAH inner join Caracteristica CAR2 on CAH.idCaracteristica = CAR2.idCaracteristica where CAH.idCaracteristica in (67) group by CAH.idHotel having count(CAH.idHotel) >= 1) Order by orden
Interior of Mexico Hotels in Puerto Vallarta

You found 1 Places in Hotels > Interior of Mexico

Find by "Stars" ? Find by Location Find by Meal Plan ? Find by "Best for"

Check Availability

Check-In:
Calendar
Check-Out:
Calendar
Adults:
Kids: (0-17 yrs)
Ages of children:
Child1:
Child2:
Child3:
Child4:
Child5:
Child6:
Showing 1 - 1 of 1 Order by:: Best Value Price Rating
Villa Maria Cristina
Villa Maria Cristina Category Boutique | N/A (See Map)

The first Grand Class Hotel Boutique in the beautiful and historical city of Guanajuato; a paradise of luxury, comfort and elegance.

Based on double occupancy per Night,
between Feb 8, 2011 and Apr 8, 2011
Starting From
$340 USD
Price per room
Check Availability