select '' as housetype,provider,sos.houseid,destination,adults,Housesize,pool,Jacuzzi,rooms,housesize,Petnumber,Foto1,Foto2,Foto3,dktekst,priceEUR as priceDKK,geo1,geo2 from sos inner join priceshort on priceshort.houseid = sos.houseid where PriceEUR <> 0 and Foto1 <> '' and fromdate = '' and todate = ''

Karte zeigen
8 Personen • 4 Schlafzimmer • 337 m²
4 Personen • 2 Schlafzimmer • 120 m²
6 Personen • 3 Schlafzimmer • 174 m²