Onsite and Local Services

Search

Results: 1-10 of 150

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [All Results]

1 Degree West Marine Services On site at Premier Marinas

The Boatshed, Southsea Marina,
Hampshire, PO4 9RJ.

02392 838 335

Specialising in engineering, rigging and chandlery.

1st Sea School On site at Premier Marinas

1st Sea School
17 The Slipway
Port Solent
Portsmouth
Hampshire
PO6 4RT

02392 373309

07767 398892 or 07778 145444

www.1stseaschool.co.uk


A2 Rigging On site at Premier Marinas

Falmouth Marina, North Parade, Falmouth, TR11 2TD

01326 312209

07785 710364

www.a2rigging.com


Rigging services

Ancasta Boat Sales (Gosport) On site at Premier Marinas

Gosport Marina, Mumby Road, Gosport, PO12 1AH

02392 524821

www.ancasta.com

New and used boat sales

Ancasta Boat Sales (Swanwick) On site at Premier Marinas

Swanwick Marina, Swanwick, Southampton, Hants, SO31 1ZL, United Kingdom

+44 (0)1489 854455

www.ancasta.com

New and Used Boat Sales.

Ancasta Boat Sales Limited (Falmouth) On site at Premier Marinas

Falmouth Marina,
North Parade, Falmouth,
Cornwall, TR11 2TD

01326 211 007

www.ancasta.co.uk

New and Used Boat Sales.


 

Ancasta International Boat Sales (Port Solent) On site at Premier Marinas

12 The Slipway, Port Solent Marina, Portsmouth, Hants, PO6 4TR

023 9237 3300

New and Used Boat Sales.

BDA Marine Services On site at Premier Marinas

Swanwick Marina, Swanwick
Southampton, Hampshire
SO31 1ZL

07852 228852 / 07852 228853

BDA Marine Services

All boat maintenance including; heating systems; air con, passerelle, thrusters, anodes, customer joinery, teak decking, antifouling, hull polishing and GRP repairs.

Black Rock Yachting Ltd & Brighton Yacht Brokerage On site at Premier Marinas

East Lockside,
Brighton Marina Village,
Brighton, BN2 5UF

01273 697777

www.blackrockyachting.co.uk

New Jeanneau Yacht Sales
Power and Sailboat Brokerage

Bombay Bay On site at Premier Marinas

Fort Cumberland Road,
Southsea Marina,
Portsmouth, PO4 9RJ

023 9281 6066

Indian Cuisine Restaurant.

17 queries took 41 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '1' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC 772
2SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`slug` = 'marina_and_boatyard_tenant_directory') AND ( `Page`.`status` != 'Deleted') LIMIT 1114
3SELECT `Redirect`.`id`, `Redirect`.`source_url`, `Redirect`.`destination_url`, `Redirect`.`status`, `Redirect`.`created`, `Redirect`.`created_by`, `Redirect`.`modified`, `Redirect`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `redirects` AS `Redirect` LEFT JOIN `administrators` AS `CreatedBy` ON `Redirect`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Redirect`.`modified_by` = `ModifiedBy`.`id` WHERE (`Redirect`.`source_url` = '/pages/marina_and_boatyard_tenant_directory') AND (`Redirect`.`status` = 'Enabled') LIMIT 1002
4DESCRIBE `tenants`19193
5DESCRIBE `tenant_categories`992
6SELECT COUNT(*) AS count FROM `tenants` AS `Tenant` LEFT JOIN `tenant_categories` AS `TenantCategory` ON `Tenant`.`tenant_category_id` = `TenantCategory`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Tenant`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Tenant`.`modified_by` = `ModifiedBy`.`id` WHERE (`Tenant`.`status` = 'Enabled') 112
7SELECT `Tenant`.`id`, `Tenant`.`company_name`, `Tenant`.`tenant_category_id`, `Tenant`.`on_site`, `Tenant`.`description`, `Tenant`.`telephone`, `Tenant`.`mobile`, `Tenant`.`email`, `Tenant`.`website`, `Tenant`.`address`, `Tenant`.`logo`, `Tenant`.`order`, `Tenant`.`listing_style`, `Tenant`.`priority`, `Tenant`.`status`, `Tenant`.`created`, `Tenant`.`created_by`, `Tenant`.`modified`, `Tenant`.`modified_by`, `TenantCategory`.`id`, `TenantCategory`.`name`, `TenantCategory`.`parent_id`, `TenantCategory`.`order`, `TenantCategory`.`status`, `TenantCategory`.`created`, `TenantCategory`.`created_by`, `TenantCategory`.`modified`, `TenantCategory`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `tenants` AS `Tenant` LEFT JOIN `tenant_categories` AS `TenantCategory` ON `Tenant`.`tenant_category_id` = `TenantCategory`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Tenant`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Tenant`.`modified_by` = `ModifiedBy`.`id` WHERE (`Tenant`.`status` = 'Enabled') ORDER BY `Tenant`.`priority` DESC, `Tenant`.`company_name` ASC LIMIT 1010104
8SELECT `TenantCategory`.`id`, `TenantCategory`.`name` FROM `tenant_categories` AS `TenantCategory` WHERE `TenantCategory`.`status` = 'Enabled' ORDER BY `name` ASC 13131
9SELECT `Marina`.`id`, `Marina`.`name` FROM `marinas` AS `Marina` WHERE id != 8 991
10SELECT `Page`.`navigation_style` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` LEFT JOIN `images` AS `SpotlightImage` ON `Page`.`spotlight_image_id` = `SpotlightImage`.`id` LEFT JOIN `pages` AS `SimulatedPage` ON `Page`.`simulated_page_id` = `SimulatedPage`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Page`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Page`.`modified_by` = `ModifiedBy`.`id` WHERE (`Page`.`id` = '684') LIMIT 1111
11SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` WHERE (`Page`.`id` = '684') LIMIT 1112
12SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`simulated_page_id` = 0 AND `Child`.`status` = 'Enabled' AND `Child`.`parent_id` = '684' ORDER BY `Child`.`order` ASC005
13SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` WHERE (`Page`.`id` = '7') LIMIT 1112
14SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`simulated_page_id` = 0 AND `Child`.`status` = 'Enabled' AND `Child`.`parent_id` = '7' ORDER BY `Child`.`order` ASC445
15SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`id` = '684') LIMIT 1112
16SELECT `SidebarModule`.`id`, `SidebarModule`.`page_id`, `SidebarModule`.`order`, `SidebarModule`.`module_type_id`, `SidebarModule`.`subid`, `SidebarModule`.`status`, `SidebarModule`.`created`, `SidebarModule`.`created_by`, `SidebarModule`.`modified`, `SidebarModule`.`modified_by` FROM `sidebar_modules` AS `SidebarModule` WHERE `SidebarModule`.`status` = 'Enabled' AND `SidebarModule`.`page_id` = '684' ORDER BY `SidebarModule`.`order` ASC001
17SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`id` = '7') LIMIT 1112