Latest Listings

SELECT *, wp_posts.ID as ID FROM `wp_posts` inner join boat_post on admin_post_id = wp_posts.id INNER JOIN wp_55_posts ON wp_55_posts.id = member_post_id where wp_posts.post_type= 'post' and wp_posts.post_title != '' and wp_posts.post_status ='publish' and bd_listing_status in (12,13,14) and (boat_post.member_blog_id = 55 or boat_post.member_blog_id in ( 0)) GROUP BY `wp_posts`.`ID` ORDER BY wp_55_posts.post_date DESC LIMIT 0,12

Boats On Display at Marina

Marina Oceans

Ray White Marine is a Joint Venture between Ray White Surfers Paradise Group and Marina Oceanus