compra y venta de bienes inmobiliarios en los Hautes Pyrénées

ESQUI

TERMALISMO

ALOJAMIENTOS

OCIO

ESCAPADAS

COMERCIO

RESTAURACION

INMOBILIARIA

SERVICIOS

Sitio Local

El Pays Toy

Luz Saint Sauveur, Luz Ardiden, Gavarnie, Barèges-Tourmalet, Pico de Midi de Bigorre.

Inicio / Inmobiliaria

Inmobiliaria

<% Dim dcnDB 'As ADODB.connection Dim recordset 'As ADODB.Recordset Dim SQL, Pays, granderegion, region, departement, vallee ' 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 type from immobilier 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 designation from immobilier 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 nbrechambres from immobilier WHERE (pays='"&pays&"') and (granderegion='"&granderegion&"') and (region='"®ion&"') and departement=" & departement recordset.Open SQL, dcnDB, 1, 1%> <%recordset.Close set recordset = nothing%> <%dcnDB.Close Set dcnDB = nothing%>

Compra / Venta

Tipo de bien

N° de habitaciones míni

Presupuesto