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 ('+house +properties +for +sale' IN BOOLEAN MODE)) AND iCityID IN (13008,11501,13010,13011,11526,13005,13009,11249,11485,11543,11320,13006,11285,13007,11374,11199,12021,11652,12115,11902,11465,13012,11186,11899,11788,13003,16203,11334,11593,11562,11764,12007,11956,11555,12035,12196,11582,11768,12276,11704,12228,12077,13013,11829,11708,12109,11594,11499,11250,11598,11394,12355,11548,16204,12183,12066,11207,11198,11613,12022,12383,11786,11890,11660,11327,11219,11606,12008,11641,11827,11872,6887,11576,11352,11810,12009,11903,11713,12074,11603,11635,16651,12334,11760,12323,12297,11850,12361,11779,11185,11650,13014,11372,11464,12051,11824,11732,11544,11778,12011,12227,13004,11611,11665,12401,11392,12151,11460,11345,12052,12030,11322,11609,11848,12369,13002,11168,11996,11794,11558,11636,11621,11793,11841,11587,16251,12232,6734,12156,11838,12112,11442,11468,11175,11585,11573,11456,11884,4485,12351,11203,11340,12114,12079,12063,11823,11911,12373,12366,11766,12285,11491,16215,6708,12175,11241,11142,11620,11737,11632,11633,11845,11583,11505,12379,12356,12081,11747,12327,11818,11201,12113,12139,12164,11683,12010,6742,12094,11685,12170,11247,12098,11773,11717,11758,11607,12203,12037,11966,11173,11970,11339,12320,12017,11549,12378,11678,11155,11503,12328,12102,11756,12108,16259,12267,12038,12368,12099,11851,12150,11393,12012,16237,11570,12084,11287,11980,11674,12036,11654,12157,12291,12307,11371,11731,4471,12214,11204,12088,11243,11669,11308,11282,11904,11213,11631,16250,12261,4288,12097,11360,11808,11600,11991,16247,11962,11228,4892,4845,11361,11697,12065,11655,11337,11399,11801,4832,12357,12249,11488,11451,11907,11280,11401,11355,11805,11297,11176,11435,11831) ORDER BY FIELD(iCityID, 13008,11501,13010,13011,11526,13005,13009,11249,11485,11543,11320,13006,11285,13007,11374,11199,12021,11652,12115,11902,11465,13012,11186,11899,11788,13003,16203,11334,11593,11562,11764,12007,11956,11555,12035,12196,11582,11768,12276,11704,12228,12077,13013,11829,11708,12109,11594,11499,11250,11598,11394,12355,11548,16204,12183,12066,11207,11198,11613,12022,12383,11786,11890,11660,11327,11219,11606,12008,11641,11827,11872,6887,11576,11352,11810,12009,11903,11713,12074,11603,11635,16651,12334,11760,12323,12297,11850,12361,11779,11185,11650,13014,11372,11464,12051,11824,11732,11544,11778,12011,12227,13004,11611,11665,12401,11392,12151,11460,11345,12052,12030,11322,11609,11848,12369,13002,11168,11996,11794,11558,11636,11621,11793,11841,11587,16251,12232,6734,12156,11838,12112,11442,11468,11175,11585,11573,11456,11884,4485,12351,11203,11340,12114,12079,12063,11823,11911,12373,12366,11766,12285,11491,16215,6708,12175,11241,11142,11620,11737,11632,11633,11845,11583,11505,12379,12356,12081,11747,12327,11818,11201,12113,12139,12164,11683,12010,6742,12094,11685,12170,11247,12098,11773,11717,11758,11607,12203,12037,11966,11173,11970,11339,12320,12017,11549,12378,11678,11155,11503,12328,12102,11756,12108,16259,12267,12038,12368,12099,11851,12150,11393,12012,16237,11570,12084,11287,11980,11674,12036,11654,12157,12291,12307,11371,11731,4471,12214,11204,12088,11243,11669,11308,11282,11904,11213,11631,16250,12261,4288,12097,11360,11808,11600,11991,16247,11962,11228,4892,4845,11361,11697,12065,11655,11337,11399,11801,4832,12357,12249,11488,11451,11907,11280,11401,11355,11805,11297,11176,11435,11831) ASC, p.tmPosted DESC LIMIT 24
house properties for sale, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in New Cumberland
