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 (233,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 - Castlecomfort House, Murroe, Co Limerick - OMG Auctioneers

Residential Property Previous Page


Castlecomfort HouseMurroe, Co LimerickPrice: €800,000

Ground Floor:
Entrance Porch


3.30m(10'10'') x 2.06m(6'9'')

Tiled floor. Solid teak front door. Ornate coving and cornice.

Entrance Hall


4.24m(13'11'') x 2.06m(6'9'')

Fanlight window above door. Original floor boards. Cornice work and coving. Feature high ceilings to 10.5 ft. and wood panelled architraves for doors.

Drawing Room


6.40m(21'0'') x 5.00m(16'5'')

A great room with many original features. Marble fireplace with brass and tile inserts. Ornate coving, cornice and picture rails. Two large Georgian windows with original recessed shutters. Varnished tongue and groove wooden flooring.

Dining Room


6.40m(21'0'') x 5.08m(16'8'')

Original black granite fireplace with tile inserts. Beautiful cornice, coving and picture rail detail. Original recessed window shutters. Wall mounted lights. Varnished tongue and groove wooden flooring.

Central Reception Hall


4.47m(14'8'') x 3.66m(12'0'')

Stunning winding staircase leads to the first floor landing. Impressive double height ceiling extending to c. 20 ft. Large Georgian fanlight style window fills entire area with light. Ornate coving and cornice. Cloaks closet for storage.

Sitting Room


5.00m(16'5'') x 4.47m(14'8'')

Ornate coving and cornice work. Feature red brick fireplace with wood burning stove. Large corner TV & display unit. Window with private garden aspect.

Back Hall


4.24m(13'11'') x 0.86m(2'10'')

Leading to cellar area.

Cellar


4.34m(14'3'') x 2.51m(8'3'')

Kitchen


4.55m(14'11'') x 4.22m(13'10'')

Fully fitted pine kitchen with excellent range of presses. Integrated dishwasher. tiled floor and back splash area. Larder style press units. TV point.

Utility


1.70m(5'7'') x 1.27m(4'2'')

Plumbed for washing machine and dryer. Worktop area.

Guest Shower


3.91m(12'10'') x 2.79m(9'2'')

Wc, whb and shower unit. Tiled floor and shower area.

First Return:
Bathroom


4.67m(15'4'') x 2.41m(7'11'')

Wc, whb and bath. Recessed lighting. Marble flooring. Fully tiled wall area.

First Floor:
Landing


6.17m(20'3'') x 3.66m(12'0'')

Spacious open plan area. Original features including 3ft. depth curved archway along with ornate cornice detail. Original wooden flooring.

Bedroom 1


5.16m(16'11'') x 4.50m(14'9'')

Feature cast iron fireplace. Original 6 inch floor boards. Recessed window shutters.

Bedroom 2


5.05m(16'7'') x 4.57m(15'0'')

Feature cast iron fireplace. Original 6 inch floor boards. Recessed window shutters.

Bedroom 3


4.67m(15'4'') x 4.39m(14'5'')

Feature cast iron fireplace. Original 6 inch floor boards. Recessed window shutters.

Bedroom 4


5.00m(16'5'') x 4.39m(14'5'')

Feature cast iron fireplace. Original 6 inch floor boards. Recessed window shutters. Built in wardrobes.

Bedroom 5


4.88m(16'0'') x 3.78m(12'5'')

Varnished tongue and groove wooden flooring. Side garden window aspect. Recessed window shutters.

Exterior:
Garden


Stables / out offices.
Cobblelock finish courtyard.
2 Patio areas.
Outside lighting.

Your recent activity on OMG: Clear history