v2-SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.ID IN (296000,566072,573675,574012,758399,768299,787142,790111,805964,295388,751183,279022,294419,294545,572503,573878,573462,756724,557561,568011,754370,786621,292179,293071,294143,295132,295585,572339,572407,572791,572822,573290,573322,574214,574236,768092,779278,791411,796507,295502,294881,754294,783308,787998,294889,292600,571902,572010,573627,574184,761572,766282,294370,294447,775414,765024,768144,770583,291088,280045,297364,576584,577697,579788,582826,583683,806316,295602,295858,573971,760862,770804,787719,801132,582124,583398,284525,285198,299014,579568,285852,575542,580239,580554,581250,581518,582984,769031,796522,799591,295779,573669,752438,290066,291059,288907,289366,758609,803240,574629,579605,751644,752016,779436,290336,290852,554606,571721,571923,572318,573482,573506,573546,793046,806529,764425,788367,338628,554587,766522,768546,772776,768612,775734,289864,291394,559804,577520,775358,801217,297902,582704,298058,397969,573649,574446,575422,575486,576743,578679,579017,579733,581612,583209,809499,292454,293392,295189,768399,772340,576659,580304,582479,765449,801242,576542,583430,297130,297961,297997,298559,578166,578860,775508,802842,298886,578688,579213,579232,582639,583806,584180,584340,759901,760954,767692,774068,779959,787750,788296,581823,575664,768476,299844,565292,577959,581777,774981,785637,581696,583795,775158,792483,576041,576918,759248,763052,764151,770741,772498,777372,783186,788421,795813,798208,805597,292364,292926,293622,572471,573184,573791,573897,753139,807961,769616,294115,572031,572525,765556,767368,782280,788166,805089,545362,801170,551044,758489,574613,580398,795885,560332,575236,752146,762576,780350,291759,291863,291981,293031,293888,294084,294308,295883,295933,571649,571847,571968,573259,574089,754579,762396,763578,782201,793989,794833,794935,795509,795937,806337,548524,549041,577315,578022,808675,778827,751605,293145,296572,576740,576866,577879,578203,582054,583715,754817,763649,767233,807707,292744,294181,291686,292265,292669,294196,572093,572204,572724,572955,573690,803722,750618,756890,574669,767529,548960,798009,773786,792325,555935,566728,774641,289602,553516,766512,788344,771012,772944,784412,789567,806154,289756,297081,297200,297260,572498,575712,577156,578496,580913,581042,581172,581200,581789,582030,582613,584421,797584,805798,806585,809096,806918,289927,766629,290095,582188,753796,755906,787787,298367,298726,578710,581399,582263,582807,769897,776973,778772,579967,777347,551221,553135,579135,750908,572249,765300,783200,784880,295564,546679,548720,554675,573244,792786,574379,583322,575316,575444,576816,579403,579495,583126,583375,583750,753515,787525,792918,808335,296056,296191,296342,578949,581861,584356,762586,794103,578083,792736,790722,297987,570762,576570,576794,577553,578346,578836,580329,580405,580460,581359,581802,582558,583474,583490,757630,771069,801674,804982,805415,575127,576317,578489,793122,299713,545016,574719,576290,577447,578323,583945,754994,776792,778494,790334,580793,582928,780751,808612,575801,576683,785109,788991,548377,771289,771783,783414,577895,580665,542895,783745,578477,578624,806613,290565,299870,576181,576238,577995,579077,580116,580902,581019,581990,582240,582288,582352,583868,584002,584284,754771,796420,804262,808131,296541,577618,579356,580487,756794,763725,796121,575952,296873,550860,582743,776562,760712,542472,770036,790200,807026,297274,577719,796947,781041,342717,753445,775829,787210,578580,579104,579248,772356,797174,803496,577798,580368,562829,563638,575346,577085,752119,765166,770754,781447,783219,792106,792881,548881,557950,574816,576416,582611,584223,761583,771058,781821,789330,798308,296724,786437,583265,572803,751473,547757,561836,576766,751703,758948,761392,765295,774992,785827,790426,792673,297099,575079,581719,578239,581662,580962,581546,808199,544353,550257,574973,575368,579694,582098,582492,582853,583730,753107,756068,773283,776244,782646,800929,560909,581435,765943,785325,803393,551348,799558,559546,789614,774453,541347,566382,775075,786880,802707,803175,806388,758971,545140,559224,566407,751211,759027,761882,766352,774554,785070,785905,290300,770921,772462,545656,761346,775689,783484,788642,541832,543313,543579,543934,548487,555654,556569,557815,568238,750429,756743,769258,772627,772841,778209,778531,782352,789497,789658,790803,793446,760918,769801,781689,580940,758793,799973,570069,764857,804297,397911,772757,794013,794963,797777,798081,800998,802904,804850,809347,757970,795921,751768,768575,608467,800960,758658,344708,753946,771761,784939,801338,804275,804466,805724,805768,758725,782222,783527,786932,787320,795767,796166,799698,801812,802561,802928,804220,804908,804944,805443,806096,806263,807185,807935,808037,808047,808750,794192,802947,787806,796282,807766,794763,802053,804378,797369,771553,283709,779905,771127,766992,793077,795081,795282,805564,754094,768307,801468,808778,799827,797708,797195,801604,560198,786777,802972,770513,799937) AND ( wp_term_relationships.term_taxonomy_id IN (36) ) AND ( wp_postmeta.meta_key = 'prop_featured' ) AND wp_posts.post_type = 'estate_property' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, wp_posts.ID DESC LIMIT 0, 30
Login to save search and you will receive an email notification when new properties matching your search will be published.
Use the form below to contact us!