0,209,249,897,656,744,612,453,731,792,261
a.*,c.bezeichnung as bezirkname,b.name as ortname
haus a left join ort b on a.ortid=b.id left join ortsteil c on a.ortsteilid=c.ortsteilid left join hauseigenschaft v on a.hausid=v.hausid
a.sperre=0 and a.status=0 and a.ortid in (65) and ( kategorieid in (3 )
or kategorieid2 in (3)
or kategorieid3 in (3)
or kategorieid4 in (3)
or kategorieid5 in (3)
) and a.hausid in (0,209,249,897,656,744,612,453,731,792,261,219,780,726,713,546,367,356,763,741,617,749,654,661,738,779,236,369,739,825,775,848,2044,254,736,720,793,673,732,336)
a.hausid
FIELD (a.hausid,0,209,249,897,656,744,612,453,731,792,261,219,780,726,713,546,367,356,763,741,617,749,654,661,738,779,236,369,739,825,775,848,2044,254,736,720,793,673,732,336)
771,777,E-Mail,Ab-Preis / Nacht,Tel ,in,Buchen,Anfrage,0,de,Details,767,768,,
10
© Tourismusbüro Lechtal . Kontakt . Impressum . Presse . Sitemap . Vermieter-Login . E-Meldeschein




