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 (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 - 40 Alandale Orchard, Courtbrack Ave, South Circular Rd, Limerick - OMG Auctioneers

Residential Property Previous Page


40 Alandale OrchardCourtbrack Ave, South Circular Rd, LimerickPrice: €185,000

Type: Apartment
Address: 40 Alandale Orchard, Courtbrack Ave, South Circular Rd, Limerick
Asking price: €185,000
Accommodation: 2 Beds

A wonderful opportunity awaits to acquire an appealing ground floor apartment which offer bright and spacious accommodation with a private rear garden. Private door access leads to an exceptional layout which boasts large bedrooms and kit/din/living area. Located in one of Limericks most popular developments off the ever popular South Circular Road and a short stroll from the city centre, this property will not dissapoint on inspection. Ent Hall; Kitchen/Living area; 2 Beds(1 Ensuite); Bathroom.

Features:
  • Excellent decorative condition throughout.
  • Gas fired central heating.
  • Private garden to rear.
  • Excellent parking facilities to front.
  • Close to a host of amenities and services.
  • Spacious accommodation throughout.

Your recent activity on OMG: Clear history