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 (804,807,474,) Apartment For Sale - 1 Fitzhaven Place, South Circular Road, Limerick - OMG Auctioneers

Residential Property Previous Page


1 Fitzhaven PlaceSouth Circular Road, LimerickPrice: €160,000

Type: Apartment
Address: 1 Fitzhaven Place, South Circular Road, Limerick
Asking price: €160,000
Accommodation: 3 Beds
Sale Status: For sale

Boasting a prestigous address and convenient location this 3 bed ground floor apartment is situated on the South Circular Road with every amenity close to hand and the city centre a short walk away. Stylishly appointed, the property may be suitable as an investment opportunity. Viewing comes highly recommended.

Acc: Ent Hall, Living/Kitchen/Dining, 3 Bed, 2 Bathroom (1 En-Suite)

Features:
  • 3 Double Bedrooms
  • Located close to Mary Immaculate College
  • Good rental potential
  • Private parking
  • Gas fired central heating
  • Double glazed PVC windows

Your recent activity on OMG: Clear history