hacienda north coast villa with swimming pool

select * from Mls where ID in (140747,140766,229675,137355,218216,209573,96599,171167,171093,113861,62706,106758,102723,101845,93297,97947,92559,82537,82544,71916,55266,55267,55268,55269,55270,55271,51364,39114,15224,234125,234123,150342,81705,175640,241471,241301,233867,233868,233869,233870,233871,233872,233873,233825,233823,233531,233146,233184,233190,232290,229717,229728,108277,228549,228543,228503,228502,221964,228489,228267,228257,228253,148238,228230,228208,228206,228882,80681,225693,227783,227675,225163,224755,131627,196442,196445,196446,197866,197953,224320,224089,224098,224026,223815,223593,110998,222281,221872,221699,220138,220968,220531,217011,220286,220140,217742,218759,217731,191916,216853,216858,216700,216389,216391,216392,216401,216209,215467,215465,215466,215468,215469,215472,215269,215146,215148,225348,214979,225347,215131,215069,225346,215073,213025,212581,84219,210885,210833,209819,209743,209762,209633,209562,209563,209499,209501,207416,120882,204085,203985,202742,94413,200603,187236,110341,64803,196141,196147,196153,193146,193163,193140,193147,94519,94414,192726,192729,190612,191153,190756,190635,186005,189775,189780,178887,185399,93403,176205,175514,77734,69180,18573,164674,164675,164652,164653,164654,164642,164643,69178,69169,69390,163073,163077,113825,113860,113900,113898,113897,113939,113981,113979,113978,113977,113975,113974,113973,113971,113970,113969) ORDER BY FIELD(ID, 140747,140766,229675,137355,218216,209573,96599,171167,171093,113861,62706,106758,102723,101845,93297,97947,92559,82537,82544,71916,55266,55267,55268,55269,55270,55271,51364,39114,15224,234125,234123,150342,81705,175640,241471,241301,233867,233868,233869,233870,233871,233872,233873,233825,233823,233531,233146,233184,233190,232290,229717,229728,108277,228549,228543,228503,228502,221964,228489,228267,228257,228253,148238,228230,228208,228206,228882,80681,225693,227783,227675,225163,224755,131627,196442,196445,196446,197866,197953,224320,224089,224098,224026,223815,223593,110998,222281,221872,221699,220138,220968,220531,217011,220286,220140,217742,218759,217731,191916,216853,216858,216700,216389,216391,216392,216401,216209,215467,215465,215466,215468,215469,215472,215269,215146,215148,225348,214979,225347,215131,215069,225346,215073,213025,212581,84219,210885,210833,209819,209743,209762,209633,209562,209563,209499,209501,207416,120882,204085,203985,202742,94413,200603,187236,110341,64803,196141,196147,196153,193146,193163,193140,193147,94519,94414,192726,192729,190612,191153,190756,190635,186005,189775,189780,178887,185399,93403,176205,175514,77734,69180,18573,164674,164675,164652,164653,164654,164642,164643,69178,69169,69390,163073,163077,113825,113860,113900,113898,113897,113939,113981,113979,113978,113977,113975,113974,113973,113971,113970,113969) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired