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 (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 - 24 Fernhill, North Circular Road, Limerick - OMG Auctioneers

Residential Property Previous Page


24 FernhillNorth Circular Road, LimerickPrice: €197,000

Type: Semi-detached house
Address: 24 Fernhill, North Circular Road, Limerick
Asking price: €197,000
Accommodation: 4
Sale Status: For sale
New/Secondhand: Secondhand

Just over the bridge from Limerick City Centre, this unrivalled residential location will appeal to those looking for a home with a full range of facilities on its doorstep. A three storey four/five bedroomed (two ensuite) house bringing style and convenience to the market.

Features:
  • Unrivalled location 5 minutes walk from Limerick City Centre
  • Three storey 4/5 bedroomed house
  • Gas Fired Central Heating
  • Short distance to schools, shops, amenities

Your recent activity on OMG: Clear history