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 (272721,273108,273220,274529,275339,276451,276568,277040,277552,278614,278751,278831,278971,279022,279353,279406,279473,279748,279832,280033,280045,280075,280356,280638,280768,280856,280998,281088,281541,281550,281716,281721,281845,281917,282022,282303,282379,282655,282729,282793,282857,282971,283098,283242,283285,283378,283709,283864,283888,283979,284072,284167,284345,284525,284595,284745,284914,285016,285135,285198,285267,285462,285543,285681,285800,285852,285893,285917,285961,286044,286218,288907,289366,289602,289756,289864,289927,290066,290095,290300,290336,290565,290852,291059,291088,291394,291686,291759,291863,291981,292179,292265,292364,292454,292600,292669,292744,292926,293031,293071,293145,293392,293622,293888,294084,294115,294143,294181,294196,294308,294370,294419,294447,294545,294881,294889,295132,295189,295388,295502,295564,295585,295602,295779,295858,295883,295933,296000,296056,296191,296342,296541,296572,296724,296873,297081,297099,297130,297200,297260,297274,297364,297902,297961,297987,297997,298058,298367,298559,298726,298886,299014,299713,299844,299870,328957,329074,329309,329556,329644,330317,330348,330415,330740,330857,331254,331732,331823,332262,332888,332955,333333,333511,333598,333632,333763,333781,334027,334201,334355,334568,334594,334656,334706,334715,334869,334899,334935,335051,335074,335461,335526,335667,335736,335742,336297,336698,337198,337481,337490,337562,337704,337730,337758,337810,338253,338358,338385,338628,338693,338713,338957,339049,339065,339190,339219,339337,339373,339469,339491,339514,339524,339534,339565,339687,340025,340136,340193,340214,340284,340358,341030,341077,341117,341123,341290,341420,341618,341664,341700,341721,341849,342036,342072,342086,342138,342210,342219,342273,342375,342459,342567,342573,342625,342717,342805,342959,343049,343159,343255,343314,343360,343457,343569,343578,343680,343844,343959,344295,344708,346286,347202,347468,347884,348346,348447,348874,348908,349504,349538,351195,351234,351360,351464,351548,351762,351971,352116,352156,352313,352340,352633,352670,352905,353169,353279,397843,397911,397969,541106,541143,541177,541241,541328,541347,541368,541401,541472,541494,541597,541666,541731,541821,541832,541859,541955,542054,542066,542093,542368,542401,542440,542472,542553,542591,542617,542635,542694,542719,542761,542815,542851,542895,542937,543105,543185,543203,543293,543301,543313,543489,543549,543579,543649,543672,543687,543702,543740,543766,543801,543845,543856,543909,543934,543966,544020,544139,544161,544192,544284,544342,544353,544377,544400,544426,544429,544494,544565,544604,544774,544902,544940,544977,545016,545027,545057,545076,545140,545184,545306,545331,545362,545481,545525,545553,545656,545678,545694,545702,545757,545855,545871,545978,546157,546178,546215,546255,546387,546396,546465,546532,546553,546574,546679,546814,547042,547072,547138,547161,547222,547286,547319,547363,547372,547442,547542,547589,547653,547701,547757,547778,547800,547843,548079,548141,548181,548224,548259,548264,548346,548377,548392,548421,548440,548487,548495,548524,548586,548639,548689,548720,548736,548881,548894,548924,548960,548993,549041,549062,549108,549277,549314,549339,549437,549585,549829,549922,549993,550056,550159,550200,550215,550257,550278,550340,550365,550366,550394,550431,550443,550582,550604,550647,550663,550752,550769,550782,550796,550860,550936,550975,551027,551044,551053,551089,551221,551247,551348,551379,551436,551464,551497,551567,551654,551678,551709,551821,551856,551869,551955,552056,552082,552119,552123,552131,552144,552192,552223,552235,552274,552337,552420,552453,552488,552563,552590,552645,552712,552822,552947,552984,553012,553109,553135,553154,553178,553193,553290,553391,553410,553431,553460,553512,553516,553567,553615,553714,553837,553894,553934,553997,554065,554124,554195,554241,554315,554529,554587,554606,554675,554730,554878,554937,555024,555031,555099,555252,555306,555320,555345,555396,555421,555434,555534,555569,555603,555629,555654,555717,555773,555788,555820,555829,555839,555870,555900,555935,555977,556045,556090,556134,556190,556239,556294,556362,556474,556569,556634,556672,556696,556816,556929,557045,557292,557314,557340,557418,557444,557561,557577,557732,557798,557815,557866,557879,557893,557915,557950,557965,558014,558194,558323,558348,558369,558442,558479,558503,558526,558558,558685,558752,558856,558882,558992,559062,559101,559142,559183,559224,559244,559277,559418,559431,559462,559494,559546,559620,559640,559684,559750,559790,559804,559859,559886,559953,559987,560037,560066,560069,560101,560198,560206,560265,560301,560332,560448,560471,560512,560612,560681,560687,560878,560909,560923,561004,561096,561163,561277,561511,561527,561577,561678,561691,561813,561836,561903,561921,561924,562010,562072,562248,562433,562479,562501,562528,562533,562705,562821,562829,562878,562888,562918,562949,562951,562968,562988,562999,563013,563061,563172,563312,563329,563433,563444,563514,563538,563550,563570,563638,563651,563729,563970,563991,564019,564187,564230,564281,564288,564312,564358,564377,564393,564482,564529,564600,564617,564700,564793,564842,564852,564946,565094,565270,565292,565464,565488,565538,565575,565585,565605,565846,565883,565894,565926,565963,566025,566072,566162,566202,566224,566275,566365,566382,566407,566428,566444,566457,566494,566525,566543,566657,566683,566704,566728,566832,566879,566928,567012,567053,567065,567125,567173,567249,567389,567526,567547,567583,567600,567668,567813,567843,567878,567888,567982,568011,568026,568079,568088,568141,568194,568206,568223,568238,568322,568384,568400,568416,568496,568525,568573,568677,568782,568845,568882,568951,569071,569248,569267,569286,569305,569334,569365,569370,569398,569464,569563,569642,569665,569688,569738,569789,569813,569883,570011,570034,570069,570112,570203,570237,570329,570367,570478,570509,570516,570595,570733,570762,570770,570829,570953,570984,571039,571099,571132,571150,571174,571263,571336,571385,571649,571721,571847,571902,571923,571968,572010,572031,572093,572204,572249,572318,572339,572407,572471,572498,572503,572525,572724,572791,572803,572822,572955,573184,573244,573259,573290,573322,573462,573482,573506,573546,573627,573649,573669,573675,573690,573791,573878,573897,573971,574012,574089,574184,574214,574236,574379,574446,574613,574629,574669,574719,574816,574973,575079,575127,575236,575316,575346,575368,575422,575444,575486,575542,575664,575712,575801,575952,576041,576181,576238,576290,576317,576416,576542,576570,576584,576659,576683,576740,576743,576766,576794,576816,576866,576918,577085,577156,577315,577447,577520,577553,577618,577697,577719,577798,577879,577895,577959,577995,578022,578083,578166,578203,578239,578323,578346,578477,578489,578496,578580,578624,578679,578688,578710,578836,578860,578949,579017,579077,579104,579135,579213,579232,579248,579356,579403,579495,579568,579605,579694,579733,579788,579967,580116,580239,580304,580329,580368,580398,580405,580460,580487,580554,580665,580793,580902,580913,580940,580962,581019,581042,581172,581200,581250,581359,581399,581435,581518,581546,581612,581662,581696,581719,581777,581789,581802,581823,581861,581990,582030,582054,582098,582124,582188,582240,582263,582288,582352,582479,582492,582558,582611,582613,582639,582704,582743,582807,582826,582853,582928,582984,583126,583209,583265,583322,583375,583398,583430,583474,583490,583683,583715,583730,583750,583795,583806,583868,583945,584002,584180,584223,584284,584340,584356,584421,584478,584514,584565,584621,584675,584736,584825,584934,585107,585317,585350,585396,585423,585461,585488,585518,585571,585603,585637,585656,585693,585783,585828,585887,585898,585926,585933,586032,586054,586111,586116,586189,586235,586404,586501,586598,586660,586748,586889,586902,586988,587043,587071,587192,587250,587274,587316,587400,587541,587574,587594,587621,587705,587737,587794,587946,588171,588213,588377,588456,588491,588534,588573,588615,588739,588940,589044,589095,589136,589168,589239,589257,589314,589409,589542,589607,589679,589734,589755,589792,589847,589972,590087,590108,590140,590203,590260,590331,590350,590374,590401,590427,590443,590559,590592,590613,590652,590727,590742,590771,590815,590933,590995,591009,591061,591076,591228,591249,591300,591353,591364,591491,591506,591534,591600,591630,591691,591706,591794,591890,592052,592095,592268,592330,592337,592418,592435,592625,592664,592742,592844,592866,592945,592959,592985,593051,593121,593173,593228,593264,593300,593331,593384,593418,593441,593472,593486,593501,593615,593656,593737,593790,593840,593885,593948,594094,594155,594178,594198,594301,594350,594475,594568,594677,594727,594778,594805,594840,594909,594953,595063,595258,595448,595495,595543,595570,595666,595772,595842,595921,595950,596023,596053,596110,596130,596178,596206,596275,596350,596414,596576,596867,597061,597067,597077,597149,597163,597226,597240,597294,597300,597516,597573,597607,597804,597853,597879,597971,598031,598142,598258,598272,598298,598359,598398,598495,598545,598609,598628,598710,598739,598770,598811,598860,598906,598932,599021,599120,599195,599211,599350,599363,599404,599442,599502,599530,599582,599619,599668,599734,599751,599863,599956,600003,600089,600123,600155,600321,600363,600406,600450,600529,600566,600793,601001,601020,601264,601287,601336,601369,601441,601488,601717,602026,602105,602201,602286,602452,602485,602590,602632,602669,602758,602782,602813,602853,602912,602919,602947,603013,603162,603262,603368,603438,603471,603511,603551,603728,603796,603841,603964,604046,604132,604169,604254,604272,604298,604474,604584,604707,604784,604866,604960,604989,605001,605112,605216,605314,605391,605557,605644,605684,605687,605746,605774,605818,605855,605972,606053,606175,606302,606326,606448,606538,606623,606657,606711,606734,606903,607055,607066,607100,607198,607247,607337,607364,607390,607418,607588,607624,607644,607682,607777,607815,607967,607993,608009,608022,608029,608066,608088,608129,608191,608246,608386,608403,608432,608467,608567,608599,608655,608736,608813,608846,609011,609051,609105,609183,609244,609312,609334,609366,609436,609520,609560,609631,609705,609708,609733,609788,609804,609869,609923,609946,609980,610316,610361,610389,610416,610435,610486,610561,610601,610703,610768,610800,610831,610891,610964,610995,611001,611013,611029,611103,611135,611259,611289,611348,611414,611437,611554,611623,611792,611981,612013,612081,612113,612230,612459,612496,612595,612624,612625,612676,612780,612876,612889,612930,612976,613010,613358,613375,613460,613489,613528,613565,613600,613767,613796,613856,614024,614049,614127,614181,614234,614345,614359,614515,614683,614702,614724,614763,614819,614855,614892,614993,615005,615046,615081,615126,615152,615199,615220,615275,615321,615335,615418,615438,615476,615766,615849,615866,615883,615928,615953,616017,616123,616146,616211,616239,616249,616296,616334,616375,616385,616429,616465,616522,616537,616569,616595,616632,616651,616666,616846,616907,616969,617002,617095,617377,617390,617488,617571,617602,617683,617701,617773,617785,617821,617949,617970,617997,618019,618054,618077,618131,618189,618280,618339,618371,618403,618466,618492,618509,618543,618594,618623,618672,618728,618746,618813,618964,619014,619083,619188,619462,619523,619591,619609,619636,619734,619891,619904,619911,619983,620017,620040,620064,620089,620192,620268,620365,620455,620570,620592,620686,620797,620861,620913,620960,621028,621071,621183,621312,621346,621418,621491,621647,621666,621728,621753,621801,621825,621864,621866,622018,622037,622049,622095,622146,622382,622398,622415,622462,622483,622507,622564,622586,622657,622709,622761,622822,623126,623169,623214,623256,623320,623546,623556,623694,623728,623763,623796,623831,623859,624085,624237,624371,624436,624487,624538,624649,624681,624724,624754,624886,624900,625144,625190,625310,625350,625385,625404,625428,625513,625529,625596,625634,625665,625700,625849,625948,626086,626110,626183,626305,626405,626460,626560,626604,626640,626700,626839,626921,626936,626949,627010,627108,627128,627173,627274,627314,627329,627387,627420,627621,627746,627776,627866,627920,628036,628057,628083,628107,628176,628245,628294,628320,628345,628421,628530,628585,628626,628653,628680,628732,628786,628804,628885,628976,629011,629041,629063,629109,629154,629225,629362,629389,629428,629529,629588,629615,629735,629777,629797,629927,629986,630068,630095,630128,630161,630191,630251,630267,630338,630363,630392,630430,630501,630536,630571,630615,630678,630715,630736,630805,630897,630927,630942,630970,630991,631016,631085,631196,631227,631250,631277,631315,631358,631391,631400,631541,631601,631746,631793,631810,631957,632037,632093,632219,632282,632336,632363,632429,632451,632494,632512,632569,632592,632675,632732,632744,632772,632823,632854,632899,632923,632940,633033,633058,633246,633292,633325,633338,633539,633574,633707,633737,633866,633887,633907,634028,634144,634189,634199,634347,634372,634398,634506,634517,634570,634643,634662,634704,634800,634861,634938,635051,635126,635156,635185,635199,635228,635253,635304,635343,635425,635441,635492,635574,635659,635850,636040,636108,636193,636310,636345,636484,636541,636637,636738,636842,636881,636962,637029,637107,637153,637165,637236,637251,637321,637413,637576,637659,637668,637737,637805,637934,637974,638024,638040,638091,638151,638204,638224,638277,638328,638411,638517,638575,638691,638711,638749,638779,638831,639008,639033,639069,639085,639170,639206,639273,639402,639436,639487,639631,639722,639734,639750,639938,639962,640058,640146,640218,640237,640255,640291,640310,640477,640527,640568,640615,640680,640709,640726,640807,640859,640883,641031,641041,641059,641099,641118,641133,641160,641187,641336,641370,641500,641612,641643,641714,641738,641856,641907,641940,641974,642025,642052,642126,642164,642255,642309,642381,642484,642590,642669,642843,642973,643035,643044,643068,643103,643126,643152,643178,643199,643308,643327,750313,750328,750372,750397,750429,750455,750471,750509,750532,750570,750583,750615,750618,750644,750680,750702,750719,750746,750772,750817,750835,750865,750883,750908,750919,750939,750957,750979,751007,751032,751120,751146,751148,751171,751183,751211,751227,751251,751299,751311,751341,751388,751408,751431,751457,751473,751502,751511,751529,751542,751605,751644,751677,751703,751743,751768,751783,751804,751821,751838,751857,751873,751899,751917,751988,751999,752016,752051,752077,752102,752119,752146,752215,752239,752266,752305,752331,752348,752419,752438,752444,752469,752518,752533,752569,752602,752684,752688,752721,752749,752760,752776,752796,752832,752877,752918,752935,752954,752977,752995,753025,753053,753089,753107,753139,753165,753199,753216,753237,753265,753281,753286,753305,753330,753361,753405,753445,753515,753530,753564,753570,753588,753602,753618,753636,753697,753749,753766,753796,753827,753844,753860,753902,753946,753967,754027,754036,754094,754112,754123,754166,754193,754219,754254,754267,754294,754333,754370,754411,754446,754473,754484,754522,754542,754579,754607,754660,754728,754754,754765,754771,754801,754817,754827,754830,754835,754889,754913,754994,755027,755051,755075,755098,755143,755218,755239,755272,755329,755365,755379,755409,755448,755473,755492,755513,755553,755586,755622,755648,755661,755663,755692,755708,755747,755756,755792,755811,755859,755876,755906,755908,755921,755929,755969,756011,756028,756057,756068,756079,756145,756193,756220,756263,756302,756318,756336,756352,756380,756419,756438,756473,756507,756542,756568,756592,756605,756666,756699,756710,756724,756743,756767,756794,756839,756856,756884,756890,756906,756931,756933,756984,757019,757088,757160,757209,757222,757244,757252,757257,757271,757278,757294,757316,757326,757345,757353,757363,757379,757404,757416,757494,757536,757558,757569,757588,757590,757630,757649,757682,757711,757750,757785,757798,757838,757840,757879,757910,757970,757983,757994,758012,758027,758047,758064,758074,758192,758202,758229,758234,758256,758271,758324,758377,758399,758419,758477,758489,758502,758560,758598,758609,758658,758706,758710,758722,758725,758756,758783,758786,758793,758819,758840,758853,758907,758923,758948,758971,759007,759027,759068,759098,759103,759137,759142,759169,759202,759248,759267,759311,759361,759401,759443,759492,759522,759547,759578,759628,759675,759721,759746,759769,759817,759833,759853,759901,759931,759948,759964,760002,760040,760068,760133,760145,760197,760243,760274,760307,760336,760354,760388,760452,760457,760481,760495,760507,760547,760572,760582,760604,760615,760650,760672,760681,760712,760742,760747,760749,760771,760800,760808,760830,760862,760918,760954,761020,761062,761122,761141,761166,761291,761311,761346,761358,761392,761408,761442,761467,761572,761583,761623,761667,761685,761731,761763,761865,761882,761923,761957,761968,761973,761996,762012,762044,762062,762101,762130,762138,762139,762162,762194,762239,762268,762299,762348,762354,762396,762405,762417,762457,762480,762493,762524,762576,762586,762645,762683,762702,762773,762804,762806,762837,762855,762874,762885,762901,762922,762929,762955,762994,763006,763052,763072,763143,763178,763202,763218,763243,763266,763297,763355,763385,763411,763428,763449,763498,763511,763516,763578,763594,763597,763639,763649,763681,763688,763725,763777,763827,763875,763910,763941,763968,764002,764036,764089,764127,764151,764164,764221,764252,764290,764305,764333,764384,764425,764470,764494,764525,764553,764609,764625,764645,764685,764715,764755,764776,764857,764894,764927,764951,764955,764974,765005,765024,765071,765087,765129,765150,765166,765189,765207,765252,765295,765300,765328,765364,765391,765410,765449,765470,765475,765498,765545,765556,765608,765613,765624,765635,765686,765702,765731,765750,765756,765769,765801,765836,765847,765850,765883,765933,765943,765971,766000,766074,766085,766109,766119,766126,766148,766178,766182,766237,766253,766272,766277,766282,766297,766322,766324,766352,766383,766406,766428,766456,766500,766502,766512,766522,766532,766567,766598,766616,766629,766641,766666,766689,766758,766806,766831,766871,766902,766933,766972,766992,767059,767107,767144,767178,767233,767253,767273,767289,767312,767368,767401,767422,767438,767485,767529,767595,767627,767648,767677,767692,767724,767745,767777,767790,767844,767895,767901,767913,767943,767951,767982,767997,768032,768056,768092,768114,768144,768161,768240,768255,768299,768307,768333,768346,768353,768368,768399,768413,768476,768482,768501,768536,768546,768557,768575,768612,768646,768657,768681,768712,768734,768784,768809,768859,768910,768948,769031,769053,769115,769138,769179,769200,769258,769293,769300,769321,769349,769379,769448,769461,769477,769482,769512,769531,769584,769616,769626,769697,769753,769785,769801,769826,769834,769861,769897,769909,769934,769949,769971,770012,770036,770056,770058,770100,770127,770186,770226,770253,770283,770320,770331,770359,770410,770423,770436,770449,770513,770533,770583,770608,770610,770629,770642,770643,770665,770704,770726,770741,770754,770804,770825,770851,770871,770897,770920,770921,770944,770987,770992,771012,771049,771054,771058,771060,771069,771096,771101,771127,771141,771174,771232,771269,771289,771306,771308,771329,771369,771410,771435,771458,771499,771527,771553,771562,771609,771635,771682,771719,771737,771748,771761,771783,771801,771854,771879,771904,771941,772000,772063,772106,772124,772134,772182,772210,772232,772272,772277,772310,772340,772356,772377,772400,772425,772462,772474,772487,772498,772515,772550,772566,772627,772657,772666,772711,772714,772722,772749,772757,772776,772785,772792,772813,772820,772841,772866,772907,772917,772944,772962,773033,773086,773102,773162,773196,773230,773271,773283,773312,773330,773343,773356,773367,773419,773473,773486,773575,773595,773598,773648,773673,773711,773740,773758,773786,773802,773834,773841,773877,773894,773944,773979,773986,774007,774049,774068,774077,774104,774143,774224,774282,774308,774339,774376,774393,774439,774453,774463,774473,774499,774527,774554,774573,774634,774641,774668,774701,774724,774749,774817,774820,774853,774924,774981,774992,775033,775046,775075,775158,775189,775205,775227,775240,775253,775267,775289,775294,775327,775358,775398,775414,775421,775438,775475,775499,775508,775530,775538,775554,775592,775614,775653,775689,775700,775732,775734,775742,775764,775799,775829,775860,775890,775900,775967,775994,776021,776045,776070,776087,776137,776186,776213,776244,776279,776293,776343,776348,776358,776396,776430,776480,776495,776543,776562,776586,776613,776619,776682,776719,776724,776739,776773,776792,776799,776830,776838,776879,776891,776907,776925,776953,776973,776999,777012,777032,777089,777113,777161,777172,777255,777277,777297,777312,777347,777372,777414,777443,777495,777568,777583,777602,777660,777665,777675,777700,777735,777786,777791,777805,777834,777865,777883,777885,777908,777922,777934,777963,777978,777980,778003,778010,778035,778051,778071,778099,778149,778185,778209,778237,778264,778326,778400,778407,778448,778478,778494,778515,778531,778541,778567,778580,778590,778626,778671,778692,778715,778756,778764,778772,778792,778827,778870,778892,778925,778963,779015,779048,779071,779084,779105,779110,779144,779168,779216,779240,779278,779314,779369,779378,779394,779413,779436,779468,779493,779572,779600,779679,779697,779717,779738,779757,779789,779810,779830,779905,779922,779948,779959,779968,779996,780015,780020,780045,780075,780121,780135,780162,780202,780207,780229,780291,780326,780350,780376,780392,780404,780446,780482,780521,780549,780595,780613,780651,780672,780698,780701,780707,780727,780729,780751,780765,780792,780818,780883,780910,780945,780992,780994,781011,781041,781061,781086,781166,781225,781234,781255,781315,781400,781408,781447,781474,781494,781497,781507,781544,781552,781591,781602,781630,781666,781689,781711,781736,781765,781784,781806,781821,781844,781872,781914,781931,781948,781958,781987,782041,782072,782081,782102,782156,782184,782195,782201,782207,782222,782280,782285,782297,782331,782352,782376,782381,782410,782469,782485,782496,782515,782559,782581,782606,782646,782678,782695,782697,782729,782757,782770,782785,782804,782836,782858,782908,782957,782974,782989,782991,783032,783050,783093,783117,783128,783164,783186,783200,783219,783238,783245,783253,783284,783308,783354,783367,783414,783437,783448,783470,783484,783514,783527,783565,783570,783589,783611,783628,783687,783699,783719,783745,783768,783832,783856,783869,783880,783910,783958,783979,784000,784012,784035,784112,784141,784161,784249,784307,784313,784332,784365,784401,784412,784445,784464,784486,784508,784522,784578,784598,784621,784689,784697,784709,784763,784776,784802,784823,784858,784865,784880,784919,784939,784964,784983,785022,785033,785070,785109,785160,785193,785224,785269,785297,785317,785325,785337,785353,785387,785426,785447,785486,785541,785565,785598,785624,785637,785643,785661,785663,785712,785744,785772,785798,785827,785866,785905,785915,785953,785976,786032,786083,786112,786145,786189,786205,786231,786260,786272,786321,786333,786335,786372,786386,786404,786437,786461,786471,786492,786503,786550,786578,786600,786621,786639,786660,786692,786709,786777,786812,786822,786880,786908,786932,786986,787015,787034,787072,787100,787142,787163,787210,787216,787227,787297,787320,787422,787446,787464,787504,787525,787548,787572,787613,787630,787640,787664,787690,787708,787719,787750,787787,787806,787819,787849,787870,787884,787920,787940,787987,787998,788000,788046,788066,788084,788131,788141,788166,788199,788242,788296,788309,788344,788367,788374,788421,788428,788499,788501,788552,788582,788614,788642,788692,788714,788753,788764,788801,788833,788849,788878,788936,788991,789033,789054,789107,789121,789187,789203,789237,789284,789316,789330,789359,789398,789427,789455,789497,789503,789543,789567,789614,789641,789658,789664,789677,789705,789775,789778,789792,789821,789898,789914,789981,790026,790052,790090,790111,790200,790218,790247,790275,790301,790334,790341,790346,790399,790417,790426,790469,790486,790509,790531,790568,790596,790629,790653,790700,790720,790722,790756,790789,790803,790824,790839,790846,790893,790930,790946,790988,791032,791039,791123,791140,791160,791199,791222,791241,791279,791340,791379,791411,791442,791494,791534,791546,791550,791565,791577,791590,791595,791614,791638,791644,791688,791699,791770,791792,791825,791868,791894,791905,791933,791954,791971,791983,792035,792045,792096,792106,792141,792170,792207,792241,792272,792320,792325,792360,792371,792415,792436,792440,792463,792483,792498,792539,792560,792609,792612,792623,792656,792673,792685,792709,792736,792755,792786,792811,792830,792881,792889,792918,792934,792943,793007,793023,793046,793071,793077,793122,793133,793139,793199,793234,793292,793311,793316,793332,793348,793366,793446,793476,793565,793600,793622,793631,793647,793668,793687,793698,793709,793722,793768,793782,793810,793897,793937,793989,794013,794065,794103,794138,794179,794192,794283,794315,794394,794441,794478,794508,794567,794634,794660,794692,794763,794789,794810,794833,794834,794862,794935,794963,794980,795081,795119,795122,795190,795206,795246,795282,795290,795325,795421,795509,795523,795557,795578,795622,795660,795706,795767,795813,795834,795863,795877,795885,795921,795937,795982,796013,796077,796121,796166,796198,796282,796370,796420,796465,796507,796511,796522,796565,796596,796600,796663,796689,796708,796749,796760,796902,796947,796996,797042,797083,797119,797128,797130,797157,797174,797195,797226,797277,797283,797297,797310,797331,797367,797369,797406,797468,797521,797527,797561,797584,797670,797672,797708,797777,797792,797821,797861,797900,797904,797950,797955,798001,798009,798081,798104,798149,798166,798208,798222,798308,798386,798450,798489,798503,798583,798606,798712,798750,798777,798850,798875,798924,798971,799030,799065,799089,799164,799199,799241,799330,799344,799392,799420,799447,799480,799510,799558,799591,799593,799635,799666,799694,799698,799757,799765,799789,799827,799847,799877,799929,799937,799973,799999,800005,800046,800061,800119,800153,800186,800194,800237,800284,800286,800323,800393,800440,800511,800547,800565,800609,800630,800720,800758,800788,800809,800856,800876,800921,800929,800960,800998,801046,801066,801068,801100,801132,801146,801170,801217,801242,801275,801296,801338,801378,801386,801466,801468,801485,801515,801562,801604,801650,801674,801707,801738,801812,801838,801876,801933,801954,801965,802002,802025,802053,802083,802086,802102,802161,802200,802274,802292,802362,802407,802472,802529,802561,802580,802615,802622,802656,802707,802750,802771,802808,802842,802878,802897,802904,802928,802947,802970,802972,803023,803060,803102,803134,803155,803175,803200,803240,803303,803332,803377,803393,803410,803430,803450,803496,803546,803598,803614,803670,803722,803774,803820,803840,803844,803852,803869,803906,803943,803975,804040,804106,804167,804220,804262,804275,804297,804339,804378,804438,804466,804487,804533,804547,804572,804582,804641,804675,804750,804788,804850,804898,804908,804942,804944,804982,805014,805021,805075,805076,805089,805125,805184,805237,805260,805304,805307,805383,805415,805443,805473,805545,805553,805564,805597,805627,805724,805768,805798,805827,805863,805914,805964,806028,806063,806096,806154,806191,806225,806263,806316,806337,806388,806456,806486,806516,806529,806585,806613,806644,806681,806720,806743,806755,806800,806863,806885,806918,806934,806973,807026,807062,807071,807085,807090,807174,807185,807208,807241,807304,807329,807407,807426,807527,807568,807583,807619,807659,807673,807707,807760,807766,807827,807883,807935,807961,807978,808004,808037,808047,808069,808131,808153,808181,808199,808246,808276,808301,808335,808361,808402,808441,808463,808502,808563,808612,808675,808710,808750,808778,808818,808854,808891,808927,809001,809046,809096,809110,809132,809190,809237,809267,809317,809347,809366,809416,809484,809499,809513,809571) 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
click to enable zoom
loading...
We didn't find any results
open map
View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next

