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 (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 - Ard Aulinn, Mungret, Limerick - OMG Auctioneers

Residential Property Previous Page


Ard AulinnMungret, LimerickPrice: €140,000

Type: Apartment
Address: Ard Aulinn, Mungret, Limerick
Asking price: €140,000
Accommodation: 2 Beds

ArdAulin is an exclusive new development of 97 houses with a choice of house types to satisfy all purchasers. Located just off Quinn's roundabout at the top of Fr. Russell Road it is just five minutes from Limerick City Centre. The Development is within walking distance of a neighbourhood retail centre which includes a supermarket, pub, restaurant, creche and beauty salon just to mention a few. Schools, churches and the Crescent Shopping Centre are all located nearby.

Note: These particulars are detailed for the purposes of representing the development only. Visual representations, finishes, layouts and/or scales may be approximate or representative of the development rather than exact specifications of the actual unit. The developer reserves the right to make alterations to the design and specification in the overall interest of the development.

Your recent activity on OMG: Clear history