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

You found 1 Places in Hotels > Two Stars

Find by "Stars" ?
Luxury (3)
Gran Turismo (4)
Five Stars (6)
Four Stars (14)
Three Stars (5)
Two Stars (1)
Not rated (1)
Boutique (3)
 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
Belmar
Belmar Category 2 stars | Romantic Zone (See Map)
Customer rating: Too few comments. Write one!

The Hotel Belmar Puerto Vallarta is one of the choicest budget accomodations in town according to specialized travel counselors worldwide.

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