Search

Advanced Version
New/Used
Boat Category
Price From
Keyword
Price To

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_49_posts ON wp_49_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 = 49 or boat_post.member_blog_id in ( 0)) GROUP BY `wp_posts`.`ID` ORDER BY wp_49_posts.post_date DESC LIMIT 0,8

Specials