chalet resale ground floor with garden

select * from Mls where ID in (121327,166821,208538,204086,112882,178315,161036,149836,114109,127767,114387,112075,110453,110267,20111,108879,108844,108818,99988,69588,224550,226956,183983,214562,195350,183769,183818,98120,125466,122690,137915,123207,155578,229193,231747,230130,230143,226971,83899,227958,225777,107031,227732,224567,224553,221604,218556,218503,218073,218025,215052,216646,216505,216266,215638,214888,214242,214207,214211,214027,144642,155119,168758,210610,208294,205429,205372,204872,201030,200599,201103,200319,103619,200033,151271,202136,150244,197810,197737,112891,112858,196891,196692,35750,193253,191655,190632,191387,189574,189307,189361,189034,69600,188891,194336,194233,188338,194178,194129,194096,188241,194047,187492,187316,193824,186889,186484,186229,182434,185410,182453,182564,181173,182081,182033,180024,180340,180369,182006,181941,181866,177760,177663,176962,176773,181840,181836,181818,176453,172480,176305,176172,168909,175440,47785,174626,149664,173136,118365,118366,172471,156591,156657,171913,171929,171562,171216,155386,149433,168699,168326,167899,167030,166329,162995,112208,162813,161389,161391,161392,161393,161348,161336,183807,126558,155504,154821,155137,154784,70444,70454,63557,63477,154638,154642,154643,154485,154662,154371,154181,153928,154160,153836,154177,98229,153496,127481,148660,148093,147791,146776,146238,91082,38942,80133,142412,140932,138764,89264,136019) ORDER BY FIELD(ID, 121327,166821,208538,204086,112882,178315,161036,149836,114109,127767,114387,112075,110453,110267,20111,108879,108844,108818,99988,69588,224550,226956,183983,214562,195350,183769,183818,98120,125466,122690,137915,123207,155578,229193,231747,230130,230143,226971,83899,227958,225777,107031,227732,224567,224553,221604,218556,218503,218073,218025,215052,216646,216505,216266,215638,214888,214242,214207,214211,214027,144642,155119,168758,210610,208294,205429,205372,204872,201030,200599,201103,200319,103619,200033,151271,202136,150244,197810,197737,112891,112858,196891,196692,35750,193253,191655,190632,191387,189574,189307,189361,189034,69600,188891,194336,194233,188338,194178,194129,194096,188241,194047,187492,187316,193824,186889,186484,186229,182434,185410,182453,182564,181173,182081,182033,180024,180340,180369,182006,181941,181866,177760,177663,176962,176773,181840,181836,181818,176453,172480,176305,176172,168909,175440,47785,174626,149664,173136,118365,118366,172471,156591,156657,171913,171929,171562,171216,155386,149433,168699,168326,167899,167030,166329,162995,112208,162813,161389,161391,161392,161393,161348,161336,183807,126558,155504,154821,155137,154784,70444,70454,63557,63477,154638,154642,154643,154485,154662,154371,154181,153928,154160,153836,154177,98229,153496,127481,148660,148093,147791,146776,146238,91082,38942,80133,142412,140932,138764,89264,136019) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired