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 (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 - 23 Cluain Dubh, Dooradoyle, Limerick - OMG Auctioneers

Residential Property Previous Page


23 Cluain DubhDooradoyle, LimerickPrice: €205,000

Type: Semi-detached house
Address: 23 Cluain Dubh, Dooradoyle, Limerick
Asking price: €205,000
Accommodation: 3 Beds
Sale Status: For sale
New/Secondhand: Secondhand

Boasting one of Limericks most popular addresses, this excellently located family home offers spacious accommodation in a quiet cul de sac off the Fr Russell Road. Decorated to showhouse standard this property has 3 bedrooms (master ensuite) combined with well proportioned reception rooms. Immediately adjacent to a host of amenities such as shops, schools, creches etc., Crescent Shopping Centre, Mid West Regional Hospital and Raheen Industrial Estate. This house will suit both first time buyers and families. Viewing of this property is highly recommended.
Acc: Ent hall, Living Room, Kitchen / Dining , Utility, Guest WC, 3 beds (1 ensuite), Bathroom

Features:
  • 3 Bedroomed (1 ensuite) semi detached house
  • Well located close to a host of amenities
  • Excellent decorative condition
  • Cul de sac
  • Private south West facing rear garden

Your recent activity on OMG: Clear history