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 (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,) Semi-detached house For Sale - Bruachlan - 2 Bed Semi, Westbury, Corbally, Co. Clare - OMG Auctioneers

Residential Property Previous Page


Bruachlan - 2 Bed SemiWestbury, Corbally, Co. ClarePrice: €155,000

Type: Semi-detached house
Address: Bruachlan - 2 Bed Semi, Westbury, Corbally, Co. Clare
Asking price: €155,000
Accommodation: 2 Beds
New/Secondhand: New

Two bedroom homes, too good to miss. 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 fitted kitchens, excellent living rooms and two double bedrooms. Virtual tour - www.chieftain.ie/bruachlan

SHOW HOMES OPEN BY APPOINTMENT.

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

Your recent activity on OMG: Clear history