Aas Group Services

3 Mt Elizabeth #07-04 Mt Elizabeth Medical Centre

Website

(65) 6737 6080

11:00 to 08:00

Visited 633 times, 1 Visit today

Posted in Commercial and Serviced Office

Add a Review

Rate this by clicking a star below:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (848) AND ( wp_term_relationships.term_taxonomy_id IN (40,46,47,48,49,50,51,52,53) ) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID in (select pm.post_id from wp_postmeta pm where pm.meta_key ='post_city_id' and FIND_IN_SET( 4, pm.meta_value )) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 3

Related Listingsddddddddddddd