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 (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 - 5 Bracken Gardens, North Circular Road, Limerick - OMG Auctioneers

Residential Property Previous Page


5 Bracken GardensNorth Circular Road, LimerickPrice: €420,000

Type: Detached house
Address: 5 Bracken Gardens, North Circular Road, Limerick
Asking price: €420,000
Accommodation: 4 Beds

A highly desirable family home providing tasteful and elegant accommodation throughout. Combining a
tremendous location along with its spacious well cared for accommodation, this property is a dream home for those seeking a family residence off the prestigious North Circular Road. Among its many features are an oak fitted kitchen, off street parking and a private rear garden.

Acc: Ent Hall, Liv/Din, Kit, Fam, Util, Guest wc, 4 Beds, Bath

Features:
  • Quiet cul de sac.
  • Very good decorative condItion.
  • Prestigious North Circular Road Address.
  • Oil fired central heating.
  • Excellent amenities closeby.
  • Double glazed woodgrain PVC windows.
  • C. 1500 sq.ft.

Your recent activity on OMG: Clear history