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 (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 - 3 The Park, Briarfield, Castletroy, Limerick - OMG Auctioneers

Residential Property Previous Page


3 The ParkBriarfield, Castletroy, LimerickPrice: €210,000

Type: Semi-detached house
Address: 3 The Park, Briarfield, Castletroy, Limerick
Asking price: €210,000
Accommodation: 6 Bedrooms
Sale Status: For sale

Extremely attractive 6 bedroom semi detached home boasting spacious and well appointed accommodation. Situated in one of Castletroy's most popular areas, No.3 has been extremely well maintained and enjoys easy access to a wide range of amenities and services. The Univeristy of Limerick is located only minutes walk from the property and this home is sure to suit investors and owner occupiers alike.

Features:
  • Excellent decorative condition
  • Gas fired central heating
  • Double glazed uPVC windows throughout
  • Located adjacent to Castletroy Shopping Centre and on the doorstep of the University of Limerick

Your recent activity on OMG: Clear history