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 (343844,547161,550394,561004,567389,628804,641041,751857,751873,751988,757160,757278,765613,768346,772232,781931,783958,784035,788714,789427,792415,618728,623546,767107,617377,629615,605001,750372,750509,764955,786492,803840,593656,599530,627420,628680,642164,552082,784249,283242,615081,619083,622507,804438,561691,774339,557045,566428,793768,564312,616632,592418,594568,598906,609733,616465,618054,622018,626560,628107,792207,342959,772666,773086,339049,762457,759522,616522,771801,585828,632429,587071,568079,773419,782770,772813,554529,791905,343255,769949,623694,617683,280638,587946,590331,604989,618403,630095,807090,338713,784445,568496,620268,639206,541821,595543,598272,599211,612876,626086,631196,632494,641160,755663,758502,796760,800061,621864,805125,560687,616569,593840,587737,563312,567249,759833,555031,756336,768032,754267,609105,624538,799666,278751,284914,604584,553410,791644,333763,642669,562918,620455,760354,780729,335736,802002,600321,340193,551089,568416,545978,611001,614993,752331,793687,629225,772792,781011,637153,764290,783869,772657,332262,335461,601336,611289,614515,592095,636881,615220,789121,632823,634347,753361,762012,550366,565585,565926,612625,771269,797083,760336,782102,785317,605818,752760,561924,347468,756839,785447,777255,282022,633707,641907,775653,780482,808854,564793,754830,773944,774282,551247,568525,791638,799089,792440,621825,762874,772210,597226,767627,562248,636962,341077,341700,343569,563991,604254,754835,782729,602782,629011,610389,613856,617821,633539,602813,627274,634861,770533,789677,552947,567668,593264,550443,551955,552420,559987,567526,587794,588940,604960,617773,628786,754728,766324,774463,785772,786335,787100,784697,542368,769785,570203,612780,339524,342375,766383,778756,598932,794789,338385,547589,547778,586054,770186,784000,784508,559750,561163,628732,752918,765071,776045,777934,781591,792241,793366,547222,559859,585656,340358,620570,542719,552453,553193,564281,569286,594301,602912,608009,608022,616907,625428,628530,632732,635574,760040,769626,769834,780701,786145,787987,788764,792685,342573,566928,608088,622822,776293,626183,640310,607198,551654,557577,559462,563970,751999,758598,759931,766119,766272,772820,777297,781711,561903,751431,773834,801296,586235,339534,334568,545331,617488,635492,544774,786189,585107,590742,623320,637107,541494,567982,600529,632336,633033,763910,790946,585783,620686,610316,621666,794283,337481,340136,561813,599668,779757,546465,563061,609334,750397,750583,766616,780020,782581,788374,589679,568206,757416,602919,806885,588534,590592,593300,598710,609788,611135,615046,624649,593384,541597,552645,562988,625385,630942,622564,563013,612676,611414,802407,593486,619609,809001,611437,598545,617571,640291,795206,803155,621418,628345,616146,798875,638224,625948,563570,544902,784689,635126,634372,622037,587043,621728,629109,597294,640146,607588,629927,587621,605391,606053,793234,333333,334201,341618,567065,764333,603471,615928,618077,329556,608567,280998,594805,332888,277552,619911,343959,597573,599350,632282,591506,607364,611981,614234,642590,285543,284745,285135,588615,600793,605774,609631,618543,639436,642052,279748,280356,612081,590771,766322,803598,808301,329309,330415,342210,790930,586111,567878,593051,641643,607418,614702,334355,617002,763202,802529,640255,612595,639273,609804,330857,330348,801386,766406,641500,588377) 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