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 (802771,772425,783437,803410,799164,803200,806225,568400,805184,796596,799344,767677,775398,784313,776619,808402,553391,783284,772785,776279,762044,809190,794862,804898,548440,782974,778326,800194,808441,799877,803844,775732,760747,801466,768657,800758,757404,760507,760808,796689,784464,566704,750680,756473,800153,803774,764305,778448,779048,781544,807071,807407,759721,798149,548079,563651,769826,778185,803943,801046,802972,804641,771609,546553,791933,804378,787708,787806,754094,798489,798583,608467,799447,797130,800511,794763,751804,800119,800960,796565,797950,804297,273220,797708,768333,290300,804547) 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!