SELECT wp_posts.*, ROUND(RAND()*1000) 'rand_ind' FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND wp_posts.post_type = 'bo_yachts' AND ((wp_posts.post_status = 'publish')) AND ( wp_postmeta.meta_key = 'bo_select_type_name_en' AND ( ( mt1.meta_key = 'bo_port_val' AND CAST(mt1.meta_value AS CHAR) = '89' ) OR ( mt1.meta_key = 'bo_port_val' AND CAST(mt1.meta_value AS CHAR) = '3728' ) OR ( mt1.meta_key = 'bo_port_val' AND CAST(mt1.meta_value AS CHAR) = '1452' ) OR ( mt1.meta_key = 'bo_port_val' AND CAST(mt1.meta_value AS CHAR) = '87' ) ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value ASC,rand_ind LIMIT 0, 30

Znaleźliśmy 23 jachtów spełniających kryteria

Filter
Show filterHide filter


Amiga 27 Details
Yacht ID
#00001995
Marine area
Masuria
Port
Mikołajki
No. of berths
8
No. of cabins
2
Year of bulding
Yacht lenght
8,20m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Antila 24 Details
Yacht ID
#00001997
Marine area
Masuria
Port
Mikołajki
No. of berths
8
No. of cabins
1
Year of bulding
Yacht lenght
7,18m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Antila 26 Details
Yacht ID
#00005993
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
1
Year of bulding
2009
Yacht lenght
7,80m
Equipment: Set of kitchen pots, Heating, Fridge, Installation of outboard water, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Antila 27 Details
Yacht ID
#00004957
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2011
Yacht lenght
8,21m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Antila 27 Details
Yacht ID
#00005823
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
1
Year of bulding
2012
Yacht lenght
8,21m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Hot water, Installation of drinking water, Gas cooker, DVD, TV, Radio, Lighter socket
More details
Antila 27 Details
Yacht ID
#00006000
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
3
Year of bulding
2014
Yacht lenght
8,21m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Antila 27 Details
Yacht ID
#00006294
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
3
Year of bulding
2012
Yacht lenght
8,24m
Equipment: Depth sounder, Installation 220V in port, Set of kitchen pots, Heating, Fridge, Hot water, Installation of drinking water, Gas cooker, DVD, TV, Radio, Lighter socket
More details
Antila 27 Details
Yacht ID
#00001964
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2011
Yacht lenght
8,85m
Equipment: Reservoir maps , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Mellody 30 Details
Yacht ID
#00002279
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2013
Yacht lenght
9,46m
Equipment: Reservoir maps , Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of outboard water, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Nautiner 30s Details
Yacht ID
#00004440
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
3
Year of bulding
2010
Yacht lenght
9,00m
Equipment: Depth sounder, Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Hot water, Installation of outboard water, Installation of drinking water, Gas cooker, DVD, TV, Radio, Lighter socket
More details
Phila 900 Details
Yacht ID
#00005396
Marine area
Masuria
Port
Giżycko
No. of berths
10
No. of cabins
3
Year of bulding
2014
Yacht lenght
9,0m
Equipment: Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, DVD, TV, Radio, Lighter socket
More details
Raptor 27 Details
Yacht ID
#00004788
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2012
Yacht lenght
8,23m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Raptor 27 Details
Yacht ID
#00004757
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2011
Yacht lenght
8,23m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Sasanka 600 Details
Yacht ID
#00001999
Marine area
Masuria
Port
Mikołajki
No. of berths
6
No. of cabins
1
Year of bulding
Yacht lenght
6.6m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Solina 800 Details
Yacht ID
#00004765
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2009
Yacht lenght
8.5m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Tango 780 Sport Details
Yacht ID
#00002264
Marine area
Masuria
Port
Giżycko
No. of berths
7
No. of cabins
1
Year of bulding
2008
Yacht lenght
7,8m
Equipment: Reservoir maps , Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
TES 32 Dreamer Details
Yacht ID
#00004408
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
Yacht lenght
9.69m
Equipment: Depth sounder, Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
TES 32 Dreamer Details
Yacht ID
#00004531
Marine area
Masuria
Port
Giżycko
No. of berths
9
No. of cabins
3
Year of bulding
2013
Yacht lenght
9.69m
Equipment: Depth sounder, Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of outboard water, Installation of drinking water, Gas cooker, TV, Radio, Lighter socket
More details
TES 32 Dreamer Details
Yacht ID
#00004778
Marine area
Masuria
Port
Giżycko
No. of berths
10
No. of cabins
3
Year of bulding
2008
Yacht lenght
9.69m
Equipment: Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Tes 678 BT Details
Yacht ID
#00001968
Marine area
Masuria
Port
Giżycko
No. of berths
6
No. of cabins
1
Year of bulding
2004
Yacht lenght
6,78m
Equipment: Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Twister 780 Details
Yacht ID
#00005385
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
1
Year of bulding
2010
Yacht lenght
7,80m
Equipment: Set of kitchen pots, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Twister 780 Details
Yacht ID
#00005393
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
1
Year of bulding
2010
Yacht lenght
7,80m
Equipment: Set of kitchen pots, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details
Twister 800 Details
Yacht ID
#00005366
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
2
Year of bulding
2004
Yacht lenght
8m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Installation of drinking water, Gas cooker, Radio, Lighter socket
More details