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 (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 - 6 Glantann, Golf Links Road, Castletroy, Co. Limerick - OMG Auctioneers

Residential Property Previous Page


6 GlantannGolf Links Road, Castletroy, Co. LimerickPrice: €200,000

Type: Semi-detached house
Address: 6 Glantann, Golf Links Road, Castletroy, Co. Limerick
Asking price: €200,000
Accommodation: 3 Beds
Sale Status: For sale

An excellent opportunity to acquire a highly desirable family home providing tasteful and elegant accommodation throughout. Combining a convenient location with its bright spacious accommodation, this property is an ideal starter home for those seeking to get a foot on the property ladder. Situated in a quiet cul de sac with the benefit of a private westerly facing rear garden, this property has much to offer. Acc: Ent Hall, Liv, Kit/Din, 3 Beds, 1 Ensuite, Bath

Features:
  • Cul De Sac Location
  • Excellent Decorative Condition
  • Ample Parking To Front
  • Landscaped Rear Garden
  • Gas Fired Central Heating

Your recent activity on OMG: Clear history