chalet north coast for sale with installment

select * from Mls where ID in (227839,231248,227982,230483,230466,229705,228521,228509,97240,227942,227937,79531,227774,227770,225290,225358,225166,224649,195725,223812,223753,223755,219124,219126,223608,111906,222693,222586,103176,222258,221677,221693,221427,220881,220508,220509,220479,220275,220193,217578,216640,218643,217486,214478,107039,152383,147407,170350,193203,192722,83461,175250,78168,77751,99425,166947,164917,140487,162997,120123,162648,78333,78328,78327,78326,78322,78621,162319,162312,162204,73301,49650,104937,155390,104938,106771,107321,143039,84558,83016,36998,142561,139629,122179,134293,134287,128105,129945,129909,126003,128282,128277,123788,113247,113024,100316,116414,89761,115800,114233,112020,89461,108970,108222,108164,107764,107351,105288,105265,104833,104807,104802,104534,104536,89820,103812,103716,103529,103499,103501,103489,103278,102851,98943,100620,100621,100634,100568,100570,100355,99982,99918,99525,99433,99377,103439,99164,99168,99063,99033,98869,98841,98842,97499,97009,97012,94721,94259,93976,93977,93883,83570,93258,93236,93239,92930,92311,90840,83592,54788,83455,83453,83457,83454,83458,83460,82352,82350,81353,81373,81380,81389,81390,81399,81404,82032,80006,80007,80008,77736,77733,80013,78305,80052,80045,80039,80037,80040,78811,79921,79689,77756,78804,78613,78808,78815,78818,78600,78604,78610) ORDER BY FIELD(ID, 227839,231248,227982,230483,230466,229705,228521,228509,97240,227942,227937,79531,227774,227770,225290,225358,225166,224649,195725,223812,223753,223755,219124,219126,223608,111906,222693,222586,103176,222258,221677,221693,221427,220881,220508,220509,220479,220275,220193,217578,216640,218643,217486,214478,107039,152383,147407,170350,193203,192722,83461,175250,78168,77751,99425,166947,164917,140487,162997,120123,162648,78333,78328,78327,78326,78322,78621,162319,162312,162204,73301,49650,104937,155390,104938,106771,107321,143039,84558,83016,36998,142561,139629,122179,134293,134287,128105,129945,129909,126003,128282,128277,123788,113247,113024,100316,116414,89761,115800,114233,112020,89461,108970,108222,108164,107764,107351,105288,105265,104833,104807,104802,104534,104536,89820,103812,103716,103529,103499,103501,103489,103278,102851,98943,100620,100621,100634,100568,100570,100355,99982,99918,99525,99433,99377,103439,99164,99168,99063,99033,98869,98841,98842,97499,97009,97012,94721,94259,93976,93977,93883,83570,93258,93236,93239,92930,92311,90840,83592,54788,83455,83453,83457,83454,83458,83460,82352,82350,81353,81373,81380,81389,81390,81399,81404,82032,80006,80007,80008,77736,77733,80013,78305,80052,80045,80039,80037,80040,78811,79921,79689,77756,78804,78613,78808,78815,78818,78600,78604,78610) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired