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

You found 2 Places in Hotels > Nuevo Vallarta

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
Belair Resort & Spa Vallarta
Belair Resort & Spa Vallarta Category 5 stars | Nuevo Vallarta (See Map)
Customer rating: IMG STARS Based on 7 comments

Formerly known as "The Playa del Sol Grand", the BELAIR RESORT & SPA VALLARTA is at the fabulous Flamingo Beach on Banderas Bay. This five star resort offers you world class sun, sand and surf in a tranquil atmosphere away from crowds and congestion.

Based on double occupancy per Night,
between Feb 8, 2011 and Apr 8, 2011
Starting From
$177 USD
Price per room
Check Availability
Promotions:
 
Villa La Estancia Beach Resort & Spa
Villa La Estancia Beach Resort & Spa Category 5 stars | Nuevo Vallarta (See Map)
Customer rating: Too few comments. Write one!

NEW-NEW-NEW!
Villa La Estancia the new luxury Resort & Spa in Nuevo Vallarta.

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