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 (634,815,630,802,704,502,719,741,791,208,733,804,807,474,) Terrace house For Sale - 14 Old Street, Castleconnell, Limerick - OMG Auctioneers

Residential Property Previous Page


14 Old StreetCastleconnell, LimerickPrice: 150000

Type: Terrace house
Address: 14 Old Street, Castleconnell, Limerick
Asking price: 150000
Accommodation: 3 Beds

Located in the heart of Castleconnell village, this spacious three bedroom mid terraced property boasts spacious bedroom and living accommodation which has been maintained to an excellent standard throughout. Currently earning an attractive rental income and also suitable for first time buyers, no.14 will appeal to those seeking a home close to every conceivable amenity. Acc: Ent Hall; Sitting Room; Kitchen; Shower Room; 3 Beds.

Features:
  • Very good decorative condition throughout
  • Electric heating
  • Excellent location in the hear of Castleconnell Village
  • Street Parking Outside
  • Excellent Rental Potential

Your recent activity on OMG: Clear history