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 (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 - Carraig Midhe - 3 Bed Semi, Corbally, Limerick - OMG Auctioneers

Residential Property Previous Page


Carraig Midhe - 3 Bed SemiCorbally, LimerickPrice: €185,000

Type: Semi-detached house
Address: Carraig Midhe - 3 Bed Semi, Corbally, Limerick
Asking price: €185,000
Accommodation: 3 Beds
New/Secondhand: New

Excellent value for the last 6 remaining homes. These spacious 3 bedroom semi detached homes are now €210,000. Included in the prices is a tiling allowance, excellent range of kitchen units, wardrobes in two bedrooms, ceilings and wood work painted, wired for alarm, fireplace fitted. These homes have excellent design features which include 9ft high ceilings, 3 double bedrooms and spacious living areas. Viewing is by appoitment only.

Features:
  • Semi detached homes:
  • Gas fired central heating.
  • Wired for alarm.
  • Ceilings and woodwork painted
  • Kitchen units fitted
  • Wardrobes in two bedrooms
  • Sanitary ware fitted
  • Gardens levelled & seeded.
  • Double glazed PVC windows.
  • Booking deposit of €5,000.

Your recent activity on OMG: Clear history