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 (741,791,208,733,804,807,474,) Semi-detached house For Sale - 11 Castlewell, Courtbrack Avenue, Limerick - OMG Auctioneers

Residential Property Previous Page


11 CastlewellCourtbrack Avenue, LimerickPrice: €295,000

Ground Floor:
Entrance Hallway


Carpet flooring
Coving
Ornate centrepiece
Alarm and phone point

Living Room


Wooden surround fireplace with ornate tiles insert, gas fire and granite hearth
Ornate coving and centrepiece
TV point
Double doors to kitchen / dining area
Carpet flooring

Guest Wc


WHB & WC
Carpet flooring

Kitchen / Dining Room


Excellent range of fully fitted kitchen units with built in oven, hob and extractor fan
Patio doors to rear garden
Lino flooring

First Floor:
Master Bedroom


Carpet Flooring.
Built in wardrobe
Front garden window aspect
TV point

Ensuite


WC & WHB
Triton T80i electric shower
Tiled wall area
Lino flooring

Bedroom 2


Rear garden window aspect
Built in wardrobe
Carpet flooring

Bedroom 3


Rear garden window aspect.
Built in wardrobe
Carpet flooring

Bedroom 4


Front garden window aspect.
Built in wardrobe
Carpet flooring

Bathroom


WC, WHB and Bath.
Tiled wall area
Lino flooring
Over bath shower

Your recent activity on OMG: Clear history