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 (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,) Terrace house For Sale - 2 Stoney Meadows, Old Cratloe Road, Limerick - OMG Auctioneers

Residential Property Previous Page


2 Stoney MeadowsOld Cratloe Road, LimerickPrice: €180,000

Type: Terrace house
Address: 2 Stoney Meadows, Old Cratloe Road, Limerick
Asking price: €180,000
Accommodation: 3,4 Beds
Sale Status: For sale

Having been excellent maintained throughout, this three/four bedroom mid terraced property is located adjacent to LIT in a convenient area close to a wide range of amenities. Constantly returning a high level of rental income, No. 2 also enjoys pedestrian access to the rear and will appeal to those seeking a home with an excellent address.

Features:
  • Earning excellent level of rental income
  • Good decorative condition
  • Ample parking to front
  • Gas fired central heating
  • Pedestrian access to rear

Your recent activity on OMG: Clear history