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 (811,712,757,794,525,634,815,630,802,704,502,719,741,791,208,733,804,807,474,) Semi-detached house For Sale - 15 Merton Close, Kilkee, Co. Clare - OMG Auctioneers

Residential Property Previous Page


15 Merton CloseKilkee, Co. ClarePrice: €250,000

Type: Semi-detached house
Address: 15 Merton Close, Kilkee, Co. Clare
Asking price: €250,000
Accommodation: 3 Beds

This 3 bedroom semi-detached home is situated in a quiet residential area in the West End of Kilkee just a few minutes walk from Kilkee's renowned safe beach and bay and all other local amenitites.

Acc: Entrance Hall, Living Room, Kitchen/Dining Room, 3 Bedrooms (1 En-Suite), Bathroom.

Features:
  • Situated in a quiet residential area
  • Walking distance to kilkee beach and all other amenities
  • Excellent decorative condition
  • Parking to rear

Your recent activity on OMG: Clear history