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 (329,334,628,246,696,816,202,470,727,402,404,669,562,801,722,729,601,826,832,597,534,705,805,753,821,787,825,817,814,651,823,818,716,769,768,810,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,) Terrace house For Sale - Bruachlan - 3 Bed Terrace, Westbury, Corbally, Limerick - OMG Auctioneers

Residential Property Previous Page


Bruachlan - 3 Bed TerraceWestbury, Corbally, LimerickPrice: €155,000

Type: Terrace house
Address: Bruachlan - 3 Bed Terrace, Westbury, Corbally, Limerick
Asking price: €155,000
Accommodation: 3 Beds
New/Secondhand: New

SHOW HOMES OPEN BY APPOINTMENT.
Attractive 3 bedroom homes nestled in this convenient and popular location close to schools, shops and all other essential amenities. Careful thought has been given to these homes which offer well proportioned accommodation ideal for modern living.
VIRTUAL TOUR - www.chieftain.ie/bruachlan

Features:
  • Gas fired central heating.
  • Ceiling and woodwork painted.
  • uPVC windows.
  • Booking deposit €3,000.
  • Generous allowances.
  • Gardens levelled and seeded.
  • Suitable for investment.

Your recent activity on OMG: Clear history