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 (807,474,) Semi-detached house For Sale - 1 Clareview Avenue, Farranshone, Limerick - OMG Auctioneers

Residential Property Previous Page


1 Clareview AvenueFarranshone, LimerickPrice: €195,000

Type: Semi-detached house
Address: 1 Clareview Avenue, Farranshone, Limerick
Asking price: €195,000
Accommodation: 3 Beds
Sale Status: For sale

Built c. 1935 this charming 3 bed end-terrace home is situated just a short stroll from Limerick city centre. Beautifully maintanied throughout by it's present owners this light filled family home boasts well laid out accomodation and benefits from a sunfilled south/west facing rear garden and off street parking to front. Newly insulated, Viewing is highly recommended.

Acc: Ent hall, Living Room, Family/Dining Room, Kitchen, 3Beds, Bath

Features:
  • Excellent decorative condition
  • South west facing rear garden
  • Walking distance from city centre
  • Double glazed PVC windows throughout
  • Beautifully maintained by its present owner
  • Recently insulated

Your recent activity on OMG: Clear history