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 (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 - 8 Marian Avenue, Janesboro, Limerick - OMG Auctioneers

Residential Property Previous Page


8 Marian AvenueJanesboro, LimerickPrice: €150,000

Type: Semi-detached house
Address: 8 Marian Avenue, Janesboro, Limerick
Asking price: €150,000
Accommodation: 3 Beds
Sale Status: For sale

his 3 bed semi detached property is located in the most convenient location just outside the city centre. No. 8 Marian Ave is a light filled family home in good decorative condition and boasts an extended kitchen to the rear with a south facing rear garden. This property is immediately adjacent to shopping centres, primary and secondary schools.
Acc: Ent hall, family room, living room, kitchen, Guest WC, 3 bed, bath,Garden Shed.

Features:
  • Garden
  • Large south facing rear garden
  • Patio area
  • Tarmac driveway to front with offstreet parking
  • Walled in gardens to front and rear
  • Garden Shed

Your recent activity on OMG: Clear history