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 (750,331,332,333,820,329,334,628,246,696,816,202,470,727,402,404,669,562,801,722,729,601,826,832,597,534,705,805,753,821,787,825,817,814,651,823,818,716,769,768,810,833,808,593,198,709,813,760,728,782,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,) Detached house For Sale - Carrigeen, Croom, Co Limerick - OMG Auctioneers

Residential Property Previous Page


CarrigeenCroom, Co LimerickPrice: €280,000

Type: Detached house
Address: Carrigeen, Croom, Co Limerick
Asking price: €280,000
Accommodation: 4 Beds

Recently constructed this spacious detached property on c. .5 acre is presented in excellent decorative condition throughout. Boasting spacious accommodation and an excellent standard of decor, this property will not disappoint. Located c. 1/2 mile from Croom Village

ACCOMMODATION: Entrance Hall; Living Room; Kitchen/ Dining; Utility; Guest WC; Back Hall; 4 bedrooms (1 Ensuite with walk in wardrobe); Bathroom.

Features:
  • Oil fired central heating
  • BER Cert C3
  • 4 years old
  • Septic tank
  • Excellent decorative condition

Your recent activity on OMG: Clear history