logo pyrenees65
Esquí ESQUI
Termalismo TERMALISMO
Alojamiento ALOJAMIENTOS
Ocio OCIO
escapadas ESCAPADAS
comercioe COMERCIO
Restauración RESTAURACION
Inmobiliaria INMOBILIARIA
Servicios SERVICIOS
Escríbanos
Sitio Local

El Pays Toy
Luz Saint Sauveur, Luz Ardiden, Gavarnie, Barèges-Tourmalet
Pico de Midi de Bigorre.
   volver Inicio / Alojamientos - Alquiler
Alojamientos - Alquiler Alojamiento - alquiler


<% Dim dcnDB 'As ADODB.connection Dim recordset 'As ADODB.Recordset Dim SQL, Pays, granderegion, region, departement, vallee, type1, type2, terrain, organisme, qualite, personnesmini, personnesmaxi, nbrechambres, nom, village, telephone, lien ' As ADODB.String Set dcnDB = server.createObject("ADODB.Connection") dcnDB.Open "am12972" pays = "France" granderegion = "Pyrénées" region = "Midi-Pyrénées" departement = 65%>
Seleccione sus criterios de búsqueda
<%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT type1 from hebergements-espagnol WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT village from hebergements-espagnol WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT personnesmini from hebergements-espagnol WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement & " ORDER BY personnesmini" recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%Set recordset = server.createObject("ADODB.recordset") SQL = "SELECT DISTINCT nbrechambres from hebergements-espagnol WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement & " ORDER BY nbrechambres" recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing dcnDB.Close Set dcnDB = nothing%>
tipo de alojamiento
Pueblo
N° de personas mínimo
N° de habitaciones mín