apartment with prime location

select * from Mls where ID in (232549,225715,229170,200863,228962,229053,168954,162225,232827,230579,198181,47406,213995,186917,229059,232799,232740,232685,232341,232540,231162,231093,232021,231007,230752,230636,230580,229331,229217,229215,228789,228733,228730,228720,228846,228852,228857,228858,231493,231534,228875,231461,231446,226153,228885,228886,228895,218336,228107,228909,228911,229304,229300,229297,217530,231277,217489,225631,231257,230287,229278,227704,229266,231213,215946,227688,229261,229255,229253,225540,229201,187026,229184,225251,229181,225181,229180,225094,225139,225538,225141,224590,225055,224660,224632,224597,224599,224602,224604,124779,224539,224501,224452,224408,224410,224411,224412,224413,224377,224382,224239,229172,224097,224103,230318,132872,133605,132556,134739,223562,223473,148541,148539,148544,223232,223303,223304,223307,223310,223311,223247,229139,222953,229131,229128,217505,229116,222820,222755,222756,222758,222761,222496,222444,229112,180117,229098,229095,222122,222165,222092,222095,222096,229084,222100,222023,222003,123759,75008,229064,72513,204220,221618,221620,218514,221204,221170,221176,221145,229027,221118,221122,221092,221090,221063,229018,229016,229015,221021,229005,228998,228997,219953,220330,228977,220182,220185,228974,228969,220094,220024,219911,219912,219873,219710,220640,219471,219487,211232,219222,219223,219224,219233,218764,218683,218687,218684,218492,218432,218434) ORDER BY FIELD(ID, 232549,225715,229170,200863,228962,229053,168954,162225,232827,230579,198181,47406,213995,186917,229059,232799,232740,232685,232341,232540,231162,231093,232021,231007,230752,230636,230580,229331,229217,229215,228789,228733,228730,228720,228846,228852,228857,228858,231493,231534,228875,231461,231446,226153,228885,228886,228895,218336,228107,228909,228911,229304,229300,229297,217530,231277,217489,225631,231257,230287,229278,227704,229266,231213,215946,227688,229261,229255,229253,225540,229201,187026,229184,225251,229181,225181,229180,225094,225139,225538,225141,224590,225055,224660,224632,224597,224599,224602,224604,124779,224539,224501,224452,224408,224410,224411,224412,224413,224377,224382,224239,229172,224097,224103,230318,132872,133605,132556,134739,223562,223473,148541,148539,148544,223232,223303,223304,223307,223310,223311,223247,229139,222953,229131,229128,217505,229116,222820,222755,222756,222758,222761,222496,222444,229112,180117,229098,229095,222122,222165,222092,222095,222096,229084,222100,222023,222003,123759,75008,229064,72513,204220,221618,221620,218514,221204,221170,221176,221145,229027,221118,221122,221092,221090,221063,229018,229016,229015,221021,229005,228998,228997,219953,220330,228977,220182,220185,228974,228969,220094,220024,219911,219912,219873,219710,220640,219471,219487,211232,219222,219223,219224,219233,218764,218683,218687,218684,218492,218432,218434) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired