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 (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,) Semi-detached house For Sale - 42 The Haymarket, Cathedral Place, Limerick - OMG Auctioneers

Residential Property Previous Page


42 The HaymarketCathedral Place, LimerickPrice: €165,000

Type: Semi-detached house
Address: 42 The Haymarket, Cathedral Place, Limerick
Asking price: €165,000
Accommodation: 4 Beds
Sale Type: Private treaty
Sale Status: For sale

Conveniently located in a secure gated development this four bedroom end terrace house is new to the market. Three ensuite bedrooms and well laid out interior combined with a private south facing rear garden and within a short walk of St. John's Hospital and Limerick City Centre, this house has much to offer.

Features:
  • Secure gated developement
  • 4 bedrooms - 3 ensuite
  • South facing rear garden
  • Excellent rental potential
  • Close proximity to St. John's Hospital & Limerick City Centre
  • Gas fired central heating

Your recent activity on OMG: Clear history