SELECT DISTINCT state AS name FROM link WHERE country LIKE '%ireland%' ORDER BY name dd/country_republic-of-irelandss
SELECT id AS code, u_r_l_title as utitle, u_r_l AS address, description_80 AS description FROM link WHERE `country` LIKE '%ireland%' AND `plants` LIKE '%charter%' ORDER BY `rating` ASC, `utitle` ASC In - Eire.com, The un-official guide to Ireland

in republic-of-ireland around the area of

cork county-antrim county-armagh county-clare county-cork county-down county-dublin-city county-dublin-county county-galway county-kerry county-kildare county-kilkenny county-laois county-leitrim county-louth county-mayo county-meath county-monaghan county-offaly county-roscommon county-sligo county-tipperary county-tyrone county-waterford county-wexford county-wicklow nationwide

What do you wish to find a near here,

A accommodation accomodation accountancy aquatic art attractions audio bank boats building catering commercial construction construction-house cookery council design dictionary directory electronics-batteries employment environmental exhibitions financial gardening gardening-resources gates holidays home horticulture hotelier interiors irish-photos isp kitchen landscape maps mountaineering plants real-estate restaurant retail searching secure-dream shop sport sport-car sport-fish tourism tourist transport travel travel-car travel-fly walking weather wildlife www.doindubl
Narrowing it down a bit more  to a charter Site or 12345 803-699-6870 accommodation accomodation accountant anglers auctioneers automation b-b blinds blue-cruises breast-enlargement brick-block brick-face broadband builders building bus business cafe campers car-hire catering chamber charter children construction cooker cottages culture decorating diving driving epos equipment fabrication festival finance fireplaces fishing fly forum furniture gardens gates glass golf heating heating-pell heritage hillwalking hire holidays hotel info insulate insulation insurance metal-formin meteorologic modular mortgage museum paintball painting parks photos plumbing polytunnels railway recycle refrigeratio self-build selfbuild ski solar staircases steel stone structural-s surfing sustainable timber-frame timber-frame-log timber-frame-oak tour travel trees walking windows wine-bar wood words

Total listed in this category : 1

Dungarvan Charter Boats    4875
Located at Dungarvan, Co. Waterford, Southern Ireland. DCB has been successfully providing charter boat services for a number years, catering for sea angling, scuba diving and scenic trips.