SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+real +estate +information +websites' IN BOOLEAN MODE)) AND iCityID IN (12822,12793,12807,12797,12927,12670,12815,12859,12709,12949,12995,12973,12964,12943,12910,12680,12682,12639,12802,12677,12647,12672,12619,12779,12969,12704,12788,12698,12827,12777,12626,12909,12838,12883,12776,12607,12915,12806,12781,12816,12664,12591,12885,12825,12707,12713,12757,12902,12817,12758,12612,16657,12860,12756,12637,12971,12866,12879,12990,12611,12823,12979,12890,12616,12667,12754,12939,12900,12759,12865,12688,12714,12621,12751,7557,7760,12660,12851,7420,12689,12773,7727,12745,12997,12678,12819,12691,12854,12795,12684,12893,12683,12832,12679,12848,7732,12801,12700,12966,12685,12920,12805,12975) ORDER BY FIELD(iCityID, 12822,12793,12807,12797,12927,12670,12815,12859,12709,12949,12995,12973,12964,12943,12910,12680,12682,12639,12802,12677,12647,12672,12619,12779,12969,12704,12788,12698,12827,12777,12626,12909,12838,12883,12776,12607,12915,12806,12781,12816,12664,12591,12885,12825,12707,12713,12757,12902,12817,12758,12612,16657,12860,12756,12637,12971,12866,12879,12990,12611,12823,12979,12890,12616,12667,12754,12939,12900,12759,12865,12688,12714,12621,12751,7557,7760,12660,12851,7420,12689,12773,7727,12745,12997,12678,12819,12691,12854,12795,12684,12893,12683,12832,12679,12848,7732,12801,12700,12966,12685,12920,12805,12975) ASC, p.tmPosted DESC LIMIT 24
real estate information websites, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Monona
