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 (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 - 162 Caislean na hAbhainn, Castletroy, Co. Limerick - OMG Auctioneers

Residential Property Previous Page


162 Caislean na hAbhainnCastletroy, Co. LimerickPrice: €240,000

Type: Semi-detached house
Address: 162 Caislean na hAbhainn, Castletroy, Co. Limerick
Asking price: €240,000
Accommodation: 4 Beds
Sale Status: For sale
New/Secondhand: New

An exceptional development offering affordable luxury homes built to the highest standard. Excellently located just 2 miles from Limerick city centre. University of Limerick, Plassey Technological Park, shopping centres, retail parks, schools & shops are all within walking distance of this development further enhancing its appeal

Features:
  • 4 Bedrooms (2 ensuite)
  • Three storey
  • Spacious homes excellently located
  • Gas fired central heating
  • Contemporary style fitted kitchen
  • Fireplace and flooring included
  • Wired for alarm, broadband & satelite

Your recent activity on OMG: Clear history