Please note: we are working as usual despite the Coronavirus and still taking telephone calls and emails.
Our Mayfair centre is a two-minute walk from Bond Street tube, eight minutes from Oxford Circus and Marble Arch. Green Park is just a little further away at twelve minutes. The open, green space of Hyde Park is a stone’s throw away and is a perfect spot for alfresco lunches. Just minutes from the shopping paradise of Oxford Street, Brook Mews and Avery Row are directly behind our office, giving you access to a fantastic range of celebrated restaurants.
WordPress database error: [Incorrect parameter count in the call to native function 'radians']
( 3959 * acos( cos( radians() ) * cos( radians( a.meta_value ) )
* cos( radians(b.meta_value) - radians()) + sin(radians())
* sin( radians( a.meta_value)))) AS distance
from I3AAm_postmeta a
left join I3AAm_posts p on a.post_id=p.ID
left join I3AAm_postmeta b on a.post_id=b.post_id
p.post_status = 'publish' and p.post_type='map_locations'
and a.meta_key = 'latitude'
and b.meta_key = 'longitude'
order by distance