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 (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,) Semi-detached house For Sale - Castle Rock - Type F, Castleconnell, County Limerick - OMG Auctioneers

Residential Property Previous Page


Castle Rock - Type FCastleconnell, County LimerickPrice: From €230,000

Castlerock, Castleconnell, County Limerick

Type: Semi-detached house
Address: Castle Rock - Type F, Castleconnell, County Limerick
Asking price: From €230,000
Accommodation: 4 Beds
New/Secondhand: New

Castle Rock is an impressive development which has been designed with modern living in mind. Located in the Village of Castleconnell some 300 meters off the main Limerick to Dublin road. These architecturally designed four bedroom semi detached homes and townhouses are well appointed with a utility room off the kitchen, an en-suite in the master bedroom together with a well proportioned living room.

Features:
  • Houses will be registered by Premier and carry a full structural guarantee for ten years.
  • Elegant architectural design.
  • Gas fired central heating system.
  • PVC double glazed windows.
  • Double glazed patio doors.
  • Suitable for investment.
  • Teak doors front.
  • PVC fascia and soffit.
  • Landscaping throughout the development.
  • Fitted kitchen, wardrobe and fireplace
  • Kitchen plumbed for dishwasher.
  • Utility room plumbed for washing machine.
  • Main bedroom en-suite, including electric shower.
  • Ground floor Wc and wash-hand basin
  • Moulded skirting and architrave
  • House painted internally and externally
  • Garden lawned and seeded
  • Pre-wired for alarm
  • Wired for TV and telephone in master bedroom
  • Generous electrical specifications all round.
  • Smoke alarm fitted.
  • €3,000 flooring and tiling allowance
  • Tree lined pedestrian walkway into the centre of

Your recent activity on OMG: Clear history