Column 'hostelnumber' in field list is ambiguousSELECT position, hostelnumber, hostelname, address1, address2, county, country, yha, release, currency, review_avg, property_type, short_intro, (select Text from SuppInfo where HostelNumber = hostelinfo.HostelNumber and SuppInfo.Type = "Rating" limit 1) as Star, hostelinfo.es_intro AS LanguageIntro, has_package, hostelinfo.has_hw_availability, hostelinfo.max_pax , SuppInfo.text as shortLangDescription FROM hostelinfo LEFT JOIN SuppInfo ON (SuppInfo.HostelNumber = hostelinfo.hostelnumber AND SuppInfo.type = 'INTRO_es') WHERE country= 'Japan' AND county = 'Balchik' AND ( active = 1 OR active&17 = 17 ) AND hostelinfo.has_hw_availability = 1 Buscar Resultados: Balchik Albergues Booking International Hostels Made Easy

TravelNotes.org -- The Online Guide to Travel.

Booking International Hostels Made Easy @ TravelNotes.org

About Travel Notes™ Budget Travel Destinations Feedback Regional Search Travel Forums Travel Writing
Africa Asia Caribbean Europe Middle East North America South America Oceania
Car Hire Cruises Flights Hostels Lodging Reservations Round-The-World Tours Vacations Weather

Navigation Links

Airlines

Airports

Arrivals

City Guides

Departures

Directory

Reservations

Submit an Article

Travel Writing

Buscar Resultados: Balchik Properties
Mx 25 Nov 2009 para 3 noches

« Cambiar Fechas

Moneda: US Dollar Ordenar Por : Disponibilidad | Precio | Nombre | Tipo
Sorry, there is no online availability for the destination and dates you selected.

Possible reasons for this are:
  • You have searched too far ahead.
  • There is limited availability for the dates you chose.
  • The destination you are searching for has limited properties.

Please search again using different dates or a nearby destination.

 

Budget Tours - Cheap Hotels and Hostels.

[Customer Support - Frequently Asked Questions]

Download The Travel Notes Toolbar For The Best in Travel Surfing With Unique Custom Radio Stations.
Car Hire Cruises Flights Hostels Round-The-World Specials Tours Vacations Weather
Africa Asia Caribbean Europe Middle East North America South America Oceania
Travel Notes: Cheap Hotels, Hostels and Budget Tours -- Submit to Travel Notes

Get to your destination faster with the all new, singing and dancing, Travel Notes Toolbar!
Get to Your Destination Faster With The Travel Notes Toolbar - Downloads Available for Internet Explorer and Firefox.

| Advertise on TravelNotes.org | City Guides | Favourite Destinations | Magun's Compass | Travel Writing |
| Airlines | Airports | Car Hire | Cruises | Flights | Hotels | Holiday Rentals | Online Reservations |
| Casinos | Olympics | World Cup | General Disclaimer | Internet Resources | Meta-Travel |
| Travel Notes is a Trademark of TravelNotes.org | Travel Notes Blog | Add URL |