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 (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,) Detached house For Sale - 86 Ballyglass, Ardnacrusha, Co Clare - OMG Auctioneers

Residential Property Previous Page


86 BallyglassArdnacrusha, Co ClarePrice: €275,000

Type: Detached house
Address: 86 Ballyglass, Ardnacrusha, Co Clare
Asking price: €275,000
Accommodation: 5 Beds
Sale Status: For sale

Located in a quiet private cul de sac within this popular estate, this instantly impressive 5 bed detached home offers an abundance of space, light and comfort throughout. This family home extends to 2, 800 sq.ft and boasts a west facing rear garden with large patio area. Its excellent layout of spacious rooms and convenience of location makes this home truly appealing to a wide audience. An excellent choice of schools, shops and leisure facilities are all closeby. Acc: Ent Hall, Liv, Kit/Din, Util, Guest wc, Fam, Study/Playroom, 5 beds, 2 Ensuites, Bath

Features:
  • Gas fired central heating.
  • Double glazed PVC windows.
  • Quiet cul-de-sac.
  • Increasingly popular estate.
  • Excellent choice of amenities closeby.
  • Excellent decorative condtion.
  • Gas fired central heating.
  • 2 ensuites.

Your recent activity on OMG: Clear history