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 (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,) Semi-detached house For Sale - 44 The Village at Adare Manor, Adare, Co. Limerick - OMG Auctioneers

Residential Property Previous Page


44 The Village at Adare ManorAdare, Co. LimerickPrice: €285,000

Type: Semi-detached house
Address: 44 The Village at Adare Manor, Adare, Co. Limerick
Asking price: €285,000
Accommodation: 3 Beds
Sale Status: Sold

Superbly positioned within the grounds of Adare Manor, and in this picturesque village, this attractively aesthetic dwelling extends to 1,565 sq. ft of spacious, well laid out accommodation with rooms of elegant proportion. This attractive family home offers purchasers a fantastic opportunity to acquire a residence in this tranquil setting, within easy commuting distance of Limerick and built to the highest of standards.

Accommodation: Entrance Hall, Guest WC, Living Room, Kitchen/Dining Room, Sunroom, Landing, 3Bedrooms (1 En-Suite), Bathroom.

Features:
  • Superbly located within the grounds of Adare Manor
  • Short commute to Limerick City
  • Limestone window sill to front of house
  • Natural gas heating
  • Timber framed double glazed windows
  • Natural slate roof
  • Underfloor heating in upstairs bedrooms

Your recent activity on OMG: Clear history