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 (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,) Detached house For Sale - 35 Strandville Gardens, O'Callaghan Strand, Limerick - OMG Auctioneers

Residential Property Previous Page


35 Strandville GardensO'Callaghan Strand, LimerickPrice: €250,000

Type: Detached house
Address: 35 Strandville Gardens, O'Callaghan Strand, Limerick
Asking price: €250,000
Accommodation: 3 Beds

Ideally situated in this private residential cul de sac and just a short stroll from the city centre lies this 4 bedroom detached family home which has been well cared for by it's present owners. Benefitting from a south westerly aspect and within easy access to all conceivable amenities viewing is highly recommended.

Accommodation: Entrance Hall, Living Room, Kitchen/Dining, 4Bedrooms, Bathroom.

Features:
  • Within walking distance of Limerick City Centre
  • Oil fired central heating
  • Double glazed PVC windows
  • Recently modernised
  • Ample parking to front
  • Private rear garden
  • Garden shed

Your recent activity on OMG: Clear history