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