We found 6cc 0 results.

Properties (3977)

Login to save search and you will receive an email notification when new properties matching your search will be published.

For Sale
Active

3131 NE 7th Ave # 2605, Miami ...

$ 1,195,000
Stunning 2-bed/2-bath unit with private elevator and foyer. ...
2 2 1,088 Sqftdetails
QuiqNest Properties
For Sale
Active

3470 E Coast Ave # H2205, Miam...

$ 780,000
Renovated 2 beds & 2 baths unit located in Midtown Miami ...
2 2 964 Sqftdetails
QuiqNest Properties
For Sale
Active

1000 Brickell Plz, Miami FL 33...

$ 3,500,000
Brickell Flatiron is an ultra luxury condo development locat ...
3 4 2,342 Sqftdetails
QuiqNest Properties
For Sale
Active

3330 NE 190th St # 618, Aventu...

$ 840,000
Beautiful apartment with amazing views, excellent location, ...
3 3 1,720 Sqftdetails
QuiqNest Properties
For Sale
Active

17213 SW 156th Ct, Miami FL 33...

$ 1,149,000
This spacious one-story modern/contemporary home features 4 ...
4 3 2,166 Sqftdetails
QuiqNest Properties

300 Sunny Isles Blvd # 705, Su...

$ 1,190,000
Outstanding apartment professionally decorated by the renown ...
2 3 1,541 Sqftdetails
QuiqNest Properties
For Sale
Active

