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 (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 - 18 Fuschia Avenue, Caherdavin, Limerick - OMG Auctioneers

Residential Property Previous Page


18 Fuschia AvenueCaherdavin, LimerickPrice: €159,500

Type: Semi-detached house
Address: 18 Fuschia Avenue, Caherdavin, Limerick
Asking price: €159,500
Accommodation: 3 Beds
Sale Status: For sale

Nestled away in this quiet cul de sac lies this well maintained family home. Boasting spacious accomodation throughout and the potential for extension/conversion this property is surrounded by every conceivable amenity and is an ideal home for those looking for a quiet residential area.

Acc: Ent Hall, Living Room, Kitchen, Utility, Garage, 3 Beds, Bath.

Features:
  • Large walled in rear garden
  • Quiet cul de sac location
  • Beautifully maintained family home
  • Close proximity to schools, shops etc
  • Oil fired central heating

Your recent activity on OMG: Clear history