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 (757,794,525,634,815,630,802,704,502,719,741,791,208,733,804,807,474,) Terrace house For Sale - 145 Bloomfield, Annacotty, Limerick - OMG Auctioneers

Residential Property Previous Page


145 BloomfieldAnnacotty, LimerickPrice: POA

Type: Terrace house
Address: 145 Bloomfield, Annacotty, Limerick
Asking price: POA
Accommodation: 4 Beds

This 3 story end of terrace house is located in Bloomfield, which is a unique development of exclusive homes close to Annacotty village, the Dublin Road, University of Limerick and Plassey Technological Park. This home has been maintained to an exceptionally high standard throughout and comes highly recommended. Viewing is a must.

Acc: Ent hall, living room, kitchen / dining area, guest wc, family room, 4 bedrooms, 2 ensuite, bath.

Features:
  • Excellent decorative condition throughout
  • Highly sought after location
  • South west facing rear garden
  • Cul de sac location
  • Situated immediately adjacent to a wide host of amenities
  • Gas fired central heating
  • Double glazed windows

Your recent activity on OMG: Clear history