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 (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,) Semi-detached house For Sale - 85 Drominbeg, Rhebogue, Limerick - OMG Auctioneers

Residential Property Previous Page


85 DrominbegRhebogue, LimerickPrice: €215,000

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

If location and convenience are your priorities, then look no further than this exceptionally presented semi detached home. In turnkey condition throughout, No 85 enjoys the benefits of an extra large corner site offering excellent space to the rear and side. Its high quality finish along with its many modern and comtemporary features will appeal to any discerning purchaser. Nicely positioned in this popular residential area and overloooking a green area, this superb family home will not disappoint. Acc: Ent hall; Sitting room, Kitchen/Dining, Living room/bed 4, Utility, Guest WC, 3 bed( 1ensuite); Bathroom.

Features:
  • Excellent decorative condition.
  • Extra large corner site with excellent space to the side and rear.
  • Cul de sac location.
  • Gas fired central heating.
  • Double glazed uPVC windows throughout.

Your recent activity on OMG: Clear history