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

Residential Property Previous Page


Carraig Midhe - 2 Bed ApartmentCorbally, LimerickPrice: €170,000

Type: Apartment
Address: Carraig Midhe - 2 Bed Apartment, Corbally, Limerick
Asking price: €170,000
Accommodation: 2 Beds
New/Secondhand: New

Located in one of Limerick's newest and most popular developments, this spacious two bedroom ground floor apartment extends to c. 805sq.ft. Through a private entrance is a superbly designed layout which boasts many additional extras, an open plan living area and a private garden to the rear with excellent orientation. Conveniently situated close to all amenities, this modern and contemporary home will appeal to first time buyers and investors alike. ACC: Ent. Hall, Kitchen/Living area, 2 Bedrooms, (1 en-suite), Bathroom. VIEWING BY APPOINTMENT ONLY

Features:
  • Generous Electrical Spec
  • Recessed Lighting
  • Generous Fitted Kitchen
  • Up-graded Wardrobes
  • Private Rear Garden
  • Gas Fired Central Heating

Your recent activity on OMG: Clear history