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 (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 - 69 Alandale Orchard, South Circular Road, Limerick - OMG Auctioneers

Residential Property Previous Page


69 Alandale OrchardSouth Circular Road, LimerickPrice: €140,000

Type: Duplex
Address: 69 Alandale Orchard, South Circular Road, Limerick
Asking price: €140,000
Accommodation: 4 Beds
Sale Status: For sale

Situated in a quiet cul de sac, just off Limerick's prestigous South Circular Road, this duplex apartment offers bright and spacious accommodation. Boasting an exceptional layout and close proximity to the city centre and other local amenities this apartment comes highly recommended.

Acc: Ent Hall, Living/Kitchen/Dining area, WC, 4 Beds(1 Ensuite), Bathroom.

Features:
  • Excellent rental potential
  • Situated in a quiet cul de sac
  • Gas fired central heating
  • Walking distance to city centre
  • Surrounded by shops, schools and other local amenities
  • Double glazed PVC windows

Your recent activity on OMG: Clear history