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

in northern-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 brick-block 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 : 3

Country Manor Bricks    4812
Whether youre renovating an existing building hundreds of years old, constructing a city centre shopping centre or a 5 star hotel, designing an apartment building, fitting- out a public bar, or simply building a house extension

Eco Stein Ltd    4821
Supplying the Irish Building Industry with Ytong aerated concrete building blocks and panels. U- values required by the Irish Building Regulations are easily achieved with single leaf constructions. All components available - walls, floors, ceilings, stairs, roof panels, lintels and more. Fully recyclable, non toxic, non flammable. The only fully integrated building sytem available. Saving time, money and the environment

Ormonde Brick    4811
Ormonde Brick is a leading producer of fired- clay facing bricks & specials of different colours and textures in the Republic of Ireland.