resale chalet with garden full sea view

select * from Mls where ID in (88075,176083,216655,200328,91629,90070,102641,35361,172653,208621,220650,218240,217699,216646,215638,214270,213081,210370,209244,208825,208384,207286,207138,205742,205096,204839,204840,204379,203703,202175,201076,199137,198426,150244,197667,197684,190849,196526,196283,194890,194900,195807,193283,194517,192417,192517,192289,191206,191380,190609,190663,194405,189819,195197,189355,194325,188234,194058,187630,187631,187632,187261,183144,186250,185791,185202,185323,185341,185362,193750,193728,184343,182558,184163,184174,184190,184207,184211,183500,183514,183530,183251,183267,183282,182876,182909,182932,182937,182955,193648,193668,182552,182553,181065,178311,178315,177825,177826,157840,157839,158638,107006,176948,158741,158822,160200,175497,176566,176567,163604,160380,166392,169713,173922,171421,172716,62993,62992,172882,138475,146203,169264,172177,170467,169271,169507,168384,165798,182350,182349,162339,161421,161340,148700,85982,85979,161023,161011,158988,152966,148565,159257,157745,157912,157933,157936,44673,46149,157017,156142,156167,145484,155338,155136,154671,154159,152575,134664,148561,147720,147545,88730,88074,100078,139823,138980,107280,138046,135192,136210,136200,89239,135295,134965,83930,88112,133928,132909,130952,110870,125098,123052,122725,120149,121392,120713,121986,114651,114649,119442,120530,120508,118374,120492,121979,116078,115342,115346,114923,113285) ORDER BY FIELD(ID, 88075,176083,216655,200328,91629,90070,102641,35361,172653,208621,220650,218240,217699,216646,215638,214270,213081,210370,209244,208825,208384,207286,207138,205742,205096,204839,204840,204379,203703,202175,201076,199137,198426,150244,197667,197684,190849,196526,196283,194890,194900,195807,193283,194517,192417,192517,192289,191206,191380,190609,190663,194405,189819,195197,189355,194325,188234,194058,187630,187631,187632,187261,183144,186250,185791,185202,185323,185341,185362,193750,193728,184343,182558,184163,184174,184190,184207,184211,183500,183514,183530,183251,183267,183282,182876,182909,182932,182937,182955,193648,193668,182552,182553,181065,178311,178315,177825,177826,157840,157839,158638,107006,176948,158741,158822,160200,175497,176566,176567,163604,160380,166392,169713,173922,171421,172716,62993,62992,172882,138475,146203,169264,172177,170467,169271,169507,168384,165798,182350,182349,162339,161421,161340,148700,85982,85979,161023,161011,158988,152966,148565,159257,157745,157912,157933,157936,44673,46149,157017,156142,156167,145484,155338,155136,154671,154159,152575,134664,148561,147720,147545,88730,88074,100078,139823,138980,107280,138046,135192,136210,136200,89239,135295,134965,83930,88112,133928,132909,130952,110870,125098,123052,122725,120149,121392,120713,121986,114651,114649,119442,120530,120508,118374,120492,121979,116078,115342,115346,114923,113285) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired