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 (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 - 77 Drominbeg, Rhebogue, Limerick - OMG Auctioneers

Residential Property Previous Page


77 DrominbegRhebogue, LimerickPrice: €180,000

Type: Semi-detached house
Address: 77 Drominbeg, Rhebogue, Limerick
Asking price: €180,000
Accommodation: 3 Beds

If location and convenience are your priorities then look no further then this exceptionally presented semi detached home. In turnkey condition throughout and boasting an extended kitchen to the rear, this spacious home is nicely positioned in this popular residential area and is further complimented by a private rear garden. It's high quality finish along with its many modern and contemporary features will appeal to many. Acc: Ent hall; Guest wc; Living room; Kitchen/Dining area; 3 Beds ( 1ensuite); Bathroom.

Features:
  • Excellent decorative condition throughout.
  • Gas fired central heating.
  • Double glazed upvc windows throughout.
  • Private rear garden in excellent condition.
  • Located close to a host of amenities and services.

Your recent activity on OMG: Clear history