398 NE 5 # 3617, Miami FL 3313...

$ 1,396,756
Spacious 2 Bedrooms + Den / 3 Baths. Discover a collection o ...
2 3 1,149 Sqftdetails
QuiqNest Properties

20191 SE Country Club Dr # 271...

$ 749,900
Great size split plan 2/2 with amazing views. Really bright ...
2 2 1,622 Sqftdetails
QuiqNest Properties
For Sale
Active

1211 NE 82nd St, Miami FL 3313...

$ 2,800,000
STUNNING WATERFRONT MID-CENTURY MODERN HOME IN MIAMI’S ...
3 2 2,194 Sqftdetails
QuiqNest Properties
For Sale
Active

12970 SW 187th Ter, Miami FL 3...

$ 1,350,000
This spacious home is located on a cul de sac for extra priv ...
4 3 3,396 Sqftdetails
QuiqNest Properties
For Sale
Active

3145 Ohio St, Miami FL 33133 |...

$ 2,300,000
Spectacular Brand New Construction in Coconut Grove. This ho ...
4 4 2,335 Sqftdetails
QuiqNest Properties
For Sale
Active

15790 NE 2nd Ave, Miami FL 331...

$ 1,250,000
The wait is over! We are thrilled to present this remarkable ...
5 3 2,526 Sqftdetails
QuiqNest Properties
For Sale
Active

