0,209,739,509,382,845,348,597,247,481,457

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 (4 ) or kategorieid2 in (4) or kategorieid3 in (4) or kategorieid4 in (4) or kategorieid5 in (4) ) and a.hausid in (0,209,739,509,382,845,348,597,247,481,457,834,650,787,741,862,833,774,883,249,756,900,596,221,780,852,333,337,226,867,551,652,228,275,349,508,502,503,239,235,884,451,340,655,581,792,460,361,857,616,793,542,546,215,662,500,654,1822,649,783,560,673,846,390,363,844,619,357,593,372,236,211,222,251,835,779,592,367,227,377,748,364,775,1343,611,668,847,731,368,356,514,598,763,346,360,622,657,591,786,232,231,600)

a.hausid

FIELD (a.hausid,0,209,739,509,382,845,348,597,247,481,457,834,650,787,741,862,833,774,883,249,756,900,596,221,780,852,333,337,226,867,551,652,228,275,349,508,502,503,239,235,884,451,340,655,581,792,460,361,857,616,793,542,546,215,662,500,654,1822,649,783,560,673,846,390,363,844,619,357,593,372,236,211,222,251,835,779,592,367,227,377,748,364,775,1343,611,668,847,731,368,356,514,598,763,346,360,622,657,591,786,232,231,600)

775,777,E-Mail,Ab-Preis / Nacht,Tel ,in,Buchen,Anfrage,0,de,Details,767,768,,

10