town house with good location

select * from Mls where ID in (199701,196530,179754,190592,194323,189113,188636,188581,187754,186719,186168,195147,185692,185155,184728,195130,181135,195120,165684,180148,177842,176901,176883,176882,195111,172807,134144,171991,171823,170957,170465,181629,169958,168781,168109,125522,167234,165304,163195,161955,161046,154627,146366,149518,138110,138193,137774,120526,126967,126622,124271,124269,101578,87740,150291,150401,151020,201826,199943,199826,194844,201032,186759,178124,178078,112168,201245,201268,201287,201134,201137,201089,202073,202058,200686,200292,200025,200009,200003,199999,194342,199827,198983,199667,199468,199567,201997,198941,198958,198852,198876,198893,201943,198422,198462,197983,114861,114860,116759,118529,119026,120993,121747,123194,123208,123574,138313,138315,133123,197085,197006,171225,195944,195931,195820,140664,195702,195788,195784,172003,195045,195015,194638,193059,192761,192491,191221,194538,194493,190610,190489,194437,193639,189575,189038,188820,189105,188663,194331,194288,194263,194262,194145,194139,194135,194094,194046,193985,187445,91662,186711,186852,186565,186441,186443,186445,186455,186492,186506,185887,167937,167917,167895,167880,168239,168328,168721,185094,185346,183164,184293,184294,184266,89407,183132,183133,183686,182523,181156,180729,181191,180650,182051,182034,180370,179455,77466,179153,176207,178878,180405,182002,181937,181926,181922,181918,181876,181872,178296,177769) ORDER BY FIELD(ID, 199701,196530,179754,190592,194323,189113,188636,188581,187754,186719,186168,195147,185692,185155,184728,195130,181135,195120,165684,180148,177842,176901,176883,176882,195111,172807,134144,171991,171823,170957,170465,181629,169958,168781,168109,125522,167234,165304,163195,161955,161046,154627,146366,149518,138110,138193,137774,120526,126967,126622,124271,124269,101578,87740,150291,150401,151020,201826,199943,199826,194844,201032,186759,178124,178078,112168,201245,201268,201287,201134,201137,201089,202073,202058,200686,200292,200025,200009,200003,199999,194342,199827,198983,199667,199468,199567,201997,198941,198958,198852,198876,198893,201943,198422,198462,197983,114861,114860,116759,118529,119026,120993,121747,123194,123208,123574,138313,138315,133123,197085,197006,171225,195944,195931,195820,140664,195702,195788,195784,172003,195045,195015,194638,193059,192761,192491,191221,194538,194493,190610,190489,194437,193639,189575,189038,188820,189105,188663,194331,194288,194263,194262,194145,194139,194135,194094,194046,193985,187445,91662,186711,186852,186565,186441,186443,186445,186455,186492,186506,185887,167937,167917,167895,167880,168239,168328,168721,185094,185346,183164,184293,184294,184266,89407,183132,183133,183686,182523,181156,180729,181191,180650,182051,182034,180370,179455,77466,179153,176207,178878,180405,182002,181937,181926,181922,181918,181876,181872,178296,177769) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired