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 (234,749,610,714,655,811,712,757,794,525,634,815,630,802,704,502,719,741,791,208,733,804,807,474,) Semi-detached house For Sale - 18 Castle Rock Road,, Castle Rock,, Castleconnell,, Co. Limerick - OMG Auctioneers

Residential Property Previous Page


18 Castle Rock Road,Castle Rock,, Castleconnell,, Co. LimerickPrice: POA

Type: Semi-detached house
Address: 18 Castle Rock Road,, Castle Rock,, Castleconnell,, Co. Limerick
Asking price: POA
Accommodation: 4 Beds

With over 1,580sq.ft., this exceptionally spacious 4 bedroom semi-detached home provides the perfect living space. Large living areas together with four double bedrooms makes this an attractive choice for any growing family.

Viewings by appointment.

Features:
  • Elegant architectural design plus 9ft high ceilings on ground floor
  • Modern fitted kitchen and wardrobes
  • Contemporary sanitary ware
  • Feature fireplace
  • Utility room
  • House painted internally and externally
  • Garden lawned and seeded
  • Pre-wired for alarm
  • Generous electrical specifications
  • Gas fired zoned central heating system
  • Tree lined pedestrian walkway into village

Your recent activity on OMG: Clear history