15200 SW 167th St, Miami FL 33...

$ 1,215,000
Beautifully maintained home, nestled in the highly desired l ...
5 3 2,761 Sqftdetails
QuiqNest Properties
For Sale
Active

68 SE 6th St # 2010, Miami FL ...

$ 1,035,000
Stylish and roomy 2 Bed/2Bath condo at the sought-after Reac ...
2 2 1,193 Sqftdetails
QuiqNest Properties
For Sale
Active

1625 SW 145 Ave, Miami FL 3317...

$ 1,075,000
2023 New Construction Home with many upgrades. This Home Fea ...
4 4 2,503 Sqftdetails
QuiqNest Properties
For Sale
Active

3190 Sheridan Ave, Miami Beach...

$ 2,400,000
This elegant home is waiting to be restored to its splendor ...
5 4 3,384 Sqftdetails
QuiqNest Properties
For Sale
Active

7915 SW 64th Ter, Miami FL 331...

$ 2,499,000
A Tropical Paradise Awaits. Nestled on a corner lot in one o ...
5 4 3,344 Sqftdetails
QuiqNest Properties
For Sale
Active

7260 SW 19th St, Miami FL 3315...

$ 720,000
This beautiful house with updated 3 bedrooms, 2 bathrooms, n ...
3 2 1,164 Sqftdetails
QuiqNest Properties

