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 (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 - Ashdown Student Village, South Circular Road, Limerick - OMG Auctioneers

Residential Property Previous Page


Ashdown Student VillageSouth Circular Road, LimerickPrice: €160,000

Type: Apartment
Address: Ashdown Student Village, South Circular Road, Limerick
Asking price: €160,000
Accommodation: 4 Beds
Sale Status: For sale

Located in this secure gated development off Courtback Avenue lies this purpose built 4 bedroom apartment. With the benefit of full section 50 allowances and just a stones throw from Mary Immaculate College this property would make an ideal investment opportunity.

Accommodation: Entrance Hall, Living/Dining/Kitchen, 4Bedrooms (1 En-Suite), Bathroom.

Features:
  • Purpose built student accommodation
  • Section 50 tax allowances
  • All rooms have built in study areas with internet and phone connections
  • On-site village manager campus security

Your recent activity on OMG: Clear history