Boat Sales Search

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

Latest Boats for Sale

SELECT *, wp_posts.ID as ID, (select distinct meta_value from wp_postmeta where meta_key = 'imagefiles' and wp_postmeta.post_id = wp_posts.id) as image FROM `wp_posts` inner join boat_post on admin_post_id = wp_posts.id where ( SELECT DISTINCT meta_value FROM wp_postmeta WHERE meta_key = 'imagefiles' AND wp_postmeta.post_id = wp_posts.id ) != '' and post_type= 'post' and post_title != '' and post_status ='publish' and bd_listing_status in (12,13,14) GROUP BY `wp_posts`.`ID` ORDER BY `wp_posts`.`ID` DESC LIMIT 0,8
Sydney 36CR
Quest TP52
J120
Sydney 38 OD
Young 11
Tasman Oceans 35
Sydney 32
Farr 30

Featured Boats for Sale