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 (335,298,233,750,331,332,333,820,329,334,628,246,696,816,202,470,727,402,404,669,562,801,722,729,601,826,832,597,534,705,805,753,821,787,825,817,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,) Terrace house For Sale - Castlerock - Type E2, Castleconnell, Co Limerick - OMG Auctioneers

Residential Property Previous Page


Castlerock - Type E2Castleconnell, Co LimerickPrice: €185,000

Type: Terrace house
Address: Castlerock - Type E2, Castleconnell, Co Limerick
Asking price: €185,000
Accommodation: 3 Beds
New/Secondhand: New

These three bedroom townhouses represent excellent value for any first time buyer. Standard features include French doors to rear garden, a generous living room and master bedroom with en-suite.

SHOW HOME OPEN BY APPOINTMENT.

Features:
  • Elegant architectural design plus 9ft high ceilings on ground floor
  • Modern fitted kitchens and wardrobes
  • Contemporary sanitary ware
  • Feature fireplace
  • House painted internally and externally
  • Garden lawned and seeded
  • Pre-wired for alarm
  • Generous electrical specifications
  • Gas fired zoned central heating system
  • €3,000 flooring and tiling allowance
  • Tree lined walkway to centre of village

Your recent activity on OMG: Clear history