Family Boats Search

Advanced Version
State
New/Used
Hull Type
Boat Category
Listing ID#
Price From
Length From
Keyword
Price To
Length To

Latest Boats

SELECT *, wp_posts.ID as ID FROM `wp_posts` inner join boat_post on admin_post_id = wp_posts.id INNER JOIN wp_26_posts ON wp_26_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 = 26 or boat_post.member_blog_id in ( 0)) GROUP BY `wp_posts`.`ID` ORDER BY wp_26_posts.post_date DESC LIMIT 0,8

Featured Boats

Marina Oceans

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