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 (52) group by CAH.idHotel having count(CAH.idHotel) >= 1) Order by orden
Costa Allegre Hotels in Puerto Vallarta

You found 1 Places in Hotels > Costa Allegre

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
Careyes Beach Resort
Careyes Beach Resort Category Boutique | Costa Alegre (See Map)
Customer rating: Too few comments. Write one!

El Careyes Beach Resort is a perfect hideaway for the discerning traveler seeking relaxation or a wide range of activities.

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