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 (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 - 25 Greenview Close, Glencairn, Dooradoyle, Limerick - OMG Auctioneers

Residential Property Previous Page


25 Greenview CloseGlencairn, Dooradoyle, LimerickPrice: €225,000

Type: Semi-detached house
Address: 25 Greenview Close, Glencairn, Dooradoyle, Limerick
Asking price: €225,000
Accommodation: 3 Beds

Baosting one of Limerick's most popular addresses, this impeccably presented family home offers many stylish features. No. 25 has three spacious bedrooms with well proportioned reception rooms and a versatile layout. With an excellent range of shops, schools, pubs and public transport on its doorstep, this property will not disappoint on inspection.

Features:
  • Superb location
  • Gas fired central heating
  • Double glazed windows throughout
  • Excellent layout
  • 3 double bedrooms with option of 4th bedroom

Your recent activity on OMG: Clear history