resale chalets with garden mountain view

select * from Mls where ID in (194436,241326,239852,229664,228783,228769,228478,76919,227766,227645,225083,223317,223556,223455,222823,222830,222835,222550,222554,222111,79318,220650,219841,219595,218459,217737,217699,216643,216934,114853,216586,216208,215275,56282,213340,212589,212260,212263,212288,211762,180455,152586,89395,209198,208384,208944,208676,207286,206184,203150,195142,203804,162339,202652,202590,199703,197560,173680,169063,73985,128581,128628,129043,190616,193033,188677,187032,186103,185978,184733,195143,181065,180890,179518,178906,61879,177367,158638,176699,163604,133630,98322,174792,174794,174717,174721,174723,174727,174401,173548,164346,170955,170742,170706,170467,50201,169375,169358,169132,166536,165166,164637,164369,164029,36549,139508,161568,161508,161252,159950,159921,158020,159365,152966,157253,161288,128028,127294,127447,127347,127248,126094,154785,154002,116775,153691,120021,121211,138586,119771,119737,234585,234627,234629,234701,142557,137875,148669,234880,234955,234999,145928,127769,110519,108917,57162,57161,234765,78356,141140,141063,124396,139149,135258,139089,138969,133359,120337,120427,107280,135259,121695,138026,234835,137446,135343,234813,234406,234425,133628,133277,133308,132909,132486,132285,132237,234618,132726,98320,98576,98561,98716,98730,130076,129950,116742,128579,127442,125179,125098,123367,123045,121725,121928,121583,121186,119899,119258,118932,111871) ORDER BY FIELD(ID, 194436,241326,239852,229664,228783,228769,228478,76919,227766,227645,225083,223317,223556,223455,222823,222830,222835,222550,222554,222111,79318,220650,219841,219595,218459,217737,217699,216643,216934,114853,216586,216208,215275,56282,213340,212589,212260,212263,212288,211762,180455,152586,89395,209198,208384,208944,208676,207286,206184,203150,195142,203804,162339,202652,202590,199703,197560,173680,169063,73985,128581,128628,129043,190616,193033,188677,187032,186103,185978,184733,195143,181065,180890,179518,178906,61879,177367,158638,176699,163604,133630,98322,174792,174794,174717,174721,174723,174727,174401,173548,164346,170955,170742,170706,170467,50201,169375,169358,169132,166536,165166,164637,164369,164029,36549,139508,161568,161508,161252,159950,159921,158020,159365,152966,157253,161288,128028,127294,127447,127347,127248,126094,154785,154002,116775,153691,120021,121211,138586,119771,119737,234585,234627,234629,234701,142557,137875,148669,234880,234955,234999,145928,127769,110519,108917,57162,57161,234765,78356,141140,141063,124396,139149,135258,139089,138969,133359,120337,120427,107280,135259,121695,138026,234835,137446,135343,234813,234406,234425,133628,133277,133308,132909,132486,132285,132237,234618,132726,98320,98576,98561,98716,98730,130076,129950,116742,128579,127442,125179,125098,123367,123045,121725,121928,121583,121186,119899,119258,118932,111871) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired