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 (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 - 2 Woodbrook, Cratloe, Co. Clare - OMG Auctioneers

Residential Property Previous Page


2 WoodbrookCratloe, Co. ClarePrice: €470,000

Type: Detached house
Address: 2 Woodbrook, Cratloe, Co. Clare
Asking price: €470,000
Accommodation: 4 Beds
Sale Status: For sale
New/Secondhand: Secondhand

Exceptional family residence superbly positioned on a picturesque site with beautiful woodside views.

Excellently designed with insprational flair representing the definite in both a traditional and contemporary interior.

Light filled accommodation of c. 3,000 sq.ft with rooms of elegant proportion.

Extensive use of high quality materials make this a home of numerous notable features.

Accommodation: Entrance Hall, Living Room, Kitchen/Dining, Family Room, Playroom, Utility, WC, Sunroom, 4 Bedrooms, 2 En-Suites, Bathroom.

Features:
  • Solid wood floors.
  • Porcelain tile.
  • Ivory shaker style kitchen units.
  • Landscaped gardens.
  • Fully alarmed.
  • C.3000 sqft of stylish accommodation. Development of only 13 detached houses.

Your recent activity on OMG: Clear history