SELECT DISTINCT state AS name FROM link WHERE country LIKE '%ireland%' AND searching LIKE '%commercial%' ORDER BY name dd/theme_commercial/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 `searching` LIKE '%commercial%' AND `plants` LIKE '%chamber%' ORDER BY `rating` ASC, `utitle` ASC In - Eire.com, The un-official guide to Ireland

in republic-of-ireland around the area of

county-waterford

What do you wish to find a near here,

A commercial site or perhaps 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 chamber Site or chamber

Total listed in this category : 1

Dungarvan Chamber Of Commerce    4613
Established in 1989, Dungarvan & West Waterford Chamber Of Commerce is the Prime Business Representative Organisation of the locality. Dungarvan is a vibrant town with an excellent road network linking it to the ports and airports of Waterford and Cork.