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 (783,689,806,234,749,610,714,655,811,712,757,794,525,634,815,630,802,704,502,719,741,791,208,733,804,807,474,) Detached house For Sale - 2 Glen Abhainn, Meelick, Co Clare - OMG Auctioneers

Residential Property Previous Page


2 Glen AbhainnMeelick, Co ClarePrice: €250,000

Ground Floor:
Entrance Hall


Triple lock teak floor with glass panelling to sides
Carpet flooring
Burgular alarm
Phone point
Smoke alarm
Recessed lighting

Sitting Room


Solid Indian Rosewood floor
Two no. window aspects to front
TV point
Phone point
Fireplace with sandstone surround and gas fire

Living Room / Bedroom 4


Solid oak floor
Two no. window aspects to front
TV point
Phone point
Recessed lighting

Kitchen/dining Room


Beautiful cream shacker style kitchen with excellent storage space.
Integrated Fridge freezer, Dishwasher and eye-level double oven
Breakfast Bar
Tiled floor and backsplash
Recessed lighting
Patio doors to rear garden

Utility Room


Tiled Floor
Door to rear garden
Plumbed for washing machine / dryer
Counter top and excellent storage
Hotpress

Guest Wc


Tiled floor
WC & wash hand basin
Corner power shower unit

First Floor:
Bedroom 1


Carpet flooring
Dormer window to front
Velux window to rear
Walk in wardrobe shelved with Indian rosewood

Ensuite


Ensuite with fully tiled floor
WC, wash hand basin, electric shower
Heated towel rail

Bedroom 2


Carpet flooring
Window aspect to front

Bedroom 3


Indian rosewood flooring
Velux window to rear

Bathroom


Fully tiled floor and walls
Bath and shower, WC and wash hand basin
Velux window to rear
Heated towel rail

Landing


Carpet flooring
Access to attic, floored for storage with light socket
Recessed lighting
Smoke alarm

Exterior:
Garden


Tarmac driveway to front along with lawn to front
West facing lawn to rear, with patio area
Private rear site and fully fenced
Outside tap and socket

Your recent activity on OMG: Clear history