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=101 AND MATCH (t.strSearch) AGAINST ('+homes +for +sale +online +listings' IN BOOLEAN MODE)) AND iCityID IN (70022,69167,69730,68725,70032,69056,68206,68208,69041,69880,67586,68973,69293,68072,68415,68075,67732,69748,68507,66956,67234,67196,67474,68050) ORDER BY FIELD(iCityID, 70022,69167,69730,68725,70032,69056,68206,68208,69041,69880,67586,68973,69293,68072,68415,68075,67732,69748,68507,66956,67234,67196,67474,68050) ASC, p.tmPosted DESC LIMIT 24
homes for sale online listings, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Bagalkot
