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

You found 2 Places in Hotels > North Coast

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 - 2 of 2 Order by:: Best Value Price Rating
Vista Vallarta
Vista Vallarta Category 4 stars | Bucerias (See Map)
Customer rating: IMG STARS Based on 5 comments

Vista Vallarta is a paradise Located on the wide sandy beaches of "Huanacaxtle''.

Based on double occupancy per Night,
between Feb 8, 2011 and Apr 8, 2011
Starting From
$205 USD
Price per room
Check Availability
Promotions:40% Off
Travel Window from April 19 to December 23, 2012

Booking Window May 17, 2012
Book 2 nights and get an extra 3% Off!!
 
Star Bay Suites Resort
Star Bay Suites Resort Category Boutique | Bucerias (See Map)
Customer rating: IMG STARS Based on 10 comments

A star is born. StarBay Suites Resort in Banderas Bay, an oasis of tranquility and beauty.

Based on double occupancy per Night,
between Feb 8, 2011 and Apr 8, 2011
Starting From
$160 USD
Price per room
Check Availability
Promotions:43% Off
Travel Window from April 19 to December 23, 2012

Booking Window May 17, 2012