SHOWCASING THE WORLD’S FINEST PROPERTIES AND THE STORIES BEHIND THEM

Login to begin saving your favorite properties

[wpum_login_form psw_link="yes" register_link="yes"]

Are you a Forbes Global Properties member? Login here

Register

[wpum_register login_link="yes" psw_link="yes"]

Register

[wpum_register login_link="yes" psw_link="yes"]

Login to begin saving your favorite properties

[wpum_login_form psw_link="yes" register_link="yes"]

Are you a Forbes Global Properties member? Login here

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts 
					 WHERE 1=1  AND wp_posts.ID NOT IN (120337,120337,120337) AND (
						wp_posts.post_title REGEXP '\\bMonaco\\b'
						OR EXISTS (
							SELECT 1 FROM wp_postmeta
							WHERE wp_postmeta.post_id = wp_posts.ID
							AND (
								(wp_postmeta.meta_key = 'keywords' AND wp_postmeta.meta_value REGEXP '\\bMonaco\\b')
								OR (wp_postmeta.meta_key = 'agent_location' AND wp_postmeta.meta_value REGEXP '\\bMonaco\\b')
							)
						)
					) AND wp_posts.post_type = 'agents' AND ((wp_posts.post_status = 'publish'))
					 
					 ORDER BY SUBSTRING_INDEX(wp_posts.post_title, ' ', -1) ASC
					 LIMIT 0, 12Array
(
    [post_type] => agents
    [post_status] => publish
    [posts_per_page] => 12
    [paged] => 1
    [order] => desc
    [orderby] => date
    [memberandagent_query] => agents
    [s] => Monaco
)