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 (802,704,502,719,741,791,208,733,804,807,474,) Apartment For Sale - 133 The Strand, O'Callaghans Strand, Limerick - OMG Auctioneers

Residential Property Previous Page


133 The StrandO'Callaghans Strand, LimerickPrice: €199,000

Type: Apartment
Address: 133 The Strand, O'Callaghans Strand, Limerick
Asking price: €199,000
Accommodation: 2 Beds
Sale Status: For sale

This luxury two bedroom apartment is situated in The Strand, a lavish and tranquil apartment complex located within walking distance of Limerick City Centre. This accomodtion fuses all the best of contemporary urban living with the natural beauty of Irelands longest river.

Acc: Entrance hallway,Living room, Kitchen/dining room, Master bedroom, En-suite, Bedroom 2, Bathroom.

Features:
  • Parking included
  • City centre location
  • Quiet and secure environment

Your recent activity on OMG: Clear history