SELECT wp_posts.*, ROUND(RAND()*1000) 'rand_ind' FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.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' ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value ASC,rand_ind LIMIT 90, 30

Znaleźliśmy 141 jachtów



Yacht ID
#00002026
Marine area
Masuria
Port
Węgorzewo
No. of berths
6
No. of cabins
1
Year of bulding
Yacht lenght
6,6m
Equipment: Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00000993
Marine area
Masuria
Port
Ruciane-Nida
No. of berths
6
No. of cabins
1
Year of bulding
2005
Yacht lenght
6,6m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00005851
Marine area
Masuria
Port
Giżycko
No. of berths
10
No. of cabins
3
Year of bulding
2011
Yacht lenght
9m
Equipment: Installation 220V in port, Set of kitchen pots, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00005492
Marine area
Masuria
Port
Węgorzewo
No. of berths
9
No. of cabins
3
Year of bulding
2015
Yacht lenght
9m
Equipment: Bow thruster - stern, Installation 220V in port, Set of kitchen pots, Fridge, Installation of drinking water, Gas cooker, TV, Radio, Lighter socket
Yacht ID
#00005502
Marine area
Masuria
Port
Węgorzewo
No. of berths
9
No. of cabins
3
Year of bulding
2014
Yacht lenght
8,9m
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, TV, Radio, Lighter socket
Yacht ID
#00005500
Marine area
Masuria
Port
Węgorzewo
No. of berths
4
No. of cabins
1
Year of bulding
2016
Yacht lenght
6,75m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00005498
Marine area
Masuria
Port
Węgorzewo
No. of berths
6
No. of cabins
1
Year of bulding
2016
Yacht lenght
7,28m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00001344
Marine area
Masuria
Port
Ryn
No. of berths
8
No. of cabins
1
Year of bulding
2008
Yacht lenght
8.5m
Equipment: Depth sounder, Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
Nearest not occupied Saturday:
2019-08-31
2019-09-07
468
Yacht ID
#00005875
Marine area
Masuria
Port
Giżycko
No. of berths
8
No. of cabins
1
Year of bulding
2005
Yacht lenght
8.5m
Equipment: Installation 220V in port, Set of kitchen pots, Heating, Installation of drinking water, Gas cooker, Lighter socket
Yacht ID
#00001345
Marine area
Masuria
Port
Ryn
No. of berths
8
No. of cabins
1
Year of bulding
2006
Yacht lenght
8.5m
Equipment: Depth sounder, Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
Nearest not occupied Saturday:
2019-08-31
2019-09-07
468
Yacht ID
#00002017
Marine area
Masuria
Port
Węgorzewo
No. of berths
8
No. of cabins
1
Year of bulding
Yacht lenght
8.5m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00001140
Marine area
Masuria
Port
Ryn
No. of berths
8
No. of cabins
1
Year of bulding
2009
Yacht lenght
8.5m
Equipment: Depth sounder, Installation 220V in port, Set of kitchen pots, Heating, Fridge, Installation of drinking water, Gas cooker, Radio, Lighter socket
Nearest not occupied Saturday:
2019-09-07
2019-09-14
452
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
Yacht ID
#00005131
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
6
No. of cabins
2
Year of bulding
2010
Yacht lenght
9,96m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Fridge, Hot water, Installation of drinking water, Gas cooker, Dinghy, Radio, Lighter socket
Yacht ID
#00005135
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
6
No. of cabins
2
Year of bulding
2014
Yacht lenght
9,96m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Fridge, Hot water, Installation of drinking water, Gas cooker, Dinghy, Radio, Lighter socket
Yacht ID
#00001900
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
6
No. of cabins
2
Year of bulding
2014
Yacht lenght
9,96m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Fridge, Hot water, Installation of drinking water, Gas cooker, Dinghy, Radio, Lighter socket
Yacht ID
#00001913
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
6
No. of cabins
2
Year of bulding
2010
Yacht lenght
9,96m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Fridge, Hot water, Installation of drinking water, Gas cooker, Dinghy, Radio, Lighter socket
Yacht ID
#00005170
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2016
Yacht lenght
10,34m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Fridge, Hot water, Installation of drinking water, Gas cooker, Anemometer, Dinghy, Radio, Lighter socket
Yacht ID
#00005141
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2011
Yacht lenght
10,57m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Heating, Hot water, Installation of drinking water, Anemometer, Dinghy, Radio, Lighter socket
Yacht ID
#00005143
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2008
Yacht lenght
10,57m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Heating, Hot water, Installation of drinking water, Anemometer, Dinghy, Radio, Lighter socket
Yacht ID
#00005137
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2008
Yacht lenght
10,57m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Heating, Hot water, Installation of drinking water, Anemometer, Dinghy, Radio, Lighter socket
Yacht ID
#00005139
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2008
Yacht lenght
10,57m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Installation 220V in port, Set of kitchen pots, Heating, Hot water, Installation of drinking water, Anemometer, Dinghy, Radio, Lighter socket
Yacht ID
#00005172
Marine area
Middle Adriatic
Port
Bibinje-Sukosan
No. of berths
8
No. of cabins
3
Year of bulding
2013
Yacht lenght
11,34 m
Equipment: Reservoir maps , Plotter, Radio VHF/UKF, GPS, Autopilot, Log, Electric windless, Depth sounder, Steering-wheel, Bow thruster , Installation 220V in port, Set of kitchen pots, Heating, Fridge, Hot water, Installation of drinking water, Gas cooker, Radio, Lighter socket
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
Yacht ID
#00002021
Marine area
Masuria
Port
Węgorzewo
No. of berths
6
No. of cabins
1
Year of bulding
Yacht lenght
7,8m
Equipment: Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00002022
Marine area
Masuria
Port
Węgorzewo
No. of berths
6
No. of cabins
1
Year of bulding
Yacht lenght
7,8m
Equipment: Installation 220V in port, Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00001046
Marine area
Masuria
Port
Ryn
No. of berths
6
No. of cabins
1
Year of bulding
2007
Yacht lenght
7,8m
Equipment: Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Nearest not occupied Saturday:
2019-08-31
2019-09-07
242
Yacht ID
#00002332
Marine area
Masuria
Port
Giżycko
No. of berths
6
No. of cabins
1
Year of bulding
2004
Yacht lenght
7,8m
Equipment: Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Yacht ID
#00001044
Marine area
Masuria
Port
Ryn
No. of berths
6
No. of cabins
1
Year of bulding
2007
Yacht lenght
7,8m
Equipment: Set of kitchen pots, Installation of drinking water, Gas cooker, Radio, Lighter socket
Nearest not occupied Saturday:
2019-08-31
2019-09-07
242 230
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