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 (814,651,823,818,716,769,768,810,833,808,593,198,709,813,760,728,782,799,312,731,683,742,830,803,778,798,732,609,831,300,809,579,707,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 - 54 Coolraine Heights, Clareview, Limerick - OMG Auctioneers

Residential Property Previous Page


54 Coolraine HeightsClareview, LimerickPrice: €210,000

Type: Detached house
Address: 54 Coolraine Heights, Clareview, Limerick
Asking price: €210,000
Accommodation: 3 Beds

Located off the new Link Road in Clareivew through Shanamore Park, this 3 bed family home is conveniently situated overlooking a playing green. Ideally suited to young families this property has an excellent layout - combining space with good gardens. Close to a host of amenities including schools, shopping facilities etc.

Accommodation: Entrance Hall, Living Room, Guest WC, Kitchen/Dining, Family Room, 3 Bedrooms(1 En-Suite), Bathroom

Features:
  • Gas fired central heating with newly installed boiler
  • Overlooking playing green
  • Spacious accommodation
  • Ideal starter home for growing families

Your recent activity on OMG: Clear history