{ "PropertyId": 4961220, "Address": { "FullAddress": "The Yellow House", "Town": "Cork Road", "County": "Waterford", "Eircode": "X91TW01" }, "Location": { "Latitude": 52.2456191, "Longitude": -7.1286363 }, "PropertyDetails": { "Type": "Businesses", "FloorAreaSqM": 273.692238, "Ber": "D2", "Features": [] }, "BrochureContent": [ { "ContentType": "Description", "Content": "\nMixed-Use Property Comprising 3 Commercial Units, and Large Apartment.\n\nFormerly \"The Yellow House\" Licensed Premises.\n\nO'Shea O'Toole are delighted to bring to the market this substantial mixed-use property situated on a high-profile site on the Cork Road, across the road from the Glassworks University Enterprise Quarter currently under construction, and within walking distance of SETU Campus, Cork Road, the Regional Sports Centre, and is approximately 2 km from Waterford City Centre. \n\nThe property is in need of complete renovation. It comprises a former pub at ground floor level, along with 2 small retail units, and residential accommodation at first floor level. The total site area extends to 539 sq.m. / 0.1331 acres.\n\nThe pub unit includes an open-plan bar / lounge, along with ladies and gents w.c. facilities, and storage accommodation. The retail units are independent of the pub with roller shutter access at front. \n\nThe residential accommodation at first floor level includes 4 bedrooms, 1 reception room, bathroom and kitchen. \n\nThe property has been vacant for a number of years, is in derelict condition and in need of renovation. We are instructed to sell this property by Waterford City and County Council. Prospective purchasers need to be aware that Waterford City and County Council are asking that Planning Permission, if required, is applied for within 12 months of closing and that the works are substantially completed within 24 months (including the period to submit planning).\n\nBER for former public house - D2\n\nBER for retail unit 1 - E1\n\nBER for retail unit 2 - F\n\nBER for apartment - G\n\nViewing by appointment.\n\n" }, { "ContentType": "Negotiator", "Content": "Barry McDonald" } ], "Price": { "Display": "€225,000", "Value": 225000, "Currency": "EUR" }, "Media": { "MainPhoto": "https://photos-a.propertyimages.ie/media/0/2/2/4961220/d00b2924-dac2-42b5-a144-beb1896382b1_l.jpg", "Gallery": { "Url": [ "https://photos-a.propertyimages.ie/media/0/2/2/4961220/d00b2924-dac2-42b5-a144-beb1896382b1_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/a4adbc6d-d98b-4de9-9c3a-d874db30fc1d_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/5aa7538d-9584-4f8e-b7d1-8c8bb52107a5_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/1b56ebf8-a62f-4f26-ba04-e4bb9e004e2d_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/242d37c8-e518-44ff-b7f0-bd29a0a0aad5_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/0b5f286d-c1c6-4c90-8a23-9afcc594eda5_l.jpg", "https://photos-a.propertyimages.ie/media/0/2/2/4961220/13b337a2-d327-4078-bda7-03efc089df27_l.jpg" ] } }, "Agent": { "Name": "O'Shea O'Toole", "Logo": "https://photos-a.propertyimages.ie/groups/1/1/7/5711/logo.jpg" }, "Listing": { "Status": "For Rent", "DateListed": "13 Oct 2025" } }