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

You found 2 Places in Hotels > South 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
Costa Sur Resort & Spa
Costa Sur Resort & Spa Category 4 stars | Conchas Chinas (See Map)
Customer rating: IMG STARS Based on 6 comments

Costa Sur Resort & Spa, is unique among the beachfront resorts on beautiful Banderas Bay.

Based on double occupancy per Night,
between Feb 8, 2011 and Apr 8, 2011
Starting From
$153 USD
Price per room
Check Availability
Promotions:
 
Playa Conchas Chinas
Playa Conchas Chinas Category 4 stars | Conchas Chinas (See Map)
Customer rating: IMG STARS Based on 10 comments

Located in one of the most exclusive areas, surrounded by exotic and beautiful vegetation.

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