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 (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,) Semi-detached house For Sale - 81 Drominbeg, Rhebogue, Limerick - OMG Auctioneers

Residential Property Previous Page


81 DrominbegRhebogue, LimerickPrice: €169,000

Accommodation:
Ground Floor


ENTRANCE HALL
3.86m(12'8'') x 2.21m(7'3'')
Triple lock teak front door with glass panel to side
Solid Walnut Flooring

SITTING ROOM
4.80m(15'9'') x 3.68m(12'1'')
Feature wooden fireplace with cast iron insert and granite surround
Front garden window aspect
Solid walnut wooden flooring
Double doors leading to kitchen

FAMILY ROOM
4.75m(15'7'') x 2.59m(8'6'')
walnut sloid wood flooring
window aspect to front

KITCHEN/DINING
3.38m(11'1'') x 5.94m(19'6'')
Excellent range of Cherry wood fitted units with tiled backsplash
Oven and extractor
Patio door to rear
Tiled floor

UTILITY
3.23m(10'7'') x 2.62m(8'7'')
Plumbed for washing machine
Tiled floor
Rear garden window aspect.
pvc door leading to rear garden

Guest WC
1.55m(5'1'') x 1.40m(4'7'')
WC & WHB
Fully tiled floor and walls

First Floor


LANDING
Carpet flooring on stairs and landing
Hotpress
Access to attic with Stira

MASTER BEDROOM
4.34m(14'3'') x 2.67m(8'9'')
Built in sliderobe wardrobes
Solid oak flooring
Front garden window aspect

ENSUITE
2.41m(7'11'') x 1.45m(4'9'')
Fully tiled
WC & WHB
Corner shower unit with elctric shower

BEDROOM 2
3.81m(12'6'') x 3.18m(10'5'')
Oak timber flooringBbuilt in wardrobes
Rear garden window aspect

BEDROOM 3
2.54m(8'4'') x 2.49m(8'2'')
Oak flooring
Built in wardrobes
Front garden window aspect

BATHROOM
2.01m(6'7'') x 1.68m(5'6'')
Fully tiled
WC, WHB & bath with electric shower

GARDEN
Tarmac driveway to front
Lawn to side and rear
Patio to rear
Storage shed

Your recent activity on OMG: Clear history