1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
select * from t_property where property_id in (791,208,733,804,807,474,) Detached house For Sale - 11 Castleville, Golf Links Road, Castletroy, Limerick - OMG Auctioneers

Residential Property Previous Page


11 CastlevilleGolf Links Road, Castletroy, LimerickPrice: €445,000

Ground Floor:
Entrance Hall


4.93m(16’2’’) x 5.75m(18’10’’)

Teak front door with glass panel.
Alarm.
Wooden flooring
Phone point.
Under stair storage.

Living / Dining Room


8.37m(27’6’’) x 3.96m(13’0’’)

Feature fireplace with marble hearth & surround.
TV point
Bay window.
Ornate coving.
Wall mounted lighting.
Wooden flooring
French doors to rear garden

Family Room


4.32m(14’2’’) x 2.98m(9’9’’)

Bay Window.
TV point.
Wooden flooring.

Kitchen / Dining


4.62m(15’2’’) x 3.32m(10’11’’)

Fully fitted kitchen units with built in extractor fan, stand alone cooker, integrated fridge freezer. Plumbed for dishwasher.
Tiled backsplash.
Phone point.
Recessed lighting.
Lino flooring.
Rear garden window aspect

Utility


3.34m(11’0’’) x 2.76m(9’1’’)

Large utility with built in storage presses.
Plumbed for washing machine
Lino flooring.
Access to rear garden

Study


4.09m(13’5’’) x 2.75m(9’0’’)

Built in storage units with work station.
Phone point.
Bay window.
Wooden flooring

Guest Wc


1.86m(6’1’’) x 0.90m(2’11’’)

WC & WHB.
Carpet flooring.

First Floor:
Landing


4.29m(14’1’’) x 3.38m(11’1’’)

Access to attic.
Airing press.
Smoke alarm.
Wooden flooring.

Master Bedroom


4.88m(16’0’’) x 4.29m(14’1’’)

Built in wardrobes.
TV point.
Phone point.
Front garden window aspect
Wooden flooring. Ensuite.

Ensuite


2.45m(8’0’’) x 1.48m(4’10’’)

WC, WHB.
Power shower.
Wooden flooring.
Fully tiled walls.
Front garden window aspect.

Bedroom 2


3.48m(11’5’’) x 2.80m(9’2’’)

Built in wardrobes.
Wooden flooring.
Rear garden window aspect

Bedroom 3


3.74m(12’3’’) x 2.97m(9’9’’)

Built in wardrobes.
Wooden flooring.
Front garden window aspect.

Bedroom 4


3.33m(8’2”) x 1.72m(5’8”)

Built in wardrobe.
Wooden flooring.
Rear garden window aspect.

Main Bathroom


2.50m(8’2’’) x 1.72m(5’8’’)

WC & WHB.
Bath with electric shower.
Partially tiled walls
Wooden flooring.
Dado rail.
Rear garden window aspect.

Exterior:
Garden


Private walled in rear garden with patio area
Concrete shed
Double side entrance

Your recent activity on OMG: Clear history