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 (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 - 7 Clonmacken Court, Ennis Road, Limerick - OMG Auctioneers

Residential Property Previous Page


7 Clonmacken CourtEnnis Road, LimerickPrice: €175,000

Type: Apartment
Address: 7 Clonmacken Court, Ennis Road, Limerick
Asking price: €175,000
Accommodation: 2 Beds
New/Secondhand: Secondhand

Situated just off the Ennis Road, this two bedroom ground floor apartment is only minutes from the city centre with easy access to all local amenities such as schools, shopping centre etc. Having been maintained to an high standard and enjoying such benefits as secure parking, this apartment will suit those hoping to acquire a starter home or investment opportunity.

Accommodation; Entrance Hall, open plan kitchen / living / dining, 2 Bedrooms, (1 ensuite), Bathroom

Features:
  • Convienient location
  • Secure parking - 2 car spaces
  • Ensuite bedroom
  • Ground floor apartment
  • Good decorative order
  • Currently let

Your recent activity on OMG: Clear history