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 (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,) Duplex For Sale - Carraig Midhe - 3 Bed Duplex, Corbally, Limerick - OMG Auctioneers

Residential Property Previous Page


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

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

Nicely positioned in one of Limerick's newest and most popular developments, this three bedroom duplex offers excellently proportioned accommodation with an excellent layout extending to c. 1230 sq.ft. An abundance of local amenities are close at hand meaning No. 124 will make a secure investment opportunity or offer first time buyers an excellent opportunity to acquire an attractive family home. Acc: Ent Hall, Sit, Kit/Din, Guest wc, 3 Beds (1 Ensuite), Bath

Features:
  • Gas fired central heating.
  • Wired for alarm.
  • Walls ceilings and wood work painted. Booking deposit of €5,000.
  • Generous allowances.
  • Double glazed PVC windows.

Your recent activity on OMG: Clear history