1330 West Ave # 514, Miami Bea...

$ 709,900
Come view this beautiful corner unit in The Waverly at South ...
2 2 1,262 Sqftdetails
QuiqNest Properties

6000 Indian Creek Dr # 17B, Mi...

$ 1,750,000
Experience the epitome of luxury living in this breathtaking ...
2 3 1,300 Sqftdetails
QuiqNest Properties
For Sale
Active

1100 Biscayne Blvd # 5703, Mia...

$ 1,100,000
Views that wil leave you breathless from this 57th floor bea ...
2 3 1,498 Sqftdetails
QuiqNest Properties

851 NE 1st Ave # 3907, Miami F...

$ 1,795,000
Luxurious, stunning, fully furnished large 3/2 plus den apar ...
QuiqNest Properties
For Sale
Active

9801 Collins Ave # 10G, Bal Ha...

$ 1,200,000
Awaken each morning to views of the Atlantic, spend days lou ...
2 2 1,388 Sqftdetails
QuiqNest Properties
For Sale
Active

1155 Brickell Bay Dr, Miami FL...

$ 824,900
Breathtaking 2BR/2BA Corner Unit Penthouse at The Mark on Br ...
2 2 1,200 Sqftdetails
QuiqNest Properties
For Sale
Active

701 Brickell Key Blvd # 06, Mi...

$ 1,690,000
EXQUISITE LOW-PENTHOUSE APARTMENT! Amazing views for and fiv ...
3 4 2,163 Sqftdetails
QuiqNest Properties
For Sale
Active

2759 NE 184th Way, Aventura FL...

$ 795,000
This beautiful and spacious 3 beds & 2.5 baths plus Den ...
3 3 1,797 Sqftdetails
QuiqNest Properties
For Sale
Active

21500 SW 184th Ave, Miami FL 3...

$ 780,000
37,026 Sqft land, gated Redland home, a lot of options to bu ...
3 3 2,994 Sqftdetails
QuiqNest Properties
For Sale
Active

14992 SW 21st Ter, Miami FL 33...

$ 1,290,000
Luxury style home in a luxury area!! This property is the re ...
5 3 3,114 Sqftdetails
QuiqNest Properties
For Sale
Active

3427 Frow Ave, Miami FL 33133 ...

$ 2,390,000
Perfect Coconut Grove Home, paradise found, location, locati ...
4 4 2,001 Sqftdetails
QuiqNest Properties
For Sale
Active

2901 S Bayshore Dr, Miami FL 3...

$ 3,995,000
This is your chance to own one of Miami’s most desired ...
5 4 3,174 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings