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 (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 - 17 River Road, Rhebogue, Limerick - OMG Auctioneers

Residential Property Previous Page


17 River RoadRhebogue, LimerickPrice: €180,000

Type: Semi-detached house
Address: 17 River Road, Rhebogue, Limerick
Asking price: €180,000
Accommodation: 3 Beds

Ideally positioned three bed semi in a quiet cul-de-sac close to the Dublin Road. The property is in good decorative condition throughout and is within walking distance of schools, shops, bus stop etc. The interior is well appointed and has been well maintained throughout. Its living accommodation enjoys an attractive layout combined with well proportioned bedrooms. Acc: Ent Hall, Liv, Kit/Din, 3 Beds, 1 Ensuite, Bath

Features:
  • Walled in garden to rear. c. 1,000 sq.ft.
  • Gas fired central heating.
  • Double glazed PVC windows.
  • Good rental potential. Off street parking.
  • Close to all amenities.

Your recent activity on OMG: Clear history