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 (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 - Aghlacka, Station Road, Askeaton, Co Limerick - OMG Auctioneers

Residential Property Previous Page


AghlackaStation Road, Askeaton, Co LimerickPrice: €375,000

Ground Floor:
Entrance Hall


6.81m(22'4'') x 2.36m(7'9'')

Triple lock teak front door with glass panels to both sides. Phone point. Coving and centrepiece. Recessed lighting. Smoke alarm. Beautiful hand painted stairs with oak steps and rail to first floor.

Guest Wc


2.18m(7'2'') x 1.42m(4'8'')

Wc & whb. Window to rear.

Sitting Room


4.85m(15'11'') x 4.47m(14'8'')

Two no. window aspects to front along with window aspect to side. TV & phone points. Double doors to playroom/living room. Open fire. Coving and centrepiece. Smoke alarm.

Play Room/living Room


3.48m(11'5'') x 3.38m(11'1'')

Double doors to sitting room along with double doors to conservatory. Window aspect to side.

Conservatory


3.91m(12'10'') x 3.63m(11'11'')

French doors to rear. Double doors to playroom/living room. Window aspect to all sides. TV point.

Kitchen


4.27m(14'0'') x 4.09m(13'5'')

Window aspect to rear and side. Opening to dining area. Door to utility.

Dining Area


4.11m(13'6'') x 3.91m(12'10'')

Coving and centrepiece. Two no. window aspects to front along with window aspect to side. Opening to kitchen.

Utility Room


2.36m(7'9'') x 2.26m(7'5'')

Triple lock PVC door to rear with glass insert. Door to kitchen.

First Floor:
Landing


Two no. windows to the front. Smoke alarm. Recessed lighting. Double doors to hotpress with excellent storage space. Folding stairs to floored attic with velux window to rear.

Master Bedroom


Two no. window aspects to front. TV point and phone point. Control panel for central heating.

Ensuite


Tiled floor. Wc & whb. Corner shower unit with fully tiled wall area and power shower. Velux window allowing excellent natural light.

Bedroom 2


Window aspect to rear. TV point.

Ensuite


Tiled floor. Wc & whb and corner shower unit with fully tiled wall area and power shower. Velux window allowing excellent natural light.

Bedroom 3


Window aspect to rear. TV point.

Bedroom 4


Two no. window aspects to front. TV point.

Bathroom


Tiled floor. Bath, wc & whb. Corner shower unit with fully tiled wall area and triton T90si electric shower.

Exterior:
Garden


Site extends to c. 0.5 acres. Tarmac driveway along with tarmac to the sides and rear. Kerbing throughout. Stud railing to front. Beautifully maintained lawns to the front, side and rear.

Your recent activity on OMG: Clear history