townhouse middle prime location for sale compound

select * from Mls where ID in (229683,89391,89414,123550,123551,121923,240505,239955,238787,233946,233838,232786,230425,228675,229999,226146,226148,230290,151805,116843,225030,224636,224387,224281,138748,222372,222380,222393,222411,223227,222690,229110,222014,221734,221146,221121,219928,217362,216670,123548,213465,211160,209802,208677,206628,205724,210171,203688,202214,199817,199830,199651,199462,193044,193061,193079,191920,189563,189064,194291,194090,193865,186447,186203,181184,180389,180413,177650,176768,175707,181795,89097,89415,89378,89379,89389,89387,171052,181490,181324,89098,89412,89411,89089,89090,166995,166369,166383,165363,164099,88708,160700,123547,143333,119694,120037,120013,120014,120836,141076,85995,142952,137759,86939,123549,151641,102318,102317,151489,151441,150410,92160,92161,91674,91661,151275,87818,86634,86635,82710,242146,200863,184264,242039,231314,187972,151815,231936,242093,242053,242058,241679,241698,241519,241472,241455,241431,241144,241092,241028,240822,240827,240720,240744,240676,240476,240504,240164,240189,239982,239959,239904,238152,238034,238049,234229,234243,234074,234097,234105,234019,233976,234008,233924,233837,233575,239828,239797,232980,232901,232775,232323,232324,232150,232070,231162,230653,230443,230428,230430,231926,230108,231925,230259,231612,228741,228720,228829,228859,228862,228872,43205,218329,231452,186565,228249,228884,170881,219889,228893) ORDER BY FIELD(ID, 229683,89391,89414,123550,123551,121923,240505,239955,238787,233946,233838,232786,230425,228675,229999,226146,226148,230290,151805,116843,225030,224636,224387,224281,138748,222372,222380,222393,222411,223227,222690,229110,222014,221734,221146,221121,219928,217362,216670,123548,213465,211160,209802,208677,206628,205724,210171,203688,202214,199817,199830,199651,199462,193044,193061,193079,191920,189563,189064,194291,194090,193865,186447,186203,181184,180389,180413,177650,176768,175707,181795,89097,89415,89378,89379,89389,89387,171052,181490,181324,89098,89412,89411,89089,89090,166995,166369,166383,165363,164099,88708,160700,123547,143333,119694,120037,120013,120014,120836,141076,85995,142952,137759,86939,123549,151641,102318,102317,151489,151441,150410,92160,92161,91674,91661,151275,87818,86634,86635,82710,242146,200863,184264,242039,231314,187972,151815,231936,242093,242053,242058,241679,241698,241519,241472,241455,241431,241144,241092,241028,240822,240827,240720,240744,240676,240476,240504,240164,240189,239982,239959,239904,238152,238034,238049,234229,234243,234074,234097,234105,234019,233976,234008,233924,233837,233575,239828,239797,232980,232901,232775,232323,232324,232150,232070,231162,230653,230443,230428,230430,231926,230108,231925,230259,231612,228741,228720,228829,228859,228862,228872,43205,218329,231452,186565,228249,228884,170881,219889,228893) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired