888-QuiqNest

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

We didn't find any results

open map

View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next

For Sale

For Rent

Radius: 2 miles