Prime sea-view property presents rare opportunity for renovation and redevelopment